Bug 72473

Summary:	Sorting in Calc crashes workbook
Product:	LibreOffice	Reporter:	Petr Neudek <neutr>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID	QA Contact:
Severity:	blocker
Priority:	high	CC:	jbfaure
Version:	4.2.0.4 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:

Description Petr Neudek 2013-12-08 11:28:06 UTC

When sorting - two columns of about 900 lines of crashes that dialogue is described as follows:
VECTOR <T>
Invalid subscript.
- The file was saved just before it (total of 3 times) and is given the choice of "always save a copy"
- Restoring a file opens as blank.
-------------------------------------------------- ------------------
- This is what I found out first on an unsaved workbook. He will appear in the "Restoring a document and" but during the first phase jumps message: -
The file $ (ARG1) $ can not be repaired therefore can not be opened.
-------------------------------------------------- ------------------
For sure the whole process here:
- Open a new workbook> Link to external data.
- In the dialog to insert a link to http://www.openoffice.org/api/docs/common/ref/com/sun/star/awt/Key.html
- Now you must press enter (this is not normal - another opportunity to confirm and does not even AOO - WHY?!)
- Reads the segments of html and pick the Table.
- Then press enter in the dialogue (which is between activated - before it was not).
- Get my table "Constants group Key"
- Following the "Edit"> "Disconnect link" + confirm.
- Save
- I want to extract some lines - like this "const short NUM1 = 257"
- You are all in the "A", because in the "B" copy question IF(yes=ROW(),not="")
- Reads entire column "B" in mind and put back only value.
- Save the workbook again
- Select the correct section Ax:By
- Asks "Data"> Sort> "B" (there are line numbers, so order as in html remains)
- Enter = fall workbook (LO remains without falling).

Comment 1 Petr Neudek 2013-12-08 20:12:15 UTC

Please be careful.
Similar expressions is "maybe" also Writer. One student described that came after the fall of the seminar work.
It's here - but in the Czech language. Unfortunately, not whether the LO used and what version. But speech is very similar. Waiting for the backlash. It may not come (probably not have the time - wrote seminal work from the beginning).
Original Source: http://forum.openoffice.cz/viewtopic.php?pid=15272
- I tried to contact him and I asked for an urgent reply. But this probably will not succeed. I myself have examined over hexaeditor. The body of work is completely empty.
- In the process of transcription end ODT / ZIP system can not open the zip archive. Hexaeditor shows that there is not one bit and I got it about 35 kilobytes
- I do not do unnecessary alarm, but it may be a mistake LO. It is very annoying. Few people use the option "save a copy", which should seek to avoid. Perhaps it would be sufficient to set the default "save a copy" and give the opportunity to turn this off.

Comment 2 Petr Neudek 2013-12-09 09:49:24 UTC

(In reply to comment #1)
> Please be careful.
> Similar expressions is "maybe" also Writer. One student described that came
> after the fall of the seminar work.
> It's here - but in the Czech language. Unfortunately, not whether the LO
> used and what version. But speech is very similar. Waiting for the backlash.
> It may not come (probably not have the time - wrote seminal work from the
> beginning).
> Original Source: http://forum.openoffice.cz/viewtopic.php?pid=15272
> - I tried to contact him and I asked for an urgent reply. But this probably
> will not succeed. I myself have examined over hexaeditor. The body of work
> is completely empty.
> - In the process of transcription end ODT / ZIP system can not open the zip
> archive. Hexaeditor shows that there is not one bit and I got it about 35
> kilobytes
> - I do not do unnecessary alarm, but it may be a mistake LO. It is very
> annoying. Few people use the option "save a copy", which should seek to
> avoid. Perhaps it would be sufficient to set the default "save a copy" and
> give the opportunity to turn this off.

This my warning is not justified. The referenced error Writer became the ApacheOffice.

Comment 3 Jean-Baptiste Faure 2013-12-18 12:08:03 UTC

Who is confirming this bug report ?

Best regards. JBF

Comment 4 CJ 2014-02-13 02:35:05 UTC

Fresh install of LibreOffice on Win7 
Have sorted on one field, file of about 3000 rows. Every time it crashes. 
This makes the software useless for me.

Comment 5 Jean-Baptiste Faure 2014-02-13 20:34:49 UTC

(In reply to comment #4)
> Fresh install of LibreOffice on Win7 
> Have sorted on one field, file of about 3000 rows. Every time it crashes. 
> This makes the software useless for me.

Did you try with version 4.1.5 ? Your problem seems different from this one
Please file another bug report. Don't forget to attach an example document.

Best regards. JBF

Comment 6 Jean-Baptiste Faure 2014-02-13 20:36:29 UTC

Due to comment #2 closing as invalid. Please feel free to reopen if I understood wrongly.

Best regards. JBF

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.