To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=93265
Issue #|93265
Summary|Regarding Formula Bar Feature
Component|Formula editor
Version|OOo 2.0
Platform|Unknown
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|FEATURE
Priority|P3
Subcomponent|code
Assigned to|mru
Reported by|muthukumar_42
------- Additional comments from [EMAIL PROTECTED] Fri Aug 29 18:43:27 +0000
2008 -------
Hi,
Following are my queries.
1. How to select two coloumns completely in VLOOKUP formula "array" Field.
Solution Available :
By Entering A1:B65536 or By using Mouse have to scroll all the way from first
row first coloumn (A1) to second row Last coloumn ( B65536).
Suggested solution :
By using the mouse selecting the header of the two coloumns. ( now this feature
is not available).
2. How to use fixed/locked table in VLOOKUP formula ?
Solution Available:
by inserting $ symbol manully before the row & coloumn id like $A$1:$B$20.
Suggested sollution:
By using a function key ( F4 used in MS Excell) after selection
of the range to insert the $ symbol before the row & coloumn id to get a fixed/
locked table.
The above two features are not limited with VLOOKUP. it can be extended to other
formula's also.
Thanks & Regards,
Muthukumar VS
India.
---------------------------------------------------------------------
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]
