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.
Confirmed as per bug 67536. Needs a bibisect. Regression between 4.1.0.4 and 4.0.4.2 as of now. Suggesting as a 4.1 MAB: Regression -- loss of data.
I'll try to take a look at this
Range: http://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=04f21f9ad6c4b5be606f3c62fd10b3f1c2df283a..d46b2086f271d8cb8f3cc891363e7b4b128b6f55
Created attachment 83732 [details] bibisect log
Maybe best that I take this over, also bug 67536.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=da7c6092a644dc22f90fb8eef0c4f0df06ec204a resolved fdo#67572 export add-in equivalents as internal to .xlsx The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review for 4-1 at https://gerrit.libreoffice.org/6530
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=80994001d563ffd51f008eae4eb88c6eb2b7d38b&h=libreoffice-4-1 resolved fdo#67572 export add-in equivalents as internal to .xlsx It will be available in LibreOffice 4.1.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]