Yes, Jim. Your description is very exact about this topic. Thank you. 2012/7/3 chengjh <chen...@apache.org>
> Hi Peng, > > Let me use a scenario to confirm your problem,solution and > question..Anything misunderstood,please correct me.thanks. > > Problem: > When AOO launches an excel document with VBA,saves to ods and then saves to > excel again,the VBA info will be lost. > > Solution: > a)The VBA streams of an excel document will be saved into the ods document > with binary format when converting an excel document to an ods document in > AOO Spreadsheet with certain controller. > b)Once the ods document containing the binary VBA streams is launched into > AOO or previous releases,with certain controller,the binary VBA steams will > be loaded[still binary stream in memory] or rejected..There is no any > impact on the application,the application can still work well. > c)Based on b),if the ods document is saved to an excel document,the binary > VBA streams will be exported, thus, the VBA info will not be lost. > > Question: > You are not sure whether this solution is reasonable. So, you want to know > the comments about your solution. If no comments, you will do so to > implement it. > > On Mon, Jul 2, 2012 at 4:33 PM, Chen Peng <chenpeng2...@gmail.com> wrote: > > > Hi All, > > My name is Chen Peng, I am a developer from Symphony. My special > > areas are VBA and sw. > > Now I found an issue about macros lost: > > I saved an excel file with VBA to spreadsheet, the VBA can work > > well in spreadsheet, then I wanted to save this spreadsheet back to > excel, > > but all the macros are lost. > > I propose to save the binary data of excel VBA to spreadsheet, when > > saving excel to spreadsheet, then we can get the binary data from > > spreadsheet if need to save the spreadsheet to excel again. > > The binary data will not impact the open/save... of the ODF format > > application, it will not be touched when we operate the ODF formant > > applications. The binary data will be just used when we want to save the > > spreadsheet to excel, it is just a data prestore about saving spreadsheet > > macros to excel. > > Can you give some advice about the solution? > > Any feedback will be preciated, thanks. > > > > > > -- > > Best Regards,Jianhong Cheng >