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?