Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
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 2013/8/28 mariosv mari...@miguelangel.mobi Hi Michele, can you attach a sample file? No possible do it from your email program, but answering through mail list you can. -- View this message in context: http://nabble.documentfoundation.org/LIBREOFFICE-Version-4-1-0-4-Build-ID-410m0-Build-4-ALL-S-o-BUG-FUNCTION-GETPIVOTDATA-tp4071995p4072105.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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 -- http://contabilmenteag.wix.com/contabilmenteag-net contabilmenteag@gmail.com contabilment...@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+unsubscr...@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
[libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
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 -- ing. Carlo Strata - via Botticelli 1/4 30031 Dolo - VE Italia - Italy - tel./fax +39.041.822.0665 cell. +39.347.85.69.824 Skype carlo.strata Google carlo.strata.69 - carlo.str...@tiscali.it PEC: carlo.str...@ingpec.eu - -- ing. Carlo Strata - via Botticelli 1/4 30031 Dolo - VE Italia - Italy - tel./fax +39.041.822.0665 cell. +39.347.85.69.824 skype carlo.strata - carlo.str...@tiscali.it PEC: carlo.str...@ingpec.eu -- View this message in context: http://nabble.documentfoundation.org/LIBREOFFICE-Version-4-1-0-4-Build-ID-410m0-Build-4-ALL-S-o-BUG-FUNCTION-GETPIVOTDATA-tp4071995p4072180.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
Hi :) 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 :) -- View this message in context: http://nabble.documentfoundation.org/LIBREOFFICE-Version-4-1-0-4-Build-ID-410m0-Build-4-ALL-S-o-BUG-FUNCTION-GETPIVOTDATA-tp4071995p4072195.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
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+unsubscr...@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
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@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 mari...@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 mari...@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.orgusers%2bunsubscr...@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@gmail.com contabilment...@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
[libreoffice-users] Re: LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG FUNCTION GETPIVOTDATA
Hi Michele, can you attach a sample file? No possible do it from your email program, but answering through mail list you can. -- View this message in context: http://nabble.documentfoundation.org/LIBREOFFICE-Version-4-1-0-4-Build-ID-410m0-Build-4-ALL-S-o-BUG-FUNCTION-GETPIVOTDATA-tp4071995p4072105.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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