[Libreoffice-bugs] [Bug 69701] EDITING: Error in function GCD_ADD
https://bugs.documentfoundation.org/show_bug.cgi?id=69701 Winfried Donkers winfrieddonk...@libreoffice.org changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |winfrieddonkers@libreoffice |desktop.org |.org --- Comment #4 from Winfried Donkers winfrieddonk...@libreoffice.org --- The GCD_ADD function is present to offer compatibility with the Excel add-in function GCD from Excel 2003 and earlier (xls). The GCD function is fully ODFF1.2 compliant and is compatible with the Excel function GCD from Excel 200 and newer (xlsx). Because GCD_ADD is an add-in function in Excel, it must be handled quite differently from GCD on export/import to/from Excel. Also, effectively, it is an outdated function, available only for backward compatibilty (xls). Patching this function seems to be a waste of time. I will see if I can remove the GCD_ADD for the user, and substitute GCD with GCD_ADD when exporting to xls. When that is complete, all GCD_ADD uses from the past (in xls and in ods) will be automatically transferred to GCD. The current behaviour is that GCD_ADD already is being substituted to GCD in ods, but GCD_ADD is still in the function list, so it's somewhat confusing. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69701] EDITING: Error in function GCD_ADD
https://bugs.freedesktop.org/show_bug.cgi?id=69701 Stanislav Horacek stanislav.hora...@gmail.com changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #3 from Stanislav Horacek stanislav.hora...@gmail.com --- OK, I confirm this as a bug: GCD_ADD function does not convert input values to integers and returns rationals. E.g.: GCD_ADD(2.1;4.2) returns 2.1, should return 2 GCD(2.1;4.2) returns 2 correctly This is probably inherited from OO - see also https://issues.apache.org/ooo/show_bug.cgi?id=71158 where the same behaviour (returning rationals) was corrected for GCD function. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69701] EDITING: Error in function GCD_ADD
https://bugs.freedesktop.org/show_bug.cgi?id=69701 Stanislav Horacek stanislav.hora...@gmail.com changed: What|Removed |Added CC||stanislav.hora...@gmail.com --- Comment #1 from Stanislav Horacek stanislav.hora...@gmail.com --- GCD function works only for integers, as it is described in the ODF standard: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018532_715980110 or in Excel help: http://office.microsoft.com/en-us/excel-help/gcd-HP005209104.aspx GCD rounds input numbers down to integer and returns integers, but GCD_ADD apparently returns decimal values - maybe this is a bug. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69701] EDITING: Error in function GCD_ADD
https://bugs.freedesktop.org/show_bug.cgi?id=69701 --- Comment #2 from John Smith clicks...@yahoo.co.uk --- Yes. No problem with GCD, only with GCD_ADD. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs