[Libreoffice-qa] [Moztrap] Can someone explain test case #122 to me?

Petr Mladek pmladek at suse.cz
Mon Apr 8 08:10:38 PDT 2013

Yifan Jiang píše v Po 08. 04. 2013 v 15:28 +0800:
> Hi Miguel,
> On Sun, Apr 07, 2013 at 09:42:38AM -0700, mariosv wrote:
> > Hi Thomas, I did the test, and certain that the bad English is mine.
> Hah, actually I tried to make the scenario easier but have never done
> it in a better way, sadly even in Chinese :) I think it is not because
> of English, but the relevant complicated scenario. I feel the steps
> are concise and clear enough, certainly it will be nice when some one
> makes it more generally easy to understand for testers without little
> format conditional background knowledge.

First, I like the complex test for many scenarios.

I was confused by the #6 and #10 column names. I did not read it
carefully, saw numbers and expected row numbers. I would suggest to use
Calc column names 'J' and 'P' instead on the #N indexes ;-)

You could also use the colors for identification, for example, the
tester need to modify cells with the red top and bottom borders.

Otherwise, I wonder if we could optimize the test a bit. In the current
state, you need to click many times just to switch between two values.

One possibility would be to create static test. You crate many rows with
conditional and expected formatting. Some rows might have passing and
some failing condition. It would work if the conditional formatting is
calculated on document load. You might double check this with Markus.

If you really want to do it interactive, it would be better to change
all states by a single selection. You might create one selection box
somewhere, e.g. C5 and change all the values in columns J, L, P, ...
according to this state. For example, using =IF(C5>=1,2,0) in the cell
J6. Then you could change just A1 and visually verify all affected
columns. This will do the same test many times faster and it will be
much easier to describe,

Best Regards,

More information about the Libreoffice-qa mailing list