Date format not being remembered in Sweet #4
Description
Problem/Motivation
When applying a date format to a column it doesn't remember the formatting. It will change whatever's already there, but not anything you add new. Also when you do add new it displays blank until you click enter, then after a while what you entered will be displayed.
Also the internal field names are being displayed throughout the UI, e.g. sheet.numfmt.date. I will probably create a new issue at some point about that at some point.
Steps to reproduce
Click a column and select the sheet.numfmt.date option (I haven't figured out how/if I can get it to display it how I prefer which is 1-Sep-2024 so just using the default US YYYY-MM-DD).
It seems to work OK for currencies, so once I figured out how to display £s it does so on new data in the column too.