Change Named Range Value from formula to Value

[jaryszek]

Hi Guys,

I have named ranged VarTest with Value =

Please Login or Register  to view this content.

And this named range hides array of values:

Przechwytywanie.PNG

Problem is that field Value assigned to VarTest in Name Manager is marked as {...}:

Przechwytywanie2.PNG

Problem is that Java code doest see this.

When i have pure value there, for example: 5 or "Azor" it will read this.

Question is how to assign to value field caculated result?
To have result like:

Please Login or Register  to view this content.

or array of values there?

I thoutg maybe looping through each named range and change value fields using VBA?
So check if Value = {...} and change it for result.

Please help,
Best,
Jacek

[Norie]

Jacek

How is the named range being referred to in the Java code?

[jaryszek]

hi Norie,

i am newbie in JAva but my developer is using POI APACHE and code is:

var.png

sorry i cant input code directly bvecause of firewall on our forum.

Best,
Jacek