Difference between revisions of "User:Stefanw/Werkstatt/Date Issue Calc"
From Apache OpenOffice Wiki
< User:Stefanw | Werkstatt
| Line 9: | Line 9: | ||
# Close the spreadsheet, no matter if you save it or not.<br><br> | # Close the spreadsheet, no matter if you save it or not.<br><br> | ||
# Reopen the first spreadsheet. | # Reopen the first spreadsheet. | ||
| − | # Compare the date in the cell to the date you remember. The date that is showing up now is | + | # 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)").<br><br> | # Have a look at Tools|Options|Calc|Calculate|Date (it´s still set to "12/30/1899 (default)").<br><br> | ||
Why has the date changed? | Why has the date changed? | ||
Revision as of 17:39, 30 December 2008
| 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?
