Re: How to filter out strikethrough part of a cell?
289 views
Skip to first unread message
jmcnamara
Nov 21, 2012, 7:31:14 PM11/21/12
to Spreadsheet::ParseExcel
On Nov 22, 12:01 am, Alexanderth <xiaol...@uci.edu> wrote:
> I want to filter out the strikethrough part of a cell. Eg, cell value is
> "123,456,789" and the red part is strikethrough, the filtered result should
> be "123,,789"
> $cell->get_format()->{Font}->{Strikeout} can only give if the cell has the
> property of ''strikethrough". However, it doesn't give information which
> characters in the cell are strikethrough. Thank you.
Hi,
How exactly is the strikethrough applied to the cell. Is it in-place
in the string or is it done with a number format of some kind?
John
> I want to filter out the strikethrough part of a cell. Eg, cell value is
> "123,456,789" and the red part is strikethrough, the filtered result should
> be "123,,789"
> $cell->get_format()->{Font}->{Strikeout} can only give if the cell has the
> property of ''strikethrough". However, it doesn't give information which
> characters in the cell are strikethrough. Thank you.
Hi,
How exactly is the strikethrough applied to the cell. Is it in-place
in the string or is it done with a number format of some kind?
John
Reply all
Reply to author
Forward
0 new messages