View unanswered posts | View active topics
It is currently Wed Nov 27, 2024 7:50 pm
|
Page 1 of 1
|
[ 1 post ] |
|
Author |
Message |
teniel
Joined: Wed May 09, 2007 8:36 am Posts: 14 Location: Israel
|
Using names
I have an Excel template with a pre-defined name for cell E13 which I called "date1"
I saved a date in cell E13 using EasyXLS
I have the following formula in my Excel template in cell F13
=TEXT(<b>date1</b>,"dd-mmm-yyyy")
This formula returns #VALUE
(despite my using 'xlsSheet.easy_computeFormulas(xls, true);')
If I change the formula to
=TEXT(<b>E13</b>,"dd-mmm-yyyy")
then I have no problem
Why is this?
Thank you
|
Sun Jul 01, 2007 10:27 am |
|
|
|
Page 1 of 1
|
[ 1 post ] |
|
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|