User preferences are global settings applied to new documents. User Preferences can be overridden by database connection formatting and document-based formatting.
Order of Formatting Precedence:
Spreadsheet user preferences and chart user preferences are identical to spreadsheet options and chart properties. They are applied only to subsequently created documents.