Hello everyone!
I need your knowledge and help about the following case:
I use a spreadsheet model in ARIS10 in order to show an attribute value of 1 attribute for several objects. Please see the ilustration attaced:
- in cell B2, I typed '=ARIS_ATTRIBUTE (API name)';
- for the 1st object I typed: '=ARIS_ATTRIBUTE_VALUE(A4;B2)'
- then I tried to put in the formula '$' in order to copy and paste it for other rows, but it didn't work - '=ARIS_ATTRIBUTE_VALUE(A4;$B$2)', because in cell 'B2' is the attribites itself.
Could you please give me an advice what can I do in order to transpose the formula to the other rows and not to type it over and over again.
Thank you very much in advanced for you time!
Kind Regards,
Maria
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
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