How to check whether the cell has set strikethrough ?

[kevin-ma-86]

#section 1:question
For example, cell A3 has set strikethrough while A2 not. I imitate Demo10 to check whether strikethrough has been set , but both A2 and A3 have not strikethrough. they return strikethrough() equal 0.
What should I do? Do anyone offer me the right demo source code. Or the

 The new demo source code as following:

#section 2: demo source code

    OpenXLSX::XLDocument doc;
    doc.open("./Demo11.xlsx");

    std::cout << "Open Demo11.xlsx" << std::endl;

    XLNumberFormats & numberFormats = doc.styles().numberFormats();
    XLFonts & fonts = doc.styles().fonts();
    XLFills & fills = doc.styles().fills();
    XLBorders & borders = doc.styles().borders();
    XLCellFormats & cellStyleFormats = doc.styles().cellStyleFormats();
    XLCellFormats & cellFormats = doc.styles().cellFormats();
    XLCellStyles & cellStyles = doc.styles().cellStyles();

    XLWorksheet wks = doc.workbook().worksheet("Sheet1");
    XLStyleIndex cellFormatIndexA2 = wks.cell("A2").cellFormat();                 // get index of cell format
    XLStyleIndex cellFormatIndexA3 = wks.cell("A3").cellFormat();                 // get index of cell format

    XLStyleIndex fontIndexA2 = cellFormats[ cellFormatIndexA2 ].fontIndex();      // get index of used font
    XLStyleIndex fontIndexA3 = cellFormats[ cellFormatIndexA3 ].fontIndex();      // get index of used font

    cout << "A2 wheter strikethrough:" << fonts[ fontIndexA2 ].strikethrough() << endl;      // strikethrough() is 0
    cout << "A3 wheter strikethrough:" << fonts[ fontIndexA3 ].strikethrough() << endl;       // strikethrough() is 0

#section 3: OpenXLSX info
Dec 23th, 2024.

[kevin-ma-86]

Demo11.xlsx
here is the test excel file which cell A3 has set strikethrough while A2 not.

[aral-matrix]

Your usage seems correct at first sight. I currently have no computer with me, I will be able to check what's wrong tomorrow evening. It might be an unexpected field value in the XML that pugixml does not evaluate to true.

[aral-matrix]

bool XLFont::strikethrough() const { return appendAndGetNodeAttribute(*m_fontNode, "strike", "val", "false").as_bool() ; }

vs. your example document:
<font><strike/>[...]</font>

XLStyles expects the "val" attribute, and in absence, defaults to false.

Edit: the below suggestion will not accomplish the desired effect, it would auto-detect all fonts as strikethrough unless they have <strike val="false"/>. I will provide a better solution tomorrow.

If you change that line (758 in main branch XLStyles.cpp) to have "true" as default value, it will have the desires effect. BUT: I don't know if that is conform with OOXML standard.

Did you generate the file with MS Office?

[kevin-ma-86]

1.Yes. I both create and edit this excel file "Demo11.xlsx" from MS Office Excel 2016. And I read strikethrough symbol from excel 2016 normally.
2.And just now I create and edit this excel file from MS Office Excel 2016 again. I unzip the excel and I get the same information as you have get [...].
3.Thanks for suggestion.But the real situation is that workmate will offer me excel file which create by them by MS office instead of the demo excel file that I create . And I try read out the information from these files.

[aral-matrix]

Okay, I patched a change into the development-aral branch - please have a look & try out 99d53b2

Let me know if that fixes it (it should :)

[kevin-ma-86]

1.Thanks for your help. But the compiler can not find API appendAndSetAttribute() he appendAndGetNodeAttribute() in this XLStyles.cpp, and it compile error.
2.For this link, you only share XLStyles.cpp and README.md.

[aral-matrix]

I think maybe you misunderstood me - the patch only shows the change that I made in the last update - but you will still need to download the current status of the development-aral branch (git pull, or <> Code v-> Download ZIP) in order to get a working version of the project.

[aral-matrix]

Patch has been merged into master - please let me know if you have any further questions.