LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA

users
#1

Good Morning All.

Some users have encountered problems or technical execution of the
Function: GETPIVOTDATA?

Application: CALC

Operation: Function GETPIVOTDATA

Structure Function:
Field 1: Database area = By entering the data (also referred to as a name),
the function ignores them;
Field 2: Pivot Table reference = entering the data (also referred to as a
name), the function does not recognize the address;
Field 3: cell index = on the data, but the function does not give the
correct result.

Reason operation: Some data of the Data Base Pivot table source of origin
have changed

Structure of the worksheet and what happens:
Two Pivot Tables data is transferred on 2 different columns of a worksheet.
The function is not in any of the results from two columns of data
the response in the cells is # REF!

*I specify that it is important: the worksheet in question is the
accounting balance sheet of a company.*

#2

Hi Michele,

can you attach a sample file?

No possible do it from your email program, but answering through mail list
you can.

#3

Dear Marlosv

thanks for the reply. Enclosed is sending the file from these problems.

I look forward to technical comments from the thing.

(I have not yet thrown from my building, but customers may feel happy to
push me from the brink, if he does not finish the job .... :slight_smile: ....)

#4

Ciao Michele,

your attachment has not reached us.

To attach a file you can:
- register to nabble http://nabble.documentfoundation.org and then going to
the right post (mailing list -> thread -> post; you could find the link in
this post's footer); in Nabble's editor there is a "More" button by clicking
on it you can find "Upload a file";
- use your Dropbox public directory or link the file from the single file
share function and give us the simple file link;
- use others public web places and give us the simple file link.

Hope this help!

In addition: have you tried opening and use the sheet on the just released
4.1.1 LibreOffice version? You get the same behavior?
http://www.libreoffice.org/download

Have a nice day,

Carlo

#5

Hi :slight_smile:
Yes, as Carlo says. You can also follow the Nabble links in Carlo's or my
message to get to the exactly tight thread.

Of course security experts say we shouldn't just click on any links in any
emails or on unknown websites and should really navigate a safe known path
instead.
Regards from
Tom :slight_smile:

#6

....

Hi Michele.

1) Seems the row field is missing, WHY? I don't know, maybe a bug. Edit the PT add the field "Cod. R/D" to row fields and PT works again.

2) Calc have been a deep rework on the core for 4.1,
seems that the second form of GETPIVOTDATA, what you are using doesn't work, but the first form works for me:
in cell BILANCIOCEE.C10:
=GETPIVOTDATA("DARE";'PROSPETTO CODICI'.$A$3;'PROSPETTO CODICI'.$A$3;$A10).

Saluti.
Miguel Ángel.

#7

Hola Miguel Angel,

1) true: it's a bug and I know, it is sufficient to re-enter the field of R
/ D in the PT and this works. But I certainly can not offer people to
download this program that works well. Although it is free, the user is in
trouble. Is necessary to fix that bug.

2) cells in columns C and F that you see in the file that I sent, retain
the right results from the previous version to 4.1.0.4.
if you change a code C / R or R / D in the data base (worksheet
"PRIMANOTA") and then launches the update of the PT in the worksheet"
PROSPETTO CODICI "then the worksheet " BILANCIO CE " the GETPIVOTDATA
function no longer works and not by right results.

I have verified, however, that this bug happens using UBUNTU and also going
on Windows7.
Using XP does not seem to give this problem.

Let's see if there are further developments to the question (I hope before
my clients make me commit suicide out of the window ....)

:slight_smile:

Thanks a lot.
Best Regards

Michele