Desktop version

Main > Forum > 1C:Enterprise Platform > Bugs and functionality requests to 1C:Enterprise platform > Error during Copy-Pasting from Microsoft Excel to Spreadsheet Document

Forum

Search UsersRules
Error during Copy-Pasting from Microsoft Excel to Spreadsheet Document
#1
Just came
Points:: 0
Joined:: Sep 23, 2013

Hello,

I have come across an enteresting(for me) thing in pasting something to spreadsheet document from excel. (Tried different versions of excel and 1C:Enterprise platform, on Windows XP and Windows 7, the problem is same in all versions).

The problem is: I'm coping some text from excel (by CTRL+C) and then pasting to 1C:Enterprise Spreadsheet Document, if in copied text there are two double quotes (""), than it creates a different in total row counts between real(excel) text and copied (speadsheet document) text. For example, I have 10 rows in excel, I'm coping-pasting it to spreadsheet document, and it copies as 5 or 6 rows.

I can attach an excel document, so you can also try to make this process by yourself.

Profile
#2
Guest
Points::
Joined::

Hello, Stanislav!
Try pasting this text to any text editor. Think, you will see the same effect.

Profile
#3
Just came
Points:: 0
Joined:: Sep 23, 2013

Hello Timofey,

Thank you for your answer!
I tried to paste it to Libre, to Notepad++, and some other microsoft products, it pastes same as in excel document. The problem is only when I pasting to spreadsheet document

Profile
#4
Guest
Points::
Joined::

Hello, Stanislav!

Thank you for the information, I was able to reproduce this issue and will submit it to our developer team.
As a workaround I can suggest to replace "" with ", after doing this, I could copy cells with no problem.

Profile
#5
Guest
Points::
Joined::

This issue will be fixed in 8.3.6 version of 1C:Enterprise platform.

Profile
#6
Just came
Points:: 0
Joined:: Sep 23, 2013

Hello Timofey,

We have also solvet it by the same way. Thank you!

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.