Bug 151656 - Formatting within a cell vanished after changing by search and replace
Summary: Formatting within a cell vanished after changing by search and replace
Status: RESOLVED DUPLICATE of bug 38982
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-10-20 13:01 UTC by Roland White
Modified: 2023-02-23 08:29 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file (571.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-10-23 09:15 UTC, Roland White 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Roland White 2022-10-20 13:01:08 UTC 
For example, a cell may contain something like:

Bittner, Jacques: Suite in g-moll [ID2276]; Bach, Johann Sebastian: Suite in e-moll; Benguerel, Xavier: Versus [ID2278]; Rawsthorne, Alan: Elegy; Diabelli, Anton: Sonate [ID2280]

where the entries "IDxxxx" formatted with different character colors. After changing anything all character colors are lost.
Comment 1 Rafael Lima 2022-10-20 13:33:50 UTC 
Hi Roland, thanks for reporting.

Can you please share a sample file where the problem occurs? And also provide which steps we should take to reproduce the bug?

Also, copy and paste the info in the Help - About LibreOffice dialog.
Comment 2 Roland White 2022-10-23 09:15:06 UTC 
Created attachment 183215 [details]
Sample file

Open file "LvB-test.ods". Note that entries "IDxxxx" (column "I") formatted either dark red, green or blue.

Mark column "I".

Invoke search & replace (Ctrl-H).

Replace "Tschaikowsky" (or whatever) by "XXXXXX".

As a result all colors in affected cells are lost.

Release (opensuse 15.4):
Version: 7.3.6.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 12; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.utf8); UI: de-DE
Calc: threaded

Problem is annoying since many years.
Comment 3 Buovjaga 2023-02-23 08:29:08 UTC 

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