aral-matrix

Results 99 comments of aral-matrix

Apologies for the late reply, but let me comment on the issues that are already addressed: > the value of formula won't automatical update in office2016 Since a year or...

I could see that being useful, but it also is likely a non-trivial task, and I currently have to focus on the project that I originally needed OpenXLSX for myself,...

Hi @easymoney322 - I am going through the backlog of issues - could you provide an example XLSX file that contains a table and some basic filters? Maybe 3-5 columns...

Thank you for providing the example files. Regarding your question about the file authorship: ``` doc.setProperty(XLProperty::Creator, "aral-matrix"); doc.setProperty(XLProperty::LastModifiedBy, "aral-matrix"); std::cout

okay, regarding tables functionality, I see it falls in the category of hyperlinks and comments, in that it requires support for worksheet relationships in xl/worksheets/_rels/sheet#.xml.rels: ``` ``` This means I...

Worksheet relationships support is in now - I have tables support next on the agenda :)

Hi @Tekl7 & thank you for your contribution! Would you be disappointed if I refactored this code to skip all the manual calculations and use the built-in C/C++ functions for...

Hi @Tekl7 - timestamps (and tm_year) can be negative relative to the epoch: ``` #include // struct tm, gmtime, strftime #include void printTime( time_t timestamp ) { constexpr const size_t...

Researching this, I see one additional issue: Excel appears to have an epoch that wrongly assumes 1900 was a leap year, therefore epoch is off by 1 day until 1...

It wasn't always like this - many systems until recently (and some older systems still do, I guess) were storing timestamps in 32 bit, and making those unsigned ints because...