Ask Your Question

Wololo's profile - activity

2018-08-25 10:20:40 +0200 received badge  Notable Question (source)
2018-08-25 10:20:40 +0200 received badge  Famous Question (source)
2017-12-06 09:41:07 +0200 answered a question Query about pivotchart feature

Hi, the pivot chart feature has been implemented within the version 5.4 of Libreoffice, see https://www.libreoffice.org/

2017-11-22 17:08:53 +0200 received badge  Notable Question (source)
2017-11-22 17:08:02 +0200 answered a question Pivot-Tabelle - Details entnehmen

Hallo zusammen, ich verwende diese alte Frage um sie ein bisschen zu erweitern. Meine Erfahrung ist, dass diese "drill

2017-11-09 09:21:45 +0200 received badge  Popular Question (source)
2017-09-11 14:58:20 +0200 edited question [LO Pivot table] Drill-down (Enable drill to details) retrieves more lines than the aggregated amount.

[LO Pivot table] Drill-down (Enable drill to details) retrieves more lines than the aggregated amount. Hi, I have a sim

2017-09-11 14:57:59 +0200 edited question [LO Pivot table] Drill-down (Enable drill to details) retrieves more lines than the aggregated amount.

[LO Pivot table] Drill-down (Enable drill to details) retrieves more lines than the aggregated amount. Hi, I have a sim

2017-09-11 14:46:54 +0200 asked a question [LO Pivot table] Drill-down (Enable drill to details) retrieves more lines than the aggregated amount.

[LO Pivot table] Drill-down (Enable drill to details) retrieves more lines than the aggregated amount. Hi, I have a sim

2017-09-07 10:38:43 +0200 received badge  Popular Question (source)
2017-09-07 10:11:17 +0200 answered a question daily values by column not recognized as a date

Thanks pierre-yves samyn for looking on my problem. From your screenshot i don't see that you reproduced the issue. The

2017-09-06 16:37:42 +0200 edited answer Permanently formatting pivot tables?

my workaround : Apply the wished formatting to the source data, not to the pivot table. Example, I apply the formattin

2017-09-06 16:37:15 +0200 answered a question Permanently formatting pivot tables?

my workaround : Apply the wished formatting to the source data, not to the pivot table. Example, I apply the formattin

2017-09-06 16:26:16 +0200 asked a question daily values by column not recognized as a date

daily values by column not recognized as a date Hi, I have created a pivot table in LO calc. My source data is in the s

2017-08-28 16:05:45 +0200 commented answer LO Calc | pivot table | ability to group daily values by month, year...

thank you very much, i had'nt found it on my own.

2017-08-28 15:50:40 +0200 received badge  Popular Question (source)
2017-08-27 22:55:42 +0200 answered a question automatic update/refresh of all pivot tables at file opening: how?

thank you @https://ask.libreoffice.org/en/users/15459/pierre-yves-samyn/ Is there any option to solve this question wit

2017-08-27 22:54:23 +0200 received badge  Famous Question (source)
2017-08-27 22:54:23 +0200 received badge  Notable Question (source)
2017-08-27 22:53:45 +0200 edited question LO Calc | pivot table | ability to group daily values by month, year...

LO Calc | pivot table | ability to group daily values by month, year... Hi, I know from Office Excel 2007 the ability t

2017-08-27 22:51:21 +0200 asked a question LO Calc | pivot table | ability to group daily values by month, year...

LO Calc | pivot table | ability to group daily values by month, year... Hi, I know from Office Excel 2007 the ability t

2017-06-07 19:31:49 +0200 received badge  Notable Question (source)
2017-06-07 19:31:49 +0200 received badge  Famous Question (source)
2016-12-10 23:30:23 +0200 received badge  Popular Question (source)
2016-12-10 23:24:58 +0200 received badge  Popular Question (source)
2016-11-17 00:51:51 +0200 commented answer how to drill down from a pivot table in LibreOffice Calc

Thanks very much ! It is quite easy indeed :) I am using a French version, and the translation was not obvious understandable to me: "Enable drill to details" > "Activer le rappel des éléments"

2016-11-17 00:44:54 +0200 received badge  Enthusiast
2016-11-16 01:41:45 +0200 asked a question how to drill down from a pivot table in LibreOffice Calc

Hi,

I'm looking for the "drill-down" functionality within an existing pivot table in LibreOffice Calc. Does it exist ? If not, is there any workaround ?

I describe this functionality as follows (sorry for the excel screenshots)

  1. the user is in a pivot table, in this example on the value of Region "East" for the StartYr" 2014; He double-clicks on this cell

image description
2. the double-click opens a new sheet within the file and shows the detailed data, which summed up give the value of 15 customers for this region and Year. image description

Thanks very much in advance.

2016-11-07 12:29:43 +0200 received badge  Editor (source)
2016-11-07 12:28:21 +0200 asked a question automatic update/refresh of all pivot tables at file opening: how?

Hi, I have one LO calc file with severall sheets:

  1. one sheet with my "transactions" : a few columns and many rows. The data is "referenced" within a named range to be used in several pivot tables, so that the pivots have no issues if i add new records.
  2. 16 other sheets having different pivot tables, all analysing data of the same unique named range from point 1.

I would like that all these pivot tables automatically refresh when I open the file, so that I don't have to go manually in each single pivot table to refresh the data (Right-click > Refresh). in MS Excel 2007 I can tick a check box in each single pivot table properties for this auto-update at file opening.

See this screenshot from Excel which I would like to find in LibreOffice:

image description

Has anyone any advices? Thanks in advance

Libre Office Calc 5.1.4.2