Cannot save tab colours

Post your questions, bug reports and suggestions here for FreeOffice PlanMaker 2016 for Windows

Moderator: SoftMaker Team

Post Reply
spready
Posts: 8
Joined: Mon Oct 23, 2017 6:39 pm

Cannot save tab colours

Post by spready » Fri Dec 01, 2017 11:01 am

Hello

I can apply different colours to worksheet tabs via Properties but after closing and reopening, the colours have not been saved.

Is there a solution to this?

martin-k
SoftMaker Team
SoftMaker Team
Posts: 3002
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: Cannot save tab colours

Post by martin-k » Fri Dec 01, 2017 11:03 am

In which file format do you save?
Martin Kotulla
SoftMaker Software GmbH

spready
Posts: 8
Joined: Mon Oct 23, 2017 6:39 pm

Re: Cannot save tab colours

Post by spready » Tue Dec 05, 2017 1:19 am

All my files are Microsoft Excel 97-2003 document (.xls)

Hope this helps

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7932
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Cannot save tab colours

Post by sven-l » Wed Dec 06, 2017 4:19 pm

I will investigate this. Please save in .xlsx file as a workaround.
Sven Leßmann
SoftMaker Software GmbH

spready
Posts: 8
Joined: Mon Oct 23, 2017 6:39 pm

Re: Cannot save tab colours

Post by spready » Thu Dec 07, 2017 12:21 am

Thanks for taking trouble. I've looked at my save options but I only have plain xls options, no xlsx

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7932
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Cannot save tab colours

Post by sven-l » Thu Dec 07, 2017 9:16 am

Are you working with FreeOffice or SoftMaker Office 2016 (look in Help=>About)?
Sven Leßmann
SoftMaker Software GmbH

spready
Posts: 8
Joined: Mon Oct 23, 2017 6:39 pm

Re: Cannot save tab colours

Post by spready » Thu Dec 07, 2017 10:36 am

I have FreeOffice 2016

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7932
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Cannot save tab colours

Post by sven-l » Wed Dec 13, 2017 9:06 am

I tried to reproduce that issue in pmw16 rev.767.0516 (FreeOffice):

1. Open PlanMaker with a blank, new worksheet
2. Change the color of the worksheet tab in the worksheet properties (right mouse click on the worksheet tab)
3. Add two other worksheets and change the worksheet tab color here as well
4. Save the file in .xls (Excel 2003) and ..pmd (PlanMaker 2016) file format
5. Close and re-open the files
=> All colors are still there.

Did I something wrong?
Sven Leßmann
SoftMaker Software GmbH

spready
Posts: 8
Joined: Mon Oct 23, 2017 6:39 pm

Re: Cannot save tab colours

Post by spready » Wed Dec 13, 2017 2:00 pm

Yes I can replicate this with saving in .xls and it works perfectly allowing coloured tabs to be retained.

I've carefully checked my existing files Properties which correctly show Excel .xls 2003 and opening with PlanMaker.

I have the feeling that the problem may be connected with the fact that my files were originally in .ods format which I converted
into .xls when I saw Planmaker does not support .ods. I can't see why the conversion should have resulted in a tab problem but it seems like it has.

I have a workaround as a result of your experiment for I can add new sheets with coloured tabs by first opening PlanMaker, copying my existing data into them and replacing my old sheets with the new.

Thanks very much for your help, this is a minor glitch and I dont think it's worth spending any more of your time on it.

Post Reply

Return to “FreeOffice PlanMaker 2016 for Windows”