[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #21 from Beluga  ---
(In reply to gmarco from comment #19)
> It remains clear, however, the need to complete adequately the documentation
> (have I to open an enhancement?)

Open a new documentation report for it. Maybe not necessary to mark as
enhancement. Thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #19 from gmarco  ---
Created attachment 120042
  --> https://bugs.documentfoundation.org/attachment.cgi?id=120042=edit
autoform-newtest  (screenshot)

Happy End (at least, I think!)
Taking into due consideration the previous observations  I run some further
tests.
My conclusions are shown in attached "autoform-newtest.JPG" (with associated
rules) and in the new sample "autof-newsample-ods".
Therefore, there exist logical limitations and rules consequent.
So I can consider the issue closed, consequently I modify and mark as notabug.
It remains clear, however, the need to complete adequately the documentation
(have I to open an enhancement?)

Thank you all.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

gmarco  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTABUG

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #20 from gmarco  ---
Created attachment 120043
  --> https://bugs.documentfoundation.org/attachment.cgi?id=120043=edit
autof-newsample-ods

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #15 from Niklas Johansson  ---
m.a.riosv is correct in Comment#5 it is a limitation, making this an
enhancement request rather then a bug. As often is the case, the documentation
could be improved, but it's hard to write good documentation. 

(In reply to gmarco from comment #6)
> (In reply to m.a.riosv from comment #5)
...
> Even assuming that the sample-based data is limited to 3x3 data cells (over
> the columns/rows for titles/total), why the column "Mar" (D in the sample
> ods) is blue instead of yellow?

Read m.a.riosv answer again the sample-base data is limited to 2x2 which is
then repeated. That is why Mar is blue like Jan.

Enhancing this functionality might be in conflict with adding support for table
formats and interoperability with other office suits.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #16 from gmarco  ---
Created attachment 119998
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119998=edit
autof-ods1  (screenshot)

(In reply to Niklas Johansson from comment #15)
> m.a.riosv is correct in Comment#5 it is a limitation, making this an
> enhancement request rather then a bug. As often is the case, the
> documentation could be improved, but it's hard to write good documentation. 
> 
> (In reply to gmarco from comment #6)
> > (In reply to m.a.riosv from comment #5)
> ...
> > Even assuming that the sample-based data is limited to 3x3 data cells (over
> > the columns/rows for titles/total), why the column "Mar" (D in the sample
> > ods) is blue instead of yellow?
> 
> Read m.a.riosv answer again the sample-base data is limited to 2x2 which is
> then repeated. That is why Mar is blue like Jan.
> 
.
Let me observe again:
1) any limitation may be accepted ... if clearly documented
... but, assuming a 2x2 limit, then the pattern displayed (see attach
autof-ods1)would not display col.Mar and row Sud.
2)  if you look at Beluga test (comment #13) and my reply, you can see that
column range is 3x3(selecting only data cells) and the result is really 3x3
(see attach format-ods2 where the pattern is applied selecting B2/F8 and you
can see col.D yellow).
3)  further look at attach format-ods3: here, selecting how suggested by Beluga
cells B2/J8 and applying the pattern based on test Beluga, you'll see an
anomalous result where only col.B is blue while all Others are alternatively
red or yellow.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #18 from gmarco  ---
Created attachment 12
  --> https://bugs.documentfoundation.org/attachment.cgi?id=12=edit
autof-ods3  (screenshot)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #17 from gmarco  ---
Created attachment 11
  --> https://bugs.documentfoundation.org/attachment.cgi?id=11=edit
autof-ods2  (screenshot)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #14 from gmarco  ---
(In reply to Beluga from comment #13)
> I'm not sure, if it's like m.a.riosv said that there is some (undocumented)
> limitation. I haven't really used the feature.
> 
> I did a different test:
> 
> I created an Autoformat in autof-sample-ods1 like this:
> Select B2:G11.
> 
> With this, the colors went: blue, red, yellow, red, blank. So why no orange
> & green??
> 
> We have to find some autoformat guru.
> 

Hi Beluga, I too tried your test, it may be a "quite" good solution.
Nevertheless, if you apply that autoformat to autof-sample-ods2 (selecting
B2:F8) the result is col.E red instead of orange.
Undoubtedly we need a guru to know which is the LO issue and it would be
adjusted appropriately both help and guide: aside other inadequacies, it is
needed to exactly clarify which cells we have to select: actually I read (into
guide PF1 searching for Autoformat) "scegliete modifica-seleziona tutto" (=
choice edit-select all) and (into help) "a range of at least 4x4 cells".

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #9 from gmarco  ---
Created attachment 119941
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119941=edit
autoformat-ITguide(PF1) 2

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #8 from gmarco  ---
Created attachment 119940
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119940=edit
autoformat documentation

(In reply to Joel Madero from comment #7)
>  
> Thanks a million!

Hi Joel,
just for your million of thanks, I have made a pdf as you like (I hope).
Look at attached "Autoformat documentation.pdf".
Needing further infos let me know.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #10 from Joel Madero  ---
Hi Gmarco -

No problem but I'm still unclear at what I'm looking for. Can you describe in
enumerated steps and point me to exactly what I'm looking for in this pdf.
Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

Joel Madero  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

gmarco  changed:

   What|Removed |Added

 Attachment #119940|0   |1
is obsolete||

--- Comment #11 from gmarco  ---
Created attachment 119944
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119944=edit
autoformat documentation

(In reply to Joel Madero from comment #10)
Hi Joel
You have to point in step 12 the resulting sheet after applying the autoformat
"test" previously created and stored s pattern.
Here you can see that the cell are formatted (coloured) differently from the
original sheet "ods1" used as specimen in creating the autoformat "test" in
steps 1-8.
(warning: I have replaced the pdf)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

gmarco  changed:

   What|Removed |Added

 Attachment #119944|0   |1
is obsolete||

--- Comment #12 from gmarco  ---
Created attachment 119945
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119945=edit
autoformat documentation

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

Beluga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi
 Whiteboard||needAdvice

--- Comment #13 from Beluga  ---
I'm not sure, if it's like m.a.riosv said that there is some (undocumented)
limitation. I haven't really used the feature.

I did a different test:

I created an Autoformat in autof-sample-ods1 like this:
Select B2:G11.

With this, the colors went: blue, red, yellow, red, blank. So why no orange &
green??

We have to find some autoformat guru.

Win 7 Pro 64-bit, Version: 5.0.2.2 (x64)
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Locale: fi-FI (fi_FI)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

Joel Madero  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||jmadero@gmail.com
 Ever confirmed|0   |1

--- Comment #7 from Joel Madero  ---
Hi Gmarco -

I'm sorry but it's really hard to tell what this bug is about - it's not easy
to follow 5 attachments to determine the problem.

Please describe the issue in the comment (vs. saying "look at the 5
attachments) as clear as possible, preferably not in paragraphs but enumerated:

1. Open File.ods
2. Do X
3. Do Y
4. 

Expected Result:

Observed Result:

This makes it 10x easier on our limited QA volunteer time to look at the issue
and try to figure out if it's a bug, enhancement, or neither.

Marking as NEEDINFO - once you clarify the issue in the comment please set to
UNCONFIRMED.

As far as the Italian language - if possible please describe which menus to
push on in English - if that's an issue, please head to your locales mailing
list and ask for help translating.

Thanks a million!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #6 from gmarco  ---
(In reply to m.a.riosv from comment #5)
Hi, thanks for replying.
I think yours is a simple supposition.
Even assuming that the sample-based data is limited to 3x3 data cells (over the
columns/rows for titles/total), why the column "Mar" (D in the sample ods) is
blue instead of yellow?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #5 from m.a.riosv  ---
Hi @gmarco, thanks for reporting.

I think not a bug but a limitation to:

- Row title.
- Column title.
- Row total.
- Column total.
- Up 2 types for intermediate rows/columns.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #2 from gmarco  ---
Created attachment 119761
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119761=edit
autof-sample-ods2  (sample ods sheet)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #4 from gmarco  ---
Created attachment 119763
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119763=edit
autof-app2  (screenshot)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #1 from gmarco  ---
Created attachment 119760
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119760=edit
autof-add1  (screenshot)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 95181] LOCalc autoformat add and apply (not corresponding result)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=95181

--- Comment #3 from gmarco  ---
Created attachment 119762
  --> https://bugs.documentfoundation.org/attachment.cgi?id=119762=edit
autof-app1  (screenshot)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs