Difference between revisions of "User:Stefanw/Werkstatt/Date Issue Calc"
From Apache OpenOffice Wiki
< User:Stefanw | Werkstatt
(New page: {{UserStefanw}} # 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. Reme...) |
|||
Line 4: | Line 4: | ||
# Have a look at Tools|Options|Calc|Calculate|Date (should be set to "12/30/1899 (default)"). | # 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. | # Enter a date into a cell of the spreadsheet. Remember that date. | ||
− | # Save and close this spreadsheet. | + | # Save and close this spreadsheet.<br><br> |
− | + | ||
# Open another new spreadsheet. | # Open another new spreadsheet. | ||
# Change Tools|Options|Calc|Calculate|Date to "01/01/1900 (StarCalc 1.0)" | # Change Tools|Options|Calc|Calculate|Date to "01/01/1900 (StarCalc 1.0)" | ||
− | # Close the spreadsheet, no matter if you save it or not. | + | # 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 one day before the date you had entered. | # 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. | ||
− | # Have a look at Tools|Options|Calc|Calculate|Date (it´s still set to "12/30/1899 (default)"). | + | # 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:22, 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 one day 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?