Bug 32523

Summary:	COPYING particular external numeric column will become text
Product:	LibreOffice	Reporter:	Pierre HENAUT <libreoffice>
Component:	Spreadsheet	Assignee:	Kohei Yoshida (inactive) <libreoffice>
Status:	CLOSED FIXED	QA Contact:
Severity:	normal
Priority:	medium	CC:	gautier.sophie, LibreOffice
Version:	3.3.0 RC1
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:
Attachments:	example of bug in copy Example in zip file Example of bug Please see Comment 5!

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 (inactive) 2010-12-22 18:51:19 UTC

Yup, this is very odd.

Comment 8 Kohei Yoshida (inactive) 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 (inactive) 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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.