Welcome to the new Beta version of the MyFootballNow website! Please note that while using the Beta website, some features may not work correctly and other features are not complete. Some elements, such as notifications and chat, may act strangely during the time that both versions of the site are available. If you need to return to the old version, click on the button below.
Return to old website
People who liked this post
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).
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
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.
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