[Libreoffice-ux-advise] [Bug 89530] CALC UI: add a status list of Pivot Tables to select for update/go to.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=89530

--- Comment #8 from m.a.riosv  ---
First, thanks by talk obout on the desing/UX meeting.

comment#7
I was the one who answered in the thread of Ask., taken the answer from the
AOo-en forum.

The new ticket IHMO doesn't deal the major issue, to locate every PT and go one
by one for updating.

For example recently was implemented Pivot Charts having the same issue, good
improvement but...

Really curious, Writer has an Update all while Calc not.

Sometimes I think that we lose ourselves in trifles and forget important
things.

An Update all would be a warranty to be confident on the results, even hard
recalc it's only on a shortcut, unknown to many users.

It's possible to do it with macros (I don't know why they are called so), sure,
but it is not the right way.

In any case better forget it and lets every one solve their matters.

Meanwhile, we wonder why some much esteemed people resign?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 89530] CALC UI: add a status list of Pivot Tables to select for update/go to.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=89530

Heiko Tietze  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=89
   ||531
 Blocks||103381
 Resolution|--- |WONTFIX

--- Comment #7 from Heiko Tietze  ---
We talked about this request today in the design/UX meeting. Updating the pivot
table may take a while on slow systems or in case of many data. So the
automatic function is not good, though Excel has it optionally (the request is
in bug 61793).
While 'Refresh All' is simple to introduce it doesn't solve the actual problem
that you a) likely don't want to work on pivot tables that are not up-to-date
and b) have no feedback that a refresh is needed. The recommendation is to show
the status clearly, ideally with a progress and means to stop the processing
that both are not possible yet (new ticket bug 109521).
Setting this ticket to WONTFIX as the suggested solution is suboptimal. You
could do the trick with a macro, starting with advices from
https://ask.libreoffice.org/en/question/46939/how-can-i-make-a-simple-macro-to-update-a-pivot-table-and-then-create-a-click-button/.
Feel free to ask if you need help with that.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103381
[Bug 103381] [META] Pivot table (aka Data Pilot) bugs and enhancements
-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 89530] CALC UI: add a status list of Pivot Tables to select for update/go to.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=89530

--- Comment #6 from m.a.riosv  ---
When you have several pivot tables on different sheets, you need to go one by
one to update and you have not a way on the interface to locate them. Even the
navigator don't show the pivot tables.

Maybe there are a mistake thinking pivot tables are always alone on one sheet,
and not, they can be located anywhere, which is very usefull, making difficult
to locate them.

If at least there was an option to Recalculate and update everything on the
file:
Hard recalc
Pivot tables (pivot Charts)
Update links
Update dabase ranges.

Sorry but I think UX matter it's secondary here.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 89530] CALC UI: add a status list of Pivot Tables to select for update/go to.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=89530

Heiko Tietze  changed:

   What|Removed |Added

 CC||qui...@gmail.com

--- Comment #5 from Heiko Tietze  ---
The use case is to refresh pivot tables in the active sheet as well all other.
Your suggested solution is to add a dedicated section in the status bar with
some special interactions. I don't think a control in the status bar makes
sense just because there is enough space. And as raal pointed out we do have a
list of sheets in the Navigator.

Anyway, the 'Refresh All' idea sounds not too reasonable to me. What you
actually want to achieve is an always up-to-date pivot table. So my suggestion
is to just always refresh when you enter the sheet. @UX: what speaks against
this solution, @Tomaz: guess it's not a big deal to implement.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 89530] CALC UI: add a status list of Pivot Tables to select for update/go to.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=89530

Heiko Tietze  changed:

   What|Removed |Added

  Component|LibreOffice |Calc

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 89530] CALC UI: add a status list of Pivot Tables to select for update/go to.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=89530

Beluga todven...@suomi24.fi changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org,
   ||todven...@suomi24.fi
  Component|Calc|ux-advise
 Ever confirmed|0   |1

--- Comment #3 from Beluga todven...@suomi24.fi ---
I give this to the design team.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise