DR 17-0030 SML: ST_ConditionalFormattingOperator, extra operator

[MURATA Makoto]

Aarti,

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

Regards,
Makoto

2018-02-17 4:26 GMT+09:00 Aarti Nankani <anankani at microsoft.com>:

> Hello,
>
>
>
> For this DR, response from Product Team:
>
> There appears to be some confusion between ST_ConditionalFormattingOperator
> and ST_CfType.
>
> ST_CfType (18.18.12) defines the type of the conditional formatting rule,
> and ‘duplicateValues’ is listed as part of that enum.
>
> ST_ConditionalFormattingOperator tells how to compare a cell value to the
> formula result, and is only relevant to CF rules where the type is
> ‘cellIs’.  The standard is explicit that this value should be ignored for
> all rules not of type ‘cellIs’.
>
> Excel does not recognize ‘duplicateValues’ as a valid  value for ST_
> ConditionalFormattingOperator.
>
>
>
> Thanks,
> Aarti
>



-- 

Praying for the victims of the Japan Tohoku earthquake

Makoto
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.vse.cz/pipermail/sc34wg4/attachments/20180227/d8943fd6/attachment.html>