On Wed, 7 May 2008 15:46:27 -0400 Jerry Feldman <[EMAIL PROTECTED]> wrote:
> In an excel spreadsheet I am encountering a strange error where I have > a correct formula in a cell, in this case L190 contains: > =difdate($F$4;$K190;"y")+1 and yields Err:522, yet all other cells > between L11 and L201 display the correct result of the formula. Err:522 > has to do with circular references, but that does not make sense > because there is nothing iterative here, and that does not explain why > cell L191 does not report an error. > > Note that the difdate() macro is analogous to the Excel datedif(). > The formulai in L189 and L191 are: > L189: =difdate($F$4;$K189;"y")+1 yields 15 > L191: =difdate($F$4;$K191;"y")+1 yields 16 > > F4 contains 7/4/2007 and K189, K190, and K191 contain 5/4/2022, > 6/4/2022, 7/4/2022. > > I can fix the error by selecting L189 and dragging it down to L190, or > selecting K191 and dragging up, or, by selecting the formula > (=difdate($F$4;$K190;"y")+1), cutting it, then pasting it back. It is > very simply to fix. I'll try to reduce the size of the spreadsheet > (contains 17 sheets) and issue a bugzilla later on. > As I was trying to reduce the spreadsheet to send it, I first saved it as an OpenDocument file (.ods), and the error changed from cell L190 to Q11, that has a similar, but more complex formula with vlookup(). -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
