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.
Created attachment 48948 [details] it shows Adobe Captivate unpack, start libreoffice-calc-base.htm
Rainer, please check it.
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.
Created attachment 49030 [details] Test data exchange calc->base->calc see video
[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.
(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
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.
- 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.