Bug 146180 - Show fields in Calc's navigator
Summary: Show fields in Calc's navigator
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.5.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Navigator
  Show dependency treegraph
 
Reported: 2021-12-11 14:11 UTC by Stéphane Guillou (stragu)
Modified: 2022-08-29 13:31 UTC (History)
2 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 Stéphane Guillou (stragu) 2021-12-11 14:11:00 UTC
Description:
The fix for bug 137741 added fields to the navigator and the "Navigate by" feature in Writer.

Calc spreadsheets can also contain fields (like Date, Document name and Sheet name), but they are not listed in the navigator.

Steps to Reproduce:
1. Open Calc
2. Open the Navigator sidebar

Actual Results:
There is no "Fields" section

Expected Results:
There is a "Field" section that would list existing fields, like in Writer.


Reproducible: Always


User Profile Reset: No



Additional Info:
Tested in:

Version: 6.2.5.2
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

and:

Version: 7.3.0.0.beta1 / LibreOffice Community
Build ID: 436f14c25ec1847646b953cf13d0db4f7ca3be57
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Not sure when it started being possible to add fields in Calc (it didn't seem to be possible in LO 5.2).
Comment 1 Roman Kuznetsov 2022-08-26 13:53:25 UTC
It seems as a valid request (+1 from my side) but let's ask UX-team and Jim Raykowski about it
Comment 2 Heiko Tietze 2022-08-29 09:43:03 UTC
Sure, valid enhancement.
Comment 3 Eike Rathke 2022-08-29 13:31:00 UTC
Problem is that Calc doesn't maintain a list of used fields (and should not). A field is just a possible cell content if a cell is an EditCell and opening the Navigator's Field section you certainly don't want to scan all cells whether they have such.