[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+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