https://bugs.documentfoundation.org/show_bug.cgi?id=167766

            Bug ID: 167766
           Summary: FILEOPEN XLSX Form control element does not show up in
                    Navigator, only in Form Navigator
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]
            Blocks: 133999

Created attachment 202134
  --> https://bugs.documentfoundation.org/attachment.cgi?id=202134&action=edit
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 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


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=133999
[Bug 133999] [META] XLSX (OOXML) Form Controls related issues
-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to