Bug 104501 - when opening calc sheet so are formulas 0
Summary: when opening calc sheet so are formulas 0
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.3.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-08 14:01 UTC by Pablo
Modified: 2016-12-09 05:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
a pre-generated file (7.00 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-12-08 14:06 UTC, Pablo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Pablo 2016-12-08 14:01:29 UTC
Description:
Hi, I have a similair and maybe related problem with pre-generated files and sum or multiplication with percentage. 
When opening the file it doesnt show the calculation. 
Works when I use CTRL+SHFIT+F9 but if I close the file and then open it again it shows 0 again.

Similiar behavior if one opens the sheet in microsoft office excel, as it opens it locked, but when going to edit mode it show correct sum\multiplication, and when reopening in ms excel it shows the correct numbers.

Was going to put it togheter with bug: Bug 101694 - Formula displays wrong number
but it seems he has problem with using CTRL+SHIFT+F9

Happens in ubuntu and tested it in a windows machine aswell:
LINUX
Version: 5.1.4.2
Build ID: 1:5.1.4-0ubuntu1
CPU Threads: 12; OS Version: Linux 4.4; UI Render: default; 
Locale: sma-SE (C)

WINDOWS
Version: 5.2.3.3
Build ID: d54a8868f08a7b39642414cf2c8ef2f228f780cf
CPU Threads: 8; OS Version: Windows 6.2; UI Render: default; 
Locale: sv-SE (sv_SE); Calc: group

Steps to Reproduce:
1. Generate a xlsx-file with phpoffice/phpexcel(latest) in ubuntu, so it is hard to do a pre-genereted file.


Actual Results:  
When opening column G and H with formulas show 0.
And cell C21 and C22 shows 0.

Expected Results:
When opening column G and H with formulas should show correct calculations.
And cell C21 and C22 should shows correct calculations.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.100 Safari/537.36
Comment 1 Pablo 2016-12-08 14:06:33 UTC
Created attachment 129400 [details]
a pre-generated file

Pre generetaed file
Comment 2 Jacques Guilleron 2016-12-08 21:33:02 UTC
Hi Pablo,

Select Tools > Options > LibreOffice Calc > Formula > Recalculation on File Load >
Excel 2007 and newer
choose : Always recalculate or Prompt user
Do the same if you want it also for :
ODF spreadsheet
and OK.

Have a nice day,

Jacques
Comment 3 Pablo 2016-12-09 05:53:36 UTC
It seems strange that a recalculation needs to be done when you have not inserted anything into the cell beside a formula?, 
why does it show 0?, 
the 0 have to come from somewhere?, the 0 seems to be the default, why not calculate the formula instead if no cached result exists