https://bugs.freedesktop.org/show_bug.cgi?id=54940
--- Comment #8 from Markus Mohrhard <[email protected]> 2012-09-15 22:33:09 UTC --- (In reply to comment #7) > (In reply to comment #6) > > (In reply to comment #5) > > > Sorry Markus it was created as "enhancement", and I have no interest in > > > maintaining a discussion with you to nowhere. So if you I am wrong or you > > > don't > > > like to do, no matter, but please return their status, to allow someone > > > else > > > take a look. > > > > Sorry, but this is not a bug. This bug should not be reopened and there > > will be > > nobody else looking at this bug report. If you still feel that you're right > > and > > know calc better than me > > I think wrong way, this is not about who knows more about calc. I have not > called into question your knowledge, so please do not do it with mine. > > Developers must learn that is very important the feedback from users, at the > end, the purpose of the application it is give the best to the user. Not only > in programming in many areas of the life happens the same. The experts have > too > much knowledge to see the things from user side. > > This is about how a developer and an user understand, what must display and > edit the Manager window in Conditional Formatting. I understand that relative references in conditional formats are a complex feature. But please also understand that I get from 10 people 12 different suggestions how to make it better. In the end I have to evaluate each suggestion and check how it fits into the bigger picture and if it make sense. I know that this is difficult to understand as user but in the end I have to find a compromise between all the possibilities. For you these behavior might be confusing but for a lot of other users it is how they expect it. > > > write to the qa list and complain about me closing > > this bug. > > of course I will, in couple of days. > > > > > > > > > Sorry again but to me what you explain is not how it works. > > > > > > In A1 cell, goto to CF introduce in the condition B1, select an style to > > > apply. > > > Enter 1 in B1, the CF condition is always true, and do not depend on the > > > actual > > > cell where we are, only on the B1 value, we can go around on the > > > spreadsheet > > > but A1-CF only change if we change the value in B1. > > > > I did not say that the result in cell A1 depends on the cursor position. The > > shown formula depends on the position. The formula is NOT!! =B1 instead the > > formula is: [value one cell to the right]. > > Right, it is a relative address. > > > Since conditional formats are not > > limited to one cell the only sane way to work with them in dialogs is to the > > show the formula based on the current cursor position. > > This is the basis of the discussion, as user, that can only take me to an > error. > > What is the point to take the current position?. Using the current position is the only way to get the same formula as you originally had. Using a different position would result in more irritated users because they would then enter the shown formula string and would get a different result > > > Entering the shown > > formula in the dialog would result in exactly the same behavior as entering > > your =A1 when you defined the formula. This is just part of how relative > > references work. > > > > > > > > Even worse, if it was not possible to use so the relative formulas in CF, > > > then > > > would be impossible in many cases copy CF between cells, because always > > > remains > > > with the formula of source cell(s). > > > *Actually Copy doesn't copy the CF. > > > > > > > As I tried to explain this is only the way how formulas with conditional > > formulas are displayed. > > Then better do not display it. That is even worse. I will not even discuss this. > > In summary, the actual displaying and edit in the Manage window only can lead > the users to error and confusion. > > What I want as user is to see the entered formula, and when edit, edit the > entered formula. That is what I tried to explain you for some time. The entered formula is always relative to a position. I attached a test document that shows the problem that I think you don't understand right now. In the attached document you'll find two conditional formats both are defined as ISNUMBER(C5) or ISNUMBER(F5), so if both conditional formats would be at the same place they would have the same formula with your suggestion. BUT they did have different base cells when they were defined so they show totally different results. For the conditional format in column B it was B4 and for the one in column E it was E7. Now with the current solution you can see exactly that these two formulas are actually not the same and it is the only way to see what the formula really means. ISNUMBER(F5) or ISNUMBER(C5) is not the "real" formula, it is much more and we can make this more only visible to the user with the current solution. I don't want to be rude but at some point a developer that has the overview about all parts of a feature has to decide if a feature request/bug report that has passed QA can and should be implemented. So in this case my call is that the current solution is the only sane one and I doubt that you can convince Eike or Kohei to disagree on this one. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
