https://bugs.freedesktop.org/show_bug.cgi?id=54940

--- Comment #7 from mariosv <[email protected]> 2012-09-15 21:28:56 UTC 
---
(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.

> 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?.

> 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.

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.

Regards

-- 
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

Reply via email to