Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | M$ Excell documents not recalculating | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | sinisa <sinisa> | ||||
Component: | code | Assignee: | oc | ||||
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P2 | CC: | issues, oooqa | ||||
Version: | OOo 1.0.0 | Keywords: | oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
sinisa
2002-05-24 09:16:01 UTC
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 |