Table Cell Font/Style Issue - How to Change Multiple Cells to a Different Font

[ILoveMadoka]

I created a table in Excel, used the ROMANS font for all the cells.

Selected the desired area and pressed <CTRL>C to copy.

In Autocad 2020, created a Style & Table style with the RomanS font.

Set Current.

Started the PASTESPEC command.

Pasted as AUTOCAD ENTITIES. (do not want any links)

 

Table comes in with the correct STYLE but the cells display the CALIBRI font.

When I select a cell, the STYLE shows ROMANS in the Properties dialog.

When I DBL-Click inside the cell, my text editor ribbon appears and under formatting the font is Calibri.

 

I tried changing one cell manually then the MatchCell command at it doesn't change anything.

I read that MatchCEll does not work with a data type of TEXT.

I tried changing a cell to GENERAL but it changes back to TEXT.

 

I have hundreds of cells to change to the correct font.

One at a time is going to take forever.

 

If I PASTESPEC and use the PASTELINK option, the table comes in correctly but it linked.

I can live with this if I can convert the linked file to a regular unlinked table.

 

Can someone please help?

 

ps: Where I work our dwgs are proprietary so posting the drawing is not an option

unless I want to go to jail or lose my job.

Edited June 13, 2019 by ILoveMadoka

[ILoveMadoka]

Found a solution...

 

In Excel I reformatted all my cells to GENERAL then Copy/Pastespec into Autocad and it came in correctly..

 

Maybe I'm stupid but I didn't see that in any of the topics I found online... 

[CyberAngel]

Thank you for posting your solution. Not sure I would have found that one on my own....

[ammobake]

I think part of this is that all the roman font in AutoCAD is SHX.  So there's no truetype font in AutoCAD for any Roman front type unless you download it manually on the internet and put it in the text folder in CAD.  It's weird.

 

If I remember correctly, word/excel typically use truetype fonts for everything.? Could be wrong on this.

In the case of AutoCAD, there's actually a hidden property deep in the settings just for this purpose - text substitution.

In the settings of AutoCAD you can change this font type to whatever you want.  It will then apply in cases where AutoCAD can't figure out what text you are inserting and/or the text type is completely missing altogether.

 

Pasting the excel range directly into CAD would probably work if the text substitution was at a desired text type (normally you would change it to your company standard) or if you manually paste the truetype font version of RomanS into the autocad fonts folder.

 

But Paste Special will just import the actual excel table with it's original properties from excel.

In fact you can double click the table at that point and it will just open in excel if I remember correctly.

 

-ChriS

[ammobake]

https://knowledge.autodesk.com/support/autocad/learn-explore/caas/CloudHelp/cloudhelp/2016/ENU/AutoCAD-Core/files/GUID-928DF015-1E04-4CC2-AF1B-0037548DFBAE-htm.html

 

This link explains the order of operations for what autocad does when text substitution kicks in (couldn't find anything else more current).

 

As you can see in the table, in some cases the program has this bizarre feature built in that still amazes me where it will actually scan the text you intend to insert and it will automatically select a substitute font (that is available) that is similar in shape and characteristics - how it does this I have no idea.

 

In your case, for whatever reason, the program thought Calibri was as similar in shape as it could get for a truetype font so it used that.

 

The type of font you want for text substitution has to to be assigned manually.

Otherwise, nothing is there and autocad just goes off into left field using what it determines "similar".

 

ChriS

[ammobake]

The only reason I know all this is because of the following...

 

STORY TIME - I opened a cad drawing for a US army project back in 2012 where the floor plans were all drawn up by someone at DPW that was clearly not a drafter.

Instead of using romans font in autocad they manually downloaded truetype version of romans and assigned it to their standard text style for the entire drawing.

 

So I open the drawing and it's all strange symbols.  WTH.

I was easily able to change it but I went back on a slight "homework" project to figure out what the heck was going on because it was actually like wingdings or something (really happened).

 

LOL

 

-ChriS