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.
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:
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?
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.
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!!
Frustrated Designer in SoCal!!
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.
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.
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.