err:508 in cells after converting from excel...

[Chachoze]

Hello Everyone!

I'm looking for some help, after using the document converter function to convert some excel spreadsheets but when i did nearly all of the cells that have a formula assigned to them have this err:508 inside them. These formulas worked fine in Excel 2000 and I assumed that using the document convert would correct any syntax differences between the two programs.

Below are examples of formulas that are generating the error and I'm sure it is something simple but I just cant seem to nail it down. Hopefully someone can determine what I am missing in the formulas because I would like to ditch MS Office in favor of Open Office if possible.

=IF(Y5=0;"";VLOOKUP($D5;$I$5:$Y$28;2;FALSE()))

=RANK(Y5;$Y$5:$Y$28;0)+COUNTIF($Y$5:Y5;Y5)-1

=IF('file:///C:/Users/Charles/Documents/WGC/SCORECARD_2012.ods'#$Sheet1.$C$4'file:///C:/Users/Charles/Documents/WGC/SCORECARD_2012.ods'#$Sheet1.$C$4:$C$27=0;"";RANK('file:///C:/Users/Charles/Documents/WGC/SCORECARD_2012.ods'#$Sheet1.$C$4;'file:///C:/Users/Charles/Documents/WGC/SCORECARD_2012.ods'#$Sheet1.$C$4:$C$27;1))

Any help would be appreciated.

[coray80]

Error Code 508
Error: Pair missing
For example, closing parenthesis without opening parenthesis
or missing closing parenthesis in the middle of the formula (missing
closing parenthesis at the end of a formula is added automatically).

I don't see this problem with the examples supplied!?

[jrkrideau]

Error Code 508
Error: Pair missing
For example, closing parenthesis without opening parenthesis
or missing closing parenthesis in the middle of the formula (missing
closing parenthesis at the end of a formula is added automatically).

I don't see this problem with the examples supplied!?

I just dumped the formulae into a text editor with syntax highlighting and I don't see anything obviously missing either.

[eremmel]

Might it be possible to post the calc or excel sheet. Optionally remove all 'private' information. I just checked you first formula an that one looks fine.

[Chachoze]

Well in a strange way I guess I'm glad I'm not the only one having trouble with this...lol

I will try to post up the calc and excel sheets later on today.

Thanks to everyone trying to help me out with this.

[Chachoze]

[Here are the files from the Calc versions.

Perhaps an explanation is in order to better explain what the files are and what they are used for if you havent already guessed by the filenames. Basically it is a scoreboard system that I use on my laptop that also has an external monitor connected to it that run in extended desktop fashion. I run the Scorecard file on the laptop display an that is used for entering the scores and player names and such, the other file Scoreboard is run on the second display that players can view so they can monitor their progress throught the tournement. Everything on the Scoreboard file links back to the Scorecard file to show the Player how they ranked on each individule game played and their sum, it also performs an overall rank which is on the left side of this sheet. There is a hidden row between the two panels that helps with the overall ranking.

I will try to post the excel version in another reply.

SCOREBOARD_2012.ods

(20.53 KiB) Downloaded 305 times

SCORECARD_2012.ods

(12.03 KiB) Downloaded 261 times

[Chachoze]

Here are the Excel version for comparison, the Scorecard file thinks it has a macro in it but it doesnt so you say disable it it you are prompted as it doesnt effect it.

SCOREBOARD_2012.xls

(45 KiB) Downloaded 395 times

SCORECARD_2012.xls

(28.5 KiB) Downloaded 241 times

Thanks again for any assistance given.

[coray80]

I think ?? your formula in scoreboard_2012.0ds 'K5' should be

Code: Select all

=IF(file:///C:/Users/Charles/Documents/WGC/SCORECARD_2012.ods'#$Sheet1.$C$4=0;"";RANK('file:///C:/Users/Charles/Documents/WGC/SCORECARD_2012.ods'#$Sheet1.$C$4;'file:///C:/Users/Charles/Documents/WGC/SCORECARD_2012.ods'#$Sheet1.$C$4:$C$27;1))

If this is ok then you should be able to sort out the rest