Bug 89042 - FILESAVE: Lost ROUNDUP formula when save and load it in MSO2013
Summary: FILESAVE: Lost ROUNDUP formula when save and load it in MSO2013
Status: CLOSED DUPLICATE of bug 81596
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-02 10:42 UTC by Kami
Modified: 2015-02-02 20:20 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
ODS LO4.4 (10.20 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-02-02 10:42 UTC, Kami 		Details
XLSX LO4.4 (4.49 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-02-02 10:42 UTC, Kami 		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 Kami 2015-02-02 10:42:03 UTC 
Created attachment 113045 [details]
ODS LO4.4

I used =ROUNDUP(E2/C2) formula and saved to ODS and XLSX file format. When I load it in MSO2013 I got error messages and the Excel offer to remove the formula and add the value instead of formula because of an error.

Tried and repoducable under LO 4.2.7.2 and 4.4.0.3.

Bugdocs are attached
Comment 1 Kami 2015-02-02 10:42:24 UTC 
Created attachment 113046 [details]
XLSX LO4.4
Comment 2 raal 2015-02-02 11:58:57 UTC 
I can confirm with LO 4.4, win7 and excel2010
Comment 3 Eike Rathke 2015-02-02 20:19:27 UTC 
In Excel the second parameter of ROUND, ROUNDUP and ROUNDDOWN is not optional. Give it 0.

*** This bug has been marked as a duplicate of bug 81596 ***