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 Rd Tel +44 (0) 1706 218614
Helmshore Fax +44 (0) 1706 215143
Rossendale BB4 4AQ Mobile +44 (0) 7976 773843
United Kingdom Email [email protected]
--
To unsubscribe e-mail to: [email protected]
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
