fosnola wrote:
Hello,
concerning the 1900/1904 date problem, normally this problem was fixed in libmwaw-0.3.2 (*). The problem was that the dates are stored as decimal numbers: the number of days since 1/1/1904, so when I find a date format, I must read the date's decimal number and convert it to a date using standard date functions and I forgot to change the origin back to 1900 before calling these functions.
Concerning the language format's problem, actually, I only find that a cell must be displayed using the first/second/... date/time/number formats. As I do not know how to retrieve the language of the document (**), I choose to use the US formats lacking a better solution :-~ So I do not know if this can be fixed and how to fix it :-~
(*) which may only appear in LibreOffice 4.4.0. You can test if it is repaired by downloading mwawOSX on the libmwaw download pages : https://sourceforge.net/projects/libmwaw/files/
(**) I do not even know if it is stored in the document or if it is the localized application which defined it :-~
I'm glad to hear that the '4 year' problem can be fixed. 🙂
The other matter - language formats - puzzles me. Why should LibreOffice need to know the format of the original? Surely, if a user has declared "English (UK)" everywhere else, then you can assume they are going to import documents in that format - in other words, it's up to the user what language format is displayed, not LibreOffice. So there is no 'fix' involved, except in giving the user a wider choice of conversion language formats to use. If they choose the wrong one, it's their fault and they will have to correct it.
But in my case, I was converting my own (UK) documents where the originals used UK dates, and that's what I expected to see after conversion. However, mine are all done now, so that won't be a problem again. 😉
Having said all that, I still say LibreOffice is a superb app especially as it's free!