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. -- -- 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
