People who liked this post

  • Community
  • Log In
Open Office
Community Help Forum
  • ‹
  • 1
  • 2
  • ›
Wolfkill
Open Office
by Wolfkill @ 6/27/2020 2:14 pm
I could use some help, I've tried all day to no avail.
How can I use Open Office when downloading games and csv files?
I don't have Excel or any Microsoft products.
Any help would be appreciated..
Wolf
TarquinTheDark
Re: Open Office
by TarquinTheDark @ 6/27/2020 2:19 pm
Once you have OO installed, you can use Calc (OO's version of Excel) to open the csv files. From there, if you want to make the effort, you can copy and paste the data into tables in Base (OO's version of Access).
Liked by Wolfkill
Wolfkill
Re: Open Office
by Wolfkill @ 6/27/2020 2:20 pm
TarquinTheDark wrote:
Once you have OO installed, you can use Calc (OO's version of Excel) to open the csv files. From there, if you want to make the effort, you can copy and paste the data into tables in Base (OO's version of Access).
Wolfkill
Re: Open Office
by Wolfkill @ 6/27/2020 2:20 pm
TarquinTheDark wrote:
Once you have OO installed, you can use Calc (OO's version of Excel) to open the csv files. From there, if you want to make the effort, you can copy and paste the data into tables in Base (OO's version of Access).


I can open the file, but it doesn't look like what Excel should look like. I'm guessing I need to play around with settings...?
Last edited 6/27/2020 7:22 pm
Wolfkill
Re: Open Office
by Wolfkill @ 6/27/2020 2:32 pm
think I got it..thank you-
Phareux
Re: Open Office
by Phareux @ 6/27/2020 3:00 pm
Can someone tell me how to sort the run and pass plays in OO?
TarquinTheDark
Re: Open Office
by TarquinTheDark @ 6/27/2020 3:06 pm
if you're using Calc:

Data -> Filter -> Standard Filter
Field: Text
Condition: contains/does not contain
Value: pass

It doesn't exactly sort them, but it lets you look at one or the other. You can add more conditions to remove ST plays from the run subset if you want.

If you're using Base, you can do it using a SQL query.
Last edited 6/27/2020 8:12 pm
Liked by CrazySexyBeast, Wolfkill
Phareux
Re: Open Office
by Phareux @ 6/27/2020 3:32 pm
That works, I have no idea what SQL is but thanks
Lamba
Re: Open Office
by Lamba @ 6/27/2020 3:38 pm
I think Libre Office is more similar to Microsoft Office -- and I recall my dad talking about OO not being developed anymore, while LO is.

I might've not really listened though. Just a thought.
Liked by TarquinTheDark, Phareux
TarquinTheDark
Re: Open Office
by TarquinTheDark @ 6/27/2020 3:43 pm
OO Base's wizards ****, and OO Calc is a memory-eating monster. I'll give it a shot, thanks!
Last edited 6/27/2020 8:51 pm
  • ‹
  • 1
  • 2
  • ›
Copyright ©2013-2026 Catalyst Productions | Weather data powered by Visual Crossing
Website Version 60d139e
Terms & Conditions | Privacy Policy