We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

named range in formula

Thread ID:

Created:

Updated:

Platform:

Replies:

18626 Sep 3,2004 03:10 PM UTC Jan 20,2005 05:10 PM UTC WinForms 5
loading
Tags: XlsIO
Greg
Asked On September 3, 2004 03:10 PM UTC

Good Day, I cannot seem to reference a named range within a formula that I write out to xls - the name gets converted to the cell location, so that the formula in Excel does not show up nicely. The main value of named ranges is so that formulas contain the names instead of cell references, making the formula more readable. Example attached: namedrange namedrange_312.zip Also I see that when reading an xls file with named ranges, I also do not see the name within the formulas. In XML Spreadsheet, one can actually read whether a formula references a named range vs. a cell that happens to be named. i.e. =namedcell+5 vs. =''Sheet1"!$A$1+5 It would be nice to know the difference and have the formula as the user entered it, as opposed to assuming that the formula must have referenced the name, since that particular cell reference was named. Thanks, Greg

Administrator [Syncfusion]
Replied On September 4, 2004 03:27 AM UTC

Hi Greg, I have reported this issue to the development team and will update this thread with more information as soon as I hear back from them. Thank you for your co-operation. Best regards, Stephen. >Good Day, > >I cannot seem to reference a named range within a formula that I write out to xls - the name gets converted to the cell location, so that the formula in Excel does not show up nicely. The main value of named ranges is so that formulas contain the names instead of cell references, making the formula more readable. Example attached: namedrange > >namedrange_312.zip > >Also I see that when reading an xls file with named ranges, I also do not see the name within the formulas. In XML Spreadsheet, one can actually read whether a formula references a named range vs. a cell that happens to be named. i.e. =namedcell+5 vs. =''Sheet1"!$A$1+5 >It would be nice to know the difference and have the formula as the user entered it, as opposed to assuming that the formula must have referenced the name, since that particular cell reference was named. > >Thanks, >Greg > > > > >

Greg
Replied On January 11, 2005 07:22 PM UTC

ExcelRW ExcelUtils.Open has exception errors when opening the attached file (from Microsoft) that contains user defined named ranges. This xls also has non-visible named ranges seemingly from Solver, but simply deleting the two user named ranges causes ExcelRW to stop choking. transport_7363.zip

Administrator [Syncfusion]
Replied On January 12, 2005 03:36 AM UTC

Hi Greg, Which version did you use to open this file?. I tried it with version 3.0.1.0 and it worked fine. Thanks. Best regards, Stephen. >ExcelRW ExcelUtils.Open has exception errors when opening the attached file (from Microsoft) that contains user defined named ranges. This xls also has non-visible named ranges seemingly from Solver, but simply deleting the two user named ranges causes ExcelRW to stop choking. > > > >transport_7363.zip > >

Greg
Replied On January 14, 2005 06:10 PM UTC

Yes, we experience exceptions using 3.0.1.0. Maybe you do not have exception handling set to break on exceptions? We can "continue" past it, but figure it is something that should be cleaned up.

Administrator [Syncfusion]
Replied On January 20, 2005 05:10 PM UTC

Hi Greg, I have reported this issue to the development team and it should be fixed in the next patch. Thanks. Best regards, Stephen. >Yes, we experience exceptions using 3.0.1.0. Maybe you do not have exception handling set to break on exceptions? We can "continue" past it, but figure it is something that should be cleaned up.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;