Summary: | FILEOPEN: Formula Results Incorrect (=0) on File Re-Open | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | C A J <caj-bugz> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | miguelangelrv |
Priority: | medium | ||
Version: | 4.2.2.1 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: |
Example Problem File
Example Screenshot |
Description
C A J
2014-03-20 18:39:56 UTC
You could send me the problematic file attached to an email. You may OpenPGP encrypt the mail and attachment using my key 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A http://pool.sks-keyservers.net:11371/pks/lookup?search=0x6A6CD5B765632D3A&op=get Created attachment 96207 [details]
Example Problem File
Eike, thanks for the offer to privately email you the files, but I was able to remove the sensitive information from the smaller (and less complicated) file, uploaded herewith.
There is a slight difference in the behavior of this file from my original description. Now, cells A42, A43, and A44 show zeroes as their formula results. This is consistent with the (incorrect) behavior in my financial file.
Many thanks for taking a look at this.
Created attachment 96208 [details]
Example Screenshot
Attached is a schreenshot showing the problematic result.
Note also that Help > About identifies Calc as v.4.2.2.1, although pacman -Q says I have v.4.2.2-2 installed.
Hi C A J, thanks for reporting. There is an option for recalculate xlsx files when opening in: Menu/Tools/Options/LibreOffice calc/Formula/Recalculation on file load - Excel 2007 or newer. This option works fine with your file. Also a hard recalc [Ctrl+Shift+F9] solves the issue. I think not a bug, but I hope Eike can confirm. Thanks for the suggestion on setting recalc-on-file-load. That solves the problem for the two spreadsheets that were misbehaving. I'm just curious, though. Is recalc-on-file-load a new option? (Or a config parameter reset by v.4.2.2-2?) The problem with the file I sent has been intermittent and the problem with the 11,000-row file only occurred for the first time last week. It was a new option in 4.0. I think the intention was to allow avoid long recalculations at the opening. Thanks all 'round. I went ahead and closed out #76411. |