[Libreoffice-bugs] [Bug 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 Óvári changed: What|Removed |Added Resolution|--- |WONTFIX Status|UNCONFIRMED |RESOLVED --- Comment #15 from Óvári --- (In reply to Buovjaga from comment #14) > Óvári: can you reply to this? No longer have Windows as we have fully transitioned to GNU/Linux. Thank you -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org --- Comment #14 from Buovjaga --- (In reply to Mike Kaganski from comment #13) > 1. Some situation where decimal dot is not treated as such on a system where > it seemingly should. The questions: What is your Windows decimal separator > setting (although that likely should not affect this)? Why "User Profile > Reset: No"? ;-) Óvári: can you reply to this? -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #13 from Mike Kaganski --- I see two problems here: 1. Some situation where decimal dot is not treated as such on a system where it seemingly should. The questions: What is your Windows decimal separator setting (although that likely should not affect this)? Why "User Profile Reset: No"? ;-) 2. Having such an error made by a user on a locale with decimal comma (like ru-RU), the legitimate error shown in the document disappears after save-and-reload (so the input with dot, which rightfully isn't recognized as a valid separator, is written into the file (where only dot is expected as separator), and then everything is fine) - but I'd expect that error stays error after reload. -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #12 from Óvári --- (In reply to Oliver Brinzing from comment #6) > maybe a problem with "Decimal separator key" ? > -> Menu Tools/Options.../Language Settings/Languages/Decimal separator key No error here, as the decimal separator key is shown correctly -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #11 from Óvári --- (In reply to Oliver Brinzing from comment #9) > the only way i found to reproduce a file like the attached one is > (with: Locale: de-DE (de_DE)): > > 1. In cell A1 type: 48,0417 > 2. In cell B1 type: =A1/1.1 > 3. B1 shows #NAME?, cause decimal separator should be "," > 4. save spreadsheet > > but reloading the file will correct the error. The decimal separator is in Australia is "." not ",". Thank you for your suggestion. Tested your suggestion of saving, closing and re-opening the spreadsheet and this corrects the error; however, shouldn't this error not be present to begin with? -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #10 from Óvári --- (In reply to raal from comment #8) > CTRL-SHIFT+F9 helps? No -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #9 from Oliver Brinzing --- the only way i found to reproduce a file like the attached one is (with: Locale: de-DE (de_DE)): 1. In cell A1 type: 48,0417 2. In cell B1 type: =A1/1.1 3. B1 shows #NAME?, cause decimal separator should be "," 4. save spreadsheet but reloading the file will correct the 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 raal changed: What|Removed |Added CC||r...@post.cz --- Comment #8 from raal --- CTRL-SHIFT+F9 helps? -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #7 from Mike Kaganski --- (In reply to Oliver Brinzing from comment #6) > maybe a problem with "Decimal separator key" ? ... which shouldn't be a problem; en-AU and en-GB use decimal dot; and - no problem with ru-RU, which uses decimal comma. > -> Menu Tools/Options.../Language Settings/Languages/Decimal separator key ... which is a different unrelated setting, telling what to do when a specific key is pressed on keyboard, not about which separator to use (see [1]). [1] https://help.libreoffice.org/latest/en-US/text/shared/optionen/0114.html -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #6 from Oliver Brinzing --- no repro with: Version: 6.3.0.4 (x64) Build ID: 057fc023c990d676a43019934386b85b21a9ee99 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: xml representation of attached file is: text:p>48.04167 #NAME? maybe a problem with "Decimal separator key" ? -> Menu Tools/Options.../Language Settings/Languages/Decimal separator key -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #5 from Óvári --- (In reply to Óvári from comment #4) When installing: 1. `Optional Components` --> `Dictionaries` --> all unselected except `English` and `Hungarian` 2. `Additional user interface languages` were all unselected except `English (United Kingdom)` Thank you -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #4 from Óvári --- Created attachment 153225 --> https://bugs.documentfoundation.org/attachment.cgi?id=153225=edit Screenshot with LibreOffice 6.3.0.4 (x64) Maybe there is more information in the screenshot that can help? When LO was installed, only the English (GB) was selected. English (US) etc was unselected. Hope this helps in reproducing this bug. Thank you -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #3 from Mike Kaganski --- And also *cannot* repro with the same but Calc: threaded -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #2 from Mike Kaganski --- Cannot repro with Version: 6.3.0.4 (x64) Build ID: 057fc023c990d676a43019934386b85b21a9ee99 CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: CL -- 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 126765] Divide give #NAME? on Windows 8.1
https://bugs.documentfoundation.org/show_bug.cgi?id=126765 --- Comment #1 from Óvári --- Created attachment 153223 --> https://bugs.documentfoundation.org/attachment.cgi?id=153223=edit Test file Cell B1 incorrectly shows #NAME? on Windows 8.1 Cell B1 correctly shows the value on Linux Mint 19.2 Thank you -- 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