I just spent a full hour banging my head against LibreOffice Calc trying to get it to do something I do with great ease in Excel and Google Sheets on a regular basis. I ended up just giving up and using Google Sheets for it.

I was trying to apply some simple text cleanup and concatenation filters to a loooooong list of filenames and descriptions, and every time I'd try to copy or save it out of LibreOffice Calc, it'd lose all the TRIM() stuff it had done.

If I choose "values" and not "formulas" it'd *still* fail to keep the TRIM() formatting applied, but do all the concatenation.

Does anybody actually find themselves able to get work done with this software?

---
þ Synchronet þ Deep Space '94 - deepspace94.com - The Best 1994 Had to Offer

Re: I Hate LibreOffice
By: Deepthaw to All on Tue Jul 04 2017 06:40 pm

If I choose "values" and not "formulas" it'd *still* fail to keep the TRIM() formatting applied, but do all the concatenation.

Does anybody actually find themselves able to get work done with this softwa

Did you try copying the entire column to another column as values and no formulas whatsoever, and export that?

...darkwing!

---
þ Synchronet þ Vertrauen þ Home of Synchronet þ telnet://vert.synchro.net

Re: I Hate LibreOffice
By: Darkwing to Deepthaw on Tue Jul 04 2017 09:51 pm

Did you try copying the entire column to another column as values and no formulas whatsoever, and export that?

Countless times. I couldn't get it to work no matter what, and my first go at it in Google Sheets did exactly what I expected.

---
þ Synchronet þ Deep Space '94 - deepspace94.com - The Best 1994 Had to Offer

Does anybody actually find themselves able to get work done with this software?

Yes, I rather like it, BUT I have never tried to do anything that
complicated before, either.

---
þ SLMR 2.1a þ "Excellent...excellent..." - Mr. Burns
þ Synchronet þ CAPCITY2 * capcity2.synchro.net * 1-502-875-8938

Did you try copying the entire column to another column as values and no
formulas whatsoever, and export that?

I have had to do that in excel before in order to get some features of excel
to work.

---
þ SLMR 2.1a þ "When you have a rib-eye steak, you must floss it!"-Homer
þ Synchronet þ CAPCITY2 * capcity2.synchro.net * 1-502-875-8938

Re: I Hate LibreOffice
By: Dumas Walker to DEEPTHAW on Fri Jul 07 2017 06:03 pm

Yes, I rather like it, BUT I have never tried to do anything that complicated before, either.

Same here; they have an online version now called Libreoffice online that sounds pretty interesting. Runs on Owncloud.

I'm spending most of my time with G Suite - most of the companies I've seen lately are using G Suite if they're newer, and O365 if they're established. Once you get your head around the G suite mindset, it's pretty nice.

After using Microsoft Office since 1992 it was took a bit of getting used to to switch.

---
þ Synchronet þ realitycheckBBS -- http://realitycheckBBS.org

I'm spending most of my time with G Suite - most of the companies I've seen lately are using G Suite if they're newer, and O365 if they're established. Once you get your head around the G suite mindset, it's pretty nice.

G Suite? I have never heard of that one. Is it windows-based?

---
þ SLMR 2.1a þ All Aboard!!!
þ Synchronet þ CAPCITY2 * capcity2.synchro.net * 1-502-875-8938

On 07/09/17, Dumas Walker said the following...

G Suite? I have never heard of that one. Is it windows-based?

Google apps.

-=>Richard Miles<=-
-=>Captain Obvious<=-
-=>bbs.shadowscope.com<=-

On 2017-07-09 11:18 PM, Captain Obvious wrote:

On 07/09/17, Dumas Walker said the following...

DW> G Suite? I have never heard of that one. Is it windows-based?

Google apps.

-=>Richard Miles<=-
-=>Captain Obvious<=-
-=>bbs.shadowscope.com<=-

Who and why would one hate LibreOffice. I do like MS Word though but LibreOffice is pretty good actually.

---
* Synchronet * KK4QBN - kk4qbn.synchro.net - 7064229538 - Chatsworth GA USA

Re: Re: I Hate LibreOffice
By: Deavmi to Captain Obvious on Fri Aug 04 2017 22:07:08

Who and why would one hate LibreOffice. I do like MS Word though but LibreOffice is pretty good actually.

