https://bugs.documentfoundation.org/show_bug.cgi?id=153297
--- Comment #8 from ady <adylo811...@gmail.com> --- (In reply to m.a.riosv from comment #7) > (In reply to m.a.riosv from comment #5) > >... > > The issue in that file is in DOWN.A1 a formula with MATCH in it. I indeed saw that. Let's quote Yurij: "When changing any parameter in the "LIST"..." But there is no mention about what exactly was changed in order to replicate the reported problem. So, I repeat here the question: Which exact cells were modified in order to get that unexpected result? Which modification was made in those specific cells? For example, in attachment 185057 posted in bug 153298, in the worksheet named "DOWN", cell A1 contains the formula: $DOWN.A1: =MATCH(1;$LIST.$AA$2:$LIST.$AA$400;1)-1 or: $DOWN.A1: =MATCH(1,$LIST.$AA$2:$LIST.$AA$400,1)-1 So, in the range $LIST.$AA$2:$LIST.$AA$400 in the "LIST" worksheet, what was that Yurij changed in order to get the problem in the "DOWN" worksheet? Which specific cell in "LIST"? What was either deleted or modified in "LIST"? Similarly, in your attachment 185075 posted in comment 4, you used MATCH with whole columns, multiple times referring to the same column. That is, while MATCH is using the same column and with "1" as third argument. This means that you might understand what you yourself posted, but other users cannot replicate the original problem because there is that small detail I asked before. If either Yurij or m.a.riosv could reply with that little piece of info, I'll gladly try to replicate the problem (too). -- You are receiving this mail because: You are the assignee for the bug.
