OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office] ODD{F,L}, Yield and Price spreadsheet functions.

"Warren Turkal" <turkal@google.com> wrote on 05/15/2008 10:03:36 PM:

> And if one wants to update a document to use another convention, how
> would the user change the table:null-date value? Is this something
> that would appear in the format dialogs?

Typically this is an document-wide setting.  Excel has it in the Tools\Options\Calculation dialog.  OpenOffice puts the setting in Tools\Options\OpenOffice.org Calc\Calculate.

But note that changing this setting does not automatically shift values around so dates remains consistent.  If you have January 1st 1900 as your date origin, and then switch to 1904 origin, then any date calculation that operated on numeric data will be shifted 4 years forward.


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]