Personally, I like Microsoft Office more than LibreOffice; however, LibreOffice is a great office suite for when you cannot afford Microsoft Office or just have a Linux machine.

---
þ Synchronet þ MtlGeek - Geeks in Montreal - http://mtlgeek.com/ -

Re: Re: I Hate LibreOffice
By: Deavmi to Captain Obvious on Fri Aug 04 2017 10:07 pm

Who and why would one hate LibreOffice. I do like MS Word though but LibreOffice is pretty good actually.

I've been playing with a couple of suites lately, since my office licenses are getting out of date and I've been using my Linux laptop more these days.

It's hard to beat office365, and "renting" the newest version of office, getting 1TB of cloud storage and the online apps. You could use Office365 on any platform and use the Windows/Mac apps when applicable.

For the same price you could get G suite and use web apps all the time. I'm leaning that way.

If you had multiple systems, multiple platforms and didn't want to use cloud storage I'd use OpenOffice and Resilio Sync. Resilio does secure file syncing cross-platform and doesn't use the cloud. You could back up your docs to all of your systems and have multiple copies for safe keeping and have a free office app to work with - without any data in the cloud.

---
þ Synchronet þ realitycheckBBS -- http://realitycheckBBS.org

poindexter FORTRAN wrote to Deavmi <=-

I've been playing with a couple of suites lately, since my office
licenses are getting out of date and I've been using my Linux laptop
more these days.

I used to use suites like OpenOffice or LibreOffice, but a few years ago, I had to work on a document, which none of the free suites or cloud services like Google Docs/G Suite could handle without corrupting the formatting. I ended up subscribing to Office 365, which worked perfectly

It's hard to beat office365, and "renting" the newest version of
office, getting 1TB of cloud storage and the online apps. You could use Office365 on any platform and use the Windows/Mac apps when applicable.

That's the route I ended up going down, and it's affordable, with frequent updates.

For the same price you could get G suite and use web apps all the time. I'm leaning that way.

At the cost of compatibility. For most people, the alternatives work perfectly, and it certainly doesn't hurt to check out the free options. I used them successfully for many years, but sometimes you need the real Microsoft product for maximum compatibility.

If you had multiple systems, multiple platforms and didn't want to use cloud storage I'd use OpenOffice and Resilio Sync. Resilio does secure file syncing cross-platform and doesn't use the cloud. You could back
up your docs to all of your systems and have multiple copies for safe keeping and have a free office app to work with - without any data in
the cloud.

That's an interesting idea, and an alternative twist is to use OpenOffice on Linux and Office 365 on Windows machines, along with Resilio. That way, you can use any machine for day to day editing, but have MS Office available for when maximum compatibility is needed.


... A fail-safe circuit will destroy others.
--- MultiMail/Win32 v0.49
þ Synchronet þ Freeway BBS in Bendigo, Australia.

Re: Re: I Hate LibreOffice
By: Vk3jed to poindexter FORTRAN on Sat Aug 05 2017 04:52 pm

For the same price you could get G suite and use web apps all the
time. I'm leaning that way.

At the cost of compatibility. For most people, the alternatives work perfectly, and it certainly doesn't hurt to check out the free options.

More and more companies I talk to are moving to G Suite - companies that already have an investment in Microsoft are moving to Office365, while new companies starting out are using G Suite. I think in a couple of years you'll reach parity where people have experience with both.

---
þ Synchronet þ realitycheckBBS -- http://realitycheckBBS.org

poindexter FORTRAN wrote to Vk3jed <=-

More and more companies I talk to are moving to G Suite - companies
that already have an investment in Microsoft are moving to Office365, while new companies starting out are using G Suite. I think in a couple
of years you'll reach parity where people have experience with both.

The good thing is there's choice. I was just pointing out that my hands ended up being tied by an old document that demanded 100% compatibility, with the older Word format (.doc).


... Do it! It's easier to get forgiveness than permission.
--- MultiMail/Win32 v0.49
þ Synchronet þ Freeway BBS in Bendigo, Australia.

Personally, I like Microsoft Office more than LibreOffice; however, LibreOff
is a great office suite for when you cannot afford Microsoft Office or just have a Linux machine.

Agreed.

