Just starting to use Libre for first time. Want to use calc. First task: rename column A to something more meaningful. Right clicked on “A” button. Context menu has no Rename item. Surprised. Okay, what now? Double-clicked on “A”. No response. Not so surprised now. Starting to wonder. Leaving the column selected, clicked menu item Format. No Rename in menu. Can’t think of any other likely way to rename a column. Maybe Help will help? Clicked menu item Help, then LibreOffice Help. Get a nice wiki in my browser. Search for “calc rename column” without the quotes. Get message “There were no results matching the query.” Huh? Try again using “spreadsheet rename column”, again no results.
Okay, must report strange lack of help. Make bugzilla account, try to submit bug report. No category available for documentation bugs in LibreOffice components. Surprising. Try the user community.
That brings me here.
So, I have some questions:
Is LibreOffice really as difficult to use as my first experience of it, as described here indicates? Or did I just have bad luck?
Is it really so hard to contribute documentation bug reports?
Is it possible to extend LibreOffice quickly to act more intuitively ourselves (I am a software engineer with 40 years of experience, and a Wikipedia editor)?
How does one actually rename columns in calc? Or, aha!, are columns limited to letters like most older spreadsheet programs? (In which case, fixing this “bug” might not be so easy.)
Added: I just tried to insert an ascending list of integers by manually inserting two examples then selecting range. Doesn’t seem to work. In Help, “calc insert integers ascending” produces no results. Added question: how to do this common operation?
Added after first two answers: These answers are missing the point of my posting.
I’ll try again, with a third example: there is no simple way to duplicate (clone) a line or column. This posting shows how to do it, but it requires the user to add a 17-line macro.
My point is that this product, which may be very well constructed internally for all I know, keeps surprising the user by not providing easy ways to do common tasks, whether those tasks are within the functionality of the office component or within the Help documentation.
I get the feeling that making the product work really nicely is not one of its goals.
If there is no way to state what may be a fundamental flaw and get some enthusiastic and positive feedback, then I don’t understand how you will be successful in developing a user-friendly and complete office suite. Or maybe you have too many bugs to fix to add more complete functionality? Or, hmmm, maybe your goal is simply to maintain this snapshot of OpenOffice as is? That’s possible to do, but what is the point?
And, if you reply that this is not the place to discuss functionality or goals, then where is the right place? Or do I just need to repost this as a general discussion of functionality or goals? When I started, I didn’t think this was going to be the direction. I was just frustrated with not being able to do what I wanted to do.
I’m new here, and probably speaking out of turn, but this is my honest reaction to my first hour of working with calc.
Added later: The advice to me about spreadsheets (excellent though it was, thank you) also misses my point. I am trying here to act like a new user of LibreOffice, which I actually am. I encounter problems that could be fixed, at least with in-context documentation.
Here is another example, encountered in my ongoing actual use: I type 60+4260+1 into a cell, expecting the sum to be calculated and inserted. Just the text is inserted. Okay, I look for a way to evaluate expressions. I start with right-clicking. I can’t find a way to evaluate the expression. Must I put the components in separate cells and create a formula to find the answer? Must I use the Windows Calculator to ready data for a LO spreadsheet? It shouldn’t be this hard for someone new to spreadsheets to create one.
LO 126.96.36.199 calc, in English
Windows 8, in English
Hardware: ASUS Model X501A with wide screen