Re: [libreoffice-users] When does one cell equal another?

2013-04-25 Thread Steve Edmonds
On 2013-04-26 06:25, david_lynch wrote: On 25/04/2013 17:58, T. R. Valentine wrote: On 24 April 2013 11:47, david_lynch wrote: I use Libreoffice to process files over which I have no control. These are text files but sometimes contain unusual codes. LO (3.6.5.2 on Vista) seems to handle

Re: [libreoffice-users] When does one cell equal another?

2013-04-25 Thread david_lynch
On 25/04/2013 17:58, T. R. Valentine wrote: On 24 April 2013 11:47, david_lynch wrote: I use Libreoffice to process files over which I have no control. These are text files but sometimes contain unusual codes. LO (3.6.5.2 on Vista) seems to handle some values in cells inconsistently ... ope

[libreoffice-users] When does one cell equal another?

2013-04-24 Thread david_lynch
I use Libreoffice to process files over which I have no control. These are text files but sometimes contain unusual codes. LO (3.6.5.2 on Vista) seems to handle some values in cells inconsistently ... open a new spreadsheet: set A2 =CHAR(127) set A3 =A1=A2 set A4 =A2="" A3 contains FALSE A4