Reply to topic  [ 1 post ] 
Using names 
Author Message

Joined: Wed May 09, 2007 8:36 am
Posts: 14
Location: Israel
Reply with quote
Post 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
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 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

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.