Date base for day zero
Dates are calculated as offsets from a starting day zero. You can set the day zero to be one of the following:
'30/12/1899' (default)
'01/01/1900' (used in former StarCalc 1.0)
'01/01/1904' (used in Apple software)
Choose Tools - Options - OpenOffice.org Calc - Calculate to select the date base.
When you copy and paste cells containing date values between different spreadsheets, both spreadsheet documents must be set to the same date base. If date bases differ, the displayed date values will change!
If you're modifying the cells by copying a date (not text) from another spreadsheet, keep in mind that it's copying the number, and not the Calc > Calculate > Date option. So if you want the meaning of the number to remain unchanged, the two spreadsheets should be using the same Calc > Calculate > Date option. If you're modifying the cells by copying dates from a webpage, you're copying HTML, which is potentially a lot more complicated than it seems because formatting and possibly other properties are carried within the HTML.jackofall wrote:It only changes the cells that I modify, but it always changes them to be 4 years and 1 day earlier, …
MrProgrammer wrote:your user profile is bad (better chance of this if you installed 3.4 without creating a new one).
If you installed 3.4 but kept the user profile from a previous installation, that was probably the cause of your trouble, not a "power outage".MrProgrammer wrote:your user profile is bad (better chance of this if you installed 3.4 without creating a new one).
kingfisher wrote:MS uses a different base date from OO. (AOO and LO almost certainly use the same base date as OO.) The only .xls documents I have contain dates entered as text.
Users browsing this forum: No registered users and 11 guests