0

setnamename

asked 2016-03-31 11:54:35 +0800

billcawley gravatar image billcawley
1

Hello,

I wish to set a range name in a spreadsheet - I see that there is a function applied to Ranges.range 'setNameName'(<string>,<string>).

Can I use this function? If so, why are there two strings required?

I'd be grateful for any help.

delete flag offensive retag edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2016-04-01 04:40:26 +0800

cor3000 gravatar image cor3000
6280 2 7

updated 2016-04-01 04:51:10 +0800

to create a new "Name" (e.g. a named range) use

org.zkoss.zss.api.Range.createName(String)

to change the name of an existing "Name" you can use the 2 parameter method setNameName

org.zkoss.zss.api.Range.setNameName(oldName, newName)

Unfortunately excel introduced the concept of Names which can have a name... making it sound a bit strange to write/talk about this, using the existing terminology so I hope my answer is not too confusing.

Robert

link publish delete flag offensive edit
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow
1 follower

RSS

Stats

Asked: 2016-03-31 11:54:35 +0800

Seen: 19 times

Last updated: Apr 01 '16

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More