If you click on the link you can see step-by-step what I do in Excel with Power Query.The tables is depivoted with one click and the attributes and their values are line by line mapped.With the normal pivot-function in OpenOffice Excel is this not possible.Do you know a extension for LibreOffice that allows me the same depivotation like Power Query in Excel.
Openoffice Vs Libreoffice Excel Windows 7 If YouApache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7 If you think that I did not answer your question, make allowances for my imperfect English. Villeroy gave the link to the file in this message Thanks for the hint It does not solved my problem but after spend some more time on Google I found a solution - next post. It has some disadvantages - UI language, a limit of 65535 lines, ignoring cells with textual formulas - but it works great. It is also available in English Open the extension files with 7zip, alter the name of the.DEFAULT language file to enUS.DEFAULT For the other disadvantages I have no solution but when it is not exceeded then everything is fine. For example, the restriction of 65535 lines can be changed if we replace this constant (line 439 and other) with something similar to oCalcDoc.Sheets.getByIndex(0).getRows().getCount() For textual formulas we need to slightly complicate the long If-not-and-not-and. OtenMoten wrote: Do you know a extension for LibreOffice that allows me the same depivotation like Power Query in Excel. Read about converting a contingency table to a simple table in Tutorial Rearrange rectangular data values. This would work in OpenOffice or any related derivatives including LibreOffice. If this solved your problem please go to your first post use the Edit button and add Solved to the start of the title. Openoffice Vs Libreoffice Excel How To Change TheIt is also available in English Open the extension files with 7zip, alter the name of the.DEFAULT language file to enUS.DEFAULT For the other disadvantages I have no solution but when it is not exceeded then everything is fine hi, could you step by step say how to change the language according to your description. Openoffice Vs Libreoffice Excel Install The ExtensionYou can edit them; before you install the extension by usage of the extension manager. His spreadsheet makes use of some very smart spreadsheet formulas. Even if you dont understand the formulas, it does the job very well.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |