Apache OpenOffice (AOO) Bugzilla – Issue 101188
Bold type cannot be changed to regular if the first word contains a special character
Last modified: 2009-05-06 21:21:14 UTC
When the first word in a cell contains a special character such as / or * then the contents of the cell cannot be changed from bold to regular type, via either the "B" button on the toolbar or the "Format/Cells/Font" menu or the "Format/Cells" right-button context menu, even after suppression of the special character - see test-data attachment.
Created attachment 61665 [details] Test data for bold type changes
Doubleclick the cell, mark the text and disable B or click on cell and use Format > Default Formatting to remove all hard styles. You have got a lot of formatting problems which I cannot reproduce. Do you use an original OOo version or do you use a version which was provided from someone else, for example from your Linus provider?
I cannot reproduce that on system Windows XP with version OOO310m9 (build:9396). It looks a problem just for Linux OC.
When I select an entire column (col. B) in the attachment Test File_2 for which all entries are in Bold type, then click on the "Bold" icon to reset all entries in the column to regular typeface, the result is that all of the the entries containing "/" are only partially changed to regular type - the characters after the special character remain in bold type. This same result is obtained with both attached test files on another computer running under Windows Vista, so it is not specific to a Linux environment as far as I can understand.
Created attachment 62026 [details] Test File 2 with special characters in Column B data
I can see what you described. But the problem is not the /. If the content of the cell or part of it has got a text style, then this text style will be preserved, when you apply a cell style. Try it with cell E9 in your "Test File_2.xls". It seem to me, that your problem is duplicate to issue 53545. For further explanation read issue 28588 too.
I agree that this issue is the same as the one described in 53545. I do think that there should be a method for enabling a global cell-format change to be enforced (preferably via a button) if more than one cell has been selected (or an entire column or row). For example, for Test File_2 I would like to have a method whereby I can convert all the cells in column B to regular type.
Setting duplicate. You can mark the column and use "Format > Default Formatting", to remove all settings, which are applied to parts of the text. *** This issue has been marked as a duplicate of 53545 ***
closing