Bug 128470 - Cannot insert row until deleted one
Summary: Cannot insert row until deleted one
Status: RESOLVED FIXED
Alias: None
Product: calligrasheets
Classification: Applications
Component: opendocument (show other bugs)
Version: 1.5.1
Platform: Debian testing Linux
: NOR normal
Target Milestone: ---
Assignee: Laurent Montel
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-01 23:53 UTC by Frederik Schwarzer
Modified: 2006-08-03 08:52 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
File that behaves as described above (20.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-06-01 23:56 UTC, Frederik Schwarzer
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Frederik Schwarzer 2006-06-01 23:53:17 UTC
Version:           1.5.1 (using KDE KDE 3.5.2)
Installed from:    Debian testing/unstable Packages
OS:                Linux

I cannot insert a row in my document.
I have to delete one row before.
As this doesn't happen to me with new documents, I will attach the one to the report.
Sorry for not having more information.
Comment 1 Frederik Schwarzer 2006-06-01 23:56:31 UTC
Created attachment 16418 [details]
File that behaves as described above

I created the file with kspread and had a few crashes since then similar to
#114635. So maybe it got corrupt.
Comment 2 Frederik Schwarzer 2006-06-02 00:57:04 UTC
Just found out, that the file "content.xml" is about 3MB in size and has many (about 950000) identical lines.
Comment 3 Sebastian Sauer 2006-08-03 00:37:17 UTC
Hi Frederik,

first a lot of thanks for the bugreport. The attached document has a lot of empty rows (>=32767) and it looks as that may the reason why KSpread 1.5.x does take ages to load the file and why it's not possible to insert new rows (so, more then 32767 rows).

KSpread 1.6 still needs ages to load the document and once loaded, does not allow to insert a new row too. But once you saved the document again, KSpread cuts the empty additional lines away. So, just save the document and the file will be much smaller on the one hand and allows insert of new rows on the other. Also loading the document is much faster then.

So, I confirm that bug and even if I would see it as fixed (since KSpread 1.6 does handle it correct once saved), I'll leave it open for the case you may see it as bug, that KSpread does not recognize, that the 32767 cells are empty on initial loading (so, before saving the first time).
Comment 4 Frederik Schwarzer 2006-08-03 01:08:02 UTC
It's good to hear that v1.6 fixes this sort of corrupt files. :)

But I do not feel to decide whether this report should be closed or not.
There sure could be a check for this sort of defective file on load. But it's not on me to demand that. If you think it should be there, let it open. Otherwise, close it. :)

Thanks for the great work.
regards
Comment 5 Sebastian Sauer 2006-08-03 01:12:50 UTC
Ok, then I'll close that report :) and again a lot of thanks for the feedback!
Comment 6 Stefan Nikolaus 2006-08-03 08:52:53 UTC
Just for the record: KSpread does not cut these rows away. As they have the same content, they're stored in one XML element, which has a repeated x times attribute. Plus: KSpread saves and loads a default row/column style now. That's the actual fix for this problem.
Before, all possible 32767 rows were occupied (with non-default rows) and you were not able to insert another one. This sucks badly btw, but I'll will touch this fragile piece of code for 1.6.
Anyway, thanks for your report.