Ask Your Question
1

Auto size column width on protected worksheet [closed]

asked 2012-05-24 18:17:37 +0100

anonymous user

Anonymous

updated 2013-01-27 21:06:24 +0100

qubit gravatar image

I've set up a Calc template with several password protected sheets. Is there a way to (preferably automatically) shrink/grow the column width dependent on the cell contents without turning off the password protection and resizing the columns after the data is entered?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-27 01:45:45.445825

Comments

Hi @Anonymous -- Have you found an answer for your question? Still looking for an answer?

Thanks!

qubit gravatar imagequbit ( 2013-03-12 02:42:25 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2013-03-17 05:56:30 +0100

razon_22 gravatar image

updated 2013-03-17 05:58:47 +0100

You can create a macro to resize the columns then assign the macro to a certain event like opening or closing a document. Macros are an experimental feature currently and it has to be enabled from Tools > Options. You will also need a Java runtime installed. Once the macro is created, go to Tools > Customize, click the Events tab and choose the event to associate it with. One of the options is to run the macro after the modified status is changed. If you choose that event, it will run it every time a cell is changed. Let us know if this works for you.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-05-24 18:17:37 +0100

Seen: 959 times

Last updated: Mar 17 '13