Ah, the data may have been inserted into the report using POI but, and this is simething that I guess you could not have been aware of, POI cannot be used to create or edit macros. Therefore, it is quite likely that the authors of the original document used a template that contained those macros and then utilised POI to open the template a stuff data into it because they could not have used it to either create or edit the macros. That was why I advised you to post the question onto an Excel forum rather than this one, sorry if I did not make that clear.
Yours Mark B Patil Minal wrote: > > Mark, > > I know this forum is specifically to address issues regarding POI, and I > tried a lot searching on google also but with no success. However, I > thought if anyone on this forum might possibly have answer for my problem > then I would be grateful. Although, the web application from where we > download the excel report in question uses POI to generate the excel > report, I think there wouldn't be any POI's relevance in this issue. > > - Minal. > > -----Original Message----- > From: MSB [mailto:[email protected]] > Sent: Tuesday, February 16, 2010 10:01 PM > To: [email protected] > Subject: Re: event to notify excel initialisation end > > > Think you may have posted this question in the wrong place; most of the > members of this list know how to use an API to create files that are > compatible with Excel. It seems to me that you want to post this sort of > question on an Excel users forum and I feel confident that Google will > point > the way to those. > > Yours > > Mark B > > > Patil Minal wrote: >> >> Hi, >> >> I have one excel report wherein I need to trigger a macro >> which performs chart scaling once the report is fully downloaded. The >> excel report has a lot of formulae which internally call other macros to >> populate the excel cells on one sheet from a different data sheet. The >> excel does not respond until the excel is fully populated i.e. all the >> cells have there formulae executed. However, all the events like Activate >> or open occur quite before that. Hence, I don't get a trigger event to >> call the macro to change the chart scaling. >> >> Please help. >> >> Minal Patil >> >> >> >> > > -- > View this message in context: > http://old.nabble.com/event-to-notify-excel-initialisation-end-tp27609032p27611025.html > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/event-to-notify-excel-initialisation-end-tp27609032p27619989.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
