poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stuart Turner <stu...@turner.eu.com>
Subject Re: FormatConditions for cells
Date Tue, 15 Jan 2013 09:37:43 GMT
Hi Yegor

Thanks for your reply.

I don't understand how I can tell if a cell has had its CellStyle modified.

What will cell.getCellStyle().getIndex() return if it is the default
style (without any modification)?

Thanks

Stuart

On 15 January 2013 16:56, Yegor Kozlov <yegor.kozlov@dinom.ru> wrote:
> CellStyle is a global object stored at workbook level. Cells referer
> to their style by 0-based index.
>
> You can pre-build a map <cellStyleIndex, ifModifiedFleg> and  then
> simply check if the value is set for cell.getCellStyle().getIndex().
>
>
>
> On Tue, Jan 15, 2013 at 5:02 AM, Stuart Turner <stuart@turner.eu.com> wrote:
>> Hi Everyone
>>
>> Is there a way to determine whether a cell has ANY format conditions?
>> In Excel, you can ask Range.FormatConditions.Count to obtain whether
>> any cell has formatting different from the default.
>>
>> In POI, am I correct in saying every cell has a CellStyle and I will
>> need to go through each one to determine if the font, colour, borders,
>> etc. are different from the default?
>>
>> Thanks
>>
>> Stuart
>>
>> ---------------------------------------------------------------------
>> 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


Mime
View raw message