incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 115447] Importing CSV file with double-quoted numbers treats numbers as text
Date Fri, 14 Sep 2012 19:15:06 GMT

--- Comment #3 from jobeard <> ---
circumvention found:-

open CVS file with a text editor (eg notepad)
copy all data
open a NEW spreadsheet
paste the data

formulas work again.

ps: visual confirmation is the right justified numbers whereas
if they are left justified, they are being treated as text.

You are receiving this mail because:
You are on the CC list for the bug.

View raw message