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.
- From: robert_weir@us.ibm.com
- To: "Warren Turkal" <turkal@google.com>
- Date: Fri, 16 May 2008 11:32:49 -0400
"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.
-Rob
- References:
- ODD{F,L}, Yield and Price spreadsheet functions.
- From: robert_weir@us.ibm.com
- Re: [office] ODD{F,L}, Yield and Price spreadsheet functions.
- From: "David A. Wheeler" <dwheeler@dwheeler.com>
- Re: [office] ODD{F,L}, Yield and Price spreadsheet functions.
- From: "Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>
- Re: [office] ODD{F,L}, Yield and Price spreadsheet functions.
- From: robert_weir@us.ibm.com
- Re: [office] ODD{F,L}, Yield and Price spreadsheet functions.
- From: "Warren Turkal" <turkal@google.com>
[Date Prev]
| [Thread Prev]
| [Thread Next]
| [Date Next]
--
[Date Index]
| [Thread Index]
| [List Home]