[Libreoffice-bugs] [Bug 136272] New: Corrupted calc file: invalid number format condition [<= 1.79769313486232E+308 ]

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136272

            Bug ID: 136272
           Summary: Corrupted calc file: invalid number format condition
                    [<= 1.79769313486232E+308 ]
           Product: LibreOffice
           Version: 7.0.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dave at excellentsite.com

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 ]"  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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200829/b484b470/attachment.htm>