Bug 92447 - sub-cell text style is removed/misapplied during search/replace
Summary: sub-cell text style is removed/misapplied during search/replace
Status: RESOLVED DUPLICATE of bug 38982
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-30 08:59 UTC by localcbug
Modified: 2023-05-22 17:08 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 localcbug 2015-06-30 08:59:52 UTC
Steps to reproduce:
1) in a  new spreadsheet, enter text "AAABBB" into a Calc cell
2) select the "AAA" part of text
3) from toolbar, select "Font Color" and apply any color to AAA
4) the cell now contains "<color>AAA</color>BBB"
4) press Ctrl-H to open the Search & Replace dialog
5) Search for "B", Replace with "C", press Replace

Bug A:

Expected behaviour:
Cell should contain "<color>AAA</color>CCC".

Actual behaviour:
Cell contains "AAACCC".

This is an errorneous behaviour I was able to reproduce. A similar errorneous behaviour I originally encountered in an .xls file (saved both in Excel and Calc) resulted in "<color>AAACCC</color>" after performing the same steps (on different text with the same style).


Bug B:
Expected behaviour:
Press Ctrl-Z to undo. Cell should contain "<color>AAA</color>BBB".

Actual behaviour:
Press Ctrl-Z to undo. Cell contains "AAABBB".
Comment 1 Marc Kaulisch 2015-06-30 09:13:01 UTC
Hello localcbug,
Thank you for reporting the bug. 

For Bug A: I can confirm that the bug is present in LO 4.4.5 and  LO 5.0.0.2 64bit on Win8.1.

For Bug B: I cannot (!) confirm that the bug is present in LO 4.4.5 and  LO 5.0.0.2 64bit on Win8.1.
Comment 2 QA Administrators 2016-09-20 10:13:53 UTC Comment hidden (obsolete)
Comment 3 Thomas Lendo 2018-03-26 14:51:25 UTC
I can reproduce both issues with

Version: 6.1.0.0.alpha0+ (x64)
Build ID: 751191ed2d7d6af6eddc3d738e8c45b0a2ab2572
CPU threads: 8; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-03-22_00:36:35
Locale: de-AT (de_AT); Calc: CL

Bub B is covered with bug 38982 (Calc [EDITING, FORMATTING] find & replace causes default formatting to be applied to cells, undo working incorrectly).
Comment 4 QA Administrators 2019-03-27 03:40:23 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2023-01-11 03:23:30 UTC Comment hidden (obsolete)
Comment 6 Stéphane Guillou (stragu) 2023-05-22 17:04:23 UTC
Marking as duplicate of bug 38982, which covers exactly the two issues described here: loss of (partial) formatting, and inability to undo.

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