You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Bill Stackhouse <bi...@gmail.com> on 2020/11/24 16:37:31 UTC
CTCfRule.setTimePeriod() & STTimePeriod
I am using CTCfRule to create conditional formats and I can't find STTimePeriod so I can use CTCfRule.setTimePeriod(). Can anyone offer suggestions how to do this? My goal is to have the Excel rule display Today, Yesterday rather than Formula: xxx
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: CTCfRule.setTimePeriod() & STTimePeriod
Posted by Bill Stackhouse <bi...@gmail.com>.
The STTimePeriod class is missing from the poi-ooxml-schemas jar, and I hope in a future release it can be added. My solution was to add the source to my project in the correct package, and now I can create conditional format rules for the "cells that contain" dates.
On 2020/11/24 16:37:31, Bill Stackhouse <bi...@gmail.com> wrote:
> I am using CTCfRule to create conditional formats and I can't find STTimePeriod so I can use CTCfRule.setTimePeriod(). Can anyone offer suggestions how to do this? My goal is to have the Excel rule display Today, Yesterday rather than Formula: xxx
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org