https://bugs.freedesktop.org/show_bug.cgi?id=67572
Priority: medium
Bug ID: 67572
Assignee: [email protected]
Summary: Functions with *_ADD don't work correct on xslx export
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
When using some functions with *_ADD within the name, the table don't work
correctly when saving in different formats. This concerns:
- CUMIPMT_ADD
- CUMPRINC_ADD
- EFFECT_ADD
- GCD_ADD
- ISEVEN_ADD
- ISODD_ADD
- LCM_ADD
- NOMINAL_ADD
Not concerned are:
- CONVERT_ADD
- DURATION_ADD
- WEEKNUM_ADD
When saving as XLSX and opening again, functions without _ADD are converted to
subtractions.
E.g.: Type into A1 "=GCD(24;18)" and saving the spreadsheet as XLSX.
Expected behavior: When opening A1 contains =GCD(24;18).
Shown behavior: When opening A1 contains =(24-18).
This is known to work on LibreOffice 4.0.4, so a regression.
This issue has been split our of bug 67536.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs