incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rob Weir <>
Subject Re: [DISCUSS]Macros are lost after saving the xls file to ods, then save as to xls again
Date Tue, 03 Jul 2012 11:15:01 GMT
On Mon, Jul 2, 2012 at 4:33 AM, 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.

How common is this scenario?   Wouldn't the more typical user action
be to re-save the document back to XLS format?  Isn't that what
happens by default when they do a save when editing an XLS file? If
the user does this, will the macro be saved correctly?

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

View raw message