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: Calc (show other bugs)
Version:
(earliest affected)
4.1.4.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
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:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
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.