Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

None of the basic table AutoFormat schemes in LibreOffice Writer have both an alternation style defined and no sum column/row style defined. If they have alternation, they always seem to have sums. Because of this I'd like to define my own table scheme.

What is the easiest way to accomplish this?

A WYSIWYG isn't totally necessary. I am not scared of editing simple XML files as long as I have examples to work from, and if I don't have to edit base install files. If I can place them in a custom area or my user profile directory then that would be best.

If there is a way to get the GUI Add functionality to properly recognize an alternation then that would also be helpful.

share|improve this question

No XML is necessary, it's just not obvious. Open up Calc and format some cells just the way that you want the new AutoFormat theme to look. Select everything (Ctrl+a or Edit | Select All) and then choose Format | AutoFormat and click the Add button.

If you go to use AutoFormat from the Format menu in Writer afterward, your new style should be listed there.

share|improve this answer
There's no AutoFormat in the Format menu, neither a Format entry in the context menu in LO 4.3.5 – Andy Feb 26 '15 at 10:27

From the LibO 3.5 getting started guide (calc section):

Defining a new AutoFormat

You can define a new AutoFormat that is available to all spreadsheets.

  1. Format a sheet (in the style for the new AutoFormat).
  2. Choose Edit > Select All.
  3. Choose Format > AutoFormat. The Add button is now active.
  4. Click Add.
  5. In the Name box of the Add AutoFormat dialog, type a meaningful name for the new format.
  6. Click OK to save. The new format is now available in the Format list in the AutoFormat dialog.
share|improve this answer
Which new format is made available after this? All it shows is the new AutoFormat name in the list. How to customize it? this is not given in this answer. – Tem Pora Apr 17 '14 at 13:45

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .