Bug 74210

Summary: Formula in cell shows 0 until edited.
Product: LibreOffice Reporter: Pavel Chernyak <fjfalcon>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: medium CC: mariosv
Version: 4.1.4.2 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: Test file

Description Pavel Chernyak 2014-01-30 07:50:13 UTC
Created attachment 93038 [details]
Test file

Greetings. I used apache poi to generate this simple file.
It has 4 cells, in 4th formula, that uses cell b and c. 
But when i open it, it shows 0 as result... (but not formula result)
If i edit it anyway and undo changes all shows as it should.
How can i fix it?
Comment 1 Pavel Chernyak 2014-01-30 08:13:12 UTC
Created attachment 65089 [details]
File that have this problem.

Problem description: 
When opening file, that was generated from apache poi formulas cells shows 0.

Steps to reproduce:
1. Open attached file.
2. View cell D1(it has formula), but shows 0
3. Delete contents of cell D1
4. Undo changes.
5. All looks as it should

Current behavior:
Shows 0, not formula's result

Expected behavior:
Shows formula's result
Platform (if different from the browser): 

ArchLinux x86_64.
Comment 2 Pavel Chernyak 2014-01-30 08:14:13 UTC
Second comment has wrong file attachment, sorry.
Comment 3 m.a.riosv 2014-01-31 00:17:06 UTC
Hi Pavel,
maybe you need modify the option:
Menu/Tools/Options/LibreOffice calc/Formula/Recalculation on file load - Excel 2007 and newer [Prompt]|[Always recalculate]
Comment 4 Pavel Chernyak 2014-01-31 04:59:03 UTC
Thank you, exactly what i need.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.