[libreoffice-users] Calc, =left not working as expected

2014-08-31 Thread IGraham
Hello Could someone tell me whats going on in the spreadsheet i uploaded This is a small part (to demonstrate) of a couple of legacy (by year) spreadsheets Column C contains a 7 cell drop down list with a range to select. these rangers did originally contain a graphic face (seemed like a good

Re: [libreoffice-users] Calc, =left not working as expected

2014-08-31 Thread Brian Barker
At 07:51 31/08/2014 -0700, Graham Lovatt wrote: Could someone tell me what's going on in the spreadsheet i uploaded [...] Altering the original sheets as little as possible i used =LEFT(cell ref,1) This seemed to work, except the values returned aren't seen by vlookup and can not be summed