Bug 74210 - Formula in cell shows 0 until edited.
Summary: Formula in cell shows 0 until edited.
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.4.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-30 07:50 UTC by Pavel Chernyak
Modified: 2015-01-24 12:50 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
Test file (3.22 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-01-30 07:50 UTC, Pavel Chernyak 		Details
View All

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.