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.*
*
*
*You've never seen an accountant who commits suicide from the tower? This
is a good occasion!*
Thanks for your attention, waiting for some user can verify the same
problem.
--
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
Context
- [libreoffice-users] LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA · Michele contabilmenteAG
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.