To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82339 Issue #|82339 Summary|Calc OLH enhancement: referencing cell range intersect |ions Component|Spreadsheet Version|OOo 2.3 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|jfnif
------- Additional comments from [EMAIL PROTECTED] Sat Oct 6 17:20:17 +0000 2007 ------- I can't find any information within the French version of the Calc OLH about referencing cell range intersections. So, following Sophie Gautier's advice, I've written a short description which could be used as a starter for an OLH item. Here goes: Referencing cell range intersections If you want to reference cell range intersections within formulas, just use the "!" (exclamation mark) as a separator for the two ranges to be intersected, like in: = C10:C20!A15:E15 This intersection will return the value currently stored in cell C15. Whether the cell range is named or not doesn't make a difference. If you named the C10:C20 range as MyVertRange and the A15:E15 range as MyHorizRange, the following formula is equivalent to the former: = MyVertRange!MyHorizRange --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
