Google Spreadsheet does not preserve some formatting. Every time I set, for example font size to 12, for the whole sheet, newly copied data uses a smaller font size.
This only started being an issue after an upgrade to
New Sheets, some time in March.
An example sheet that recreates the issue:
Steps to reproduce
- CTRL + A twice to select the whole sheet
- Set font size to
- Copy & Paste clear text into column
- Text in column E is in font size
- Text in column E is in
UPDATE: To recreate the date formatting issue I have created another sheet.
Steps to Reproduce
- Set date formatting on column D to
DD MMM YYY(like 1 Jun 2015)
- Insert some short test in a cell in column B
OnEditevent preserves the formatting: 1 Jun 2015
OnEditevent does not preserve the formatting: 01/06/2015 07:20:34
time = Utilities.formatDate(time, "UTC", "dd-MM-yyyy **HH:mm:ss** "); s.getRange(r.getRow(), LMDTCol).setValue(time);
Yes, the formatting is set to
dd-MM-yyyy HH:mm:ss but for last five years or so column formatting had higher priority than the formatting set in the script.