Bug 69152

Summary:	Replacing contents of empty cells then undoing locks up LibreOffice
Product:	LibreOffice	Reporter:	Jonathan Ryshpan <jonrysh>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	jbfaure, jmadero.dev
Priority:	medium
Version:	4.2.0.0.alpha0+ Master
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Jonathan Ryshpan 2013-09-09 21:55:47 UTC

A: Find and replace all empty cells with some value:

1 Edit -> Search & Replace
2 Search for nothing but check "[x] Entire cells"
3 Insert into the "Replace With" field the replacement value
4 Click Replace All

Everything works as advertised.

B: Now click Undo.  LibreOffice locks up using almost 100% of a CPU.


It's possible to *save* the edited spreadsheet and reload it.  The reloaded spreadsheet works fine.

Comment 1 Joel Madero 2013-11-15 23:29:22 UTC

3 Insert into the "Replace With" field the replacement value
4 Click Replace All

Everything works as advertised.

What does "everything works as advertised" mean - you mean it says "search key not found"? At which point you push "ok"  then close the search and replace dialog, then do undo?

If so, I can't confirm this issue

Comment 2 Jonathan Ryshpan 2013-11-16 19:38:54 UTC

Works as advertised means that empty cells are replaced with the proposed replacement value; there are now no empty cells in the document anywhere above and to the left of the lower right most cell with an entered value.  Calc is now better, since it no longer locks up (the bug was reported two months ago); however undo doesn't undo the replacement.

Thanks for your help - jon

Comment 3 Jean-Baptiste Faure 2013-12-07 19:30:27 UTC

Not reproducible for me with version 4.2.0.0.beta2+ Build ID: 9bb72868b846a7ba7e8f985a87e944fb760a0f10 under Ubuntu 13.10 x86-64
Calc answers "Search key not found". I tried with both choices how to handle empty cells (as zero or not).

So closing as NotABug. Please, feel free to reopen if you still experience the behavior you described and you can provide some information helping to reproduce it.

Best regards. JBF