I have a question about sheets…

Is it possible to insert a blank row within a sheet…when I click new record the blank row appears at the bottom.

Also is it possible to do basic SUM, like a simple spreadsheet?

No, you can’t insert a record in a certain position. And there are a few Applescripts under the script icon menu > Sheets for creating a sum, but there are no functions as found in Excel.

Well, what you can do is the following:

Open the sheet in another program (Excel or text editor), insert a row there and save the document back to disc.

DTP will pick up the changes and display the modified sheet.

I have tried this but it does something weird to the formating when I open the csv in excel.

There is no formatting in either a Sheet nor a CSV file (which is plain text). What are you seeing?