I would like to change font in the formula bar to a monospaced font, or at least have the option to do so. Of all the places, the formula bar is where you can least afford to confuse “I” with “l” with “1” and where counting parentheses needs all the help it can get. I also think that the change to italics is a bad one. Most screens do not render italics as cleanly as regular fonts, and some characters do not display as distinctly when displayed in italics. The same applies, by the way, to the sheet tab names.
Thank you for filing this issue.
Migrating Whiteboard tags to Keywords: (needsDevEval, topicUI) [NinjaEdit]
Is there any news on this? I notice that the font is not in italics. It’s been a while … ?
*** Bug 162238 has been marked as a duplicate of this bug. ***
+1
I was about to file the same bug, particularly for multiline editing. When you click the arrow on the right of the formula bar in Calc, you can create a nicely-formatted multi-line formula to facilitate reading and troubleshooting the formula. However, if you use a formula like this (with linebreaks done with Shift+Enter): = SUM($'Summary invoicing pivot table part 1'.D25:M25) - SUM($'Summary invoicing pivot table part 2'.D32:N32) + SUM($'Summary invoicing pivot table part 3'.D25:G25) * A12 …it becomes apparent (as you will be able to see in screenshot I will attach) that LibreOffice uses a variable-width system font to display the contents of the multiline input field, as the words and characters don't line up at the beginning of the lines etc. For such usecases, it would be better if LibreOffice Calc used the system's default monospaced font for the formula input field, especially when it is set to multiline mode. I don't think an option would be necessary for this, it should just do that by default automatically, it's somewhat expected for a formula input textfield. ------------ I've observed this issue in: Version: 25.8.4.2 (X86_64) / LibreOffice Community Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df CPU threads: 8; OS: Linux 6.18; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Flatpak …and: Version: 26.2.0.3 (X86_64) Build ID: afbbd0df0edb6d40b450b0337ac646b0913a760c CPU threads: 8; OS: Linux 6.18; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Flatpak
Created attachment 205366 [details] Screenshot comparing the text in LibreOffice Calc's formula input textfield vs a text editor with monospaced fonts
User control in UI for the font selection for the inputwin editshell would be great. See also bug 153727 where current os/DE default font with CJK locales is too small. Or here where ability to visually align formula input with a monospaced font as alternative to os/DE system font--that can be modified, but usually is proportional by default. It needs to be a user selectable option in UI. There is no use case for "automagically" detecting that multiline input needs monospaced font assignment. Just provide the option for a simple UI font selection for the widget.