Simply: If you replace F12 with the expression ="G3:" & "I6" the errors vanish.
If INDIRECT is passed a cell which contains a reference eg G3:I6 then it works. If INDIRECT is passed a string which is a named reference, it returns an error. Is that helpful? [EMAIL PROTECTED] wrote:
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4695 ------- Additional comments from [EMAIL PROTECTED] Tue Dec 12 21:02:15 -0800 2006 ------- Sorry about the delay on this, I just got an email today that reminded me that I said I would fixthis... Ok I looked back at the source code I had downloaded when I originally was looking at this problem and remembered quickly that I could not really find any kind of structure to this program. To save me alot of time (because I'm guessing some of the people on this board know this program pretty well) I need to be pointed to the following: Where & What is the source file/function name that has the function INDIRECT in it? Where & What is the source file/function name that allows you to place =<named field> into a cell and it will do the look up of that cell name and place the value of that named cell into the cell? Where & What is the source file/function name that allows cells values to be looked up out of external spread sheets so I can make the following work as requested in one of the messages below: =indirect( 'file://path-to-file.sxc#named_cell' ) --------------------------------------------------------------------- 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
-- ===================================================================== Jonathan Mills, Desktop Practice, Client Solutions Sun Microsystems, Solaris House, Guillemont Park, Minley Road, Blackwater, Camberley, Surrey, GU17 9QG, UK. Ext (70)21481 DDI: +44 (0)1252 421481 Mob: +44 (0)7802 175797 ===================================================================== --------------------------------------------------------------------- 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]