Haz tu Pregunta

perfil de Alias duel zone - actividad

2018-12-03 13:12:08 +0200 recibió una medalla  Crítico (fuente)
2017-01-17 11:53:03 +0200 comentar respuesta Is it possible to view two calc sheets side by side?

Simpler answer does translate to MacOS X environment easily.

2016-03-03 16:53:23 +0200 la mejor respuesta fue marcada Why definition of a character style "relative" to the "Default Style" is blocked?

I only work with styles within any editor (because I intend to work on large and professionnal documents).

I would like to define a character style which will only depend on the "Default Style". Let's take an example with a style I need: "Important". This character style named "Important" will be used within any paragraph to just change the Font Typeface from "Regular" to "Bold". I want to get the same result whichever is the actual paragraph font in use in my actual paragraph.

Here is how I proceeded. My cursor is on a paragraph of style "P1". P1 is using typeface Papyrus, 16pt. I defined a new character style named "Important" with the function "New Style from Selection". Within "Organizer" I choosed Linked with "Default Style". LibreOffice displayed an error message:

This Style cannot be used as a base Style,

because it would result in a recursive reference.

I can't understand how defining a relation as simple as

Default Style → Important

might cause any form of recursion: there is no loop of dependency there.

Why is this relative definition blocked?

I feel that such a relative definition is very practical and basic need. To ensure all my character styles won't stay stiff if I decide to change a full range of paragrahs styles I need relative character definitions and not absolute ones.

2016-03-03 16:31:04 +0200 recibió una medalla  Pregunta Famosa (fuente)
2016-03-03 16:08:39 +0200 la mejor respuesta fue marcada How to define a character style changing just one component of style?

I only work with styles within any editor (because I intend to work on large and professionnal documents).

I would like to define a character style which will only depend on the "Default Style". Let's take an example with a style I need: "Important".

To overcome an error message I don't yet understand (and fully described there: Why definition of a character style "relative" to the "Default Style" is blocked?) I choosed to link this character style with "- None -".

I put my cursor on another paragraph which is in style P2 and using Font Times, 12 pt. I select the word "based". If I change this word with the character style "Important" it is changed correctly to a bold typeface, but at the same time is switched to Papyrus 16 pt coming from P1.

This is producing this result which is of no use (for me): Important_character_style_pb


How should I define this new "Important" character style so as to be able to change just the component of my character style I want to change and not all the other ones?

2016-03-03 11:34:57 +0200 la mejor respuesta fue marcada Page breaks management?

I'm working with:

LibreOffice     4.2.3.3
MacOS X         10.8.5

I activated the mode: View > Non printing characters because I'm not able to manage a document where I don't see everything. Then I can see all the returns and tabulations and have an immediate understanding of any alignement problem coming from extra spaces or tabulations or returns. I can directly select any of them and simply remove them with a basic delete ⌫.

But I still find it very hard to see and manage page breaks.


  1. How may I render page breaks directly visible?
  2. How may I remove them as easily as any other "non printing" character?
2016-03-03 11:29:46 +0200 recibió una medalla  Pregunta Famosa (fuente)
2016-03-03 10:36:02 +0200 la mejor respuesta fue marcada How to get rid of WW8Num8 list style

I'm working with:

LibreOffice     4.2.3.3
MacOS X         10.8.5

I got more than 20 list styles I don't use and I would like to remove. I want to get rid of menus jamed with useless entries.

These list styles have names of the form:

WW8Num<n>

where n is a number in [1 ; 25]. These styles are the results of a .doc opening.

When a select anyone of this list styles, let's say for example WW8Num8,

open the control drop down menu,

and select Delete..., the selected list style disappear from the displayed list.

But...

I have a problem.

  1. If I close and reopen Format > Styles and Formatting, the list style WW8Num8 is there again.
  2. If I am on a paragraph where this list style was used, this paragraph is still using the list style WW8Num8.

How may I get rid of (for example) the WW8Num8 list style?

Is this a bug?

