Bug 133936 - Find & Replace removing bold
Summary: Find & Replace removing bold
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 134044 134406 (view as bug list)
Depends on:
Blocks: Find-Search
  Show dependency treegraph
 
Reported: 2020-06-12 16:22 UTC by Devamitta
Modified: 2025-04-23 03:10 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
FIND&REPLACE (289.13 KB, image/jpeg)
2020-06-12 16:22 UTC, Devamitta
Details
FIND&REPLACE problem (51.03 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-06-13 01:43 UTC, Devamitta
Details
replace for example word seyyathāpi (377.81 KB, image/jpeg)
2020-06-13 01:45 UTC, Devamitta
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Devamitta 2020-06-12 16:22:49 UTC
Created attachment 161926 [details]
FIND&REPLACE

When I Find & Replace word with another word, and push REPLACE ALL, it is removing all formatting what I have in cell, particularly bold text. After replace all - all bold text in cell become normal text. Is it a bag, or it is should be like this?
Comment 1 V Stuart Foote 2020-06-12 18:39:58 UTC
Could not duplicate with
Version: 6.4.4.2 (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 8; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: CL

The default Find & Replace string/string Replace (or Replace All) left the direct formatting (I checked Bold and Underline) in place on the replaced strings. 

Need better steps to reproduce and a sample document.
Comment 2 Devamitta 2020-06-13 01:43:12 UTC
Created attachment 161937 [details]
FIND&REPLACE problem
Comment 3 Devamitta 2020-06-13 01:44:07 UTC
Comment on attachment 161937 [details]
FIND&REPLACE problem

this is the example
Comment 4 Devamitta 2020-06-13 01:45:35 UTC
Created attachment 161938 [details]
replace for example word seyyathāpi

replace for example word seyyathāpi
Comment 5 Devamitta 2020-06-13 01:48:23 UTC
I attached file with example.
If I find and replace word seyyathāpi with seyyathā'pi (like in screenshot)
this action REPLACE or REPLACE ALL clean the bold what I have in cells.
Even if I go back CTRL+Z it does not return to bold
Comment 6 Devamitta 2020-06-13 01:51:07 UTC
I use
Version: 6.4.4.2 (x86)
Comment 7 QA Administrators 2020-06-13 03:43:24 UTC Comment hidden (obsolete)
Comment 8 dante19031999 2020-06-17 14:56:09 UTC
Tested on:
Linux, LO 7.0 beta: bug is there.
Linux, LO 6.4 : bug is there.

This could be a duplicate of bug 134044.
Comment 9 aadijain 2020-06-30 17:54:47 UTC
Thanks for reporting the bug. However, I could not reproduce the bug in 

Version: 6.4.4.2 (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 10 Sea Mac 2020-07-12 15:06:49 UTC
Tested on Mac 10.13 LO6.3.6.2 in both Calc / and Writer - No Bug ... formatting preserved in replaced items.
Comment 11 Xisco Faulí 2020-07-14 10:48:46 UTC

*** This bug has been marked as a duplicate of bug 134044 ***
Comment 12 V Stuart Foote 2020-07-14 14:10:48 UTC
*** Bug 134044 has been marked as a duplicate of this bug. ***
Comment 13 V Stuart Foote 2020-07-14 14:11:16 UTC
*** Bug 134406 has been marked as a duplicate of this bug. ***
Comment 14 V Stuart Foote 2020-07-14 14:12:54 UTC
a little QA cleanup
Comment 15 V Stuart Foote 2020-07-14 14:20:40 UTC
STR from dupe bug 134406 

<clip>
Created attachment 162529 [details]
example spreadsheet

I following file there are actions:
1. Select the column
2. Find & Replace
3. 'having' with 'having done'
4. Replace All
5. After this or any other replacement all text in the cells become normal, without bold.

Created attachment 162530 [details]
this action
</clip>
Comment 16 QA Administrators 2022-07-15 03:44:27 UTC Comment hidden (obsolete)
Comment 17 Safeer Pasha 2023-04-23 15:15:42 UTC
Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

just tested, the bug does NOT exist anymore.
Comment 18 Safeer Pasha 2023-04-23 15:16:15 UTC
Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

just tested it, the bug does NOT exist anymore.
Comment 19 QA Administrators 2025-04-23 03:10:19 UTC
Dear Devamitta,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug