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

Reply via email to