Originally posted by ktecho
View Post
LibreOffice 25.2 Alpha 1 Open-Source Office Suite Released
Collapse
X
-
Originally posted by ktecho View PostDuality? How can I choose one?
Comment
-
-
Originally posted by oiaohm View Post
I guess you are using Ubuntu package libreoffice. I use debian if I don't have libreoffice-qt5 package installed libreoffice falls back to gtk backend and gives me this trouble. This comes down to how your distribution/source has packaged libreoffice.
ii libreoffice-qt6
Edit: Your message prompted me to search and I found this:
Code:rucu@trucu:~$ sudo nala install libreoffice-kf6 ================================================== ================================================== ================================================== ========================================== Instalando ================================================== ================================================== ================================================== ========================================== Paquete: Versión: Tamaño: libreoffice-kf6 4:24.8.2-0ubuntu1 26 KB libreoffice-style-breeze 4:24.8.2-0ubuntu1 3.3 MB
Now it still displays like shit, but at least I can see the icons, so thanks!!!
image.png
Comment
-
-
Originally posted by Lionel View PostI am retired now but in In 2018 I wrote in the thread " Changes Begin Building Up For LibreOffice 6.1"
" 01 April 2018, 12:27 AM
I would like a real tool for data analysis...
Today 6.0 pivot table module in Calc is incredibly inferior to the Excel 2000 version I use at work."
Originally posted by [BJPFSanders[/B]]
Calc is very basic compared to what an advanced user does with Excel, and that I am missing the larger picture, I do not work in Finance or with Scientific stuff. Office app usage is a comparatively small part of what I do daily.
I'm not saying this in particular regarding you yourself, but most of the complains I observe people have with complex software are generally that they are trying to work in one particular way with one particular program rather than trying to find a way to solve a problem/task.
I do not agree that it is depending on how the user uses the software, since it is the software's responsibility to guide the user.
Comment
-
-
Originally posted by Lionel View PostI am retired now but in In 2018 I wrote in the thread " Changes Begin Building Up For LibreOffice 6.1"
" 01 April 2018, 12:27 AM
I would like a real tool for data analysis...
Today 6.0 pivot table module in Calc is incredibly inferior to the Excel 2000 version I use at work."
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Use clean, tabular data for best results.
Make sure all columns have headers, with a single row of unique, non-blank labels for each column. Avoid double rows of headers or merged cells.
Absolutely does not look like a table you use in Excel to make a Pivot Table in any version but that is a valid Calc one. This is where things start going south when a perosn like me working in Libreoffice Calc share data with Excel user. We using Calc can use different formatting that makes the document human readable when printed and still pull a pivot table out of it.
At home I have Excel 2003, and have been working on a pivot table. The table counts data from a spreadsheet..(not to hard). On excel 2003, on the drop down box in the table I can tell the table not to count blanks and 0's. When I try to do this in Excel 2000,( which is what I have in the...
Yes Calc pivot table module absolutely is superior to the 2000 and 2003 MS Office ones just in the number of items that can be processed into a piviot table alone..
Its really simple to have rose color glasses when comparing just using memory not putting the two programs side by side and going feature to feature. These differences are even true in the 6.1 LibreOffice.
Notice the feature called drilling on the Calc side. Lot of cases it not that libreoffice cannot do something but its a different work flow to get same or close to the same result. Close to the same is like how Libreoffice calc to connect macro to cell it expecting you to use form items this makes sense particularly with high security default on Macros meaning that Macros have higher risk of being non functional due to security.
Lionel; the question required to change something is what is missing? Saying inferior does not answer that question. Without question libreoffice Calc piviot table is superior to Excel 2000 in some areas. There might be others with weaknesses.
Comment
-
-
Originally posted by Landway12 View PostYes, totally agree, LibreOffice is worse than MS Office from the 90s. it is roughly 40 years behind, and at this pace, it looks almost like a dead project.
To get past most of those limit issues you have to be at least MS Office 2007/2008.
Comment
-
-
Originally posted by pharmasolin View PostI do some basic stuff with csv, edit some docx and libre office does it's job pretty good for me
Comment
-
-
Originally posted by Estranged1906 View PostWell, for starters it would be nice if it had even basic compatibility with excel spreadsheets....
Yes part VBA support exists for excel VBA in Libreoffice its disabled by default.
That writeup you have basically Libreoffice as best of a bad bunch when it comes to excel compatibility.
Of course that only compared current version of excel. There are functions that have been removed as well.
There are items that are libreoffice general keyboard short cut differences.
Alt + Enter for line break in formula and text
Yes shift+Enter is one of the most overloaded keys with features in LibreOffice.
fill right does exist in libreoffice Ctrl+R is not assigned to it and can be assigned.
Shift + F9 to recalculate workbook/sheet that in Libreoffice is Ctrl+Shift+F9 Data > Calculate > Recalculate Hard. Yes it possible to change this to shift+F9
Alt + = for quick sum
Use Alt key to navigate the user interface using the keyboard*
So really the only two in my eyes that does not work at all "Ctrl + Shift + V to paste values" and the "alt+enter/shift+enter for inserting returns" in short cuts. First one matching point to assign a shortcut to in Libreoffice and the second one is a hard coded locked option in libreoffice. Nice if both got assignable options.
In short cuts if you are willing todo the effort you can get libreoffice quite close to excel. Most annoying is there is a apply keybinding thing in tools options libreoffice-calc compatibility with only 2 options default and openoffice legacy. Yes it possible for a LibreOffice extensions to add to that list so there could be a excel keyboard short cut configure or a tabbed toolbar config. Also in tools->customize you can save and load configurations. So yes someone could customized LibreOffice close to excel in short cuts and provide a configuration file for end users to use.
Notice in the above link. GCD_EXCEL2003 and others like it appear in Libreoffice and no where else. There are a set of Functions Microsoft changed at MS Office 2007/2008. Opening up a old excel 2003 document on new MS Office and it uses one of these changed functions be ready for your results to be messed up.
That cartoon about a banker created a document in 2003 and is now dead at the top of the page you referenced that can be reason why you are using Libreoffice because its the only modern office suite that stands a chance of running it correctly. Yes the other option its spin up virtual machine and install old version of Windows and old version of MS Office if you have them. Libreoffice is your best friend if you have to start digging around in document archives. Kind of make sense thinking a good block of libreoffice development is funded by national archives.
There are things that are workflow. Like calc you have to tell it to ignore stuff there are ways to tell it to ignore like #N/A and the like. Here is a fun one you have a reason to treat #N/A as a value now excel fights with you. The LibreOffice stuff is not without reason why it the way it with some of this stuff. Document compadiblity options would be great for some of these things.
Comment
-
-
Originally posted by oiaohm View PostThere is stuff in that table that not 100 percent right for Libreoffice but to know the corrent answer you have to know libreoffice workflow.
By the way, in Customize -> Keyboard, you can only set the predefined shortcut combinations right? There's no way to actually recreate these "sequential" Alt shortcuts that Excel does like Alt -> A -> B -> C -> D -> E, right?
Comment
-
Comment