Conditional formating changes when saved and reopened

Post Reply
nortsout
Posts: 2
Joined: Sat May 25, 2019 12:02 pm

Conditional formating changes when saved and reopened

Post by nortsout »

Hello,
I'm new to planmaker. I really like it but I noticed a problem which I'm facing when opening .xlsx files in planmaker in Linux.
The file and all the formulas were made at work on Windows (excel) computer.
After I open it in planmaker all looks ok, until I save the file and reopen.
The conditional formatting changes and shows wrong icons in the cells. The green check should be where value is zero but it is now where value is negative, the exclamation mark should be where value is greater but it's at where value is zero and cross should be where value is negative but now it shows where value is greater.
I have attached two photos.

Of course I can change it back everytime by opening conditional formatting, but thats not really what I want to do each time I work from my home computer which runs linux.

Just wondering if anyone had similar problem and if there's a solution or other way to do it, to keep the colors, icons the way I have them now.

Thank you
Attachments
Conditional-pic-1.png
Conditional-Pic-2.png
martin-k
SoftMaker Team
SoftMaker Team
Posts: 2944
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: Conditional formating changes when saved and reopened

Post by martin-k »

Upload the file before and after, and we will have a look.
Martin Kotulla
SoftMaker Software GmbH
nortsout
Posts: 2
Joined: Sat May 25, 2019 12:02 pm

Re: Conditional formating changes when saved and reopened

Post by nortsout »

Hi,
Attached are the "before" and "after" files.

Thank you
Attachments
After1.xlsx
(10.52 KiB) Downloaded 136 times
Before.xlsx
(17.54 KiB) Downloaded 138 times
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1026
Joined: Wed Jun 05, 2019 12:02 pm

Re: Conditional formating changes when saved and reopened

Post by miguel-c »

Hi, I was able to reproduce the issue you reported and I'm going to report it to the developers.
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1026
Joined: Wed Jun 05, 2019 12:02 pm

Re: Conditional formating changes when saved and reopened

Post by miguel-c »

This issue was fixed and the fix will be included in the next service pack
Post Reply

Return to “PlanMaker 2018 for Linux”