Hallo Cad-users
I try to copy/paste a MS Exel spreadsheet into Autocad 2006.
The spreadsheet is make with a "conditional formatting" on the cells
By this way I can give the values in the cells a different color.
Cell value is greater than or equal to =$c14
The color for the value becomes than for example "red"
Cell value is between - a formula than the value becomes than for example "blue"
After selecting the spreadsheet (cells values with colors green. red, blue, black)
and then a copy to clipboard.
I do the following in Autocad, Edit, Paste Special, Microsoft a Exel Spreadsheet.
(try both paste and paste link)
The spreadsheet is placed into the autocad drawing, 100% looks in Exel, the colors
in the cells are the same as in Exel.
But I was very surprised when I print to PDF or Postcript I loose the color information
of the cells. (it disappears)
On the Screen/Monitor everything looks good.
When I choose paste special "AutoCAD entities" I also see strange things a lot of the cells
becomes green and the formulas becomes #
When I have to modify the hole spreadsheet with a lot of columns and rows for much
cells on a manual way than that is a lot of work.
Is there someone with a solution for this question ?
thanks in advance,
Theo van Rossum
ros@geodelft.nl