EasyXLS
http://forum.easyxls.com/

Using names
http://forum.easyxls.com/viewtopic.php?f=5&t=51
Page 1 of 1

Author:  teniel [ Sun Jul 01, 2007 10:27 am ]
Post subject:  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

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/