Apache OpenOffice (AOO) Bugzilla – Issue 5242
M$ Excell documents not recalculating
Last modified: 2013-08-07 15:13:47 UTC
I use OpenOffice to work with M$ Excell files, but sometimes when I delete one row (or more of them), some cells don't get recalculated when I change some values they depend on. The calculations are very simple addition and multiplication of two cells. I cannot even force recalculation, until I re- enter the formula in the cell. After re-entering formula, everything works fine, until next deletion. This is really a big problem, because I want to move all my PCs to OpenOffice. Thanks
Thanks for posting Sinisa. Does this problem still exist in OO 1.0.1? If the problem does exist in OO 1.0.1: Could you please attach a file that demonstrates this problem? Could you also provide us with a list of exact steps to reproduce this problem? Thanks
From Sinisa: 1. I don't know if problem still exists in 1.0.1 because I haven't downloaded it yet because my current bandwidth doesn't allow that :( 2. Problem exists in build 641 for Linux which comes bundled with SuSE linux 8.0, and in version 1.0 for windows, all on three different machines. 3. I have created a simple test containing addition, substraction, multiplication and division in Excell, so you can try for yourself. All you have to do is: - open the document 'test.xls' - you have two columns of numbers, third column depends on first two, and fourth depends on second and third - mark row 6 and delete it - replace all 1's with 3's and all 2's with 4's in upper and lower table - compare the results in two tables - results in column 4 will be different, - I have noticed that after changing any cell in a row makes row below it recalculated correclty - also saving and reopening the document solves problem temporarily, until next row delete. I don't know if I'm making much sense because English is not my native language, and the problem is not so easy to describe, but feel free to ask for additional explanation. Test table is attached with this mail, it contains no macros or other harmfull contents. 4. I'll try to get version 1.0.1 to try this also, but I don't know when I'll be able to do that, so please try... Best Regards, Sinisa Bandin
Created attachment 2601 [details] Excel spreadsheet to duplicate the issue.
Duplicated on Win NT 4.0 SP6a, OO 1.0.1. Problem happens with autorecalc on and off. The users instructions can be used to duplicate the problem.
Hi Eike, one4you
The cause is an imported so-called shared formula not being properly updated, such that listeners are established at wrong places and propagation of changes doesn't work right. A workaround is to initiate a hard recalc using Shift-Ctrl-F9 Lowering priority, as P1 is reserved for issues that render an entire module completely useless, such as crashes upon startup or similar.
fixed in sc/source/core/tool/compiler.cxx 1.30 sc/source/core/data/cell2.cxx 1.16 On OOO_STABLE_1 branch: sc/source/core/tool/compiler.cxx 1.29.2.1
Reopening because the fix needs additional handling in the Excel export because now shared formulas may be moved in a way Excel can't cope with. Don't use the above fix until the export filter has been adapted as long as you want to re-export imported Excel files to Excel again.
life goes on..
Since we didn't want to mess around with the Excel export filter at this point I took a different approach. Fixes in: SRX643/SRX644: sc/inc/compiler.hxx 1.12 sc/source/core/tool/token.cxx 1.13 sc/source/core/tool/compiler.cxx 1.31 sc/source/core/data/cell.cxx 1.14 sc/source/core/data/cell2.cxx 1.17 OOO_STABLE_1: sc/inc/compiler.hxx 1.11.6.1 sc/source/core/tool/token.cxx 1.11.6.2 sc/source/core/tool/compiler.cxx 1.29.2.2 sc/source/core/data/cell.cxx 1.12.2.3 sc/source/core/data/cell2.cxx 1.14.2.1
Have to reopen to reassign, rediculous.
reassign to QA
restore status
Closed because fixed