Fwd: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA

---------- Forwarded message ----------
From: Michele contabilmenteAG <contabilmenteag.net@gmail.com>
Date: 2013/8/29
Subject: Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build
ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
To: MiguelAngel <mariosv@miguelangel.mobi>


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 ....)

:-)

Thanks a lot.
Best Regards

Michele



2013/8/29 MiguelAngel <mariosv@miguelangel.mobi>

> El 29/08/13 10:38, Michele contabilmenteAG escribió:
>
>  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 .... :-) ....)
> >
> > ------------------------------**--------------------
> > ------------------------------**------------------
> > Please : Some Notes & details for the use of the file:
> >
> > It is a complete accounting double entry for businesses.
> >
> > The worksheets are to be observed:
> >
> > "PROSPETTO CODICI" (which contains 2 PivotTable): one for a "CODICI
> > DARE" and one for "CODICI AVERE"
> >
> > The origin of the data is in the worksheet "PRIMA NOTA".
> >
> > activity 1) If you update the PivotTable "CODICI AVERE" (red numbers),
> > updating the Codes field disappears and the pivot table does not work.
> >
> > Task 2) If you ask in the Pivot table detail of a code (double "click"
> > on an amount in AVERE column or DARE column) opens a worksheet regularly
> > with details.
> >
> > If you make the task 1) or 2) in the worksheet named "BILANCIO CE"
> > columns C (visible column) and F (hidden column) where the functions are
> > written in the cells GETPIVOTDATA refer to 2 Pivot Tables do not contain
> > more results GETPIVOTDATA = function no longer works.
> >
> > Even rewriting the Pivot Tables and rewriting the GETPIVOTDATA function
> > in those cells (the cells before deleting), the function from the
> > results that more has to give. And then the balance is no longer results
> > ....
> > Oh My God What a disaster!
> >
> > Best Regards.
> >
> > Michele Ras
> ....
>
> 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.
>
>
> --
> To unsubscribe e-mail to: 
> users+unsubscribe@global.**libreoffice.org<users%2Bunsubscribe@global.libreoffice.org>
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette <http://wiki.documentfoundation.org/Netiquette>
> List archive: 
> http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> All messages sent to this list will be publicly archived and cannot be
> deleted


-- 

http://contabilmenteag.wix.com/contabilmenteag-net
contabilmenteAG.net@gmail.com
contabilmenteAG@hotmail.it
Ras Michele Perito Agrario
Salita S.Barnaba 24d/18 16136 Genova Ge
Tel./Fax.:  010 213059
Tel.Mobile:3201107102

**** Riservatezza / Confidentiality **** In ottemperanza al D.Lgs. n. 196
del 30/6/2003 in materia di protezione dei dati personali, le informazioni
contenute in questo messaggio sono strettamente riservate ed esclusivamente
indirizzate al destinatario indicato (oppure alla persona responsabile di
rimetterlo al destinatario). Vogliate tener presente che qualsiasi uso,
riproduzione o divulgazione di questo messaggio è vietato. Nel caso in cui
aveste ricevuto questo messaggio per errore, vogliate cortesemente
avvertire il mittente e distruggere il presente messaggio.
According to Italian law D.Lgs. 196/2003 concerning privacy, if you are not
the addressee (or responsible for delivery of the message to such person)
you are hereby notified that any disclosure, reproduction, distribution or
other dissemination or use of this communication is strictly prohibited



-- 

http://contabilmenteag.wix.com/contabilmenteag-net
contabilmenteAG.net@gmail.com
contabilmenteAG@hotmail.it
Ras Michele Perito Agrario
Salita S.Barnaba 24d/18 16136 Genova Ge
Tel./Fax.:  010 213059
Tel.Mobile:3201107102

**** Riservatezza / Confidentiality **** In ottemperanza al D.Lgs. n. 196
del 30/6/2003 in materia di protezione dei dati personali, le informazioni
contenute in questo messaggio sono strettamente riservate ed esclusivamente
indirizzate al destinatario indicato (oppure alla persona responsabile di
rimetterlo al destinatario). Vogliate tener presente che qualsiasi uso,
riproduzione o divulgazione di questo messaggio è vietato. Nel caso in cui
aveste ricevuto questo messaggio per errore, vogliate cortesemente
avvertire il mittente e distruggere il presente messaggio.
According to Italian law D.Lgs. 196/2003 concerning privacy, if you are not
the addressee (or responsible for delivery of the message to such person)
you are hereby notified that any disclosure, reproduction, distribution or
other dissemination or use of this communication is strictly prohibited

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted