There should be a spcification for OFFSET, too, but I couldn’t find one, and the help texts offered by support pages are notoriously unreliable. It is not so easy to find specifications concerning Excel. In Calc OFFSET should work as specified here. Please note that NewHeight=0 or NewWidth=0 should be considered illegal for any implementation. If you want to get what OFFSET(StartRef ro co rs cs) is claimed to return in Excel even if rs and/or cs are negative generalized in Calc, you have to use If you want to get access to A1:A3 by OFFSET based on A3 as the reference to start with, you have to use OFFSET(A3 -2 0 3 1) in Calc. The behaviour reported for Calc may be fact, but should be considered a bug (see below). The fifth parameter is the NewWidth in columns also in Excel. “Offset (A3 0 0 1 -3) gives as a result: - in Excel”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |