openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Wang <>
Subject Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again
Date Tue, 03 Jul 2012 09:02:40 GMT
Jian Hong,

Will AOO save VBA as Star Basic in ods file when saving a xls file with VBA
as ods file? If it is true, can user modify the Star Basic in the new ods
file? What happened if user change the Star Basic in the ods file then save
as a xls file?

On Tue, Jul 3, 2012 at 3:57 PM, chengjh <> wrote:

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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message