Hello we are generating some excel files with date formatting as below, it works fine for Excel, but LibreCalc did not use the date metadata.
var dateStyle = wb.getStyleSheet().createFormat({
format: 'yyyy-MM-dd HH:mm'
});
We take a moment.js object and create the row as such
if(moment.isMoment(formatted)) {
row.push({value: 25569.0 + formatted.valueOf() / (60 * 60 * 24 * 1000.0), metadata: dateMetaData});
...
I tried to format cells in LibreCalc using User-defined and Format code as yyyy-MM-dd HH:mm and it displays correctly.
Is there any reason why LibreCalc does not pickup the dateMetadata?
I know this library is for Excel and it does its work quite good, just wondering if anyone overcome the issue without sending a string. Thanks for the tips!
Aucun commentaire:
Enregistrer un commentaire