[Solved] Remove/Hide drop down arrows

Discuss the spreadsheet application

[Solved] Remove/Hide drop down arrows

Postby Mnemonic67 » Tue Feb 27, 2018 12:04 pm

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?

header_row.png
header_row.png (57.31 KiB) Viewed 933 times


Thanks,
TK
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.
Mnemonic67
 
Posts: 11
Joined: Sun Feb 18, 2018 10:44 pm

Re: Remove/Hide drop down arrows

Postby RoryOF » Tue Feb 27, 2018 12:05 pm

How were they put there? What were they dropping down?
Apache OpenOffice 4.1.6 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 27917
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Remove/Hide drop down arrows

Postby Zizi64 » Tue Feb 27, 2018 12:20 pm

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?


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.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.4 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.1.4 and AOO4.1.5
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.
User avatar
Zizi64
Volunteer
 
Posts: 7590
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Remove/Hide drop down arrows

Postby Mnemonic67 » Tue Feb 27, 2018 8:08 pm

Hi Rory,

Thanks for responding.

RoryOF wrote:How were they put there? What were they dropping down?


They just appeared when making the header row.

TK
Apache OpenOffice 4.1.5
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
Mnemonic67
 
Posts: 11
Joined: Sun Feb 18, 2018 10:44 pm

Re: Remove/Hide drop down arrows

Postby Mnemonic67 » Tue Feb 27, 2018 8:14 pm

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.


Hi Zizi64,

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 27 times
Apache OpenOffice 4.1.5
Windows 10 64 Bit
Each day I awake with renewed energy for my pursuit to alter this Koyaanisqatsi.
Mnemonic67
 
Posts: 11
Joined: Sun Feb 18, 2018 10:44 pm

Re: Remove/Hide drop down arrows

Postby Zizi64 » Tue Feb 27, 2018 9:35 pm

They are Data Filter control arrows. Select the related columns, and switch off the filter by the menu item "Hide autofilter"
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.4 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.1.4 and AOO4.1.5
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.
User avatar
Zizi64
Volunteer
 
Posts: 7590
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Remove/Hide drop down arrows

Postby Mnemonic67 » Wed Feb 28, 2018 8:27 pm

Zizi64 wrote:They are Data Filter control arrows. Select the related columns, and switch off the filter by the menu item "Hide autofilter"


Hi,

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.
Mnemonic67
 
Posts: 11
Joined: Sun Feb 18, 2018 10:44 pm

Re: [Solved] Remove/Hide drop down arrows

Postby charleswhammond » Tue Dec 04, 2018 3:56 pm

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?
OpenOffice 4.1.6 -- Windows 10
charleswhammond
 
Posts: 1
Joined: Tue Dec 04, 2018 3:52 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests