Textfields in Excel and TM1Web

wlx123

Hi All,

I have some trouble with editing textfields in excel as well as in TM1Web  and therefore several questions. I know a database I can't compare with e.g. MS Word, but I am still missing some functions to use textfields. Please see the simple example in the attached file. It's an Excel-file, I only have 3 textfields, the contents I catch by TM1-DBRW-functions.

1) If I once have inserted a text, is it possible to edit this text (changing, updating, adding) without typing the hole text once again ?
2) column D to M are connected. Is there any chance to get the "optimal" line-height ? (if I enter 4 or more lines, so that everything is displayed)
3) is it possible to copy text (which is e.g. edited by notepad or word) to my fields without deleting the dbrw-function ?
4) is it possible to save text-formattings (bold, italics or something else for a PART of the contents) in the textfields ?

5) Inserting a linebreak in textfields within TM1Web seems to be not possible ? Does anybody know more about this "feature" ?

Thanks a lot in advance
Newcomer

西山红叶

Newcomer wrote:1) If I once have inserted a text, is it possible to edit this text (changing, updating, adding) without typing the hole text once again ?

Easy. In TM1web just double-click the cell.  In Excel F2 followed by F9 and edit text

Newcomer wrote:2) column D to M are connected. Is there any chance to get the "optimal" line-height ? (if I enter 4 or more lines, so that everything is displayed)

By "connected" I assume you mean merged? If the user interface for end users in Excel you can add a VBA macro to autofit row height after data entry.  If web then there's no way as far as I know of, you have to allow enough height in advance.

Newcomer wrote:3) is it possible to copy text (which is e.g. edited by notepad or word) to my fields without deleting the dbrw-function ?

Yes this is how TM1 works. If you paste a value over a DBRW formula the formula isn't deleted the value is sent to the database. The caveat or limitation in Excel is that this can only be done one_cell_at_a_time, for larger ranges the DBRW formulas will be deleted on paste.  TM1 web isa better solution for this type of functionality as you can paste as large a region as you want.

Newcomer wrote:4) is it possible to save text-formattings (bold, italics or something else for a PART of the contents) in the textfields ?

No.

Newcomer wrote:5) Inserting a linebreak in textfields within TM1Web seems to be not possible ? Does anybody know more about this "feature" ?

Alt + Enter in Excel. As far as I'm aware this is not possible in TM1web.

龙创天下

Thank you for your answer.

Do anybody know, if such a workflow is possibe:

- starting a ti-process from tm1web
- process starts e.g. a text-editor
- editing text with text-editor

... until here I think it is no problem, but now:

- saving text in texteditor e.g. in html- or xml-format (so that text-formatting is save)
- returning text to tm1 and saving the texct in a cube

????

lindejink

Newcomer wrote:Do anybody know, if such a workflow is possibe:

- starting a ti-process from tm1web
- process starts e.g. a text-editor
- editing text with text-editor

... until here I think it is no problem

Actually I think there would be a problem.  Remember that the TI process runs on the application server which may not be the same physical machine as the web server and will almost certainly not be the same machine as hosting the client web session.  Any ExecuteCommand function to call an external program is happening only on the application server, you cant make an application launch on the client machine via a TI process on the server.  (Potentially you could launch an application on the client machine via a hyperlink embedded in a websheet but there is no way to have interactivity with the TM1 window.)

Newcomer wrote:- saving text in texteditor e.g. in html- or xml-format (so that text-formatting is save)
- returning text to tm1 and saving the texct in a cube

You may be able to save a formatted text file, but what would be the point? When TM1 stores strings it stores the character values only, there is no capacity for encoding formatting.