Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-dev@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of lei.wang.leiw@gmail.com
 designates 209.85.160.175 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAAG1rAxTVM=99sE=Odbv_nr4itB-hPZgueFcAeC=VpF7Gf9d-g@mail.gmail.com>
References: 
 <CALbOLXtUuY715YUT11ZYTeHwORGp4En0rkcjcXeyRg6WwKZ2cA@mail.gmail.com>
	<CAAG1rAyYLZ_GiArE7v5=k1KQt7PEVvzAPxrFnJaGdo1p3CHa1Q@mail.gmail.com>
	<CA+mMfTfsRzfvP0q0DHRCF6E3eMXPfUrXHYmLgQwL4fBUW3iHSA@mail.gmail.com>
	<CAAG1rAxTVM=99sE=Odbv_nr4itB-hPZgueFcAeC=VpF7Gf9d-g@mail.gmail.com>
Date: Tue, 3 Jul 2012 22:22:12 +0800
Message-ID: 
 <CA+mMfTfw7L6Ni0CUc0ohiBg+S8QW5Nq1+hFm19Z2WywpJ1A90w@mail.gmail.com>
Subject: Re: [DISCUSS]Macros are lost after saving the xls file to ods, then
 save as to xls again
From: Lei Wang <lei.wang.leiw@gmail.com>
To: ooo-dev@incubator.apache.org
Content-Type: multipart/alternative; boundary=f46d042f9eb0ff492604c3eda3a1

--f46d042f9eb0ff492604c3eda3a1
Content-Type: text/plain; charset=ISO-8859-1

As I know, VBA code can be related with specific sheet. When end user open
the ods file and remove this sheet, then save it as xls file.  According to
your solution, all VBA codes will be restored in xls file. Is this xls file
valid?

Another concern is does your solution conform to ODF1.2 standard?

On Tue, Jul 3, 2012 at 6:32 PM, chengjh <chengjh@apache.org> wrote:

> That doesn't matter that you think they are VBA or Star Basic when saving a
> xls with VBA as ods file..To some APIs with behavior difference,they will
> be distinguished with the line "Option VBASupport 1" at the beginning..End
> users can modify the Star Basic codes in AOO Spreadsheet,but all Star Basic
> contents including original and modified will be lost when exporting to xls
> file..Here,if the ods file is converted from a xls file based on Peng's
> solution,the behavior is still kept unchanged...The only difference is that
> the saved binary VBA streams within the ods file will be exported to the
> xls file at that time.Thus,when end users launch the xls file in MS
> Excel,the original VBA will be there.That's the expected result.thanks.
>
> On Tue, Jul 3, 2012 at 5:02 PM, Lei Wang <lei.wang.leiw@gmail.com> wrote:
>
> > 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 <chengjh@apache.org> 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 <chenpeng2006@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
> > >
> >
>
>
>
> --
>
> Best Regards,Jianhong Cheng
>

--f46d042f9eb0ff492604c3eda3a1--