Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

That is a true statement - LibreOffice does not support the proprietary
Microsoft VBA (it may in a very very limited way but not enough for most
test cases that I've seen) - you'll have to rewrite it in Basic.

Best,
Joel

On Thu, Sep 10, 2015 at 2:04 PM, Tim Lloyd <tim.lloyd@gmx.com> wrote:

> Hi David,
>
> my understanding is that macros in excel and calc are written in different
> languages so need to be rewritten.
>
> Maybe one of the more learned members of the forum can confirm or
> otherwise.
>
> Cheers
>
>
> On 10/09/15 19:48, David Johnson wrote:
>
> > Dear Gabriele and Tim,
> > PFA; This is the Excel Macro sheet we are trying to convert. Could you
> > please help me.
> >
> > --
> > Thanks &Regards,
> > *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
> > Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
> > Bangalore - 560027*|***|***www.janalakshmi.com**|*
> > *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
> > 95-38-455118*||**E-Mail *: david.johnson@janalakshmi.com*|*
> > On 10-09-2015 12:17, Tim Lloyd wrote:
> >
> > > Hi David,
> > >
> > > as noted below. It could just work! Which version were you think of
> > > using? I think there is some consensus that 5.0 may be a little too "fresh"
> > > for an enterprise environment. So the still version of 4.4.5 may be a good
> > > base. Download this version and give it a go:
> > >
> > > http://www.libreoffice.org/download/libreoffice-still/
> > >
> > > There may also be some value having a hunt around the bugzilla to see if
> > > any issues are relevant to yourselves.
> > >
> > > https://bugs.documentfoundation.org/
> > >
> > > Cheers
> > >
> > > On 10/09/15 16:24, Gabriele Ponzo wrote:
> > >
> > > > What's your problem specifically?
> > > >
> > > > Unless there are macros, usually it's enough to open LibreOffice Calc
> > > > and
> > > > let it open the excel file. Then save it in odf (.ods) format.
> > > >
> > > > Let is know of there are troubles with these steps, and please report
> > > > specific problems.
> > > >
> > > > All the best.
> > > > Il 10/set/2015 07:16, "David Johnson" <david.johnson@janalakshmi.com>
> > > > ha
> > > > scritto:
> > > >
> > > > Dear Users,
> > > > > I'm David Johnson, from the Technology team from Janalakshmi Financial
> > > > > Services, Bangalore based NDFC. Currently we are migrating our excel
> > > > > based
> > > > > application to Libre office; hence I need Help on the same. We have
> > > > > been
> > > > > using a survey kind of tool which is developed in Excel to be
> > > > > converted in
> > > > > to Libre office. Can anybody advice us how we go about it. It has to
> > > > > work
> > > > > on all the platforms. Please advice.
> > > > >
> > > > > If there is anybody (a consultant) in around Bangalore. Who can
> > > > > support us
> > > > > are welcomed. Look forward for your support at the earliest.
> > > > >
> > > > > --
> > > > > --
> > > > > Thanks &Regards,
> > > > > *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi
> > > > > Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar,
> > > > > Bangalore - 560027*|***|***www.janalakshmi.com**|*
> > > > > *|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91
> > > > > 95-38-455118*||**E-Mail *: david.johnson@janalakshmi.com*|*
> > > > >
> > > > > --
> > > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > > Problems?
> > > > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > > > Posting guidelines + more:
> > > > > http://wiki.documentfoundation.org/Netiquette
> > > > > List archive: http://listarchives.libreoffice.org/global/users/
> > > > > All messages sent to this list will be publicly archived and cannot be
> > > > > deleted
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted



-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero.dev@gmail.com

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted