You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Jan Stette <ja...@gmail.com> on 2010/04/07 15:25:34 UTC

Getting strikethrough info from cells

Hi all,

is there a way to get details about whether a cell has a "strikethrough"
style applied?  I can't find any reference to this in either the CellStyle
class or the HSSFRichTextString class.

Thanks,
Jan

Re: Getting strikethrough info from cells

Posted by Jan Stette <ja...@gmail.com>.
That's just what I was looking for, thanks!

Jan

On 7 April 2010 15:19, Paul Spencer <pa...@apache.org> wrote:

> Jan,
> In 3.6, I use the following:
> >               // Ignore cells marked with Strike through font attribute
> >               CellStyle style = cell.getCellStyle();
> >               Font cellFont = cell.getSheet().getWorkbook().getFontAt(
> >                               style.getFontIndex());
> >               if (cellFont.getStrikeout()) {
> >                       return;
> >               }
>
> Paul Spencer
>
>
> On Apr 7, 2010, at 9:25 AM, Jan Stette wrote:
>
> > Hi all,
> >
> > is there a way to get details about whether a cell has a "strikethrough"
> > style applied?  I can't find any reference to this in either the
> CellStyle
> > class or the HSSFRichTextString class.
> >
> > Thanks,
> > Jan
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Re: Getting strikethrough info from cells

Posted by Paul Spencer <pa...@apache.org>.
Jan,
In 3.6, I use the following:
> 		// Ignore cells marked with Strike through font attribute
> 		CellStyle style = cell.getCellStyle();
> 		Font cellFont = cell.getSheet().getWorkbook().getFontAt(
> 				style.getFontIndex());
> 		if (cellFont.getStrikeout()) {
> 			return;
> 		}

Paul Spencer


On Apr 7, 2010, at 9:25 AM, Jan Stette wrote:

> Hi all,
> 
> is there a way to get details about whether a cell has a "strikethrough"
> style applied?  I can't find any reference to this in either the CellStyle
> class or the HSSFRichTextString class.
> 
> Thanks,
> Jan


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org