2016-03-02 23:45:54 +0200 la mejor respuesta fue marcada Basic paragraph indentation and numbering

Running LibreOffice 4.2.3.3 I don't manage to define basic paragraph numbering scheme. I just want to define correctly 2 paragraph styles only and named:

  • Title 1
  • Title 2

I want to get a very basic numbering and indentation scheme I tried to mimmic here:

1.  Chapter 1              [style Title 1]
    1.1. sub chapter 1     [style Title 2]

2.  Chapter 2              [style Title 1]
    2.1. sub chapter 1     [style Title 2]

I have created these 2 paragraph styles and modified them from the Styles and Formatting tool. Style Title 2 is linked to Title 1 since I want to keep them consistent.

But I can't get the Title 1 correct indent of text after number to work. I entered a specification of 1.00 cm for the 1st tab, and a numbering scheme Numbering 1 specifying to add a tab after the number. I applied this modification, but nothing happens.

The numbering scheme for both styles is Numbering 1. Nonetheless, the numbering stays wrong.

Here is the deception point I reached thus far:

1. Chapter 1              [style Title 1]
    2. sub chapter 1     [style Title 2]

3. Chapter 2              [style Title 1]
    4. sub chapter 1     [style Title 2]

I thoroughly read the documentation but can't see what I didn't get right there.


How should I modify my Title 2 paragraph style to obtain the basic specified indentation and numbering scheme?

2015-08-28 11:41:13 +0200 recibió una medalla  Pregunta Famosa (fuente)
2015-06-04 22:50:29 +0200 recibió una medalla  Pregunta Famosa (fuente)
2015-04-06 16:13:50 +0200 recibió una medalla  Pregunta Notable (fuente)
2015-04-06 14:34:58 +0200 respondió a una pregunta How to insert a [return] in a cell?

To place a return within a cell containing text, you have to type [⌘]+[return].

This is ununderstandable in a MacOS X context.

This is an error on a Mac in 3 ways:

  1. On MacOS X, the [⌘] key is reserved for commands and is never used to input text. The keys used to modify the keyboard mapping for input are [⌥], [⌃] and of course [⇧].
  2. The [return] is redundant with the [↓] (down arrow key), hence there was no real need to map the [return] key to move the cursor down (I have a more natural key for this function).
  3. Most of the MacOS X application are assigning to keys the most natural function everyone is expecting. The most natural function which might be associated to typing a [return] is to insert a return.
2015-04-04 14:52:28 +0200 comentar respuesta How to insert a [return] in a cell?

I understand our misunderstanding. As indicated in my OQ, I have this problem on MacOS X Mountain Lion.

2015-04-02 01:25:06 +0200 comentar respuesta How to insert a [return] in a cell?

Sorry, it doesn't work: just jump on the next cell (down).

2015-04-02 01:12:26 +0200 recibió una medalla  Pregunta Popular (fuente)
2015-04-01 16:47:26 +0200 realizó una pregunta How to insert a [return] in a cell?

I'm actually using LibreOffice 4.2.3.3 on MacOS X Mountain Lion

I need to place returns in cells containing text. Just as usual when typing text.

I tried [⇧]+[return], [⌥]+[return} and I always fall on the next cell.

I tried to change Preferences:

LibreOffice Calc > General
☐ Press Enter to move selection

which does only change my [return] to a dead key.


How may I switch to a mode where my [return] key does work as most usually expected putting a new line exactly where I am typing?

If this isn't possible is there a way to remap any key or combination of keys so as to include [return] as fluently as possible?

2015-01-22 21:38:26 +0200 recibió una medalla  Pregunta Famosa (fuente)
2014-11-20 18:05:30 +0200 recibió una medalla  Pregunta Notable (fuente)
2014-11-20 02:48:23 +0200 recibió una medalla  Pregunta Popular (fuente)
2014-11-19 19:00:28 +0200 comentar respuesta How to color cells efficiently?

To make a try, I just copied one of my table in writer and pasted it within calc. The formulas are there, but all the formatting styles are lost.

