https://bugs.freedesktop.org/show_bug.cgi?id=67536
Priority: medium
Bug ID: 67536
Assignee: [email protected]
Summary: Functions with *_ADD don't work correct
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
1) When saving as ODS and opening again, these functions are renamed to its
variant without _ADD.
E.g.: Type into A1 "=GCD_ADD(24;18)" and saving the spreadsheet as ODS.
Expected behavior: When opening A1 contains =GCD_ADD(24;18).
Shown behavior: When opening A1 contains =GCD(24;18).
2) 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).
3) When saving as XLS and opening again, functions without _ADD show #MACRO? as
output value.
E.g.: Type into A1 "=GCD(24;18)" and saving the spreadsheet as XLS.
Expected behavior: When opening A1 shows 6.
Shown behavior: When opening A1 shows #MACRO?.
--
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
