Reaaaalllly. That is GOOD to know. Thanks! Yeah, I only tested it once or twice, and ended up abandoning that approach (for a number of reasons unrelated) so I didn't get to fully test. But that is very good to know.
Thanks! ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Doug Bezona [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 4:27 PM To: CF-Talk Subject: RE: ColdFusion and Microsoft Excel Well, changing the values in the .MHT won't change the gif version of the chart that's embedded, BUT the chart does get updated against the proper values when re-imported to Excel (just tested it). > -----Original Message----- > From: Ben Nadel [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 28, 2006 4:09 PM > To: CF-Talk > Subject: RE: ColdFusion and Microsoft Excel > > Doug. That is a good solution idea to explore. As far as charts, I think > the MHT file actually stores a Base64 GIF image of the chart. Then when > you open it up in Excel, it has the GIF chart, but does not recompute > based on the excel data. But, I have not tried anything that complex in > a while. > > If nothing else, this method helps you figure out how to get numeric > columns to render AS text (so that leading zeros don't get taken off and > date/time values don't go all weird). > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4