[libreoffice-users] LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function
Anomaly discovered in *versions 4.2.8 and 4.4.6* - VLOOKUP function Good morning, . LibreOfficeCalc use on a package of administration that contains many features that interact with Pivot Tables A very used is VLOOKUP. The package works very well and there are no problems on the LO version 4.0.6 both Windows and Linux (Ubuntu 12.04 LTS, 4.14 32bit or 64bit). In this version of the function's result it is right. THE versions 4.2.8 and 4.4.6 the VLOOKUP function from incorrect result. In particular, in the spreadsheet attached "PROVA SU VERS 446 - CONTABILMENTE": - In Sheet "Registro Mastri' function is in cell B4: = VLOOKUP (+ B6; PianocontiCE.$A$3.$B$1060;2) the function result is # N / A correct resultate is: "CONTO TRANSITORIO PAGHE LL.DD." I checked several times. The function syntax is correct. The reference of the search range is correct; The search key is correct; The index of the data result is correct. My interpretation is that in later versions to 4.0.6 LO does not recognize the data contained in a PivotTable (Ie the value of Cod. C / R in the example = 3359) This might be so? I kindly ask the technicians LO to verify that this bug is really very important because it undermines the proper functioning of the package (which is distributed free to download). I look forward to answers. Best regards. Michele Ras -- 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] LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function
Anomaly discovered in *versions 4.2.8 and 4.4.6* - VLOOKUP function Good morning, . LibreOfficeCalc use on a package of administration that contains many features that interact with Pivot Tables A very used is VLOOKUP. The package works very well and there are no problems on the LO version 4.0.6 both Windows and Linux (Ubuntu 12.04 LTS, 4.14 32bit or 64bit). In this version of the function's result it is right. THE versions 4.2.8 and 4.4.6 the VLOOKUP function from incorrect result. In particular, in the spreadsheet attached "PROVA SU VERS 446 - CONTABILMENTE": - In Sheet "Registro Mastri' function is in cell B4: = VLOOKUP (+ B6; PianocontiCE.$A$3.$B$1060;2) the function result is # N / A correct resultate is: "CONTO TRANSITORIO PAGHE LL.DD." I checked several times. The function syntax is correct. The reference of the search range is correct; The search key is correct; The index of the data result is correct. My interpretation is that in later versions to 4.0.6 LO does not recognize the data contained in a PivotTable (Ie the value of Cod. C / R in the example = 3359) This might be so? I kindly ask the technicians LO to verify that this bug is really very important because it undermines the proper functioning of the package (which is distributed free to download). I look forward to answers. Best regards. Michele Ras -- 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
Re: [libreoffice-users] Re: LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function
Thanks, I solved the problem by entering the 4th argument to 0. The solution, as I look for now is effective. cordial greetings Michele Ras 2015-11-23 18:00 GMT+01:00 Andreas Säger <ville...@t-online.de>: > Am 23.11.2015 um 16:33 schrieb Michele contabilmenteAG: > > Anomaly discovered in *versions 4.2.8 and 4.4.6* - > > VLOOKUP function > > > > menu:Tools>Options>Calc>Calculation > Regular expression = OFF > Match whole cell = ON > > You leave out the 4th argument which means it defaults to 1. You want 0. > VLOOKUP(x;range;2;0) > > > > -- > 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] LibreOffice ver 4.1 - GETPIVOTDATA function not working
Dear Miguel Angel Dear Mario and Tom I installed the release 4.1.1.2 ITA on ubuntu 12.04 lts, but the result is exactly the same. The problems with PT and getpivotdata continue to be there. I thoroughly analyzed what he says Miguel Angel in point 2) of its response. The function in C10 as you say, Miguel, does not work at all. The function in that column C, as in column F should be used to bring back the values in the columns that are recognized in the 2 pivot tables on the worksheet PROSPETTOCODICI. In fact, the original formula, which worked fine with the 3.6 release of LIBEROFFICE, must be understood in this way - and how he worked in origin: premise = Table PIVOT analyzed is only 2 fields, consisting of C / R (or R / D in column F) and the range value SumDARE a) the source field from which to extract the data is $ A3 $ Axx .. and in this case the area shown covers the entire pivot table. For convenience in the compilation I planned to *define the name* of an area at the Pivot Table as* CODICIDARE*. b) For the worksheet BILANCIOCE the value to be found in the area (PivotTable) CODICIDARE is therefore the corresponding value for the field SumDARE C / R (or R / D in column F) that corresponds to the number shown in the cells of column A to the worksheet BILANCIOCE. This in the case of extracting data from a Pivot Table with only 2 fields. If there are more fields and extraction of indices is right that in the GETPIVOTDATA function. I tried to rewrite the formula as suggested by Miguel Angel (Mariosv), but I did not get the correct results. I also proceeded to make a comparison between versions and S.O. in use by me and point them out below, might be helpful. * = presence of the bug LibreOffice Language S/O Bug. 2Nd Pivot Table Refresh Bug. GETPIVOTDATA 4.1.1.2 ITA UBUNTU 12.04 LTS * * 3.6.0.4 ENG UBUNTU 12.04 LTS * 4.1.0.5 ENG XP home edition SpIII 4.1.0.5 ITA WINDOWS 7 Smart Ed. * * For my work, I then reinstalled all the pc version of LibreOffice 3.6.7 because it is stable. On the download page free utility accounting for business I told my customers to install LibreOffice of the same version to avoid the problems of production data BilancioCE. Thank you very much for your cooperation and look to future releases. Michele Ras -- 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
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
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] LIBREOFFICE - Version: 4.1.0.4 Build ID: 410m0(Build:4) / ALL S.o. / - BUG PIVOT TABLE Refresh
Goood Morning All. Maybe someone has found serious problems in the management of Pivot Tables from version 3.6 to 4.1? I described the problem in the BUGS section of the site Libreoffice. Application: CALC Coverage: Pivot Table Command: Refresh Reason operation: Some data of the Data Base pivot table have changed Structure of the worksheet: Report Table / Pivot Tables: Pivot Tables reports are two, side by side on the same worksheet and refer to the same database, but need to run a report different between them. What happens: In release 4.1: One of the Pivot Tables (the Second tiled), the refresh command, in its structure eliminates the The selection field, and makes it impossible to compile the report Thanks for your attention, waiting for some user can verify the same problem. Michele Ras - 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] 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 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