Skip to content

Is it possible to check letters style within a cell one by one, at least part by part #1787

Open
@fyy623

Description

@fyy623

title.

I want to filter my cells by only keeping letters that do not have a strike through.

I see that there a cell.font attribute, but it does not go down to letter level.

I have also tried to traverse the content of a cell using cell.value, but it doesn't produce the font attribute either.

The confusion further grows as you may notice in the screenshot below, before the strike through, "Control " is parsed as a str, while after the strike through appear once, its following letters "s Record" is parsed as a rich_text. str does not have a font attribute and therefore this task seems impossible.

is this an expected behavior or a known issue?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions