incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 115447] Importing CSV file with double-quoted numbers treats numbers as text
Date Fri, 14 Sep 2012 19:15:06 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=115447

--- Comment #3 from jobeard <jbeard1185@roadrunner.com> ---
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.

Mime
View raw message