Search found 13 matches

by robert-l
Wed Jun 05, 2019 2:03 pm
Forum: PlanMaker 2018 for Windows
Topic: conditional formatting - highest and 2nd highest
Replies: 6
Views: 5439

Re: conditional formatting - highest and 2nd highest

Hello Hans,
look at attached PlanMaker file.
by robert-l
Tue Jun 04, 2019 2:20 pm
Forum: PlanMaker 2018 for Windows
Topic: conditional formatting - highest and 2nd highest
Replies: 6
Views: 5439

Re: conditional formatting - highest and 2nd highest

Hello Hans, your problem is that you have duplicate maximum values. In that case, none of them is marked as highest, both are marked as second-to-maximum, third highest is not marked. Change the formula for the 2nd highest value to =RANK(C2;$C$2:$L$2;)=(COUNTIF($C$2:$L$2;MAX($C$2:$L$2))+1) Just for ...
by robert-l
Mon Jun 03, 2019 1:40 pm
Forum: PlanMaker 2018 for Windows
Topic: conditional formatting - highest and 2nd highest
Replies: 6
Views: 5439

Re: conditional formatting - highest and 2nd highest

Hello Hans,

you can bypass what happens if you pay attention to the order in which the rules are executed. This is the same behavior as in Excel.

It becomes really problematic if values are changed afterwards. Then it can come to some confusion. I need to take a closer look at this.
by robert-l
Tue Apr 02, 2019 8:40 am
Forum: TextMaker 2018 for Linux
Topic: Loosing DOCPROPERTY fields
Replies: 7
Views: 12605

Re: Loosing DOCPROPERTY fields

With a new Microsoft Office version it can come first of all to errors. Of course we try to solve compatibility problems as soon as possible. Fields can be different, e.g. the function is displayed and not the value. Sometimes it is enough to update the field to get the value, sometimes you have to ...
by robert-l
Tue Mar 19, 2019 2:05 pm
Forum: PlanMaker 2018 for Windows
Topic: Is it possible to use a calendar in a cell?
Replies: 8
Views: 9995

Re: Is it possible to use a calendar in a cell?

We currently don't support that, but I will forward your idea to product management.
by robert-l
Fri Mar 15, 2019 7:54 am
Forum: SoftMaker Office 2018 for Windows (General)
Topic: Registration fails Internet connection not detected (Broadband)
Replies: 2
Views: 4661

Re: Registration fails Internet connection not detected (Broadband)

Amendment: often Comodo is blocking the access to the license server.
by robert-l
Thu Mar 14, 2019 3:42 pm
Forum: PlanMaker 2018 for Windows
Topic: Is it possible to use a calendar in a cell?
Replies: 8
Views: 9995

Re: Is it possible to use a calendar in a cell?

Do you mean something like Insert - Form object - Listbox ... ?
by robert-l
Thu Mar 14, 2019 3:32 pm
Forum: TextMaker 2018 for Linux
Topic: Loosing DOCPROPERTY fields
Replies: 7
Views: 12605

Re: Loosing DOCPROPERTY fields

Not comprehensible (Word 2019, TextMaker 2018)
by robert-l
Thu Mar 14, 2019 3:08 pm
Forum: Presentations 2018 for Linux
Topic: Insert > Photo album
Replies: 4
Views: 8139

Re: Insert > Photo album

We will check what´s the matter.
by robert-l
Thu Mar 14, 2019 3:01 pm
Forum: PlanMaker 2018 for Windows
Topic: Trendline problems
Replies: 1
Views: 4539

Re: Trendline problems

1. Mark (click on) the legend of the deleted trendline and delete the legend.
2. A trend line usually does not update extremely and it is possible that even several changes do not produce a visible result.
by robert-l
Thu Mar 14, 2019 2:17 pm
Forum: TextMaker 2018 for Windows
Topic: Comments muliplied in rtf documents
Replies: 5
Views: 5117

Re: Comments muliplied in rtf documents

Sorry, but I cannot find a mail from you with attachment in forum(at)softmaker.com.
by robert-l
Wed Dec 05, 2018 8:14 am
Forum: PlanMaker 2018 for Windows
Topic: How to copy a formula from one tab to another
Replies: 1
Views: 4163

Re: How to copy a formula from one tab to another

You can type in =sheet2!b2 for example. Or You only type in = an then change to the sheet with the formula you want to copy an click on the cell.

Go to advanced search