Bug 99805 - Clicking some character formatting buttons twice does not remove the formatting (see comment #9)
Summary: Clicking some character formatting buttons twice does not remove the formatti...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Character
  Show dependency treegraph
 
Reported: 2016-05-12 17:46 UTC by OfficeUser
Modified: 2024-07-08 13:07 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
issue.ods (11.69 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2016-05-12 17:46 UTC, OfficeUser
Details
Remaining buggy behavior as of v24.2: Overline only (9.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-07-08 13:07 UTC, Eyal Rozenberg
Details

Note You need to log in before you can comment on or make changes to this bug.
Description OfficeUser 2016-05-12 17:46:46 UTC
Created attachment 125014 [details]
issue.ods

Please open the attached spreadsheet. It contains all information.
Comment 1 Theodore Matula Jr. 2016-05-12 23:39:23 UTC
Summary: In Calc, Bold is the only function that removes the partial character formatting and applies a cell formatting. If there are 2 words in a cell, and one word has character formatting (bold, italics, etc), then selecting the whole cell and applying/unapplying said formatting will only override the character formatting if bold is used. In the same example with Italics, underline, etc, applying/unapplying the formatting to the cell will keep the character formatting.

Test with Bold:
1. Open a new Calc spreadsheet
2. Type two separate words in cell A1 (I used "Sky Net")
3. Highlight the second word and right click it. Click Character...
4. Under style, select Bold and click OK.
5. Select Cell A1 and either press the bold Button on the Formatting Bar twice or CTRL+B twice

Result: neither words will be bolded

Test with Italics:
1. Open a new Calc spreadsheet
2. Type two separate words in cell A1 (I used "Sky Net")
3. Highlight the second word and right click it. Click Character...
4. Under style, select Italics and click OK.
5. Select Cell A1 and either press the Italics Button on the Formatting Bar twice or CTRL+I twice

Result: the second word will still be italicized
Comment 2 Buovjaga 2016-05-15 15:52:15 UTC
Confirmed with document.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.2.0.0.alpha1+
Build ID: 1dbdc947fcc9d843764731e6dae7ce60082576e0
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on May 14th 2016
Comment 3 QA Administrators 2017-05-22 13:39:08 UTC Comment hidden (obsolete)
Comment 4 OfficeUser 2017-05-23 06:58:35 UTC
I still can reproduce this bug using:

Version: 5.3.3.2
Build-ID: 1:5.3.3~rc2-0ubuntu0.14.04.1~lo0
CPU-Threads: 8; BS-Version: Linux 4.4; UI-Render: Standard; VCL: gtk2; Layout-Engine: alt; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Comment 5 QA Administrators 2018-05-24 02:45:23 UTC Comment hidden (obsolete)
Comment 6 OfficeUser 2018-05-31 19:57:21 UTC
Bug still reproducible with:

Version: 6.0.3.2
Build-ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU-Threads: 8; BS: Linux 4.4; UI-Render: Standard; VCL: gtk2; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Comment 7 QA Administrators 2019-06-01 02:49:53 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2021-06-01 04:30:31 UTC Comment hidden (obsolete)
Comment 9 Eyal Rozenberg 2024-07-08 12:55:54 UTC
From the originally-reported problems only one remains in effect:

If a cell has a word without overline, followed by a word with overline - pressing the overline button twice keeps the second word with an overline rather than removing it entirely.

... as of:

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: en-IL (en_IL); UI: en-US
Calc: threaded
Comment 10 Eyal Rozenberg 2024-07-08 13:07:00 UTC
Created attachment 195169 [details]
Remaining buggy behavior as of v24.2: Overline only

Reproduction instructions:

0. Add the Overline button to your formatting toolbar (e.g. via right-click, then Visible Buttons > Overline).
1. Open the attached ODS document2
2. Select cell B2 (with the word "test" followed by an overlined coy of the same word)
3. Press the Overline button twice

Expected behavior: No words are overlined.

Actual behavior: The second word is overlined again (and the first isn't).


Note the use of the button is only for convenience you can do this using the Format > Cells... dialog as well.