Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index

Hi again Celia,

I have looked a little further at the Expand Formatting option.

The first thing to say is that we need to correct the description of this interaction in Chapter 14 of the next English version of the Calc Guide (once we are clear exactly what behaviour is implemented!). As the same text is in the Help files, we will need to change that too.

It is also worth noting that Bug 94499 (first raised in 2015) exists on this function relating to the impact on non-empty cells when the Expand Formatting option is ticked.

With regards to your main point about a restart of LO being required, I did not find that necessary. The following steps showed that selecting the Expand Formatting option certainly had some effect without a restart. Perhaps you could try out these steps and see whether you agree?

1. Open Calc from the Start Center in its default configuration, i.e.
   Expand Formatting unticked.
2. Check that Calc has created a new document named “Untitled 1”.
3. Type any character string into cell A1 (e.g. “abcd”). Type any
   number into cell B1 (e.g. “123.4”). The text in A1 should be left
   justified and the number in B1 should be right justified.
4. Select cell A1 and change the formatting on the cell (via Format >
   Cells) to “Text”. There should be no obvious change visible to the
   contents of cells A1 and B1.
5. Change the value displayed in B1 to something different. The new
   value should be displayed right justified (as you might expect).
6. Go to Tools > Options > LibreOffice Calc > General and tick the
   Expand Formatting option and press OK.
7. Type any character string into cell A10. Type any number into cell
   B10. The text in A10 should be left justified and the number in B10
   should be right justified.
8. Select cell A10 and change the formatting on the cell (via Format >
   Cells) to “Text”. There should be no obvious change visible to the
   contents of cells A10 and B10.
9. Change the value displayed in B10 to something different. The new
   value is displayed left justified, showing that the behaviour
   changes following selection of the Expand Formatting option.

There was no closing of either the document, Calc, or LibreOffice during this process, demonstrating that with my setup, no restart was needed. For the record I am running LO Version (x64) under Windows 10.0.



On 24/01/2021 02:39, Celia Palacios wrote:
Hi, guys

I keep translating and verifying chapter 14 of Calc Guide 6.2. Two things I want to bring up to your attention (maybe are also carried over to next guides).

1. Expand formatting option. Must restart LibreOffice in order to apply change to it. Also, if data entry in adjacent cells is interrupted with another action in Calc, also the expanding of formatting is interrupted (I do not know if this is a feature or a bug XDXDXD ). These annotations are omitted in the guide an dI think they're important. Firstly, I changed the option without restaring and I almost went crazy because nothing  happened.

2. Value highlighting. English guide mentions that logical values and dates are green when this option is enables, but it is not true. In fact, they are blue, because they are numbers, internally. Only results from formulas are green. I checked in a localized (Spanish) version, but I believe it's true for every Calc.

If you think my findings are OK, please confirm. Otherwise I will return the parapgraphs to initial state.

Best regards,

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.