Hi :) This question has already gone to the Users List so i am sure it will be answered fairly quickly there.
I am just wondering if anyone has dealt with Pivot Tables recently and has a quick easy answer. I vaguely remember this functionality changed names a year or so ago. I think the guides got updated https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide but maybe not the in-built help. Now the team has so many new people is there a chance it now has the capacity to proof-read and update the in-built help? Sorry so many different topics in just 1 email! Apols and regards from Tom :) ________________________________ From: Michele contabilmenteAG <[email protected]> To: [email protected] Sent: Wednesday, 28 August 2013, 9:46 Subject: [libreoffice-users] LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA 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 [email protected] [email protected] 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: [email protected] 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 -- To unsubscribe e-mail to: [email protected] 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/documentation/ All messages sent to this list will be publicly archived and cannot be deleted
