Re: [libreoffice-users] difference between Excel and Calc

Hi :)
Isn't there a setting to change the way cells are addressed in Calc?
Something like;
Tools - Options - Calc
errr, somewhere in there?  I think you have to be in Calc to get those
options.
Regards from
Tom :)



On Tuesday, 26 January 2016, Ian McCarthy <idm@cronkshaw.com> wrote:

> 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   idm@cronkshaw.com
>
>
> --
> 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

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