Hi,
I have no use for the drop down arrows on my sheet. I want to hide or remove them from display.
How can I achieve this?
Thanks,
TK
[Solved] Remove/Hide drop down arrows
-
- Posts: 11
- Joined: Sun Feb 18, 2018 10:44 pm
[Solved] Remove/Hide drop down arrows
Last edited by Mnemonic67 on Wed Feb 28, 2018 8:28 pm, edited 1 time in total.
Apache OpenOffice 4.1.5
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
Re: Remove/Hide drop down arrows
How were they put there? What were they dropping down?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Remove/Hide drop down arrows
It seems as they are Form control elements. Switch the Form controls to Edit mode and delete them.I have no use for the drop down arrows on my sheet. I want to hide or remove them from display.
How can I achieve this?
Or: Please upload your sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 11
- Joined: Sun Feb 18, 2018 10:44 pm
Re: Remove/Hide drop down arrows
Hi Rory,
Thanks for responding.
TK
Thanks for responding.
They just appeared when making the header row.RoryOF wrote:How were they put there? What were they dropping down?
TK
Apache OpenOffice 4.1.5
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
-
- Posts: 11
- Joined: Sun Feb 18, 2018 10:44 pm
Re: Remove/Hide drop down arrows
Hi Zizi64,Zizi64 wrote:It seems as they are Form control elements. Switch the Form controls to Edit mode and delete them.
Or: Please upload your sample file here.
Thanks for responding.
I tried playing with each of the available tools under Form controls and I couldn't get them to affect the issue.
I have added a file to this reply.
Thanks
TK
- Attachments
-
- demo.ods
- (12.31 KiB) Downloaded 150 times
Apache OpenOffice 4.1.5
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
Re: Remove/Hide drop down arrows
They are Data Filter control arrows. Select the related columns, and switch off the filter by the menu item "Hide autofilter"
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 11
- Joined: Sun Feb 18, 2018 10:44 pm
Re: Remove/Hide drop down arrows
Hi,Zizi64 wrote:They are Data Filter control arrows. Select the related columns, and switch off the filter by the menu item "Hide autofilter"
Thanks for your response.
An interesting thing happens if I only select one column and then Data> Filter> Hide Autofilter it won't allow me to do more columns. Even if I saved it after doing one as when I reopened it the Autofilter was back on that column.
I had to select all columns and then do the Data> Filter> Hide Autofilter before it would stick
Thanks for your help!!
TK
Apache OpenOffice 4.1.5
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
-
- Posts: 1
- Joined: Tue Dec 04, 2018 3:52 pm
Re: [Solved] Remove/Hide drop down arrows
I can hide the auto filter dropdown arrows that appear in row 1 (without my wanting them!!!), but after saving and reopening the spreadsheet they are back.
Am I missing something?
Am I missing something?
OpenOffice 4.1.6 -- Windows 10