[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-11-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

m.a.riosv  changed:

   What|Removed |Added

 CC||ville...@t-online.de

--- Comment #33 from m.a.riosv  ---
*** Bug 158254 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-11-15 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Eike Rathke  changed:

   What|Removed |Added

 CC||lp.allar...@gmail.com

--- Comment #32 from Eike Rathke  ---
*** Bug 158220 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-11-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

 CC||sonick@gmail.com

--- Comment #31 from Stéphane Guillou (stragu) 
 ---
*** Bug 158106 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-10-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Mike Kaganski  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=15
   ||7902

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-10-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #30 from LeroyG  ---
(In reply to robert from comment #26)
> 
> 65 CC's on, from your own website, some 200,000,000 users? My 0.01% was
> still way too optimistic!!!

That "only" 65 users are involved in this question means that a lot of people
are interested. There are many who don't bother to add their duplicate comment,
and many more that don't know how to do it (or that it is possible to comment).
Those who participate here are only the tip of the iceberg.

Please, someone hide my comment as obsolete (as per this question). Thanks.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #29 from Mike Kaganski  ---
(In reply to robert from comment #28)
> Even if those 66 comments represent 66,000 users, it's still only 0.033% of
> users asking for it.

You seem to throw numbers randomly. Are you a bot? or just a troll? Both
plausible, given your comments (which make no sense). 66? Comments? where was
that number from (we only mentioned *65*)? where were "comments" mentioned (we
only mentioned CCed *users*)?

> And you didn't answer the far more fundamental question, why dump this
> anagram-of-this on ordinary users, when there's the paid-for supported
> version?

There is *no* "paid-for" version, which would include even a single feature not
available for everyone. LibreOffice is FLOSS.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #28 from rob...@prino.org ---
(In reply to Mike Kaganski from comment #27)
> (In reply to robert from comment #26)
> > 65 CC's on, from your own website, some 200,000,000 users? My 0.01% was
> > still way too optimistic!!!
> 
> Lol. So here we only have 16 users in CC list. Should we disregard this?

Even if those 66 comments represent 66,000 users, it's still only 0.033% of
users asking for it.

And you didn't answer the far more fundamental question, why dump this
anagram-of-this on ordinary users, when there's the paid-for supported version?

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #27 from Mike Kaganski  ---
(In reply to robert from comment #26)
> 65 CC's on, from your own website, some 200,000,000 users? My 0.01% was
> still way too optimistic!!!

Lol. So here we only have 16 users in CC list. Should we disregard this?

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #26 from rob...@prino.org ---
(In reply to Mike Kaganski from comment #24)
> > Who asked for 16K rows, the 0.01% of users?
> 
> tdf#50916 has multiple duplicates and 65 people in CC list. You rarely find
> a request with that many interested people. Thinking that you know what
> people need most, based on your little use case; and that developers do not
> see the picture much better, just because they constantly face the flow of
> requests from real users having *different* needs, in another way to show
> how you disregard anyone but yourself.

65 CC's on, from your own website, some 200,000,000 users? My 0.01% was still
way too optimistic!!!

Why the flipping 'ell didn't you add this "very important" feature to the
"Professional Version", instead of saddling up us "normal" uses with something
we will never ever use?

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #25 from LeroyG  ---
It seems good to me to have "steps" for Ctrl + A. But the selection range must
be shown.

Otherwise, I will consider to add a notification like the one when we paste
content in cells already occupied (with [ ] Don't remember me again about
this).

There are more than three questions about this issue.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #24 from Mike Kaganski  ---
(In reply to V Stuart Foote from comment #2)
> Actually believe this is correct behavior.

(In reply to V Stuart Foote from comment #10)
> Pretty clearly the move to 16K columns necessitated this shift.
> ...
> This is not a bug, nor a regression, as implementing 16K columns
> necessitates retraining to keep sheet manipulations efficient.

This issue is definitely a bug; what you describe about 16K is just something
technical, some implementation detail, that is not the only one way to
implement the feature, and so is not a justification for this to be defended.
Other (even if better) ways to do the same is also not a justification to keep
direct formatting *feature* broken. LibreOffice must help style users to be
most productive, but not at the cost of making basic users (relying on direct
formatting) suffer.

(In reply to robert from comment #20)
> And as for "those changes are required because we now have sheets with a
> billion cells?" and the general "we know better" attitude from the
> developers?

Sometimes it's best to keep silent, and not write things you have no clue
about, but which show how arrogant you are toward some group ("developers" in
your case), showing that you are ready to regard some people based on their
"group". Indeed, the developers appearing here - namely, the lead Calc
developer, erAck, told several times - in comment 5 ("In this case even
completely unused columns would have to be allocated to be able to attribute
all 16k columns ... [which] is expected in _this_ case here"); comment 13 and
comment 15 (discussing how to actually solve this) - that this *is* an issue,
and that it needs a fix. I myself say the same. If there are opposite opinions,
it is normal (for sane people, at least - sane people do not insist that there
only exist one true opinion, which is indeed theirs); it is the discussion that
is expected to take place in bug reports.

> Who asked for 16K rows, the 0.01% of users?

tdf#50916 has multiple duplicates and 65 people in CC list. You rarely find a
request with that many interested people. Thinking that you know what people
need most, based on your little use case; and that developers do not see the
picture much better, just because they constantly face the flow of requests
from real users having *different* needs, in another way to show how you
disregard anyone but yourself.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Mike Kaganski  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=14
   ||4521

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Mike Kaganski  changed:

   What|Removed |Added

 CC||amrams...@gmail.com

--- Comment #23 from Mike Kaganski  ---
*** Bug 157084 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-09-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Mike Kaganski  changed:

   What|Removed |Added

 CC||roque.b...@mail.com

--- Comment #22 from Mike Kaganski  ---
*** Bug 156826 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-08-31 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=15
   ||6793

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-08-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

BogdanB  changed:

   What|Removed |Added

 CC||buzea.bog...@libreoffice.or
   ||g
 Blocks||108252


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108252
[Bug 108252] [META] Cell-related bugs and enhancements (including formatting)
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-08-25 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Kohei Yoshida  changed:

   What|Removed |Added

 Blocks|145509  |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=145509
[Bug 145509] [META] Bugs Related to Liborcus
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

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

--- Comment #21 from Heiko Tietze  ---
(In reply to robert from comment #20)
> Who asked for 16K rows, the 0.01% of users?
Large sheets is a valid requirement, see
https://design.blog.documentfoundation.org/2021/10/18/results-from-the-survey-about-libreoffice-calc/.
 

(In reply to robert from comment #20)
> The problem described in bug 155395 is completely different...
Yes, it's about direct formatting for parts of a cell while we discuss here the
scope of ctrl+A (whether it affect cells with content or any cell).

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-05-19 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #20 from rob...@prino.org ---
The problem described in
https://bugs.documentfoundation.org/show_bug.cgi?id=155395 is completely
different, in the case there the formatting of a single cell is completely
screwed up, the first 6 characters remain what they were, the last ones are
changed to the new font. 

And as for "those changes are required because we now have sheets with a
billion cells?" and the general "we know better" attitude from the developers?
Who asked for 16K rows, the 0.01% of users?

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-05-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

TBeholder  changed:

   What|Removed |Added

 CC||turbobehol...@mail.ru

--- Comment #19 from TBeholder  ---
(In reply to defector from comment #0)
> Then you want
> to format all the cells. Select all cells and press Ctrl + 1 and format the
> cells: 
Obviously it’s a bug, but… I know some people try to paint on spreadsheets
manually like this, but you know there are editable styles, right?

(In reply to ady from comment #11)
> other complains), the response would also be about a UX decision, with a
> relevant comment about workarounds ("modify the default cell style").
It’s not a workaround, it’s the primary tool for this purpose. I mean, is it
not obvious that ability to apply the same formatting to many elements is the
main reason for having styles to begin with?

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-05-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

m.a.riosv  changed:

   What|Removed |Added

 CC||rob...@prino.org

--- Comment #18 from m.a.riosv  ---
*** Bug 155395 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-05-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=15
   ||5368

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-05-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #17 from defector  ---
In the meantime I have updated LibreOffice for Windows to version 7.5.3.2.
Unfortunately, this did not change the behavior described.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-05-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

m.a.riosv  changed:

   What|Removed |Added

 CC||flywi...@gmail.com

--- Comment #16 from m.a.riosv  ---
*** Bug 155180 has been marked as a duplicate of this bug. ***

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #15 from Eike Rathke  ---
I wasn't talking of the Default cell style. IIRC there's some kind of "default
column" for all columns that are not yet allocated. For that default column the
attribution would need to change for Ctrl+A.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

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

Heiko Tietze  changed:

   What|Removed |Added

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

--- Comment #14 from Heiko Tietze  ---
(In reply to Eike Rathke from comment #13)
> ... default attribution item set that is also used when new columns are
> actually added to contain data needs to be populated as well...

I struggle to follow. The default attributes (Default Cell Style) are not
changed, the request is to apply direct formatting to empty cells.

Tested now myself and I can apply the background color or the text alignment to
empty cells. Please check again.

If there is an issue we should treat it as bug.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

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

--- Comment #13 from Eike Rathke  ---
The proper solution for the Ctrl+A All special case could probably be that the
default attribution item set that is also used when new columns are actually
added to contain data needs to be populated as well, not only for allocated
columns. Bear in mind though that changing attribution of just one single cell
somewhere then will have to allocate all columns up to that cell's column as
there can be no gaps.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

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

Buovjaga  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=15
   ||4114

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-02-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #12 from Heiko Tietze  ---
Let's focus on 'apply formatting to all selected cells', and I agree that empty
but selected cells should become formatted as well. If this has been done
intentionally we better allow to interrupt lengthy operations than blocking /
hindering it (see bug 150239).

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-02-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #11 from ady  ---
(In reply to V Stuart Foote from comment #10)
> As to some edit engine cyclic application of the +A selection--seems
> overly complex, and you'd never be sure what you'd selected (you can't see
> the last cell selected).

FWIW, having "steps" for +A is what Excel already does (see bug 131916
comment 14 regarding [CTRL]+[A]). Such behavior does not contradict whichever
other decision about which action is applied to which ranges. In fact, by
imitating Excel in this regard the "mistake" of users applying some attribute
to the entire worksheet is reduced, while letting users _know_ that they are
applying it just to the selected area. IOW, it brings mostly pros, especially
in comparison to the current behavior.

Regarding not seeing the last cell, I don't understand why that is relevant in
any case. At any rate, users get "surprised" by the result. In some cases, it
is a welcome result, whereas in others, it might be an eventual "why is this
cell not formatted as I expected?".

I understand the performance issue. I happen to disagree that _forcing_
unexpected results on users is the best that can be done. When users complain
about unexpected results, they receive some explanation, or at least a hint,
and NAB. I think that allowing "steps" in +A behavior would reduce the
amount of "surprises". If then a user complains about performance when
selecting the entire worksheet (which would replace the other complains), the
response would also be about a UX decision, with a relevant comment about
workarounds ("modify the default cell style").

I am not a developer. My comments come from a user's POV only. It seems strange
to _silently force_ users (against the behavior they are used to and expect,
from prior experience), when there might be alternatives, especially when the
product is named _libre_ :p).

IDK whether having an option to "allow" applying attributes to an entire
worksheet is an adequate solution. I do know that having "steps" for +A
should be welcome (because, in comparison to the current status, it brings more
freedom and efficiency). Whichever the case, until users are _somehow_
"allowed" to see their actions applied to the selected range of cells (with
whichever pros and cons, as with anything), these types of bug reports will
keep showing up, simply because the behavior is unexpected by users,
independently of whichever logical and justified reasoning developers could
present.

Let me put it this way. Current answer: "You cannot do that, even when you
expected that result". Alternative answer: "You pressed +A three times in
order to select the entire worksheet and the reaction from Calc is not
absolutely immediate? Well, you have the choice to select only the relevant
areas of your worksheet, and work faster; or you could change the default cell
style; but if you anyway decide to select the entire worksheet with 10^6
columns (or whatever), please be patient".

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-02-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

V Stuart Foote  changed:

   What|Removed |Added

 Blocks||145509

--- Comment #10 from V Stuart Foote  ---
Pretty clearly the move to 16K columns necessitated this shift.

Past practice of applying per cell attribute to a +A selection of the
entire sheet instantly became non-performant with sheets of a billion cells.

For acceptable performance the *reasonable* solution of ShrinkToDataArea()
requires minor adjustment to work flows, acceptable UX.

As noted, styling of sheet cells is the only way to efficiently apply
formatting to entire sheets--not selecting all cells on a sheet and applying
DF.

This is not a bug, nor a regression, as implementing 16K columns necessitates
retraining to keep sheet manipulations efficient.

As to some edit engine cyclic application of the +A selection--seems
overly complex, and you'd never be sure what you'd selected (you can't see the
last cell selected).

No, seems best to just accept that the +A selection will encompass only
the sheets active cells as implemented for bug 147842 keeping the UX for Calc
performant.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=145509
[Bug 145509] [META] Bugs Related to Liborcus
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-02-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

--- Comment #9 from ady  ---
(In reply to ady from comment #6)
> FWIW and only as a side note, see bug 131916 comment 14 (and/or the whole
> ticket) regarding the use of CTRL+* (in numeric pad) and CTRL+A in Calc (and
> in Excel).

@UX team,

When users apply an attribute to a selected range of cells, they are usually
expecting for the attribute to be applied to all the range of the selected
cells. If that's _all_ cells, then that should be it.

If devs are afraid of users misusing any selection method, the way it should be
considered should be to affect the resulting selection, not the attribute not
being applied to part of the selected cells.

For example, as mentioned in bug 131916 comment 14, if users use [CTRL]+[A],
the initial selection should cover the immediate active range of cells. The
second immediate consecutive [CTRL]+[A] should select the entire active range
of cells. Only the third [CTRL]+[A] would select the entire worksheet. This of
course should depend on whether a surrounding active range exists, and/or an
entire active range of cells exists; when either of them is not relevant, the
next "step" of the selection takes over.

So, for instance, if the worksheet is entirely blank, the first [CTRL]+[A]
immediately selects the entire worksheet.

Whichever the case, when a selection of cells is performed, the attributes or
actions that follow the selection should apply to the entire selected range.

IOW, please don't overprotect users from their own actions. Preventing users
from performing expected actions and receiving expected results should not be
overpowered by misused or "by-mistake" selections/actions. Help users, but
please don't "block" users from performing the intended action. Allow "steps"
for [CTRL]+[A] (for example) is a much better approach than silently affecting
a different range of cells than what was selected.

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

[Libreoffice-bugs] [Bug 153527] LibreOffice 7.5 Calc: unable to apply formatting to all cells in spreadsheet

2023-02-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=153527

Stéphane Guillou (stragu)  changed:

   What|Removed |Added

   Keywords|bibisectRequest |bibisected, bisected,
   ||needsUXEval
 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org,
   ||noelgran...@gmail.com,
   ||stephane.guillou@libreoffic
   ||e.org
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=14
   ||7842
Summary|LibreOffice 7.5 Calc|LibreOffice 7.5 Calc:
   |Windows 11 22H2 Failed to   |unable to apply formatting
   |format entire spreadsheet   |to all cells in spreadsheet

--- Comment #8 from Stéphane Guillou (stragu) 
 ---
bibisected with linux-64-7.5 repo to first bad commit
9bbe835ae76014760a6abfe10b7e50874a5ea2fa which points to core commit:

commit  ac859a4c6a7fce4efee9cdd45821a0c9e40e9e9a
author  Noel Grandin  Mon Oct 17 16:36:23
2022 +0200
committer   Noel Grandin  Tue Oct 18
09:35:01 2022 +0200
tree6e7d452d038e92eb122ab3f3d94304bf43fde71e
parent  aa70820a79152830a32070eb722311b8531945a4
tdf#147842 shrink selection to data area when applying to entire sheet
This takes the time to apply the formating from "who knows how long" to about
500ms on my machine.
Change-Id: I202d023c58ea191bf080ef3a85068e8acab52dec
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/141463

So the change was definitely on purpose, and in response to a performance issue
reported in bug 147842.

Bringing UX into the discussion too, regarding the desirability of applying
some formatting to all cells preemptively.

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