[BUG] date (format) not properly read / written

fslaborg / FsSpreadsheet

Spreadsheet creation and manipulation in F#, Javascript, and Python.

http://fslab.org/FsSpreadsheet/

MIT License

19 stars 1 forks source link

[BUG] date (format) not properly read / written #80

Open Brilator opened 9 months ago

Brilator commented 9 months ago

Popped up while using ARCitect and copy-pasting a date from another excel file to the isa.investigation.xlsx of a new ARC. When the date format is changed (via Excel) the out format can be messed up.

#r "nuget:FsSpreadsheet.ExcelIO"

open FsSpreadsheet
open FsSpreadsheet.ExcelIO

FsWorkbook.fromXlsxFile("isa.investigation.xlsx").ToFile("out.xlsx")

HLWeil commented 7 months ago

What format was the input value in? (e.g. DD/MM/YY)

What was the error with the output? Was it not a date anymore, just a different format or a wrong date?