|
|
Actually the post was 08/09/2007 and I still have the same problem. I've been a
member since '03. Your first solution " changed it to "=DataSheet!A1" .." is
what I was doing. Also I was doing your solution #2 except once it grabs the
value, it converts the formula in the chart to text, making it useless the next
time. I went to Adobe MAX and spoke with the developers. Their suggestion was
to use the .Net integration in CF8, since it seems to be a POI/Excel bug. My
client is still on CF7, so I'm stuck for now, but will be trying to understand
the .Net integration solution in the meantime. I see the topic is in Forte's
latest book Adobe ColdFusion 8: web application construction kit Vol.3. Chapter
74 - Integrating with .NET and chapter 76 - Integrating with Microsoft Office.
If we could contact a POI-HSSF developer, perhaps they could fix the bug. I
have not had any luck.
:gift;
|
|