Created attachment 120051 [details]
Having I performed various tests to understand the logic by which are initially stored and then applied the predefined models, I have reached these conclusions that it would be appropriate were stated in the help and guide instructions (please correct the imperfections of my English).
Refer to attachment "autoform-newtest" and to my bug 95181.
a) Rules for ADD the current formatting to the list of predefined AutoFormats:
1- Select all the range of the formatted "model" sheet (at least 4 x 4 cells) and click on Format - AutoFormat. (my note: about "Select all the range", it is wrong what I read in the IT guide PF1 instructing to choice Edit–Select all)
The AutoFormat dialog then appears.
Click Add, then enter a name and click OK.
2- Then, in the formatting options (usually selected), deselect those currently in your spreadsheet you want to keep into the predefined AutoFormat.
In the preview field you can see a preview of the predefined formatting.
Calc AutoFormat stores a predefined format using these criteria: the first row and the first column selected are considered to be “titles”, the last row and the last column are considered to be “totals” and other cells are considered to be "data".
3- Click CLOSE. (my note: don't click OK now, otherwise you can get a LO hang; see my bug 92506)
b) Rules for APPLY a predefined AutoFormat to a sheet:
1- Select all the range of cells (at least 3x3) in the sheet to be formatted.
2- Open the the AutoFormat dialog clicking on Format - AutoFormat.
3- Select a specific formatting from the list of all predefined automatic formatting, select/deselect those options you want to be discarded/applied into the marked sheet.
4- Click OK to assign the format to the marked sheet.
The predefined AutoFormat will be applied to new sheets regardless of the amount of cells to format (that is "titles/totals" formats will be applied to the first row and the first column in the selection, "data" formats will be applied to all other cells in the selection.
c) Rules for DELETE/RENAME a predefined AutoFormat:
1- Open the the AutoFormat dialog clicking on Format - AutoFormat. (my note: the AutoFormat selection is usually inhibited; in order to disinhibit it, previously select fictitiously a range of any cells)
2- Select a specific formatting from the list of all predefined automatic formatting.
3- Click Delete or Rename. Cicking Rename you will be asked for a new name, enter it in and click OK.
4- Click CLOSE. (my note: don't click OK now, otherwise you can get a LO hang; see my bug 92506)
I was one of the testers, so setting to NEW.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.1.6 or 5.2.3 https://www.libreoffice.org/download/
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
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
(In reply to QA Administrators from comment #2)
Running LO 18.104.22.168 Win10 it seems nothing changed.
Because of the topic complexity I retested all the topic in LO 22.214.171.124 creating a new one (105152).
Please close this bug (CLOSED-MOVED).