Bug 32523 - COPYING particular external numeric column will become text
Summary: COPYING particular external numeric column will become text
Status: CLOSED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 RC1
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Kohei Yoshida
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-20 05:26 UTC by Pierre HENAUT
Modified: 2013-12-17 13:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
example of bug in copy (1.08 KB, text/plain)
2010-12-22 00:28 UTC, Pierre HENAUT 		Details
Example in zip file (588 bytes, application/x-rar)
2010-12-22 00:41 UTC, Pierre HENAUT 		Details
Example of bug (588 bytes, application/x-rar-compressed)
2010-12-22 00:42 UTC, Pierre HENAUT 		Details
Please see Comment 5! (220.27 KB, application/x-zip-compressed)
2010-12-22 02:13 UTC, Rainer Bielefeld Retired 		Details
Show Obsolete (2) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Pierre HENAUT 2010-12-20 05:26:28 UTC 
Hi,
when I past a 2 columns files from an external file,
if I select Text on the left one, and standard to the right one,
the right cells change in text format when the left one is an numeric based field.

Example

Text    |   Standard
A       |      1
B       |      2
4       |      5

The cells containing 1 and 2 are numeric and
the cell containing 5 is text because 4 is Text 
(the cell with 5 is expected to be numeric)
So I'm unable to sum the right column for example ...

thanks
Comment 1 Rainer Bielefeld Retired 2010-12-20 08:19:01 UTC 
A quick test with tab separated .csv document and "LibreOffice 3.3.0 RC1 - WIN XP German UI  [OOO330m17 (build 3.3.0.1" did not show reporter's result.

@Pierre HENAUT:
May I ask you to read <http://wiki.documentfoundation.org/BugReport>?
Then please:
- Contribute a zipped test kit with source document, copy past result
  as spreadsheet and my be some screenshots.
- add information 
  -- Step by step instruction how to reproduce the problem containing every 
     mouse click and every key press
  -- everything else crossing your mind after you read a.m. URL

Thank you for your attention!
Comment 2 Pierre HENAUT 2010-12-22 00:28:59 UTC 
Created attachment 41362 [details]
example of bug in copy

open the attached file with notepad,
copy all
and paste under calc with the two first column in text format and the others in standard format.
For example at cell D11 the value is 0,65476 in string instead of numeric.
Comment 3 Pierre HENAUT 2010-12-22 00:41:32 UTC 
Created attachment 41363 [details]
Example in zip file
Comment 4 Pierre HENAUT 2010-12-22 00:42:24 UTC 
Created attachment 41364 [details]
Example of bug
Comment 5 Rainer Bielefeld Retired 2010-12-22 02:06:54 UTC 
I can confirm the effect with reporter's "bugfile.txt" and copy / paste as plain text with TAB-separator for "LibreOffice 3.3.0 RC1 - WIN XP German UI  [OOO330m17 (build 3.3.0.1". I tested as per Comment 2

I see text instead of expected numbers in rows where
- first column = "M"
- second column numeric value
What ever that might mean.

This unreliability for copy/paste seems serious to me.

The problem is not visible when I copy / past from "bugfile.txt" to OOo3.1.1

I attached the different results with LibO ans OOo in "MyResults.zip"
Comment 6 Rainer Bielefeld Retired 2010-12-22 02:13:53 UTC 
Created attachment 41367 [details]
Please see Comment 5!
Comment 7 Kohei Yoshida 2010-12-22 18:51:19 UTC 
Yup, this is very odd.
Comment 8 Kohei Yoshida 2010-12-22 20:00:18 UTC 
Heh.  The bug was lurking in an unexpected place!

Anyway, fixed this on master.
Comment 9 Kohei Yoshida 2010-12-23 07:33:59 UTC 
Ported to 3.3, with Caolan's sign-off.  This will be fixed in 3.3 final.
Comment 10 Pierre HENAUT 2010-12-23 07:35:50 UTC 
Wonderful Job !:)
Comment 11 sophie 2011-01-16 22:53:19 UTC 
Verified in RC3 - Closed - Sophie