[Libreoffice-bugs] [Bug 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Version|7.0.0.3 release |5.1 all versions Status|NEW |ASSIGNED -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #16 from Eike Rathke --- @Xisco, it happens when you open the file in Gnumeric. We need to write a not (or less) rounded value 1.7976931348623157e+308 instead. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #15 from Xisco Faulí --- Meanwhile, I found bug 138507 while checking this issue in master @Eike, in which file is it possible to reproduce the 1.79769313486232e+308 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org --- Comment #14 from Xisco Faulí --- The three files open within 1-2 seconds for me in Version: 7.0.3.1 (x86) Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); Interfaz: es-ES Calc: threaded I can't reproduce the "General ODF error Corrupted file: invalid number format condition [<= 1.79769313486232E+308 ]" error either... -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #13 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/28521056a22719dffa0814883d06a7c9531b02ad Related: tdf#136272 accept 1.79769313486232e+308 as DBL_MAX It will be available in 7.0.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 Commit Notification changed: What|Removed |Added Whiteboard|target:7.2.0|target:7.2.0 |target:7.1.0.0.beta2|target:7.1.0.0.beta2 ||target:7.0.5 -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #12 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/711e69e333faaf0570ddf2cb1fc721bc59cc61bc Related: tdf#136272 accept 1.79769313486232e+308 as DBL_MAX It will be available in 7.1.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 Commit Notification changed: What|Removed |Added Whiteboard|target:7.2.0|target:7.2.0 ||target:7.1.0.0.beta2 -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 Ming Hua changed: What|Removed |Added CC||ming.v@qq.com --- Comment #11 from Ming Hua --- Can not reproduce with 6.4.7 on Windows 10: Version: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; Locale: zh-CN (zh_CN); UI-Language: en-US Calc: threaded Both sample ODS files (attachment 164858 and attachment 167009) opens in 1-2 seconds for me. However the first one looks empty. The second one looks normal, 12 rows and 180 cols of data, no error messages. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #10 from Commit Notification --- Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ee2cc952eeb5385ee37485c822d7ad7abd8fb989 Related: tdf#136272 accept 1.79769313486232e+308 as DBL_MAX It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 Commit Notification changed: What|Removed |Added Whiteboard||target:7.2.0 -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #9 from Eike Rathke --- Apart from the double max value string representation being off limits to be read in again, regarding any performance slowdown this all doesn't make sense. The value occurs only once in the document and is discarded anyway because it is a condition for a text number subformat which it is not needed in the number format or UI, but in ODF subformat style maps can't be stored without a condition; when read in it results in the MM/DD/YY;@ format it was before. (in fact the entire explicit text subformat isn't needed at all and MM/DD/YY would be sufficient but that's how Excel stores these so probably the document originated there). However, I'll add a fix for the string representation, but it will likely not change anything for the Windows slowness. Not running Windows myself I can't check. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #8 from d...@excellentsite.com --- I tried opening the corrupted files with the Linux version of LibreCalc. The files open normally (less than a second) with Linux. So, this issue seems to be isolated to the Windows environment. I did not try saving the file with Linux to see if that fixes the issue (like Gnumeric fixes). If you need me to try that, let me know. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #7 from d...@excellentsite.com --- Created attachment 167010 --> https://bugs.documentfoundation.org/attachment.cgi?id=167010=edit This file opens in the normal / expected time (about 1 second). This is the fixed version of the file I previously uploaded (167009). It is an exact copy of file 167009 that has been opened and fixed with Gnumeric and then saved. As you can see, after Gnumeric fixed the file, it is smaller (22,513 bytes instead of 41,416 bytes) and takes less than a second to load. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #6 from d...@excellentsite.com --- Created attachment 167009 --> https://bugs.documentfoundation.org/attachment.cgi?id=167009=edit This file takes about 5 minutes to open with LibreCalc. This file contains more data than the original file I uploaded. When this file is opened with LibreCalc, it takes about 5 minutes to open and doesn't show any errors. When this file is opened with Gnumeric, it opens very quickly (less than a second) and shows the invalid number format condition error. It's odd that this file takes so long to load since it's only 41,416 bytes. If this file is opened with Gnumeric and (after getting the error) then saved, the file will open very quickly (less than a second). I will upload a copy of the fixed (with Gnumeric) version of this file for comparison. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #5 from d...@excellentsite.com --- One more thing. These corrupted files take 15 minutes to open on multiple computers. Since it's slow opening on multiple computers, it doesn't appear to be a problem related to a specific computer or configuration. It's a data file issue. And, opening, fixing and saving the file with Gnumeric fixes the problem on multiple computers. I can check multiple platforms if needed. Typically, we use the Windows version of LibreCalc, but we have access to Linux and can see if it exhibits the same slow opening issue. Let me know if that's needed. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #4 from d...@excellentsite.com --- Thank you for your response. Hopefully, that will fix the issue. The file I attached probably doesn't seem to expose a performance problem. However, with a file that has more data (only 190 rows by 12 columns) it takes 15 - 20 minutes for the file to open. This is on an 8-core CPU and takes this long to open whether opening the file across a network or from the local hard disk. Gnumeric opens the file in less than 5 seconds. Once opened, fixed (by Gnumeric) and saved, Libreoffice is able to open the file in a reasonable amount of time (less than 5 seconds). Perhaps filling the file with more data would amplify the performance issue. Or, compare the time to open the file I attached with opening a completely empty file (which the file I attach is basically - as there is no data in any of the cells). Another possibility is for me to upload a file that is populated with more data. Perhaps that would show how incredibly slow it is (no exaggeration - about 15 minutes) to open the file. If you want me to upload a file with more data, let me know. Thanks again. Let me know if you have any further questions. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||er...@redhat.com Hardware|x86-64 (AMD64) |All Ever confirmed|0 |1 OS|Windows (All) |All --- Comment #3 from Eike Rathke --- Problem seems to be that 1.79769313486232E+308 is the double max value 1.7976931348623157e+308 rounded to 15 significant digits, which when read in and converted from string is not representable as a double value, hence does not form a valid condition. Though the attached file does not expose a performance problem. However, the double max value representation needs to be fixed. -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #2 from Janson Van --- (In reply to dave from comment #0) > Description: > FILEOPEN / FILESAVE A Calc file takes a long time to open (5 - 10 minutes). > Copied and pasted data (190 rows by 12 columns) from the corrupt file to a > new file and it worked fine for a while but now does the same thing. > LibreCalc shows no error message. I removed all of the data from the > spreadsheet and saved the file. It still takes a while to open for being an > empty file. But, doesn't take 5 minutes to open. Downloaded Gnumeric and > opened the file with with it. Gnumeric shows the error "General ODF error > Corrupted file: invalid number format condition [<= 1.79769313486232E+308 https://updato.com/reviews/best-bluetooth-headphones-for-iphone/ ]" > and then opens the file. Saving the file with Gnumeric fixes the issue. > The file opens in seconds now with LibreCalc, but it will most likely become > corrupted again as copying the data to a totally new spreadsheet didn't fix > the issue. I will attach a copy of the corrupted file with the data removed. > > Steps to Reproduce: > 1. Open the corrupted Calc file with LibreCalc. It takes about 17 seconds > (more than 5 minutes when it has data). > 2. Compare this with opening an empty Calc file with LibreCalc (takes about > 5 secons) > 3. Open the corrupted Calc file with Gnumeric and see the error message. > > Actual Results: > File takes a long time (5 - 10 minutes) to open (with 190 rows by 12 > columns) of data. > > Expected Results: > Should take less than 5 seconds to load even with 180 rows by 12 columns of > data. > > > Reproducible: Always > > > User Profile Reset: Yes > > > OpenGL enabled: Yes > > Additional Info: > Version: 7.0.0.3 (x86) > Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e > CPU threads: 16; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: > win > Locale: en-US (en_US); UI: en-US > Calc: threaded Following -- 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 136272] Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]
https://bugs.documentfoundation.org/show_bug.cgi?id=136272 --- Comment #1 from d...@excellentsite.com --- Created attachment 164858 --> https://bugs.documentfoundation.org/attachment.cgi?id=164858=edit Corrupted LibreCalc fle -- 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