Bug 119834 - Critical Data Corruption - Search on string caused calc cells to be emptied of data.
Summary: Critical Data Corruption - Search on string caused calc cells to be emptied o...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-09-13 05:31 UTC by Dan Loomis
Modified: 2019-03-21 16:51 UTC (History)
2 users (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 Dan Loomis 2018-09-13 05:31:05 UTC
Description:
I have a spreadsheet on which I ran a search on "steam engine"  There were a number of hits.  After some editing I reran the search and got zero hits.  Every cell that originally contained the search string "steam engine" was empty.  I have a backup and will experiment.
Version: 6.0.6.2 Build ID: 6.0.6.2-1.fc28 CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group

Steps to Reproduce:
1.  Search for a string
2.  Cells containing the string turn up empty


Actual Results:
Data disappeared.

Expected Results:
User entered data should not disappear.


Reproducible: Didn't try


User Profile Reset: No



Additional Info:
I have not tried to reproduce this because I need to sandbox any files I use to reproduce this.
Comment 1 Roman Kuznetsov 2018-09-13 07:42:38 UTC
please attach file with your spreadsheet

please write more clear steps to reprodution
Comment 2 Dan Loomis 2018-09-15 04:33:11 UTC
Thank you for the reply.  The spreadsheet isn't for public release.   I need some time to create a mock up and see if I can reproduce the problem.
The steps I remember are:
Search all sheets for all occurrences of "steam engine"
I went through that section of the spreadsheet applying minor edits.
At some point I noticed a lot of empty cells.  "steam engine" was not the only text in these cells so I doubt it was a careless mouse click on replace all with a blank target field.  
When I reran the search it returned no hits.   
I was not making global changes.  
Please give me a few days to explore reproducing this.
Comment 3 Xisco Faulí 2018-09-17 11:28:49 UTC
Hello Dan,
Thanks for reporting the issue.
If possible, please provide a public sample document to reproduce the issue.
If that couldn't be possible, please send it to me privately. I'm the QA engineer at the Document Foundation and I can investigate it further without compromising your data.
Thanks
Comment 4 QA Administrators 2019-03-21 11:11:59 UTC Comment hidden (obsolete)
Comment 5 Dan Loomis 2019-03-21 16:40:40 UTC
I have been unable to reproduce this problem.   Close the report.   If I reproduce the problem I can reopen.