AutoCAD 2013/2014/2015

AutoCAD 2013/2014/2015

Reply
Distinguished Contributor
dmmeehan
Posts: 499
Registered: ‎01-25-2006
Message 11 of 18 (557 Views)

Re: Data Link Excel sheet issue

02-21-2014 08:09 AM in reply to: msmith

Mine is also set correctly (2). We have also experienced this issue while linking to an excel sheet that is on our sharepoint server. I'd post an example but the documents in question are proprietary... I've considered requesting the software package from Dotsoft but haven't had time to test the demo for functionality.

*Expert Elite*
dbroad
Posts: 1,551
Registered: ‎08-16-2007
Message 12 of 18 (554 Views)

Re: Data Link Excel sheet issue

02-21-2014 09:28 AM in reply to: dmmeehan

You can't recreate the problem with dummy data?  Come on now.

Active Member
msmith
Posts: 7
Registered: ‎06-14-2012
Message 13 of 18 (545 Views)

Re: Data Link Excel sheet issue

02-21-2014 10:35 AM in reply to: dbroad

Attached are my sample files.  The only time I've noticed the split table formatting issues are with Sheet Set Manager "Sheet List Table".

 

For the record, here is the text of my previous post documenting other DL issues:

_______________________________________________________________________________________________________________________________

For background, I've been using datalinked excel tables since their inception in 2008.  I found them buggy initially, but they functioned wonderfully in 2013.

 

For all of our projects, we have been creating them with the formatting option "Start with Excel Format, do not update".  This function appears entirely broken now.

 

Issues I've found:

  1. There is no longer a pop up dialog to alert the user if a datalink needs updating
  2. If you override the text style in a cell (I've tried making it STANDARD, ARIAL, VERDANA, SIMPLEX, ROMANS), the displayed font does not change and appears frozen to whatever was saved in the excel file.
  3. If you update the datalinks in the drawing, even if "start with excel format, do not update" is selected, any font format changes in the excel file will come into the drawing (in acad, if the cell has been forced to text style with a width factor, that width factor will display).
  • Tried unlocking (content and fomat) a cell to see what was going on - it appears though it takes on the text style specified in the table style (or whatever was selected in a cell override), the actual font has been forced to whatever was last saved in the excel file.

 

Removing Property Overrides will reset the cell to the font size and style specified in the table style BUT the table will still only display the font last saved in the excel file.

 

FYI, tried all of this with an XLSX file, same results.  I am using C3D 2014 SP1 x64; MS Office x86 (32-bit) - don't think that is the problem since it didn't cause a problem with C3D 2013 x64?

________________________________________________________________________________________________________________________________

*Expert Elite*
dbroad
Posts: 1,551
Registered: ‎08-16-2007
Message 14 of 18 (538 Views)

Re: Data Link Excel sheet issue

02-21-2014 11:21 AM in reply to: msmith

Thanks for your detailed explanation.  That should be enough to get Joseph looking into it.  I can see your point about the fonts.  Trouble with fonts in tables though is how those fonts might be modified.  If the content is locked, it could actually affect the font since the table cell text entities are mtext and since the font codes can be embedded.

 

For example, if I select the cell that contains the simplex text, change the cell type to unlocked and then highlight the text, the font can be changed in the mtext editor of the cell.  Once the cell is format is changed, the cell can be re-locked but Excel updates swap the text font codes back.

Active Member
msmith
Posts: 7
Registered: ‎06-14-2012
Message 15 of 18 (495 Views)

Re: Data Link Excel sheet issue

03-21-2014 09:39 AM in reply to: dbroad
any updates/solutions?
New Member
vikfann
Posts: 2
Registered: ‎05-13-2014
Message 16 of 18 (426 Views)

Data Link Excel sheet issue

05-13-2014 12:56 PM in reply to: dmmeehan

I can link Excel spreadsheets to a table just fine, it's the cell formatting in excel that doesn't come out properly in AutoCAD.

 

I have a lengthy spreadsheet with several colums an rows. Most of the data looks fine, but other data doesn't follow the cell format I've set up in the spread sheet.    The cell formatting seems to have a mind of it's own once linked to a table in AutoCAD.  I've unlinked the excel file, re-linked it, tried using AutoCAD table command to modify yhr table unsecussfully.   Kinda bummed, thought I knew this stuff!!

 

Any thoughts?

 

Frustrated Designer in SoCal!!

 

 

 

 

 

 

Active Member
Sportyyyy
Posts: 6
Registered: ‎05-13-2009
Message 17 of 18 (415 Views)

Re: Data Link Excel sheet issue

05-14-2014 05:59 AM in reply to: vikfann

All of your issues were documented in my post above (msmith).  It's a known bug and there is no solution except to get the font formatting exactly as you want it in Excel.  Remove all borders so that you can assign table styles in Excel.  Attached is write up I had to do for my department but I've summariz the Excel essentials below.  If you're looking for more control over cells in ACAD, create "CELL STYLES" - you can assign these as overrides in the Table properties.

 

  • Aesthetic formatting should be kept to a minimum
  • Do not use “General” format for cells containing numbers.  AutoCAD will recognize those cells as numbers and apply the drawing’s precision settings to them.
  • Fonts must be set to Arial.
  • Column/Rows should not be “Hidden”.

Do not apply formatting anywhere outside of table – AutoCAD will interpret it as data and attempt to include it if “whole sheet option” is checked.

Active Member
msmith
Posts: 7
Registered: ‎06-14-2012
Message 18 of 18 (317 Views)

Re: Data Link Excel sheet issue

06-20-2014 06:59 AM in reply to: msmith

As a solution for the "Sheet List table" from Sheet Set manager (split tables, cells will lose any property overrides once updated), create a CELL STYLE to force Justification, Color, Bolding, whatever.  Create however many you need.

Apply those cell styles to the cells in the split section of the table (this is technically a property override but it seems to hold cell style overrides, just not individual font, justification, etc. overrides), then update the Sheet List Table. Formatting will then hold after updates.

I believe this will only work for sheet list tables since they are not linked to a formatted excel table.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.