https://issues.apache.org/ooo/show_bug.cgi?id=121696
Anders Kvibäck <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |CONFIRMED Component|configuration |ui QA Contact|[email protected] | --- Comment #9 from Anders Kvibäck <[email protected]> --- These are my teststeps to show the bug: 1.Open up a new calc sheet. 2. Tools>Options>Calc>Calculate>Automatically find column and row labels enabled 3. In cell A3, type in: t1 4. In cell B3, type in: 2 5. In cell A5, type in: Res 6. In cell B5, type in: ='t1' 7. In cell A6, type in: tstv 8. In cell B6, type in: ='t1'*4 9. The expected result in B5 is 2 and the expected result in B6 is 8 10. The shown result in B5 is Res and the shown result in B6 is #VALUE! I e not the correct values. 11. Continue to use t1 in the same way, I e step 5-8. But in other cells, for example A10, B10 and so on. You will get the same result. 12. Now, in cell A2, type in: t2 13. In cell B2, type in: 55 14. In cell A8, type in: Res2 15. In cell B8, type in: =10*'t2' 16. The expected result in B8 is 550 and the shown result in B8 is 550, I e the correct value. 17. If you from now on starts to use t1 it will work fine. 18. For example; in cell A10, type in: wxyz 19. In cell B10, type in: 't1' 20. The expected result in B10 is 2 and the showne result is 2. e As soon as you start to use another constant like t2, you seem to "break up" the bug in t1. I have changed component to ui. I've been testing on Windows Vista, AOO 3.4.1, HP -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
