Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet
Dear Joel, It is a paid processional, we need to recreate the same excel in Libre office, we need this at the earliest. -- Thanks , *|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.john...@janalakshmi.com*|* On 11-09-2015 10:40, Joel Madero wrote: You mean a paid professional? I could ask one or two people - if you're instead asking for a volunteer to assist, best bet is to just asked around on the email thread and maybe the OOo forum (there are a few great macro people over there). Best, Joel On 09/10/2015 09:39 PM, David Johnson wrote: Dear Joel & Tim, Thanks for your valuable inputs, appreciate it. Is there any professional, whom you know, could help me to redevelop the same in Libre Calc. -- Thanks , *|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.john...@janalakshmi.com*|* On 11-09-2015 04:20, Joel Madero wrote: 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.ll...@gmx.com <mailto:tim.ll...@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 , *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore - 560027*|***|***www.janalakshmi.com <http://www.janalakshmi.com>**|* *|**Phone :* +91 080-42595100 <tel:%2B91%20080-42595100>/700*|**|**Ext*-242*|**|**Mobile*: +91 95-38-455118 <tel:%2B91%2095-38-455118>*||**E-Mail *: david.john...@janalakshmi.com <mailto:david.john...@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.john...@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 , *|David Johnson|***|***H**O* - Technology
Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet
Dear Gabriele and Tim, PFA; This is the Excel Macro sheet we are trying to convert. Could you please help me. -- Thanks , *|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.john...@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.john...@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 , *|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.john...@janalakshmi.com*|* -- To unsubscribe e-mail to: users+unsubscr...@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+unsubscr...@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
Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet
Dear Joel & Tim, Thanks for your valuable inputs, appreciate it. Is there any professional, whom you know, could help me to redevelop the same in Libre Calc. -- Thanks , *|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.john...@janalakshmi.com*|* On 11-09-2015 04:20, Joel Madero wrote: 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.ll...@gmx.com <mailto:tim.ll...@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 , *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore - 560027*|***|***www.janalakshmi.com <http://www.janalakshmi.com>**|* *|**Phone :* +91 080-42595100 <tel:%2B91%20080-42595100>/700*|**|**Ext*-242*|**|**Mobile*: +91 95-38-455118 <tel:%2B91%2095-38-455118>*||**E-Mail *: david.john...@janalakshmi.com <mailto:david.john...@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.john...@janalakshmi.com <mailto:david.john...@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 , *|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore - 560027*|***|***www.janalakshmi.com <http://www.janalakshmi.com>**|* *|**Phone :* +91 080-42595100 <tel:%2B91%20080-42595100>/700*|**|**Ext*-242*|**|**Mobile*: +91 95-38-455118*||**E-Mail *: david.john...@janalakshmi.com <mailto:david.john...@janalakshmi.com>*|* -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.or
[libreoffice-users] Need help To convert Excel Sheet to Libre sheet
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 , *|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.john...@janalakshmi.com*|* -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: page break problem
My two sentences were two different (but possibly related issues). 1) Adding row breaks and then printing - the row breaks were ignored. 2) Viewing that same document in page break view showed the row breaks but I couldn't drag them to a different place. I went back and tried my original file(.csv) again and now it works on both machines. I don't have the failing document any more so I guess I will just have to see if it happens again. Thanks anyway, David On 07/07/2011 08:21 AM, Cor Nouws wrote: Hi David, David Johnson wrote (30-06-11 17:29) I also have the problem of manual row breaks being ignored in calc 3.3.3 (windows) and calc 3.3.2 (ubuntu). In page break view I can drag the page breaks but they don't stay where I want them. Am I missing something? I remember an older bug in OpenOffice.org (probably have filed a bug for that myself ;-) ): When you change only page borders in the print preview, and nothing else, those changes won't be saved. This looks like what you describe? Regards, -- David Johnson IT Coordinator Eastside Food Coop -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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
[libreoffice-users] Re: page break problem
I also have the problem of manual row breaks being ignored in calc 3.3.3 (windows) and calc 3.3.2 (ubuntu). In page break view I can drag the page breaks but they don't stay where I want them. Am I missing something? -- View this message in context: http://nabble.documentfoundation.org/page-break-problem-tp2763737p3126322.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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