... The 4 major food groups: fast, frozen, junk, & spoiled.
--- Wildcat! v6.4.454.2 (May 15 2016), Editor Mod v2.0
þ wcQWK 7.0 ÷ Neptune's Lair - Olive Branch MS - winserver.org:2323

DEAVMI wrote to CAPTAIN OBVIOUS <=-

DW> G Suite? I have never heard of that one. Is it windows-based?

Google apps.

Who and why would one hate LibreOffice. I do like MS Word though but LibreOffice is pretty good actually.

Eh - to each his own. I don't like Firefox, but I know people that swear
by it. I use Safari as my primary browser, but Chrome for GAFE stuff.

When I was primarily Windows I would use IE exclusively. I liked it -
it did what I needed - I had no problems. People called me stupid
for using it.

If we all liked the same thing there would only be one flavor of
ice cream. :-)





... Elvis has left the echo.
--- MultiMail/Darwin v0.49
þ wcQWK 7.0 ÷ Neptune's Lair - Olive Branch MS - winserver.org:2323

VK3JED wrote to POINDEXTER FORTRAN <=-

I used to use suites like OpenOffice or LibreOffice, but a few years
ago, I had to work on a document, which none of the free suites or
cloud services like Google Docs/G Suite could handle without corrupting the formatting. I ended up subscribing to Office 365, which worked perfectly

And that's an example where sometimes you need the brand name thing...

Had you been creating from scratch or just worried more about the text
and not the 'format' then ANYTHING would have worked! :-)




... Proofread carefully to see if you any words out.
--- MultiMail/Darwin v0.49
þ wcQWK 7.0 ÷ Neptune's Lair - Olive Branch MS - winserver.org:2323

POINDEXTER FORTRAN wrote to VK3JED <=-

More and more companies I talk to are moving to G Suite - companies
that already have an investment in Microsoft are moving to Office365, while new companies starting out are using G Suite. I think in a couple
of years you'll reach parity where people have experience with both.

I work for a school system and GAFE (Google Apps for Education) is FREE
with unlimited cloud storage for staff AND students. No reason NOT to
use it! :-)




... The truth is out there... Anyone know the URL?
--- MultiMail/Darwin v0.49
þ wcQWK 7.0 ÷ Neptune's Lair - Olive Branch MS - winserver.org:2323

Re: Re: I Hate LibreOffice
By: JIMMY ANDERSON to DEAVMI on Mon Aug 07 2017 10:34 am

When I was primarily Windows I would use IE exclusively. I liked it -
it did what I needed - I had no problems. People called me stupid
for using it.

I don't think anyone is stupid for using a particular program.. I think many people used IE because it was there, included with Windows. But there were other web browsers before IE..

I think the main problem with IE, in the past, was that it had bugs and didn't conform to web standards 100%, causing web developers to do additional work making their pages work correctly with IE. And because of Microsoft's dominant position in the market, many web developers went ahead with that, knowing that many people were using IE. I think Microsoft may have purposefully made IE work slightly different from the standards to encourage people to use it - Sometimes, a web site actually only worked correctly in IE..

Nightfox

---
þ Synchronet þ Digital Distortion: digitaldistortionbbs.com

Re: Re: I Hate LibreOffice
By: Nightfox to JIMMY ANDERSON on Mon Aug 07 2017 03:01 pm

Re: Re: I Hate LibreOffice
By: JIMMY ANDERSON to DEAVMI on Mon Aug 07 2017 10:34 am

When I was primarily Windows I would use IE exclusively. I liked it - it did what I needed - I had no problems. People called me stupid
for using it.

I don't think anyone is stupid for using a particular program.. I think many people used IE because it was there, included with Windows. But there were other web browsers before IE..

ie went from being the shittiest browser to a much faster secure browser.
---
þ Synchronet þ ::: BBSES.info - free BBS services :::

JIMMY ANDERSON wrote to VK3JED <=-

And that's an example where sometimes you need the brand name thing...

Yes, that's what forced my hand.

Had you been creating from scratch or just worried more about the text
and not the 'format' then ANYTHING would have worked! :-)

And for many years, OpenOffice and Google Docs did fit the bill, I used them for years, before subscribing to Office 365. In this instance, the formatting was a critical component of the document. Creating from scratch would have been the only other option, but that would have been time prohibitive, and possibly beyond my word processing ability. :)


