Bug 101913 - FILESAVE MONTHS() function not preserved
Summary: FILESAVE MONTHS() function not preserved
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: x86 (IA32) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-09-05 18:34 UTC by Lance Pymble
Modified: 2016-09-24 19:01 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Single cell exhibiting the fault - after save. (5.94 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-09-05 18:34 UTC, Lance Pymble 		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 Lance Pymble 2016-09-05 18:34:41 UTC 
Created attachment 127159 [details]
Single cell exhibiting the fault - after save.

Have a single cell with contents /=MONTHS("2016-06-01", "2016-07-01", 0)/ after save and on reloading comes back as /=months("2016-06-01", "2016-07-01", 0)/ with field showing /#NAME?/.
Comment 1 MM 2016-09-05 20:24:48 UTC 
Unconfirmed with v5.1.5.2 under windows 7 x64.
Unconfirmed with v5.2.1.2 under ubuntu 16.04 x64.

Maybe you should consider upgrading to a newer version.
Comment 2 GerardF 2016-09-06 07:27:38 UTC 
You are saving in xlsx format and MONTHS function do not exist in MS Excel.

For me, it is not a bug.
Comment 3 Buovjaga 2016-09-24 19:01:27 UTC 
Closing.