Add XLStyle support

[gvollant]

This PR add XLStyle It contain the original work from https://github.com/troldal/OpenXLSX/issues/104 CEXT see https://github.com/troldal/OpenXLSX/issues/104

[gvollant]

thank you @CEXT-Dan for writing this code

[gvollant]

@troldal I've juste made a rebase against master after 0.3.2 release

[gvollant]

@troldal I made rebase against master

[gvollant]

@troldal what is your idea about this PR?

[gvollant]

There is a function xlsx_formatter in this other library : https://github.com/damian-m-g/xlsx_drone/blob/master/src/xlsx_drone.c

[gvollant]

@damian-m-g , is it a problem for you importing your xlsx_formatter which parse format to "understand" if it is a date on openxlsx ?

[CEXT-Dan]

Hi

I’ve done some work on date-time and started on Fonts read only. It’s not done yet though. I added a class OpenXLSX::XLNumberFormat which does a better job at detecting Currency, Percent and Date formatted numbers. (cell.style().numberFormat())

Anyway, you can get the custom format strings from cell.style().formatString() From there one can parse it I.e. [$-10464]dddd,\ mmmm\ d,\ yyyy;

I wrote a parser for my app, not public because it requires non-standard formatting, it wasn’t hard, the only thing weird is excel uses mmmm for month instead of MMMM, so you have to take care when there’s minutes

So kDate Format string = m/d/yy\ h:mm;@ gets weird.

I’m a newb at GIT, so created a branch, so I don’t ruin things, which I’m quite good at. https://github.com/CEXT-Dan/OpenXLSX/tree/feature/Detect_DateTime

I plan on doing a read only border class.

[gvollant]

Hello, I suggest you create yourself a pull request after reducing the number of commit https://git-scm.com/book/en/v2/Git-Tools-Rewriting-History

[gvollant]

@troldal @CEXT-Dan I rebased my gvollant:feature/XLStyle branch of this request with all modification from Cext_dan (merged in one commit) I've also added a fix for https://github.com/troldal/OpenXLSX/issues/133 You can both commit on my fork

[damian-m-g]

@damian-m-g , is it a problem for you importing your xlsx_formatter which parse format to "understand" if it is a date on openxlsx ?

@gvollant feel free to import my code where it's neccessary. Sadly I'm unavailable to take a look at this issue during these days.

[gvollant]

@damian-m-g I've added code from xlsx_drone on commit https://github.com/troldal/OpenXLSX/pull/111/commits/bd152d289fae74ec0bbe1406a08e10099cffe6f3

@CEXT-Dan your feedback is welcome. We probably need a 'cache' to avoid parsing each style at each cell...

You call all three add commit on my fork

[MksmOrlov]

Hello. If there is a method to make first table column Bold?

[gvollant]

@troldal are you interrested by this feature?

[troldal]

@gvollant yes, I am indeed. I will eventually get around to it, but I have some other stuff I need to clean up before I proceed. But rest assured, I have not forgotten your PR.