Skip to main content

Search

Items tagged with: openoffice


* Please boost *

Which office suite(s) do you use at least once a week? (in a typical week)

Please only answer the poll *if* you use #office software, such as #wordprocessor, #spreadsheet #presentation software, etc.

--
#LibreOffice #MSOffice #MicrosoftOffice #GoogleDocs #CalligraSuite #Calligra #FreeOffice #SoftmakerOffice #Gnumeric #CollaboraOffice #CollaboraOnline #OpenOffice #OnlyOffice #Microsoft365 #WordPerfectOffice #WPSOffice #iWork #Windows #Linux #macOS #Android #iOS

  • LibreOffice (60%, 138 votes)
  • Microsoft Office (38%, 87 votes)
  • Google Docs (30%, 69 votes)
  • Other (please reply and explain) (5%, 13 votes)
229 voters. Poll end: 2 months ago


Edit2: Solved! Thanks everyone!
#Blind #Microsoft #excel users and others who, for whatever reason, only use the keyboard, NOT THE MOUSE: How the hell do I tell Excell to continue a pattern in a column without selecting it and clicking on the bottom left side of the screen or whatever?
Let's say I have a column with 1 in A1, 2 in A2, 3 in A3, so forth, and want that to go on for 150 cells or so. How the hell do I do it? Because I know I used to know, but I cannot find it.
It's not control+d. That just fills the whole column with 1's. It's not copy-paste; that does adjust properly for formulas, but for this, it doesn't. There is surely an option somewhere in the menus, but I cannot find it.
Alternatively, I'd also be happy to learn of ways to do this in #OpenOffice #Calc, so long as they are keyboard-only and accessible. LibreOffice doesn't work all that well here, at least Writer doesn't, but I could double-check if that extends to other programs.
#AskFedi #AskMastodon #ScreemReader

Edit: a couple folks suggested using formulas for this, adding so the first cell would be 1, the second A1 +1, etc. That works quite well for most use cases! It would mean the order of the numbers would stay the same when reordering the table though, so if I was using this to autocomplete a list of years, then sold by the comumn Income ... bam, the income of each year's not right anymore.
Also suggested was Home>Fill>Series. I do not see a Series option in the Fill menu at all, Bewilderingly. I'll try to switch my language to English to see if that's the issue, but I pressed all the things, so pretty sure it's not there for me in Office 365. Could someone with that version check whether it works for them?
Edit2: I figured out how to get to the series option! Turns out it was there, I just didn't realise I had to select the right type of series. :ms_facepalm: For those curious, for the Slovenian version, that's Alt +N, FI, V, Enter.


I switched to LibreOffice years ago and never looked back.

I understood that many developers had moved to LibreOffice, and OpenOffice had since stalled?

In terms of accessibility, LibreOffice continues to improve their export-to-PDF engine. They can now generate a PDF that is often pretty much compliant with PDF/UA.

Though I still use Microsoft Office for client work.

I'm curious to try OnlyOffice. I wonder how it compares?

#LibreOffice #OpenOffice #OnlyOffice #accessibility


LibreOffice vs OpenOffice, 2 articles (I've been using OpenOffice at home but now trying LibreOffice):
techradar.com/news/libreoffice…
digitaltrends.com/computing/li…
#LibreOffice #OpenOffice #MSOffice


@zotero haha my translation made it sound like a new feature, it’s two lines & some refactoring to fix an ancient bug inherited from #openoffice - though imo being able to fix such annoyances (or pay a random non-employee dev to do so on your behalf) is a really cool property of #FOSS projects like #LibreOffice. Beats hopelessly bashing my head against the wall while trying to work around the bugs and limitations of a certain proprietary office suite…