| Summary: | Other: REFRESH PIVOT TABLE & GETPIVOTDATA FUNCTION | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Michele Ras <contabilmenteAG.net> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | Keywords: | regression |
| Version: | 4.1.0.4 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | File Business accounting program for utility companies. | ||
Hi Michele, I can reproduce it in: Win7x64Ultimate Version: 4.1.1.0.0+ Build ID: c1f0f890f5065f88164add33707228f8c6d5755 Once added the row field to recover the PT https://bugs.freedesktop.org/show_bug.cgi?id=68631, in 4.0.5.2 works fine. IMHO it is better avoid use the latest version in production, specially if it will be used by people not used to deal with this issues. In fact there are other bugs for which and can not use 4.1 |
Created attachment 84760 [details] File Business accounting program for utility companies. Problem description: in the Attached File Business accounting program for utility companies. Worksheet named : PROSPETTO CODICI & Worksheet named BILANCIO CEE 1) If Updating of a two PivotTable: in the Worksheet = Prospetto codici / update SECTION CODICI DARE (black numbers) and update SECTION CODICI AVERE (red numbers), 2) in the Worksheet named BILANCIO CEE, The functions named GETPIVOTDATA in cells C3 .. C1060 = GETPIVOTDATA (CODICIDARE; Axxx) and cells in F3..F1060 = GETPIVOTDATA (CODICIAVERE; Axxx) linked to two Pivot tables CODICI DARE & CODICI AVERE of the worksheet named PROSPETTO CODICI no longer give the correct result (which worked perfectly in version 3.6), and the entire table (Table Final Report accounting) is thus completely cleared. You've never seen an accountant who commits suicide from the tower? This is a good opportunity! Current behavior:The cells in column C and column F are without correct data from the pivot tables linked to the function GETPIVOTDATA in Allied: In the Worksheet named BILANCIO CEE the GETPIVOTDATA function must generate the corresponding data found in the pivot table reference, so that the data in columns C and F are correct to give accurate results in the other columns of the Worksheet Operating System: Tutti Version: 4.1.0.4 release Last worked in: 3.6.6.2 release