Compatibility of tables between Mathcad and Mathcad Prime

[TT_12301010]

In Mathcad14, the calculation results are output in an array table as shown in the attached image. In this case, if you copy the output table and paste it into Excel, one value is entered into one cell. However, when you run it through a converter, calculate it in Mathcad Prime, and copy and paste the results, all the values ​​are entered into one cell.

Are there any compatibility issues with this behaviour between Mathcad and Mathcad Prime?

Could you please tell me a solution?

Translated by the moderation using Google Translate
-----------------------------------------------------------------------------------------------

mathcad14で添付図のように計算結果を配列で表に出力しています。この場合、出力された表をコピーしてエクセルに張り付けると、1つのセルに１つの値が入力されます。しかしコンバーターを通し、mathcad primeで計算し結果をコピー&ペーストしたところ、1つのセルにすべての値が入力されてしまいます。

mathcadとmathcad primeではこの動作について互換性はないのでしょうか。

また解決策を教えていただけますでしょうか。

[Werner_E]

Yes., copy & paste is severely broken in Prime - or maybe "just" silly and amateurish implemented.

You can select a range of values in a matrix using shift left click and therefore you will also notice that when you copy from a vector/matrix in Prime you can only copy the visible displayed elements and are not able to use scrolling to copy whole vector as we could do in real Mathcad.

Maybe using WRITEEXCEL to export the data can be a workaround for you.
Or you could insert an Excel component in Prime and use the vectors as inputs. Double clicking the component opens it in Excel and you could copy the desired values from there to the target excel sheet.

Life could be so easy - unfortunately not when using Prime...

[TT_12301010]

Thank you for your reply.

In your opinion, would you recommend using WRITEEXCEL or the Excel component?

Also, by default, the Excel component opens a new untitled Excel file.

Is it possible to achieve this behaviour using an Excel file that I have saved?

Translated by the moderation using Google Translate
-----------------------------------------------------------------------------------------------

回答ありがとうございます。

あなたの意見でいいので、WRITEEXCELを使用するか、Excelコンポーネントを使うかどちらがおすすめでしょうか。

またExcelコンポーネントでは初期状態だと新たな無題のExcelを開きます。

この動作を自分が保存しているExcelのファイルを使用することは可能でしょうか。

[TT_12301010]

Sorry, there was a typo.

Which do you recommend, using WRITEEXCEL or the Excel component?

Translated by the moderation using Google Translate
-----------------------------------------------------------------------------------------------

すいません。誤字がありました。

WRITEEXCELを使うか、Excelコンポーネントを使うかどちらをおすすめしますか？

[ttokoro]

It depends on the state of the original sheet before conversion and how you plan to use it in the future, but generally it's easy to save the original data in an Excel file using WRITEEXCEL in Prime 10, and then process only the necessary parts of it directly from Prime 10 using the EXCEL component. You can read and write with the EXCEL component, and you can use Excel formats and figures from Prime 10. (Or rather, it's like displaying EXCEL in Prime. If someone else changes the original data in Excel, the changes will be reflected by recalculating.

You can contact me directly by clicking the name next to my round icon with your mouse.

Translated by the moderation using Google Translate
-----------------------------------------------------------------------------------------------

変換前の元のシートの状況と今後の利用方法にもよりますが、一般的にはPrime 10にて元データをWRITEEXCELでエクセルファイルに保存して、その中の必要な部分のみをＥＸＣＥＬコンポーネントで直接Prime10から処理するのが簡単です。ＥＸＣＥＬコンポーネントで読み込んだり書き込んだりが可能で、Excelの書式など図も含めてPrime10から利用できます。（というか、EXCELをPrimeで表示している感じです。他者がexcelの元データを変更した場合は、再計算でその変更を反映させます。

僕の丸いアイコンのとなりの名前をマウスでチェックするとダイレクトにコンタクト可能です。

[Werner_E]

---

@TT_12301010 wrote:

Thank you for your reply.

In your opinion, would you recommend using WRITEEXCEL or the Excel component?

Personally I don't like the Excel component as it blows up and slows down the worksheet. So I would rather prefer the WRITEEXCEL function. The advantage of the Excel component is when you have to provide data for Prime and the data (= Excel sheet) is not changing constantly. Here using the component has the advantage that the Prime worksheet is self contained and you do not need to turn around two files.

---

Also, by default, the Excel component opens a new untitled Excel file.

Is it possible to achieve this behaviour using an Excel file that I have saved?

Thats the reason why I wrote that you would only use the Excel component to be able to copy the data from the Prime sheet to somewhere else like an external Excel sheet.

And as far as I know its not possible to use an existing Excel sheet in a component.

[VladimirN]

From "Help Center" - "Excel Data Files": https://support.ptc.com/help/mathcad/r10.0/en/index.html#page/PTC_Mathcad_Help/excel_data_files.html 

[ttokoro]

As explained below, there are various ways to deal with this issue. If you need help in Japanese, please contact us on this SNS.

Tokoro.

Translated by the moderation using Google Translate
-----------------------------------------------------------------------------------------------

下記の説明にも有りますが対応策は色々とあります。日本語での対応であれば所にこのＳＮＳでコンタクトして下さい。

Tokoro.