User:Stefanw/Werkstatt/Date Issue Calc
From Apache OpenOffice Wiki
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 |
- Open a new spreadsheet.
- Have a look at Tools|Options|Calc|Calculate|Date (should be set to "12/30/1899 (default)").
- Enter a date into a cell of the spreadsheet. Remember that date.
- Save and close this spreadsheet.
- Open another new spreadsheet.
- Change Tools|Options|Calc|Calculate|Date to "01/01/1900 (StarCalc 1.0)"
- Close the spreadsheet, no matter if you save it or not.
- Reopen the first spreadsheet.
- Compare the date in the cell to the date you remember. The date that is showing up now is two days before the date you had entered.
- Have a look at Tools|Options|Calc|Calculate|Date (it´s still set to "12/30/1899 (default)").
Why has the date changed?