https://bugs.documentfoundation.org/show_bug.cgi?id=95397
Bug ID: 95397
Summary: Calc AutoFormat instructions
Product: LibreOffice
Version: 4.4.5.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
Created attachment 120051
--> https://bugs.documentfoundation.org/attachment.cgi?id=120051&action=edit
autoform-newtest (screenshot)
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)
--
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
