User:Stefanw/Werkstatt/Date Issue Calc

From Apache OpenOffice Wiki
< User:Stefanw‎ | Werkstatt
Revision as of 17:22, 30 December 2008 by Stefanw (Talk | contribs)

Jump to: navigation, search
Der Inhalt dieser Seite steht unter der Lizenz Creative Commons Namensnennung - Weitergabe unter gleichen Bedingungen 3.0 Deutschland.
Bilder und Dateien können abweichende Lizenzen haben!





User-Bereich von Stefan Weigel

Seiten im User-Bereich:

Tipps

Archiv

Seiten von Stefan im OOo-Wiki:

Marketing

Makro

Dokumente

Bearbeiten...
  1. Open a new spreadsheet.
  2. Have a look at Tools|Options|Calc|Calculate|Date (should be set to "12/30/1899 (default)").
  3. Enter a date into a cell of the spreadsheet. Remember that date.
  4. Save and close this spreadsheet.

  5. Open another new spreadsheet.
  6. Change Tools|Options|Calc|Calculate|Date to "01/01/1900 (StarCalc 1.0)"
  7. Close the spreadsheet, no matter if you save it or not.

  8. Reopen the first spreadsheet.
  9. Compare the date in the cell to the date you remember. The date that is showing up now is one day before the date you had entered.
  10. Have a look at Tools|Options|Calc|Calculate|Date (it´s still set to "12/30/1899 (default)").

Why has the date changed?

Retrieved from "https://wiki.openoffice.org/w/index.php?title=User:Stefanw/Werkstatt/Date_Issue_Calc&oldid=105983"
Personal tools