Re: [libreoffice-users] R1C1 reference style with LibreOffice
Ok, but the problem is that I must do it from LibreOffice basic code. pacopyc 2016-01-20 9:46 GMT+01:00 Jean-Baptiste Faure : > Le 19/01/2016 18:37, pacopyc pacopyc a écrit : > > Hi, I have to convert a macro from Excel to LibreOffice. The Excel macro > > contains many formulas in R1C1 reference style. > > > > How can I rewrite the formulas in R1C1 reference style with LibreOffice? > Is > > it possible? > > Yes: menu Tools > Options > LibreOffice Calc > Formula > choose in the > Formula syntax dropdown list > > Best regards. > JBF > > > -- > Seuls des formats ouverts peuvent assurer la pérennité de vos documents. > Disclaimer: my Internet Provider being located in France, each of our > exchanges over Internet will be scanned by French spying services. > > -- > 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] R1C1 reference style with LibreOffice
Le 19/01/2016 18:37, pacopyc pacopyc a écrit : > Hi, I have to convert a macro from Excel to LibreOffice. The Excel macro > contains many formulas in R1C1 reference style. > > How can I rewrite the formulas in R1C1 reference style with LibreOffice? Is > it possible? Yes: menu Tools > Options > LibreOffice Calc > Formula > choose in the Formula syntax dropdown list Best regards. JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. Disclaimer: my Internet Provider being located in France, each of our exchanges over Internet will be scanned by French spying services. -- 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
[libreoffice-users] R1C1 reference style with LibreOffice
Hi, I have to convert a macro from Excel to LibreOffice. The Excel macro contains many formulas in R1C1 reference style. How can I rewrite the formulas in R1C1 reference style with LibreOffice? Is it possible? Thanks pacopyc -- 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