Copy Formatting From RowNew rows get values easily enough. Matching the fonts, number formats, and fill of your template row is the part people do by hand…
Write As Plain TextWrite 00123 to a cell and Sheets stores 123. Write a 16-digit order ID and you get 1.23457E+15, and the last digits are gone for good…
Get Display Row ObjectsgetValues() gives you what's stored in the cell: a Date object, 0.125, 4500. Sometimes you want what the cell shows: Dec 18, 2026, 12.5%, $…
