Issue 53228 - copy/paste complain (or maybe not)
Summary: copy/paste complain (or maybe not)
Alias: None
Product: Draw
Classification: Application
Component: save-export (show other issues)
Version: 680m122
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2005-08-11 22:34 UTC by stargeizer
Modified: 2013-02-07 22:42 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

image_1 (59.80 KB, image/jpeg)
2005-08-11 22:35 UTC, stargeizer
no flags Details
image_2 (73.04 KB, image/jpeg)
2005-08-11 22:35 UTC, stargeizer
no flags Details
image_3 (94.08 KB, image/jpeg)
2005-08-11 22:36 UTC, stargeizer
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description stargeizer 2005-08-11 22:34:21 UTC
Have someone use AUTOCAD or AUTOCAD LT (Very expensive software that can do 
some engineering drawing... and pretty buggy also...)???

To make my life a little more easy i use spreadsheets to make some 
calculations, tables and copy them to autocad... I'm talking about autocad 
versions 2000-2006 (although 2004+ versions comes with this feature broken... 
and badly)

Usually if you copy a spreadsheet formatted with borders,(image_1.jpg) you can 
paste it in autocad and get a table with strings... more exactly border lines 
and text. (image_2.jpg). 

Using OpenOffice 1.9.122 i can get way better results that do the same with M$ 
Excel in Autocad 2004+... but still fails something.

#1: image_3.jpg... the borders are converted to squares (more exactly, a closed 
polyline of 4 vertex) in autocad. That shouldn't be a problem if you are using 
the drawings inside work... but at the moment to send this to clients this will 
be something anoying.. usually.

#2: Import OLE limitations: For medium-large sheets (let's say more than 100 
row's) you can't paste them in autocad fully... you get sometimes about 90-93 
imported. The rest is lost. I blame windows, since AFAIK there are some 
Limitations in OLE capabilities built in windows. BTW, There's a workaround: To 
reduce the size of everything in the spreadsheed (eg. arial font go from 10 to 
2.5 and rezise cells acordingly...) this way i can get some more cells 
imported. But for large spreadsheets this is no possible,and trying to copy 2 
or more times part of the content it will be pasted... at differents sizes and 

ok ok... i bet you may think now "this must be addresed at autodesk"... same 
think here, but the problem is that they only work at M$ level...

So what i'm asking here:

for #1: maybe some investigation to make the copy/paste from OOo to Autocad 
work as expected... (border = line... numbers and text = text) i think that was 
done before (otherwise no behavior like this would be done.. at least gnumeric 
for windows don't produce it (and nothing usable anyway...)).

for #2: is possible to make an export option : save as DXF???... using the 
copy/paste capabilities of windows not always produce expected results... or to 
indicate to the OS a fixed size of the object to make autocad paste it at a 
fixed size??..

I think at least #1 can be done in OOo.. (i tried gnumeric, excel with no good 
results (gnumeric don't export cells at copy stage.. only text, and excel... 
weelll.. who cares??? ;-) )

I know this can be "exotic" since no so many people would use Autocad and OOo 
in their works, but i think that something can be done here. (or maybe not???).

thanks for your time and sorry for my poor english.

Comment 1 stargeizer 2005-08-11 22:35:20 UTC
Created attachment 28673 [details]
Comment 2 stargeizer 2005-08-11 22:35:41 UTC
Created attachment 28674 [details]
Comment 3 stargeizer 2005-08-11 22:36:02 UTC
Created attachment 28675 [details]
Comment 4 Regina Henschel 2005-08-12 01:35:17 UTC
I think, that #2, the request for a better dxf export, is covered by issue 13907.

#1 seems to be a problem with enhanced metafile format. Thin lines stay lines,
but thick lines will become closed polylines with filling. I got the same
result, when paste such a thick line to Corel Draw 12. But since I get the same
wrong result the other way round, from Corel to OOoDraw, I do not know whether
it is a bug or a limitation of emf-format.

I think it is not a spreadsheet but a drawing problem.
Comment 5 stargeizer 2005-08-12 03:06:15 UTC

In this case i don't think that the problem is thick lines at all... using the 
minimum tickness for the border produces the same effect.. (also... not all 
the polylines (from now "rectangles" :-) ) have the same size... well... i 
think that's out of subject anyway...

Probably is like you said... something is wrong with the emf, or maybe the emf 
is not created the way should be in windows...

The issue 13907 is an exporter from DRAW->CAD...(no shouting intended with 
CAPS) what i'm asking here is an exporter from CALC->CAD... altough thinking 
it twice... probably will be easier to write a BASIC routine to do the work. 
(the day when i stop thinking in Parenthesis format of course.... any Lisp 
programmer will understand me in this sense ;-) so point #2 can be discarded...

Thanks for your reply

Comment 6 oc 2008-07-15 10:44:24 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)