Date issues in Libreoffice 4.1.4.2

[allanlw]

The trunk version of this software did not work properly in Libreoffice 4.1.4.2, because date handling was changed at some point.

I patched the required script, which was only the 'Charts' script. The new version for that script is attached. I've never done any Libreoffice scripting before, so the style probably isn't correct, but it works.

I haven't tested this that much, but it works fine for me in my brief testing.

[Jon Thysell (jonthysell)]

With this fix were you able to run the spreadsheet like normal in LibreOffice 4.1? I'll take a look at it as soon as I can get a machine up with an updated LibreOffice, but if this is what's been blocking everyone from using WTODS in the newest LibreOffice I'll try to get a release out with your patch.

[John Felso (felso)]

FYI. There appear to be more date problems in 4.2.3.3 that allanlw's updates don't address.

[Phil Olynyk (4hil)]

I believe the attached ChartsFinal.txt solves the problems with dates used in LO 4.x. I am using 4.3.3.2 and no longer having problems. I have not beaten it to death, nor attempted all the corner cases, so some peer review is doubtless in order. I pretty much followed the original logic, casting types as required. I am indebted to allanlw for the pointers and hints he provided in his script, above.

[Jon Thysell (jonthysell)]

Thanks Phil for the updated module, I haven't tested it yet (I haven't had LibreOffice on my machine for six months, and I haven't used WTODS in a couple years at this point), but if it looks like it loads properly I'll try to get a new zip uploaded.