https://bugs.freedesktop.org/show_bug.cgi?id=84767
Bug ID: 84767
Summary: Calc crashes after sort when not saved
Product: LibreOffice
Version: 4.2.6.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 107525
--> https://bugs.freedesktop.org/attachment.cgi?id=107525&action=edit
This is a sanitized version of the spreadsheet where I'm having problems.
Every time I sort within CALC, it aborts UNLESS I have JUST saved the file. In
other words, if I make any edits, then sort the data, it aborts. Mind you it
saves the info first and recovers pretty well. However, I find that the first
column of my sorted info is sorted but the remaining columns are not. Thus I
now have a data mis-match.
This is my check register.
Col A is the day of the month.
Col B is whether the check has cleared (1 = cleared, 0 = not cleared)
Col C is who I sent the check to.
Col D is the amount of the check (negative is a check)
Col E is a deposit (positive number)
I will enter info in columns A, C, and (D or E). Then I will highlight a range
of cells that I wish to sort by date. For instance I'll highlight A5:E18, then
choose Data, Sort, Sort Key 1 = Column A. As soon as I hit OK, I get an error
message that LO needs to restart and saves the data. However, after the
recovery, everything is like it was before it aborted EXCEPT that column A is
already sorted.
I'm not sure this happens EVERY time but it's pretty close. Now save the file
before I sort (but occasionally forget). I'm always frustrated. This also
happened in the previous version of LO that I had (don't recall the version).
The only unique features I have are the conditional formatting and the formula
in column G. The conditional formatting looks for a 1 in Col B. If it is 1,
then Cols A, B, and C turn blue (check has cleared). Also, in Col G, the
formula is looking for a 1 in Col B to included that line's value in the
Cleared total. However, NOTHING is looking for anything to do with the date
(Col A, the sort key).
Let me know if you need screen captures of the error messages or showing the
error happening.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
