Open Office

For the last year I haven't paid up to use MS Office and have instead been using Open Office.

Is there any way to import your results into Open Office via either the BF main site or thro MF pro so that I can edit and examine my results.

I've tried everything but have failed 😭

Hi
By results are you meaning your statement? In MFP when you are viewing your statement, towards the top right are a row of buttons. One of them saves the statement as a CSV file. I believe you can import CSV files into Open Office.

Quote from: MarkV on 04 May 2018, 21:08

Hi By results are you meaning your statement? In MFP when you are viewing your statement, towards the top right are a row of buttons. One of them saves the statement as a CSV file. I believe you can import CSV files into Open Office.

Hi Mark.
Yes I do mean the statement
I can import the data but Open Office doesn't recognise the characters as numbers. Every number is imported with a prefix which I can't remove

Like this

Hi
I don't have Open Office so I can't test, but give this a try:

open csv file with notepad, word wrap off
edit > replace
find what: "
replace with: leave blank
save csv
try import to Open Office

and if you've not done so already, can you try formatting a column in Open office to "number"

There is no way to connect MF Pro to an Open Office document directly, but you can use the advice the other users kindly gave above.

These settings work for opening mfp csv files in libre office calc....I believe libre office and open office are pretty much identical.

Hope that helps

Quote from: MarkV on 05 May 2018, 09:20

Hi I don't have Open Office so I can't test, but give this a try: open csv file with notepad, word wrap off edit > replace find what: " replace with: leave blank save csv try import to Open Office and if you've not done so already, can you try formatting a column in Open office to "number"

Thanks for the replys guys.
This does seem to work. Opening first in notepad and removing the "
Its a shame we can only download one day at a time

I just need to figure it out for when downloading from the Betfair site now.
Its a totally different format from Beftaif

Open Office

Hello Guest