Page 1 of 1

ISATe Spreadsheet Request - Allow Hiding Unused Rows/Columns

PostPosted: Tue Dec 16, 2014 2:43 am
by benpdx

I've been using the ISATe spreadsheet for a few projects and I love that the spreadsheet is protected so that I can be confident that none of the inner workings have been modified. However, the same protection makes it so that rows and columns cannot be hidden. This makes it difficult to print the worksheets from the file without large unused blank spaces.

I would like to be able to hide unused rows and columns, so that a compact summary of inputs and outputs can be produced. This can be accomplished without sacrificing the content protection by selecting "Allow all users of this worksheet to: Format columns/rows" in the "Protect Sheet" menu.

I appreciate all the effort that has been done to produce these models and computational tools, and am glad that there is an active forum for user feedback.

Thank you!