Straight table problem with Copy to Clipboard/Cell Value
Hello,
I have a straight table with two dimensions, dim1 and dim2, and one expression meant as lineno, = RowNo(TOTAL)
Then I dragged the expression column to the first column in the table.
When I press the right mouse button on a cell value in the second column (dim1) and select 'Cell Value' via 'Copy to Clipboard' then I get the value from the first column (the expression).
When I do this in the third column then I get the value from the second column.
[data]:
LOAD * Inline [
Dim1, Dim2
aaa, AAA
bbb, BBB
ccc, CCC
ddd, DDD
]
;
Straight table
lineno Dim1 Dim2
------ ---- ----
1 aaa AAA
2 bbb BBB
3 ccc CCC
4 ddd DDD
What is the problem and is there another way to create a linenumber in the table by, for example, a calculated dimension ?