Skip to main content
恵大_44123603-Newcomer
3-Newcomer
Oct 5, 2025 1:39 PM UTC
Solved

Excel Copy/Paste Fails in Converted Mathcad Prime (EXPRESS) Files

I am currently using the free trial version (EXPRESS) of Mathcad Prime. After converting a file created with the old Mathcad using the "Input/Output" XMCD converter menu, I opened the converted file and tried to copy and paste a table from Excel into the original table, but it is not reflected. During the conversion, a message "To maintain the numerical results of the input table, the table has been converted into a matrix" was displayed. Is this the cause? Could you please tell me the reason and the solution?

terryhendicott
terryhendicottAnswer
21-Topaz II
Oct 6, 2025 7:38 PM UTC

Hi

I also recommend the READEXCEL wizard on the ribbon that only takes a few clicks to import a matrix rather than a table from EXCEL.

Capture.JPG  

Cheers

Terry

View in thread

5 replies

LucMeekes23-Emerald V
23-Emerald V
Oct 6, 2025 8:14 AM UTC

Well, apparently in the conversion, the link between the Mathcad sheet and the Excell sheet was detached. The corresponding data was copied into a Mathcad matrix.

The wonderfull new functionality of Prime is that it, contrary to 'real'  Mathcad, does NOT provide a means to copy a range of cells from Excel over to the Prime sheet. Going from Mathcad to Prime there are a few improvements (Units in arrays, Solving Differential equations symbolically, and  Automatic labelling of units, to name all of them) but there is a lot of functionality lost, some of which gets repaired over time, but with the speed of development of Prime. A snail runs faster.

 

Success!
Luc

 

Ah, I stand corrected.

As @terryhendicott  indicates, it is possible to copy a range of cells over from Excel to Prime, but you can (only?) create a Prime table from the data, meaning you get one or more table columns where each column effectively defines a vector. As such you cannot copy a (2D) matrix over.

Translate
    terryhendicott
    terryhendicott21-Topaz IIAnswer
    21-Topaz II
    Oct 6, 2025 7:38 PM UTC

    Hi

    I also recommend the READEXCEL wizard on the ribbon that only takes a few clicks to import a matrix rather than a table from EXCEL.

    Capture.JPG  

    Cheers

    Terry

    Translate
      恵大_44123603-NewcomerAuthor
      3-Newcomer
      Oct 7, 2025 1:42 AM UTC

      Thank you for your kind advice! After trying the READEXCEL wizard, the problem was resolved.

       

      Translate
      terryhendicott
      terryhendicott21-Topaz II
      21-Topaz II
      Oct 6, 2025 12:18 PM UTC

      Hi,

      Can you please upload your Prime worksheet, the old Mathcad worksheet and Excel workbook.

      I have tried to recreate the error but have not been able to do so,

      Select the Excel adjacent cells, copy.  Select a vacant space in the Prime worksheet and paste.  You get an Input Table with no headers defined.  That is the column vector variables of the Input Table have no name.

       

      Cheers

      Terry

       

      Translate
      Terms & ConditionsAccessibility statement