| 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/ |
|