Bug 39124 - copy base table to calc uses wrong codepage for paste
Summary: copy base table to calc uses wrong codepage for paste
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.4.1 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-07-10 20:52 UTC by Oleg
Modified: 2013-11-24 21:54 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
it shows Adobe Captivate (2.43 MB, application/zip)
2011-07-10 20:54 UTC, Oleg
Details
Test data exchange calc->base->calc (11.34 KB, application/zip)
2011-07-12 18:25 UTC, Oleg
Details

Description Oleg 2011-07-10 20:52:38 UTC
In program CALC I took some cells in a clipboard. In program Base I have inserted a clipboard on bookmark Tables. I have created the new table "Table 1", have opened it. There there is data from CALC. I have closed this table. For this table I have chosen from the context menu Copy and have inserted in CALC. In CALC there was data from BASE with an error in the text coding. I use Russian version LibreOffice, code page 1251.
Comment 1 Oleg 2011-07-10 20:54:44 UTC
Created attachment 48948 [details]
it shows Adobe Captivate

unpack, start libreoffice-calc-base.htm
Comment 2 tester8 2011-07-11 12:43:19 UTC
Rainer, please check it.
Comment 3 Rainer Bielefeld Retired 2011-07-11 21:56:07 UTC
Unfortunately base is not my forte, but let's see. Oleg's great movie might help. May be it's a problem with the not very mature LibO codepage detection?

@Oleg:
Can you please attach an additional test kit with source document and result? that would ease testing for a Base beginner like me.
Comment 4 Oleg 2011-07-12 18:25:34 UTC
Created attachment 49030 [details]
Test data exchange calc->base->calc

see video
Comment 5 Rainer Bielefeld Retired 2011-07-12 22:59:15 UTC
[Reproducible] with "LibreOffice 3.4.1  - WIN7  Home Premium (64bit) German UI [OOO340m1 (Build:103)]" 

I did some further investigations, for that I saved reporter's CALC source column as a .csv (codepage 1251). When I want to get the same result like reporter saw with copy table / paste to CALC opening the .csv, I have to select a codepage "System" when I open .csv. That codepage is not available when I create the .csv

Copy Base Table / Paste to Writer works without problems, the contents column looks at least very similar to the Base Table, but it's not identical

Original Contents: бвгдеёжзиклмопрст
Writer Result:     бвгдеёжзиклмопрст
Wrong CALC result: бâãäå¸æçèêëìîïðñò

If my results are correct, copy Base Table / Paste to CALC wrongly changes Codepage to "System" - what ever that might mean.
Because paste to WRITER works fine, I currently see that as a CALC problem, but I may be wrong.

My be some further investigations by experts for Base and/or Base will be useful?

@Oleg:
Please contribute information concerning your
- OS WIN  Version and localization
- LibO Localization 

@Kohei:
Please feel free to reassign if it’s not your area or if provided information is not sufficient.
Comment 6 Oleg 2011-07-13 08:50:56 UTC
(In reply to comment #5)
> [Reproducible] with "LibreOffice 3.4.1  - WIN7  Home Premium (64bit) German UI
> [OOO340m1 (Build:103)]" 
> 
> I did some further investigations, for that I saved reporter's CALC source
> column as a .csv (codepage 1251). When I want to get the same result like
> reporter saw with copy table / paste to CALC opening the .csv, I have to select
> a codepage "System" when I open .csv. That codepage is not available when I
> create the .csv
> 
> Copy Base Table / Paste to Writer works without problems, the contents column
> looks at least very similar to the Base Table, but it's not identical
> 
> Original Contents: бвгдеёжзиклмопрст
> Writer Result:     бвгдеёжзиклмопрст
> Wrong CALC result: бâãäå¸æçèêëìîïðñò
> 
> If my results are correct, copy Base Table / Paste to CALC wrongly changes
> Codepage to "System" - what ever that might mean.
> Because paste to WRITER works fine, I currently see that as a CALC problem, but
> I may be wrong.
> 
> My be some further investigations by experts for Base and/or Base will be
> useful?
> 
> @Oleg:
> Please contribute information concerning your
> - OS WIN  Version and localization
> - LibO Localization 
> 
> @Kohei:
> Please feel free to reassign if it’s not your area or if provided information
> is not sufficient.
I have tried to work with MS Office. As a result I think that an error in BASE and WRITER. Both of them use the old agreement on text transformations. Only they understand each other. Investigations are not required any more
Comment 7 Björn Michaelsen 2011-12-23 13:25:36 UTC
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
Comment 8 Oleg 2011-12-23 19:47:53 UTC
- OS WIN  Version and localization: Windows 7 Enterprise SP1 Russian
- LibO Localization: Russian


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.