... OUT TO LUNCH - If not back at five, OUT TO DINNER!
--- MultiMail/Win32 v0.49
þ Synchronet þ Freeway BBS in Bendigo, Australia.

JIMMY ANDERSON wrote to POINDEXTER FORTRAN <=-

I work for a school system and GAFE (Google Apps for Education) is FREE with unlimited cloud storage for staff AND students. No reason NOT to
use it! :-)

I'm guessing US only, reason I'm asking is I work for a couple of schools down here.


... Pentium Myth #1: The computer only does what you tell it.
--- MultiMail/Win32 v0.49
þ Synchronet þ Freeway BBS in Bendigo, Australia.

Re: Re: I Hate LibreOffice
By: Mro to Nightfox on Mon Aug 07 2017 08:15 pm

ie went from being the shittiest browser to a much faster secure browser.

And IE has been replaced by Edge in Windows 10..

Nightfox

---
þ Synchronet þ Digital Distortion: digitaldistortionbbs.com

Re: Re: I Hate LibreOffice
By: Vk3jed to JIMMY ANDERSON on Tue Aug 08 2017 10:17 am

JIMMY ANDERSON wrote to POINDEXTER FORTRAN <=-

I work for a school system and GAFE (Google Apps for Education) is FREE with unlimited cloud storage for staff AND students. No reason NOT to use it! :-)

I'm guessing US only, reason I'm asking is I work for a couple of schools down here.

not sure but you can look. must be why the school system here has it.
i was a beta tester so i had it for free but lost it because i never used it. ---
þ Synchronet þ ::: BBSES.info - free BBS services :::

Mro wrote to Vk3jed <=-

@VIA: VERT/BBSESINF
@TZ: c168
Re: Re: I Hate LibreOffice
By: Vk3jed to JIMMY ANDERSON on Tue Aug 08 2017 10:17 am

JIMMY ANDERSON wrote to POINDEXTER FORTRAN <=-

I work for a school system and GAFE (Google Apps for Education) is FREE with unlimited cloud storage for staff AND students. No reason NOT to use it! :-)

I'm guessing US only, reason I'm asking is I work for a couple of schools down here.

not sure but you can look. must be why the school system here has it.
i was a beta tester so i had it for free but lost it because i never
used it. ---

Time to investigate. :)


... As a computer, I find your faith in technology amusing.
--- MultiMail/Win32 v0.49
þ Synchronet þ Freeway BBS in Bendigo, Australia.

Re: Re: I Hate LibreOffice
By: JIMMY ANDERSON to POINDEXTER FORTRAN on Mon Aug 07 2017 10:36 am

I work for a school system and GAFE (Google Apps for Education) is FREE
with unlimited cloud storage for staff AND students. No reason NOT to
use it! :-)

Is it free because they harvest your information and use it for targeted advertising to children?

---
þ Synchronet þ War Ensemble BBS - The sport is war, total war - warensemble.com

Re: Re: I Hate LibreOffice
By: JIMMY ANDERSON to DEAVMI on Mon Aug 07 2017 10:34 am

When I was primarily Windows I would use IE exclusively. I liked it -
it did what I needed - I had no problems. People called me stupid
for using it.

It worked, and once you got used to it, it was the Devil You Know. For many years, an employer of mine had developed apps that worked mostly best on IE and wouldn't support third party browsers. It was so bad that we installed a Windows VM on Macs so they could run certain job-critical apps.

Third-party support for Microsoft apps like Sharepoint and support in homegrown apps has improved greatly since then, to the point where Chrome became the de facto browser of choice.

I still prefer Outlook Express over Thunderbird if I need a POP/IMAP/NNTP client. People think I'm crazy for *that*!

---
þ Synchronet þ realitycheckBBS -- http://realitycheckBBS.org

Re: Re: I Hate LibreOffice
By: JIMMY ANDERSON to POINDEXTER FORTRAN on Mon Aug 07 2017 10:36 am

I work for a school system and GAFE (Google Apps for Education) is FREE with unlimited cloud storage for staff AND students. No reason NOT to
use it! :-)