2014-11-19 18:51:12 +0200 comentar respuesta How to color cells efficiently?

I thought to this way. But this will lead me to another problem of the same size: "how will I set the paragraph formatting efficiently of many cells" ? I would like to manage within a technical document tables with text correctly formatted and cells correctly formatted. These tables contains about half an hundred cells.

2014-11-19 18:41:26 +0200 comentar respuesta How to color cells efficiently?

You are welcome to laugh: I did the same sort of error. I searched on Google: "LibraOffice Applying Conditional Formatting" and read many pages scratching my head. "Where are all these fantastic functions? Is my version that old? Are my eyes that tired?"

2014-11-19 18:36:21 +0200 comentar respuesta How to color cells efficiently?

Under the Format menu I haven't any Conditional Formatting entry. I don't get it even when I select a cell of my table. Is this a dynamical menu I could get only under certain conditions?

2014-11-19 18:10:43 +0200 realizó una pregunta How to color cells efficiently?

I'm working with:

LibreOffice     4.2.3.3
MacOS X         10.8.5

I have to manage a few tables so as to fill their cells to express a level (temperature for example). Here is an example of the background-color scheme I would like to achieve: LibreOffice table with colors

The function to implement is:

if (cell-content == 1) then color-background = green
if (cell-content == 2) then color-background = yellow
[...]

I already have a pretty good idea of a bad method:

  1. select cell
  2. select menu > Table > Table Properties...
  3. select Background, choose Background color, click OK
  4. goto 1 until deadline

What are the efficient ways to achieve this color filling efficiently and so as to be able to change the overall color scheme?

Is there a right method with "conditional paragraph styles" (p. 216 of Writer Guide 4.0)?

Is there a right method with "formulas" ( p. 282 of Writer Guide 4.0)?

Is it possible to get a function like a "cell-style" so as to apply it manually to a given set of cells?

2014-11-19 17:39:03 +0200 recibió una medalla  Pregunta Famosa (fuente)
2014-10-25 11:43:02 +0200 recibió una medalla  Pregunta Famosa (fuente)
2014-10-12 10:50:19 +0200 comentar respuesta [Solved in v4.0.2] Variable not evaluated in header

Could someone add 4.0.0.3 within the title of this question: old bug, fixed now?

2014-10-11 14:47:17 +0200 respondió a una pregunta How can I write 'ñ' in Libreoffice for Mac?

⌥(option) + N, N → ñ

⌥(option) + N, ⇧(shift) + N → Ñ

To find the other interesting characters:

  1. activate the Keyboard Viewer:

    System Preferences > Language & Text > Input Sources

    turn on Keyboard & Character Viewer

  2. open the Keyboard Viewer, from the Keyboard selector within the menu bar,

  3. press the ⌥(option) key (or any other keyboard modifier) to discover which character on the keyboard may give you access to language specific characters (ex. : ⌥ + N → ã, ñ, õ, Ã, Ñ, Õ).

.

Note : this is not a shortcut specific to LibreOffice, you can use it within the Finder anf within any application.

2014-10-08 20:12:46 +0200 comentar respuesta How do I change the formatting of Cross-References?

Is this extension compatible with LibreOffice 4.x?

2014-09-06 17:36:28 +0200 comentar respuesta Why do carriage returns within a comment (on this site) not display as expected?

[⇧]+[return] doesn't work.[included here] It "seems" to have the same function as a [return]. Are you talking of the [enter] which exists on some keyboards and is different from [return]?

2014-09-06 17:33:24 +0200 la mejor respuesta fue marcada Why do carriage returns within a comment (on this site) not display as expected?

Every time I place a return within a comment (for example to separate elements of a very small list) they are displayed correctly within the editing window. But once my comment is saved I discover that something ate all these returns.

What is the trick to put a needed return where I want within a comment?

2014-09-06 17:33:15 +0200 comentar pregunta Why do carriage returns within a comment (on this site) not display as expected?

→ oweng: thank you for improving the subject.

2014-09-06 17:31:37 +0200 recibió una medalla  Escolar (fuente)