Axolot Data

Hello, I have two formulas with OFFSET function in my "template" (it equals czech function POSUN). Both give the same result. Default value of offset is 1 and results are "A" . http://www.genet.cz/kohout/xlsrw/img/20150605_XLSRW_offset_01.jpg XLSRW writes value 2 to the cell B2 a...

Please check VLOOKUP /calculate function - it still doesn't work under 5.20.44

Josef Kohout

Now, EOMONTH woks fine under XLSRW 2.00.05 .

Hello, I have the same problem with DATE function in my "template": After writting new value of date to the cell "A1", there is wrong year in the result file. But after Ctr+Alt+F9 everything become OK . Template http://www.genet.cz/kohout/xlsrw/img/20150318_XLSRW_template_date.jp...

Hello, I made a lot of next tests. At last there is no problem in the XLSRW5 , there is problem in differences in excel versions 2007/2013. In our application, we use two ways for writting value to the cell by XLSRW and usually it works fine. 1. for strings we use Sheet.AsWideString[ColumnAsInt,RowA...

Please check calculate for EOMONTH, EODATE functions - it still doesn't work under 5.20.42

Josef Kohout

Helo, I have problem with two excel functions - column() and row() . Probably the xlsrw calculate does not work properly. Template: http://www.genet.cz/kohout/xlsrw/img/20150114_XLSRW_template_column_row.jpg After write a value 1 to the template cell A1, calculate and save it, the result has wrong v...

Hello, there is defined named formula MyList ={"Volkswagen";"Seat";"Audi"} in template workbook. Nothing another. When result file is creating from template, only number 1 is writing to cell A1. Just presence named formula is enough to cause corruption in result file. D...

Hello, I have some formulas with EOMONTH and EDATE function in my "template": The first one uses named cell and the second one uses an address. After writting new date, only the simple formula (without eomonth,edate) has correct result, but after Ctr+Alt+F9 everything become OK . Template ...

Hello, I have 2 formulas with VLOOKUP function in my "template" (it euqals czech function SVYHLEDAT): The first one uses an address of lookup area and the second one uses a named range. After writting new data, the second formula shows #N/A as wrong value, but after Ctr+Alt+F9 everything b...

Hello, I have a simple template with 2 pivot tables. The 1st one shows percentual values with default format with 2 decimal places. The second one has only one decimal place changed by options in pivot table properties. (Both tables update automatically with opening worksheet.) Template: http://www....

Hello, there is a new problem with calculation at formlulas with named cells. Since 5.20.34 version the formulas with named cells are calculated wrong. (screenshot of result) http://www.genet.cz/kohout/xlsrw/img/example_template_result_calculate_5.20.34.jpg The value of named cell is taking from the...

At version 5.20.33, I have the same problem with calculation formula with named cell as well as at the version 5.20.32 .

Josef Kohout

Hello, I have 2 formulas in my "template.xlsx": 1. Cell B5 has a formula = TARGET * 100 2. Cell B6 has a formula = A3 * 100 and Cell A3 is a named cell "TARGET" (its default value is blank). When I write integer value 10 to the cell A3 by XLSRW and open the result file, the cell ...