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