Bug 167766 - FILEOPEN XLSX Form control element does not show up in Navigator, only in Form Navigator
Summary: FILEOPEN XLSX Form control element does not show up in Navigator, only in For...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2025-08-01 16:28 UTC by Gabor Kelemen (allotropia)
Modified: 2025-08-01 16:28 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
How it looks in Form Navigator after opening the file (39.22 KB, image/png)
2025-08-01 16:28 UTC, Gabor Kelemen (allotropia)
Details
After filling the other Name box it is usable from the Navigator as well (43.95 KB, image/png)
2025-08-01 16:28 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2025-08-01 16:28:02 UTC
Created attachment 202134 [details]
How it looks in Form Navigator after opening the file

When an Excel file with form controls is opened in Calc, the Navigator does not show these controls; only the Form Navigator.
When a new form control is inserted in Calc, the Navigator lists it.

This is because the form control in Excel has a name, which is loaded into the Name property in the Properties dialog.
Calc on the other hand upon inserting a new control, auto-fills the Format -> Name property, which is shown in the Navigator, making them more easy to use.
This field is empty for the Excel-made files.

1. Open attachment 202128 [details] from bug 167764
2. Go to Tools - Forms - Form Navigator
-> It lists "Drop Down 1" and "Drop Down 2" - good
3. Rigth click on one of the controls, and go to Format - Name
-> It is empty. 
4. Type something, press OK
-> What you have typed shows up in the Navigator under Drawing Objects. Clicking on it highlights the object correctly.


Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7f4868348c14b305fcd75744e1e3544d0d3a5d61
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded
Comment 1 Gabor Kelemen (allotropia) 2025-08-01 16:28:38 UTC
Created attachment 202135 [details]
After filling the other Name box it is usable from the Navigator as well