Bug 84035

Summary:	CONFIGURATION: Functions not recalculated by default
Product:	LibreOffice	Reporter:	Dan Haiduc <danuthaiduc>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	jalojo
Priority:	medium
Version:	4.3.1.2 release
Hardware:	Other
OS:	All
Whiteboard:	BSA
Crash report or crash signature:		Regression By:
Attachments:	XlsxWriter-generated formula file Script to generate demo xlsx file

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?