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

At 12:53 26/01/2016 +, Ian McCarthy wrote: 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

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 wrote: > On

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

Hi, Some of the configurations you are referring to are done via the regional settings (at least in the version of Excel I use): this means that your separator may not always be the "!" in Excel (I have seen the "." as well). When I need to have compatible workbooks (Excel and Calc), I have a

[libreoffice-users] difference between Excel and Calc

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