Formula in Spreadsheed models in ARIS10 using '$'?

Hello Mariya,

just like in Excel it makes if difference, if you copy the text of the formula (by going into edit mode of the cell, marking the text of the formula, Ctrl+C) or if you copy the entire cell (just selecting the cell, hit Ctrl+C).

In the first case you only have some text with the formula in your clipboard. When you paste it somewhere else the system does not know where you got those characters from.

In the latter case the system knows the source cell and can translate the relative references.

Does that help?

Dear Mr. Zschuckelt,

Thank you very much for your swift reply!

Yes, when I copy the entire cell (not its content) and paste it in another place, the reference is kept, but this is not solve my issue, because I didn't have separate cell with the attribute ((=ARIS_ATTRIBUTE (API name))  as such for each row and therefore the formula is not valid - please see the attached file (2.jpg).

The thing that I am searching for a way to copy the formula, but to use some kind of '$' functionality (as it is in Excel), because the 1st parameter of the formula (cell numbers) are changing, but the second one doesn't - B2 in may case.

Is there a way to solve my issue without repeating the formula '=ARIS_ATTRIBUTE(API name)' for each row?

Kind Regards,

Maria

Hello Mariya,

the '$' functionality works exactly as in Excel. Your source cell B3 should have a reference to 'B$2' and when you copy B3 to B4 it should still read 'B$2', while reference A3 moves to 'A4'.

Dear Mr. Zschuckelt,

In my source cell B4, I put as a formula the following: '=ARIS_ATTRIBUTE_VALUE(A4;B$2$)' with the idea to copy the entire cell and to paste it throughout the cells below. But when I hit Enter or press Save button, the symbol '$' disappers.

That is why I decided to ask here, whether it is possible to use '$' functionality in Spreadsheet model in ARIS10 at all.

Now when you wrote me that '$' is available in ARIS10, the nthe impossibility to use it is because of some kind of bug and I need to report to SAG.

Kind Regards,

Maria

Please Prefix with the $. E.g. '=ARIS_ATTRIBUTE_VALUE($A4;B$2)'

This way you can copy the cell downwards (keeping the title row stable) and horizontally for further columns (keeping column A reference stable). You tried to suffix with the $, which is a Syntax error and probably the reason why it is ignored. In Excel you also prefix the components of the reference that you want to be stable.

Аh, yes, I was made a syntax error in the example, I have written above.
Now with the correct one :)
First I have tried with your suggestion '=ARIS_ATTRIBUTE_VALUE(A4;B$2)' and it works.
Then I noticed, that I haven't put '$' for A4 and tried to correct the formula as follows: '=ARIS_ATTRIBUTE_VALUE($A4;B$2)', but again when hit Enter or press Save, the '$' disappears for A4 only, keeping the $ in the 'B$2' part.
Thаt make me thinks that when the formula is saved, it can not be changed and I was right - at the beginning I save it without '$' symbols and then I tried to add them in the same formula. That is why ARIS didn't allow me to do this and the '$' symbols disappeared after saving the model. If you want to correct the formula after it is saving, you need to delete it first and then to put the correct one.

We solved the problem and I want to thank you for your quick response.

Have a nice day and Regards,

Maria

I would ask you to report this "changing formula" issue as a bug to support. Of course you should be able to change a formula.

Yes, of course!

Could you please advise how/where I have to report for this bug - via SAG Empower as an incident or somewhere else?

Thank you in advanced for the answer and regards,

Maria