Hello Hans,
look at attached PlanMaker file.
Search found 13 matches
- Wed Jun 05, 2019 2:03 pm
- Forum: PlanMaker 2018 for Windows
- Topic: conditional formatting - highest and 2nd highest
- Replies: 6
- Views: 7370
- Tue Jun 04, 2019 2:20 pm
- Forum: PlanMaker 2018 for Windows
- Topic: conditional formatting - highest and 2nd highest
- Replies: 6
- Views: 7370
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 ...
- Mon Jun 03, 2019 1:40 pm
- Forum: PlanMaker 2018 for Windows
- Topic: conditional formatting - highest and 2nd highest
- Replies: 6
- Views: 7370
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.
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.
- Tue Apr 02, 2019 8:40 am
- Forum: TextMaker 2018 for Linux
- Topic: Loosing DOCPROPERTY fields
- Replies: 7
- Views: 18249
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 ...
- 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: 16230
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.
- Fri Mar 15, 2019 3:37 pm
- Forum: TextMaker 2018 for Windows
- Topic: Copy and paste from screenshot will not auto fit to the document width
- Replies: 1
- Views: 4112
Re: Copy and paste from screenshot will not auto fit to the document width
Hello,
there are no settings to auto fit images.
there are no settings to auto fit images.
- 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: 5890
Re: Registration fails Internet connection not detected (Broadband)
Amendment: often Comodo is blocking the access to the license server.
- 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: 16230
Re: Is it possible to use a calendar in a cell?
Do you mean something like Insert - Form object - Listbox ... ?
- Thu Mar 14, 2019 3:32 pm
- Forum: TextMaker 2018 for Linux
- Topic: Loosing DOCPROPERTY fields
- Replies: 7
- Views: 18249
Re: Loosing DOCPROPERTY fields
Not comprehensible (Word 2019, TextMaker 2018)
- Thu Mar 14, 2019 3:08 pm
- Forum: Presentations 2018 for Linux
- Topic: Insert > Photo album
- Replies: 4
- Views: 13065
Re: Insert > Photo album
We will check what´s the matter.
- Thu Mar 14, 2019 3:01 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Trendline problems
- Replies: 1
- Views: 5412
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.
2. A trend line usually does not update extremely and it is possible that even several changes do not produce a visible result.
- Thu Mar 14, 2019 2:17 pm
- Forum: TextMaker 2018 for Windows
- Topic: Comments muliplied in rtf documents
- Replies: 5
- Views: 7428
Re: Comments muliplied in rtf documents
Sorry, but I cannot find a mail from you with attachment in forum(at)softmaker.com.
- 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: 4933
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.