My son's going into high school - his junior high was all on Google. He turned in assignments via google and did web-based homework. Kind of a bummer when I want to review them, but where there's a will, there's a (new) way.

---
þ Synchronet þ realitycheckBBS -- http://realitycheckBBS.org

Re: Re: I Hate LibreOffice
By: Nightfox to JIMMY ANDERSON on Mon Aug 07 2017 15:01:21

I think the main problem with IE, in the past, was that it had bugs and didn't conform to web standards 100%, causing web developers to do additional work making their pages work correctly with IE. And because of Microsoft's dominant position in the market, many web developers went ahead with that, knowing that many people were using IE. I think Microsoft may have purposefully made IE work slightly different from the standards to encourage people to use it - Sometimes, a web site actually only worked correctly in IE..

I never liked IE, and never used EDGE much, but the little I did use of EDGE I liked.

--

Tim Smith (KK4QBN)
KK4QBN BBS

---
* Synchronet * KK4QBN - kk4qbn.synchro.net - 7064229538 - Chatsworth GA USA

KK4QBN wrote to Nightfox <=-

I never liked IE, and never used EDGE much, but the little I did use of EDGE I liked.

I never liked IE either. Haven't used Edge, so I can't comment there. My biggest beef with IT was its dumbed down error message. People would ring up and say "The page cannot be displayed", the IE "catch all" error message. But it didn't distinguish between DNS lookup issues (host not found) and network issues (host not responsing, connection refused, etc), which made troubleshooting much harder than it needed to be.



... Air conditioned environment - Do not open Windows.
--- MultiMail/Win32 v0.49
þ Synchronet þ Freeway BBS in Bendigo, Australia.

DEAVMI wrote to CAPTAIN OBVIOUS <=-

DW> G Suite? I have never heard of that one. Is it windows-based?

Google apps.

Who and why would one hate LibreOffice. I do like MS Word though but LibreOffice is pretty good actually.

Eh - to each his own. I don't like Firefox, but I know people that swear
by it. I use Safari as my primary browser, but Chrome for GAFE stuff.

When I was primarily Windows I would use IE exclusively. I liked it -
it did what I needed - I had no problems. People called me stupid
for using it.

If we all liked the same thing there would only be one flavor of
ice cream. :-)

... Elvis has left the echo.
--- MultiMail/Darwin v0.49
þ wcQWK 7.0 ÷ Neptune's Lair - Olive Branch MS - winserver.org:2323

I agree with oue disagreeing. I like all the flavors :)

---
þ Synchronet þ UsersClub BBS - userclub-bbs.com

Re: Re: I Hate LibreOffice
By: Deavmi to Captain Obvious on Fri Aug 04 2017 10:07 pm

Who and why would one hate LibreOffice. I do like MS Word though but LibreOffice is pretty good actually.

I've been playing with a couple of suites lately, since my office licenses are getting out of date and I've been using my Linux laptop more these days.

It's hard to beat office365, and "renting" the newest version of office, getting 1TB of cloud storage and the online apps. You could use Office365 on any platform and use the Windows/Mac apps when applicable.

For the same price you could get G suite and use web apps all the time. I'm leaning that way.

If you had multiple systems, multiple platforms and didn't want to use cloud storage I'd use OpenOffice and Resilio Sync. Resilio does secure file syncing cross-platform and doesn't use the cloud. You could back up your docs to all of your systems and have multiple copies for safe keeping and have a free office app to work with - without any data in the cloud.

---
þ Synchronet þ realitycheckBBS -- http://realitycheckBBS.org

You could just use Syncthing for syncing. It is really awesome.

---
þ Synchronet þ UsersClub BBS - userclub-bbs.com

Re: Re: I Hate LibreOffice
By: Deavmi to Captain Obvious on Fri Aug 04 2017 22:07:08

Who and why would one hate LibreOffice. I do like MS Word though but LibreOffice is pretty good actually.

Personally, I like Microsoft Office more than LibreOffice; however, LibreOffice is a great office suite for when you cannot afford Microsoft Office or just have a Linux machine.

---
þ Synchronet þ MtlGeek - Geeks in Montreal - http://mtlgeek.com/ -

The new MS office is very nice. I must say.

---
þ Synchronet þ UsersClub BBS - userclub-bbs.com