I'm looking for a solution for the following problem:
I need a smart table that calculates certain values. The result value is supposed to get referenced in several FM files. When the values in the native smart table get modified the referenced value is supposed to change automatically to the new value.
I tried to insert an Excel table to FM but I have problems referencing one single cell as well as to keep it updated. in specific I managed to reference one cell, but it doesn't look very nice plus the value of the cell always stays the same, no matter how many modification are done in the native Excel table.
I'm interested in a solution for both DITA and unstructured FM. Since in DITA the same problem occurs because I'm not able to reference one single cell with conref. Is there maybe another way to make this working? Also Smart Paste is not working well in this situation.
Thank you in advance for your help!
As Stefan has already revealed, I have created scripts that pull data into FrameMaker (and writing it back) in both structured and unstructured documents. I have used CSV files and SQL databases in the past. Making the same method work with Excel should be doable but it will not be trivial. If you are interested in getting a solution created and have a budget for this we can discuss the requirements and possibilities. Contact me via jang at jang dot nl
Kind regards from Amsterdam
Now the result value is updated in FM every time you open the FM file.
Is this what you are looking for?
Works well. Thanks a million, Lothar!