Highlight formula

[acardiel]

Is there a way to highlight the formula in the formula inbox without editing like Google Sheet do?

Google Sheet:

LibreOffice 25.8:

Thanks in advance.

[Villeroy]

Hit F2 and you get the references and referenced ranges highlighted.

[fpy]

@Villeroy

F2

@acardiel

without editing

  

[fpy]

may be of help : Detective

[acardiel]

Thanks for the replies. I don’t think “Detective” solves the problem I mentioned. I don’t think the formula box is as intuitive as in solutions such as Google Sheets.

In my opinion, simply by placing the cursor in a cell, the highlighting of formulas should be automatic. And when editing them, it should at least match parentheses, which is especially useful in nested functions.

I assumed that this would be an accepted and implemented feature in LibreOffice given the robustness of its development, but I suspect that it is not even in the short-term plans.

If I could help with its development, I would be willing to lend a hand.

Thank you!

[Wanderer]

@acardiel

I assumed that this would be an accepted and implemented feature in LibreOffice given the robustness of its development

Feature requests should go directly to Bugzilla as Enhancements
Log in to Bugzilla 1

Is quoted from here:

This is the guide - How to use the Ask site?

Ask a question To do this, click on “+ New topic” in the top bar. [EN Button New Topic] The “Create a new topic” dialog appears. [EN Dialog Create a new Topic] In the “Type title, or paste a link here” line, enter as short a title as possible for the question. In any case, avoid entering the entire content of your question in the “Title” line. If you create your question in the “English” category, “English” will appear automatically. To the right of “Select at least 1 item”, you can sel…

[cwolan]

tdf#98319 (“EDITING: No colored cell names in the input line”) might be adequate.

[PKG]

@acardiel

a way to highlight the formula in the formula inbox without editing

No.

_{Version: 26.2.0.3 (X86_64)
Build ID: 620(Build:3)
CPU threads: 8; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded}