New Sticky Note

The new user interface is in preview!

Want to check it out? Click here! (If you don't like it, you can still switch back)

The draft is underway!

Click here to go to your war room, or visit the war room item in the draft menu.

League Forums

Main - Community Help Forum

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

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).

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).

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 at 6/27/2020 2:22 pm

Re: Open Office

By Wolfkill
6/27/2020 2:32 pm
think I got it..thank you-

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?

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 at 6/27/2020 3:12 pm

Re: Open Office

By Phareux
6/27/2020 3:32 pm
That works, I have no idea what SQL is but thanks

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.

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 at 6/27/2020 3:51 pm