My 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
12
- Copy & Paste clear text into column
E
Expected Results
- Text in column E is in font size
12
Actual Results
- Text in column E is in
smaller
font size
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
Results Expected
LMDT
triggered onOnEdit
event preserves the formatting: 1 Jun 2015
Actual Results
LMDT
triggered onOnEdit
event does not preserve the formatting: 01/06/2015 07:20:34time = 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.