Axolot Data

2019-12-18 adress of template has been corected

Still the same behavior at XLSWR 6.00.59

Now, It looks ok at XLSRW 6.00.59

Excel formula SUBTOTAL causes problem Hello, I made XLSX template containing formula SUBTOTAL for sum area A 3: A 4. http://www.genet.cz/kohout/xlsrw/img/20191031_subtotal.jpg If I open this template by XLSRW 6.00.59 and try to write "X" to the cell B 3, I get the error "Empty stack&q...

Notice 23/5/2018:
If I add missing characters " ' " to the addresses of series the chart starts work again.

Josef Kohout

Hello I made template with a chart. http://www.genet.cz/kohout/xlsrw/img/20180518_chart_axis_title_format_template.jpg I opened this template by XLSRW 6.036 and wrote null to the cell A1. The axis title in a chart lost the "bold" format. http://www.genet.cz/kohout/xlsrw/img/20180518_chart_...

Hello I made template with two TextBoxes. http://www.genet.cz/kohout/xlsrw/img/20180518_textbox_template_nogrp.jpg I opened this template by XLSRW 6.036 and wrote null to the cell A1. The result is readable - OK . I made next template from the first one with one change - I made them to the group. ht...

Hello I made template with chart. http://www.genet.cz/kohout/xlsrw/img/20180518_chart_buble_template.jpg Its datasource of series are: http://www.genet.cz/kohout/xlsrw/img/20180518_chart_buble_source_in_template.jpg I opened this template by XLSRW 6.036 and wrote null to the cell A1. Saved result ha...

Hello, I made template with B2 cell uses conditional format. The conditional format has formula =B2=1 and if there is value "1", it sets line at the top of cell's border. http://www.genet.cz/kohout/xlsrw/img/20160217_XLSRW_template_conditional_fmt_line_simple_with_1.jpg I opened the templa...

Hello, I made next templates created one by one under 2007SP3, 2010SP2 and 2013 and analyzed their rupBuild and calcId values and their behavior in result files. Templates work correct under each version of Excel. The results were created by XLSRW 5.20.50 . The results are: template created under 20...

Hello, I have still problem with "frozen" values :-( . So I had to make another tests ....... . Templates which I made under Excel 2007 SP0 (SP0=without servicepack) work different than templates which I made under Excel 2007 with SP3 !!! If I make the result by template created under &quo...

Hello, I compared the xlsx result files by their xml parts with this result: The problematic result file xlsrw_result_combo_2013.xlsx contain element " control " <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.open...

Hello, I had to test this function at the our customers' sides. At the first customer there were Excel 2007 without any actualization. And this version have still problem with offset. http://www.genet.cz/kohout/xlsrw/img/20150605_XLSRW_offset_05_2007fr.jpg These days I tested to open "problemat...

Hello, I put the templates and result files for download at http://www.genet.cz/kohout/xlsrw/xlsrw_combobox.zip . There is one template created under Excel 2013 and the same file opened and saved under Excel 2007 SP3. I made 2 results by these templates. I cannot open result "2013" - there...

Hello, there is only one ComboBox in a new template workbook. Nothing another. http://www.genet.cz/kohout/xlsrw/img/20150604_XLSRW_ComboBox.jpg When result file is creating from template, only number 1 is writing to cell A1 by XLSRW. Just presence of object ComboBox is enough to cause corruption in ...