Hiding multiple columns and rows

Post Reply
joe935
Posts: 7
Joined: Sat May 02, 2020 1:25 pm

Hiding multiple columns and rows

Post by joe935 »

Is there a limit in the number of columns and rows which will remain hidden after closing and reopening Planmaker?

In My case I am hiding, Column M to end and rows 36 to end.
but on reopening the worksheet:
only columns 36 to IV are hidden and only Rows 36 to 88 are hidden

Is this a bug or restriction of the free version?
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2930
Joined: Wed Mar 11, 2020 5:31 pm

Re: Hiding multiple columns and rows

Post by SuperTech »

No, there are no such limits to hide columns or rows.

Please make sure when hiding columns you selected all columns from M to end i.e. XFD and when hiding rows you selected all rows from 36 to end i.e. 1048576.

You can select all columns by selecting column M > press SHIFT + CTRL + right arrow and select all rows by selecting row 36 > press SHIFT + CTRL + down arrow.
joe935
Posts: 7
Joined: Sat May 02, 2020 1:25 pm

Re: Hiding multiple columns and rows

Post by joe935 »

That is exactly how I am hiding columns and rows and I end up with what i wrote in my question.
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1233
Joined: Wed Jun 05, 2019 12:02 pm

Re: Hiding multiple columns and rows

Post by miguel-c »

Could you please post your file here or send it to forum(at)softmaker.de? (and include the URL of this page, please)
joe935
Posts: 7
Joined: Sat May 02, 2020 1:25 pm

Re: Hiding multiple columns and rows

Post by joe935 »

I can not send you the worksheet as it has 4 pages of personal data in it, So
I Tried copying the pages to a new worksheet and then hid the worksheet rows and columns closed and reopened it and the rows and columns stayed hidden. But Could the problem be causes by the fact that the problem worksheet was being saved as XLS and the copied was saved as XLSX?
Could you tell me where to find the calculation settings?
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1233
Joined: Wed Jun 05, 2019 12:02 pm

Re: Hiding multiple columns and rows

Post by miguel-c »

Not sure if it's related to XLS and I can't reproduce the issue.

You can find the calculation options under File | Properties | Calculate
joe935
Posts: 7
Joined: Sat May 02, 2020 1:25 pm

Re: Hiding multiple columns and rows

Post by joe935 »

Seems to be working as an XLSX file.
Thanks for the help.
Post Reply

Return to “PlanMaker 2018 for Windows”