[Libreoffice-bugs] [Bug 117511] Setting the cell formula from a macro results Err: 508 cell value
https://bugs.documentfoundation.org/show_bug.cgi?id=117511 --- Comment #7 from Dmitry --- I fully agree with the statement that macros should use the correct syntax. However the programmer should have the ability to reason the error. I have attached another version of test.ods, this time with the "same" formula in cell B1. Now if one scrolls from A1 to B1, visually the same formula is displayed, however A1 results an error. This is not logical. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117511] Setting the cell formula from a macro results Err: 508 cell value
https://bugs.documentfoundation.org/show_bug.cgi?id=117511 Dmitry changed: What|Removed |Added Attachment #141985|0 |1 is obsolete|| --- Comment #6 from Dmitry --- Created attachment 142040 --> https://bugs.documentfoundation.org/attachment.cgi?id=142040&action=edit Test spreadsheet with a macro -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117511] Setting the cell formula from a macro results Err: 508 cell value
https://bugs.documentfoundation.org/show_bug.cgi?id=117511 --- Comment #5 from Mike Kaganski --- (In reply to Dmitry from comment #4) > You may agree that locale dependency adds a lot confusion... ... which is the reason why API *must use locale-INDEPENDENT syntax*. > For example it could work in the manner that if user > enters '=TEXT(A2,"##")' the actual formula written to cell is > '=TEXT(A2;"##")' i.e. it is "fixed" on the fly. ... and if user enters "=SUM(1,2)" it somehow knows that the "," here is meant to be argument separator and not decimal separator? Can you come with a fool-proof way of guessing everything? A programmer MUST USE CORRECT SYNTAX. Period. > With current implementation > I can put two visually identical formulas in two neighbouring cells, and one > of them works fine while another results err:508. And that will be your bug, yes. > And second, the error could be more specific, for example, err:504 > "Parameter list error". Well - yes. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117511] Setting the cell formula from a macro results Err: 508 cell value
https://bugs.documentfoundation.org/show_bug.cgi?id=117511 --- Comment #4 from Dmitry --- Thanks! Indeed it works fine with ";". You may agree that locale dependency adds a lot confusion... For example it could work in the manner that if user enters '=TEXT(A2,"##")' the actual formula written to cell is '=TEXT(A2;"##")' i.e. it is "fixed" on the fly. With current implementation I can put two visually identical formulas in two neighbouring cells, and one of them works fine while another results err:508. And second, the error could be more specific, for example, err:504 "Parameter list error". -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117511] Setting the cell formula from a macro results Err: 508 cell value
https://bugs.documentfoundation.org/show_bug.cgi?id=117511 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #3 from Eike Rathke --- In the API you have to use the non-locale-dependent and not-user-defined ; semicolon parameter separator in spreadsheet functions. This works: Formula = "=TEXT(A2;""##"")" -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117511] Setting the cell formula from a macro results Err: 508 cell value
https://bugs.documentfoundation.org/show_bug.cgi?id=117511 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117511] Setting the cell formula from a macro results Err: 508 cell value
https://bugs.documentfoundation.org/show_bug.cgi?id=117511 --- Comment #2 from Mike Kaganski --- Works for me with Version: 6.0.4.2 (x64) Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 12; OS: Windows 10.0; UI render: GL; Locale: ru-RU (ru_RU); Calc: CL ... after I replace comma (,) in the code with semicolon (;) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 117511] Setting the cell formula from a macro results Err: 508 cell value
https://bugs.documentfoundation.org/show_bug.cgi?id=117511 --- Comment #1 from Dmitry --- Created attachment 141986 --> https://bugs.documentfoundation.org/attachment.cgi?id=141986&action=edit Screenshot of the sheet after running the macro -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs