Bug 166053 - When the font format of a cell is bold, the corresponding parentheses in the formula cannot be identified
Summary: When the font format of a cell is bold, the corresponding parentheses in the ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2025-04-06 13:31 UTC by nobu
Modified: 2025-08-14 18:45 UTC (History)
5 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 nobu 2025-04-06 13:31:30 UTC
Description:
When the font format of a cell is bold, the corresponding parentheses in the formula cannot be identified.

Steps to Reproduce:
1. Open new Calc
2. Insert "=((1))" in Cell [A1] 
3. Edit Cell [A1]
4. When you place the cursor over a parenthesis in an expression, the corresponding parenthesis becomes bold and can be identified.
5. Bold the font formatting for Cell [A1].
6. Edit Cell [A1]
7. Hover the cursor over the expression parentheses.

Actual Results:
8. The corresponding parenthesis cannot be identified.

Expected Results:
8. The corresponding parentheses can be identified.


Reproducible: Always


User Profile Reset: No

Additional Info:
We need an idea to identify the corresponding parentheses.

Reproducible with

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 0d0e5c72e6344de48227b74846a6ff638b803c64
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded
Comment 1 Jessica 2025-04-07 07:49:06 UTC
Thank you for reporting the bug. I can not reproduce the bug in

Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-GB
Calc: threaded
Comment 2 Jessica 2025-04-07 08:02:28 UTC
And I also can't reproduce it in 

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 22ef238e820955f6f8ac84781289b8a1d8e477b9
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
Comment 3 mikhail.machine 2025-04-08 06:02:18 UTC
Hello nobu,

Thank you for reporting the bug. I can confirm that the bug is present in master. 

Please note: identification of parentheses is done by making them bold. In case all symbols are bold identification cannot be detected.

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a8ec21adf255b70bb6eeb0a1717190df303d8b26
CPU threads: 12; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded

and

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded
Comment 4 nobu 2025-04-10 06:35:42 UTC
Reproducible with

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7c46846ad1aeeca7e38eb0aada6dc99b5fb701e3
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
Comment 5 nobu 2025-04-10 06:37:09 UTC Comment hidden (obsolete)
Comment 6 Brandon H. 2025-04-10 22:29:33 UTC
I am able to reproduce on 

Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: fa357e4a0a44471637373302c4391e6b0c2f1a20
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Although, I wouldn't say this is a bug, but maybe there can be a change to make it easier to identify the parentheses.
Comment 7 meagan.eggert 2025-04-14 03:04:30 UTC
Version 25.2.1.2
Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49
CPU threads: 8; OS: Windows 11 x86_64
UI render: Skia/Raster; VCL: win
Locale: en-US; UI: en-US
Calc: threaded

I can confirm the behavior, but I'm not sure it is a bug. Potentially something the UX team can look at regarding being able to identify parentheses when text is already bold.
Comment 8 BogdanB 2025-07-13 18:15:10 UTC
UX Team -- please take a look at this enhancement. Thanks!
Comment 9 Heiko Tietze 2025-08-14 11:59:42 UTC
We discussed the topic in the design meeting. The following options are feasible:

a) resolve NAB/WF; if a user messes up with the formatting so it should be
b) (temporary) drop all formatting in edit mode
c) invert the format and show the corresponding bracket in regular weight
   if the character is bold

Option c) seems to be a good compromise.
Comment 10 Eyal Rozenberg 2025-08-14 18:45:51 UTC
I will also note that if and when we get traction on bug 35538, and the UI supports a range of font weights, this question will become more complicated, since we will no longer have a two-state bold/not-bold situation.