Bug Hunting Session
Bug 85981 - 4.2.7 results in data loss and should be pulled immediately
Summary: 4.2.7 results in data loss and should be pulled immediately
Status: RESOLVED DUPLICATE of bug 81633
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.7.1 rc
Hardware: All All
: medium blocker
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-11-07 01:21 UTC by Andrew Cunningham
Modified: 2015-06-08 17:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Andrew Cunningham 2014-11-07 01:21:43 UTC
My computer automatically upgraded from 4.2.6 to 4.2.7 since it's supposed to be a "stale" release with only security and bug fixes. For some reason, the perfectly good sorting was changed to one that is scrambling users  spreadsheets.As I've been saving over my old spreadsheet, now I've lost all my work for the week. It's very unprofessional to make a change like this to the stable line.

This release should be pulled from the download site and replaced with 4.2.6 until you can straighten out your sorting bugs.
Comment 1 Luke 2014-11-07 02:35:23 UTC
Andrew
This likely stems from Bug 81633 and is similar to Bug 85614. Can you please attach a sample of one of your scrambled spreadsheets along with a description of how to sort it? 

JBF,
Do you need more test cases for Bug 85490?
Comment 2 Jean-Baptiste Faure 2014-11-07 05:49:44 UTC
(In reply to Luke from comment #1)
> Andrew
> This likely stems from Bug 81633 and is similar to Bug 85614. Can you please
> attach a sample of one of your scrambled spreadsheets along with a
> description of how to sort it?

Note: in some cases it is easy to restore the original order. For example in cases like bug 81633 test case "bank account" (attachment 108255 [details]).

> 
> JBF,
> Do you need more test cases for Bug 85490?

From those complaining against the change in 4.2.7 (bug 81309), I think no, unless there is case where sorting produce an _unrecoverable_ disorganization of the spreadsheet which can be seen as a dataloss.

From those needing this change, yes because I still not have a clear use-case from real life in which this change is needed.

Best regards. JBF
Comment 3 Andrew Cunningham 2014-11-09 05:21:17 UTC
@Jean-Baptiste Faure
Thank you for your concern. The problem is you can only undo if you haven't pressed the save button. Also, I use my spreadsheets by copy and pasting data into the tables that need to be sorted. By the time I noticed anything was wrong, formulas had been totally scrambled by 4.2.7. 

Did you know the undo sort in 4.2.7 is buggy? I use this feature all the time, but now it only partially undoes the sort. How can you do this to a stable releases? People choice LTS and stable releases so they can do work, not be bug testers. For my home computer that's fine, but not for when I want to do some work.

I will check with my boss tomorrow to see if I can attach my spreadsheet to this report. Thanks for you help and understanding!
Comment 4 Jean-Baptiste Faure 2014-11-09 17:59:12 UTC
Hi Andrew,

I didn't write "undo" but "restore". In cases like attachment 108255 [details] it is enough to propagate the formula from the top of the mangled column.

What is your OS. I guess it is Linux (<-automatic update), but which distribution? 

Best regards. JBF
Comment 5 QA Administrators 2015-06-08 14:28:44 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!

This NEEDINFO Message was generated on: 2015-06-08

Warm Regards,
QA Team
Comment 6 Luke 2015-06-08 17:21:55 UTC
This was like fixed in 4.2.8, Bug 81633. Please reopen if it was not.

*** This bug has been marked as a duplicate of bug 81633 ***