Bug 84035 - CONFIGURATION: Functions not recalculated by default
Summary: CONFIGURATION: Functions not recalculated by default
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-18 09:50 UTC by Dan Haiduc
Modified: 2015-04-09 16:11 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
XlsxWriter-generated formula file (5.27 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-09-24 10:04 UTC, Dan Haiduc 		Details
Script to generate demo xlsx file (680 bytes, text/plain)
2014-09-24 10:05 UTC, Dan Haiduc 		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 Dan Haiduc 2014-09-18 09:50:26 UTC 
Problem description: 

Steps to reproduce:
1. Generate an XLSX with formulas using XlsxWriter
2. Open in LibreOffice

Current behavior:
Default settings when installed make all formulas to appear as 0.

Expected behavior:
The default settings should be that formulas are recalculated on file load and the values appear.

Operating System: All
Version: 4.3.1.2 release
Comment 1 Jacques Guilleron 2014-09-18 21:38:33 UTC 
Hi Dan,

Can you provide a sample we could handle easily?

This will be really kind.

regards,

Jacques
Comment 2 Dan Haiduc 2014-09-24 10:04:38 UTC 
Created attachment 106780 [details]
XlsxWriter-generated formula file
Comment 3 Dan Haiduc 2014-09-24 10:05:09 UTC 
Created attachment 106781 [details]
Script to generate demo xlsx file
Comment 4 Dan Haiduc 2014-09-24 10:05:40 UTC 
Here you go :)
Sorry for the delay.

(In reply to comment #1)
> Hi Dan,
> 
> Can you provide a sample we could handle easily?
> 
> This will be really kind.
> 
> regards,
> 
> Jacques
Comment 5 Jacques Guilleron 2014-09-24 13:01:53 UTC 
Hi Dan,

Thanks for the sample.

In this case, you have an option:
Option > LibreOffice Calc > Formula > Recalculation on File Load
and set: Excel 2007 and newer 
to 
 Allways recalculate 
or 
 Prompt user

regards,

Jacques
Comment 6 Dan Haiduc 2014-09-24 13:38:43 UTC 
(In reply to comment #5)
> Hi Dan,
> 
> Thanks for the sample.
> 
> In this case, you have an option:
> Option > LibreOffice Calc > Formula > Recalculation on File Load
> and set: Excel 2007 and newer 
> to 
>  Allways recalculate 
> or 
>  Prompt user
> 
> regards,
> 
> Jacques

I found that out, indeed I have this option. 
But what I suggested was this option to be *default* (both for "Excel 2007 and newer ", and for "ODF Spreadsheet (not saved by LibreOffice)".

I believe this would be helpful, saving everyone the time to find and enable it. And it was set as such in OpenOffice. Is there a reason why this option was changed not to recalculate, as default?