There are identical formatting options and user preferences. 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 only applied to subsequently created documents.