[libreoffice-users] Re: difference between Excel and Calc
Am 26.01.2016 um 13:53 schrieb Ian McCarthy: > Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've > fallen over an incompatibility > as spread sheet will be used by both tools is there a switch I can use. > The problem > =CELL("filename",A1) in LO returns > 'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15 > > where as in Excel the returned data is different > cant easily paste the excel result here but the terminal filename is in > square brackets > is there a way I can either spot which program I'm using and therefore > switch the detection of the sheet name > > using LibreOffice 5.0.4.2 > =LEFT(CELL("FileName");8)="'file://" returns TRUE in Calc and FALSE in Excel -- 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: difference between Excel and Calc
On 1/26/2016 1:17 PM, Andreas Säger wrote: Am 26.01.2016 um 13:53 schrieb Ian McCarthy: Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've fallen over an incompatibility as spread sheet will be used by both tools is there a switch I can use. The problem =CELL("filename",A1) in LO returns 'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15 where as in Excel the returned data is different cant easily paste the excel result here but the terminal filename is in square brackets is there a way I can either spot which program I'm using and therefore switch the detection of the sheet name using LibreOffice 5.0.4.2 =LEFT(CELL("FileName");8)="'file://" returns TRUE in Calc and FALSE in Excel Just fallen down another Excel/Calc wormhole - indirect addresses formats are different on Excel its 'sheetFred'!$C:$C where are its 'sheetFred'.$C:$C in Calc fortunatley the above test works for this just as well. :-) -- Cheers Ian Mac - Ian D McCarthy Cronkshaw Fold Off Alden RdTel +44 (0) 1706 218614 Helmshore Fax +44 (0) 1706 215143 Rossendale BB4 4AQ Mobile +44 (0) 7976 773843 United Kingdom Email i...@cronkshaw.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
[libreoffice-users] Re: difference between Excel and Calc
Yes there are two Tom Menu/Tools/Options/LibreOffice calc/Formula - Formula Options - Formula syntax. and another one in Menu/Tools/Options/LibreOffice calc/Formula - Detailed calculation settings - Custom - Details - Reference syntax. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/difference-between-Excel-and-Calc-tp4173065p4173160.html Sent from the Users mailing list archive at Nabble.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