Setting up OOo to Suit the Way I Work by Jean Hollis WeberĬonfiguring Writer by Bruce Byfield You can also revert most auto-formatting (including the conversion of straight quotes into curly quotes, e.g., for use in measurements, 3") on a time-by-time basis by pressing Cmd-Z (Undo) after the automatic formatting takes place, and your original text will re-appear. Likewise if you meant April 3rd, then you could just enter Apr 3 Calc will recognize these entries correctly and display the dates as you have the cell (s) formatted. If you want a different year, simply enter it at the end. Reverting automatic formatting on a “one-time” basis and Calc will recognize that as March 4th 2019 (the current year). To turn off auto-completion in Calc, open the Tools menu, then the Cell Contents sub-menu, and select (un-check) the Autoinput item. the programmer can consult the Spreadsheet section in the OpenOffice Developers Guide As. To turn off the AutoFormat feature entirely, open the Format menu, then the AutoFormat sub-menu, and select (un-check) the While Typing option. Excel Conditional Formatting Based on Another Cell Value.
Turning off automatic number-to-date formatting in tables Most of the other options are self-explanatory.
#OPENOFFICE CALC DATE FORMAT SERIES#
Un-check Apply border, for instance, to disable the transformation of a series of dashes, underscores, or asterisks into borders (lines)., for instance, to disable automatic list numbering.Choose the Options tab from the top of the window.You can disable other common auto-formatting annoyances in the same AutoCorrect window. Press OK at the bottom of the window to save your changes.
#OPENOFFICE CALC DATE FORMAT MANUAL#
If you insist on manual formatting, the same options are available using Format > Cells.
0 kommentar(er)
