• progeCAD in French Language
  • progeCAD in Spanish Language
  • progeCAD in English Language

progeTABLE FAQ

Frequently asked questions about progeTABLE

I cannot find the toolbar of progeTABLE in Excel 2007
When I create/edit a table, the "progeTABLE" toolbar disappears in Excel and cannot be retrieved?
Is it possible to import a rather huge Excel spreadsheet?
Does it suffer the limitations of OLE technology?
How can I control over the scale of the imported spreadsheet?
How can I control over the size of imported text?
progeTABLE does not bring in gridlines surrounding cells; only text is displayed. Why?
My problem is that in some, but not all, cases when the text in a cell wraps, the cell size in the anonymous block produced by your program does not "grow" sufficiently to maintain the look of the spreadsheet. The text then overlaps the text in adjacent cells.
What object is the table imported by progeTABLE from Excel?
When I imported an Excel sheet, some of symbols truned into "?".
I've created a number of Excel spreadsheets that show no borders around the cells. But of course on the screen, you can still see the faint lines delineating the cells. When I copy and paste the borderless spreadsheet into progeCAD, the faint lines delineating the cells comes over and they print from within progeCAD. With progeTABLE, however, the faint lines around the cells are not transferred over. I am forced to always assign borders around all cells. So is there a way I can mimic the faint lines without having to add borders using progeTABLE?


  • When I create/edit a table, the "progeTABLE" toolbar disappears in Excel and cannot be retrieved?

    Try the following methods:

    Method for Excel 2002/xp/2003:

    1. Launch Excel. (Don't use progeTABLE to launch Excel.)
    2. On the Help menu of Excel, click About Microsoft Office Excel.
    3. Click Disabled Items.
    4. If progeTABLE 200x is applicable, select it and click Enable.
    5. On the Tools menu in Excel, point to Macro, and click Security.
    6. Click Trusted Publishers tab, and select the Trust all installed add-ins and templates check box.
    7. Now try again.



    Method for Excel 2007:

    1. Launch Excel (don't use progeTABLE to launch Excel).
    2. and click the Microsoft Office Button .
    3. Click the Excel Options button.
    4. In the categories pane, click Add-ins.
    5. In the details pane, locate the add-in in the Disabled Application Add-ins list.
    6. The Name column specifies the name of the assembly, and the Location column specifies the full path of the application manifest.
    7. In the Manage box, click Disabled Items, and then click Go.
    8. Select the add-in (progeTABLE2008.dll) and click Enable.
    9. Click Close.




  • Is it possible to import a rather huge Excel spreadsheet?
    Yes, you can import huge spreadsheets into progeCAD. No clipboard limitation issue.


  • Does it suffer the limitations of OLE technology?
    All imported text and border are native elements in progeCAD which are fully editable.


  • How can I control over the scale of the imported spreadsheet?
    Create table> Options button> Scale box



    Default scale factor: 1

    With regard to the default scale, progeTABLE imports Excel spreadsheet into progeCAD by 1:1,
    i.e. the point size from Excel to an equivalent size in progeCAD/MicroStation units.



    For example, if you have an Excel spreadsheet (10 rows x 13 columns, row height = 16.5), then you import it into progeCAD by default scale factor 1:1, the length of table borderline will be 165 inches (16.5 x 10 =165, and the units depends on your progeCAD drawing units).

    Before importing Excel spreadsheet, you should calculate an appropriate scale factor and enter it into the scale box.

    Please note that the scale option only works when you import an Excel worksheet for the first time. progeTABLE will ignore this option when edit/update the imported spreadsheet.

    In addition, you can use 'scale' command to resize the imported table.

  • How can I control over the size of imported text?
    The size of the imported text is automatically scaled to approximate the text size in the original Excel application. We will add a 'Text Scale' option in the coming version 3.5 so that you can control text height accurately.


  • progeTABLE does not bring in gridlines surrounding cells; only text is displayed. Why?
    progeTABLE does not import Excel gridelines. progeTABLE is now formatting cells as per the Excel spreadsheet. If you want to import borderlines, add them firstly.


  • My problem is that in some, but not all, cases when the text in a cell wraps, the cell size in the anonymous block produced by your program does not "grow" sufficiently to maintain the look of the spreadsheet. The text then overlaps the text in adjacent cells.
    You can adjust the column width a little manually, so that the cells can fill the text.

    progeTABLE imports Excel spreadsheet into progeCAD by 1:1, i.e. the point size from Excel to an equivalent size in progeCAD units. But with regard to text, progeCAD and Excel have different arithmetics to display the same truetype font.

  • What object is the table imported by progeTABLE from Excel?
    For progeCAD, it's an anonymous block.


  • When I imported Excel sheet, some of symbols truned into "?".
    Please use Excel font while importing symbols.
    Click progeTABLE Options, Select Excel Font.


  • I've created a number of Excel spreadsheets that show no borders around the cells. But of course on the screen, you can still see the faint lines delineating the cells. When I copy and paste the borderless spreadsheet into progeCAD, the faint lines delineating the cells comes over and they print from within progeCAD. With progeTABLE, however, the faint lines around the cells are not transferred over. I am forced to always assign borders around all cells. So is there a way I can mimic the faint lines without having to add borders using progeTABLE?
    The faint lines you refer are gridlines, not borderlines. progeTABLE does not recognize gridelines in Excel.

    As you know some customers only want to import text only. If you want to import table borderline, format them firstly. progeTABLE is formatting cells as per the Excel spreadsheet.

    progeTABLE supports borderline style (double-line, dashed line, diagonal and etc).
    • Google +One
     
    DWG is the native file format for Autodesk AutoCAD®. Autodesk and AutoCAD are registered trademarks or trademarks of Autodesk, Inc. in the USA and/or other countries. progeSOFT and progeCAD are registered trademarks or trademarks of progeCAD s.r.l. in the USA and/or other countries.