Bug 122533 - EDITING: Custom Calc formula - highlight values, ranges etc.
Summary: EDITING: Custom Calc formula - highlight values, ranges etc.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
Reported: 2019-01-07 15:40 UTC by duceil
Modified: 2019-11-04 12:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description duceil 2019-01-07 15:40:00 UTC
It is more a wish than a bug: lack of custom calc formula.

Using large spreasheets with long and complex formulas. When these formulas need some maintenance, they are not easily read because the font/size used is not changeable via settings menu.

My wishes:
- possibility to set different colors and font size for: column and raw references, comma and brackets (or other signes) via the general calc menu.
- with long and embended commands, get the possibility to set a seconf color for braces/brackets/... delimiters.

Actually i have tried some alternative addons 'libreoffice extensions' like 'highlitning' and 'FaF' but after they get installed as expected, they refuse to edit a cell or range due to a basic runtime error (on a ubuntu gnome-shell on xorg session; while someone told me he succeed with Kde).

Hope you guys will put some fun around the formula editor for calc.
Comment 1 Xisco Faulí 2019-03-21 14:33:49 UTC
Moving to NEW
Comment 2 duceil 2019-11-04 12:52:11 UTC
Now using 6.3.3

I have been well surprised by the better font & size now used with the formula editor: this a a huge step done about readability. Many thanks.

Hope to get next a solution to differenciate the script & their subscript(s) (embedded) using colored () [] {} for example