So the cells are the result of opening a .csv file where the string has
nothing between commas such as
5,4,,,3,,2,1
between the consecutive commas is nothing, so the cell should be made
totally empty.
gs
On 8/19/2013 8:22 PM, Steve Edmonds wrote:
On 2013-08-20 13:02, Virgil Arrington wrote:
On 08/19/2013 03:10 PM, Gregory Smith - Oracle Sparc Verification wrote:
I am disappointed that Libre Office does not treat blank cells as a
zero in math calculations. I have a dozen spreadsheets from Excel
and Open Office that take advantage of this fact. Now I get errors
with Libre Office. Going back and retrofitting n(cell reference) to
achieve the translation is a ton of extra work. Am I missing
something.
gs
I'm not sure what you're missing, but my LO spreadsheets always treat
blank cells as zeros. I'm not that well versed in spreadsheets, but
I've never had the problem you describe.
Virgil
I have just tried in LO 3.6 and a blank cell is treated as zero. A
cell with text in it such as a space causes an error in calculations.
Do you mean that Excel and Open Office treat white space characters as
zero.
Steve
--
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
