sc-im icon indicating copy to clipboard operation
sc-im copied to clipboard

Date formatted cell output twice in CSV

Open marrs opened this issue 1 year ago • 1 comments

To reproduce, export the following file to CSV.

# This data file was generated by the Spreadsheet Calculator Improvised (sc-im)
# You almost certainly shouldn't edit it.

newsheet "Sheet1"
movetosheet "Sheet1"
offscr_sc_cols 0
offscr_sc_rows 0
nb_frozen_rows 0
nb_frozen_cols 0
nb_frozen_screenrows 0
nb_frozen_screencols 0
format A 13 2 0
leftstring A0 = "1/2/20"
let A0 = 1580515200
fmt A0 "d%d/%m/%y"
leftstring A1 = "1/2/20"
let A1 = 1580515200
fmt A1 "d%b %Y"
goto A1

The following CSV is produced

01/02/201/2/20
Feb 20201/2/20

The following should be produced:

01/02/20
Feb 2020

marrs avatar Jul 02 '24 15:07 marrs