Bug 95182 - LOCalc autoformat (documentation)
Summary: LOCalc autoformat (documentation)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
4.4.5.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Help-Changes-Features
  Show dependency treegraph
 
Reported: 2015-10-19 16:49 UTC by gmarco
Modified: 2018-09-29 20:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
autoformat1 (screenshot) (103.58 KB, image/jpeg)
2015-10-19 16:49 UTC, gmarco
Details
autoformat2 (screenshot) (45.25 KB, image/jpeg)
2015-10-19 16:50 UTC, gmarco
Details
autoformat help anomalies (895.61 KB, application/pdf)
2015-10-26 16:50 UTC, gmarco
Details
odt document (2.73 MB, application/vnd.oasis.opendocument.text)
2016-11-08 18:01 UTC, gmarco
Details
screenshot about the help (72.54 KB, image/jpeg)
2017-01-06 17:20 UTC, gmarco
Details
screenshot about the menu (52.23 KB, image/jpeg)
2017-01-06 17:22 UTC, gmarco
Details

Note You need to log in before you can comment on or make changes to this bug.
Description gmarco 2015-10-19 16:49:59 UTC
Created attachment 119764 [details]
autoformat1  (screenshot)

Sorry, but my LO is in Italian language, so I cannot show all in English (attachments are in Italian).
Referring to help (https://help.libreoffice.org/Calc/Using_AutoFormat_for_Tables/it  and attach. "autoformat1" mark1), it says:

To Apply an AutoFormat to a Sheet or Selected Cell Range
1.Select the cells, including the column and row headers, that you want to format.
2.Choose Format - AutoFormat.
3.To select which properties to include in an AutoFormat, click More.
4.Click OK.
 The format is applied to the selected range of cells.

Well, item 3 instructs to "click More" ("Extra" in the IT version) but I don't see any of that (see attach. "autoformat2").
Comment 1 gmarco 2015-10-19 16:50:42 UTC
Created attachment 119765 [details]
autoformat2  (screenshot)
Comment 2 Buovjaga 2015-10-21 05:39:38 UTC
Confirmed.

To see the English help, you can simply click on the EN link..
https://help.libreoffice.org/Calc/Using_AutoFormat_for_Tables
Comment 3 gmarco 2015-10-21 10:10:53 UTC
(In reply to Beluga from comment #2)
> Confirmed.
> 
> To see the English help, you can simply click on the EN link..
> https://help.libreoffice.org/Calc/Using_AutoFormat_for_Tables

I wish to add a further note I forgot.
You should add item 7 instructing to exit clicking on CHIUDI (I think CLOSE in EN), otherwise, clicking OK, LO hangs (see bug 92506 comments 7 and 12).
Comment 4 Buovjaga 2015-10-21 11:15:08 UTC
(In reply to gmarco from comment #3)
> (In reply to Beluga from comment #2)
> > Confirmed.
> > 
> > To see the English help, you can simply click on the EN link..
> > https://help.libreoffice.org/Calc/Using_AutoFormat_for_Tables
> 
> I wish to add a further note I forgot.
> You should add item 7 instructing to exit clicking on CHIUDI (I think CLOSE
> in EN), otherwise, clicking OK, LO hangs (see bug 92506 comments 7 and 12).

I think you should join the documentation team. You should join #libreoffice-design as that is where the help content tinkerers currently hang out. They now use an extension to help with help authoring: http://listarchives.libreoffice.org/global/design/msg07341.html
Comment 5 gmarco 2015-10-26 16:50:59 UTC
Created attachment 119971 [details]
autoformat help anomalies

I have summarized all my comments in the attached pdf.
Comment 6 QA Administrators 2016-11-08 11:56:01 UTC Comment hidden (obsolete)
Comment 7 gmarco 2016-11-08 17:32:44 UTC
(In reply to QA Administrators from comment #6)
> ** Please read this message in its entirety before responding **
.....
> If the bug is present, please leave a comment that includes the version of
> LibreOffice and 
> your operating system, and any changes you see in the bug behavior
>  

Hi, the bug is still present,
I am running LO 5.2.2.2 and Win10

Regards
Comment 8 gmarco 2016-11-08 18:01:30 UTC
Created attachment 128585 [details]
odt document
Comment 9 gmarco 2016-11-08 18:03:43 UTC
I think nothing has changed: look at the attached odt for a full expaination about the anomalies.
Comment 10 gmarco 2017-01-06 17:20:14 UTC
Created attachment 130213 [details]
screenshot about the help
Comment 11 gmarco 2017-01-06 17:22:41 UTC
Created attachment 130214 [details]
screenshot about the menu
Comment 12 gmarco 2017-01-06 17:25:33 UTC
Tested again in LO 5.2.3.3 the help problem persists.
At links https://help.libreoffice.org/Calc/Using_AutoFormat_for_Tables/it and EN https://help.libreoffice.org/Calc/Using_AutoFormat_for_Tables instructions are still incorrect or incomplete.
Same comments apply to the local help.

1- the title "Usare la formattazione automatica per le tabelle" ("Using AutoFormat for Tables"): why "tabelle" ( "Tables") speaking of  "un foglio o a un'area di celle selezionata" ("Sheet or Selected Cell Range")?

2- in both paragraphs it says "Scegliete Formato - Formattazione automatica." but in the IT menu we get "Formato - Stili di formattazione automatica..."

3- in the paragraph "Per applicare una formattazione ...." ( "To Apply an AutoFormat ....") it says "Per selezionare le proprietà da includere nella formattazione automatica, fate clic su Extra." ( "To select which properties to include in an AutoFormat, click More.") but in the IT version no EXTRA appears to click on.

4- in the paragraph "Per definire una formattazione ...." ( "To Define an AutoFormat ....") it says "Scegliete Modifica - Seleziona tutto" ( "Choose Edit - Select All")  but it is not right: all mean all the sheet, while you must select only the formatted cell range (at least 4 x 4 cells) you wish use as a model.

5- however, the instructions are very limited and poor in content with respect to the topic complexity; further nothing is said about  Elimina e Rinomina (Delete and Rename). In this respect refer to the bug 105152.

6- relatively to the previous p.2 also at  https://help.libreoffice.org/Calc/AutoFormat/it we can read "Menu Formato - Formattazione automatica..."  but in the IT menu we get "Formato - Stili di formattazione automatica..." and here it says too "Più Consente di nascondere le opzioni supplementari della sezione Formattazione, qualora sia attualmente aperta"  ("More Closes the Formatting options section, if it is currently open")  but the option does not exist .

7- at  https://help.libreoffice.org/Calc/Format/it what appears is completely different from the real (see attachments Calc-help for Formato and Calc-menu for Formato).