Apache OpenOffice (AOO) Bugzilla – Issue 53228
copy/paste complain (or maybe not)
Last modified: 2013-02-07 22:42:51 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 scales... 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. J.
Created attachment 28673 [details] image_1
Created attachment 28674 [details] image_2
Created attachment 28675 [details] image_3
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.
Hmmm... 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 J.
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)