[Libreoffice-bugs] [Bug 149429] Changing Calc document's language should overwrite cell direct formatting language

2023-03-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149429

--- Comment #14 from Heiko Tietze  ---
(In reply to Mike Kaganski from comment #13)
> Do you mean that "Clear direct formatting" must be removed? It is the
> operation that exactly overwrites direct formatting.

No, I was replying to the summary "Changing Calc document's language should
overwrite cell direct formatting language". And my take is that any DF should
remain. But this discussion is off-topic.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149429] Changing Calc document's language should overwrite cell direct formatting language

2023-03-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149429

--- Comment #13 from Mike Kaganski  ---
(In reply to Heiko Tietze from comment #12)
> we must not overwrite direct formatting by any operation (this summary is WF).

Do you mean that "Clear direct formatting" must be removed? It is the operation
that exactly overwrites direct formatting.

Also: do you suggest to change the application of paragraph styles, so that it
doesn't overwrite DF?

In essence: "we must not overwrite direct formatting by any operation" is
simply a wrong statement. The effect of a given operation on DF is defined by
us. And if it's "set this to *everything*", then a *natural* expectation is
that after this user-initiated operation, *everything* has the wanted property.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149429] Changing Calc document's language should overwrite cell direct formatting language

2023-03-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149429

Heiko Tietze  changed:

   What|Removed |Added

   Keywords|needsUXEval |
 CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda
   |.freedesktop.org|tion.org

--- Comment #12 from Heiko Tietze  ---
My UI lang is English (USA), locale German, default language for documents
English (USA). Dictionaries for both languages are installed. Testing with
v7.5.1.2, VCL kf5.

Calc starts a new document with Text Language = German (no idea why) but I can
change it via status bar to English and "Hello World" is recognized then as
correct. Switching the language means correctly to change it for the 'Default'
cell style.
Cell R10 in the example, is defined as French (France), removing the direct
formatting (ctrl+M) makes it English for me. And subsequently language is
applied to this cell.


So I can follow Eike's comment 8. And we must not overwrite direct formatting
by any operation (this summary is WF).
However, the situation is very much unclear to users as the direct formatting
is potentially overlooked and not aligned with the various places where the
language is set (statusbar and menu). Calc also lacks on something like tools >
language > for selection. Putting all together I think at least the statusbar
needs to reflect the currently active language on the focused cell.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 149429] Changing Calc document's language should overwrite cell direct formatting language

2023-03-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=149429

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

Summary|AutoCorrection detects  |Changing Calc document's
   |misspelled words in English |language should overwrite
   |(USA) whether language is   |cell direct formatting
   |English (USA) or None   |language
 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1
   Keywords||needsUXEval
 OS|Windows (All)   |All
 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org,
   ||stephane.guillou@libreoffic
   ||e.org
 Blocks||96000, 119352

--- Comment #11 from Stéphane Guillou (stragu) 
 ---
I updated the summary to hopefully more accurately describe the issue.

Minimal steps from a new document:
1. Open Calc
2. Right-click on cell A1 > Format cell > Font > change language to e.g. French
> OK
3. Change language for document to e.g. English (from status bar, or Tools >
Language > For all text, or Tools > Options > Language settings > Languages >
Default languages for documents)

Result: cell A1 is still in French.

UX team, what do you think?
- Is this difference between Writer and Calc desired? If so, we should probably
make it clearer (in UI / in documentation) that direct cell formatting will not
be overwritten by a change in default document language. And clarify that the
status bar in Calc is to set the "Default language for this document", and not
just the selected cells.
- Or do we need to make a document language change overwrite the direct cell
formatting?


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=96000
[Bug 96000] [META] Spelling and grammar checking bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=119352
[Bug 119352] [META] Language issues
-- 
You are receiving this mail because:
You are the assignee for the bug.