Conditional formating changes when saved and reopened

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Linux.

Moderator: SoftMaker Team

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

Conditional formating changes when saved and reopened

Post by nortsout » Sat May 25, 2019 12:24 pm

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: 2870
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 » Sat May 25, 2019 12:58 pm

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 » Sat May 25, 2019 1:16 pm

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

Thank you
Attachments
After1.xlsx
(10.52 KiB) Downloaded 12 times
Before.xlsx
(17.54 KiB) Downloaded 11 times

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 100
Joined: Wed Jun 05, 2019 12:02 pm

Re: Conditional formating changes when saved and reopened

Post by miguel-c » Thu Jun 06, 2019 2:47 pm

Hi, I was able to reproduce the issue you reported and I'm going to report it to the developers.

Post Reply

Return to “PlanMaker 2018 for Linux”