Summary: | Formula in cell shows 0 until edited. | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Pavel Chernyak <fjfalcon> |
Component: | Spreadsheet | Assignee: | 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 |
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.
Second comment has wrong file attachment, sorry. 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] 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.
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?