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 reproduceCTRL + A twice to select the whole sheetSet font size to 12Copy & Paste clear text into column EExpected ResultsText in column E is in font size 12Actual ResultsText in column E is in smaller font sizeUPDATE:To recreate the date formatting issue I have created another sheet.Steps to ReproduceSet date formatting on column D to DD MMM YYY (like 1 Jun 2015)Insert some short test in a cell in column BResults ExpectedLMDT triggered on OnEdit event preserves the formatting: 1 Jun 2015Actual ResultsLMDT triggered on OnEdit 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.
Cell formatting in Google Spreadsheets does not get preserved
google spreadsheets;formatting;conditional formatting