Excel formula SUBTOTAL causes problem "Empty Stack"

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
jsfkcz
Posts: 29
Joined: Thu Sep 11, 2014 8:29 am

Excel formula SUBTOTAL causes problem "Empty Stack"

Post by jsfkcz »

Excel formula SUBTOTAL causes problem

Hello,
I made XLSX template containing formula SUBTOTAL for sum area A3:A4.
Image
If I open this template by XLSRW 6.00.59 and try to write "X" to the cell B3, I get the error "Empty stack" with resutt code 10 .
If I open this template by XLSRW 5.20.71 and try to write "X" to the cell B3, I get the error "Empty stack" with resutt code 10, too.

(If I try the same with template of XLS version by XLSRW 4.00.65 everything is ok.)


The template is at http://www.genet.cz/kohout/xlsrw/201910 ... mplate.zip to download. (link for example corrected 20191218)

Josef Kohout
jsfkcz
Posts: 29
Joined: Thu Sep 11, 2014 8:29 am

Re: Excel formula SUBTOTAL causes problem "Empty Stack"

Post by jsfkcz »

2019-12-18 adress of template has been corected
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Excel formula SUBTOTAL causes problem "Empty Stack"

Post by larsa »

Hello

This is fixed in update 6.00.65 Please download the component again.
Lars Arvidsson, Axolot Data
Post Reply