DR 17-0030 SML: ST_ConditionalFormattingOperator, extra operator

[Charlie Clark]

Am .02.2018, 02:24 Uhr, schrieb MURATA Makoto <eb2m-mrt at asahi-net.or.jp>:

> Aarti,
>
> Thank you for this reply.  Charlie, can we close this DR
> without action in Prague?

Yes, it looks like it. I've just reviewed the source of the file that  
caused me to check and it looks like I got the wrong attribute; it should  
be operator.

Here's a sample (generator appears to have been LibreOffice) which is  
definitely invalid but Excel is happy with:

<cfRule type="duplicateValues" dxfId="0" priority="2" aboveAverage="0"  
percent="0" bottom="0" operator="duplicateValues" text="" rank="0"  
equalAverage="0">
   <formula>0</formula>
</cfRule>

The operator is definitely nonsense here I just wonder why Excel doesn't  
raise an objection?

Charlie
-- 
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226