Date format is lost when copying a row from one sheet to other.

[heaven]

row = input_sheet.row(idx)
output_sheet.insert_row(errors_sheet.last_row_index, row)

Input file has:
| 28.10.2011 | 21.10.2007 | 21.10.2007 |

Output file:
| 40844 | 39376 | 39376 |

BTW, the last_row_index return 0 even if sheet is just created and empty, but this should be nil (for example when dimensions = [0, 0, 0, 0]). Also would be nice to save the input row formatting.

[zdavatz]

are you creating a new file or editing an existing one?

[zdavatz]

OS, Ruby Version, Spreadsheet version, complete sample code to run?