file Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice

11 Feb 2014 13:07 - 11 Feb 2014 13:09 #59123 by Lech
Can't we just get archon in modern, open format ?

Always when you use shit m$ products, problems arise.

:laso: :CEL: :DOM: :OBT: :POT: :cap8:
Sabbat.Black Hand Shakar: Lech loathe ranged weapons. Once each action, he may burn 1 blood to become Camarilla Prince of Krakow until the end of the action.
Last edit: 11 Feb 2014 13:09 by Lech.
The following user(s) said Thank You: Lönkka

Please Log in or Create an account to join the conversation.

More
11 Feb 2014 13:44 #59126 by PetriWessman
Well, it's not just an MS problem, I'm also getting weird issues even if I save and work in .ods format; OpenOffice and LibreOffice have compaibility issues with each other (at least on this level, since Archon uses some non-trivial function stuff). And of course, Excel is different in yet other ways. Sigh.

Please Log in or Create an account to join the conversation.

More
11 Feb 2014 13:45 #59127 by PetriWessman
Also: I'm not sure how the vekn.net Archon upload handles .ods format. (?)

Please Log in or Create an account to join the conversation.

More
11 Feb 2014 14:24 - 11 Feb 2014 14:30 #59128 by PetriWessman
Ok, I managed to create a new .xls version (1.5b) of the Archon which now seems to work with the latest OpenOffice and LibreOffice (at least on Linux). The problem is, I have no idea of whether it works in other environments and/or Excel itself -- I don't have access to a copy at the moment.

You can download a copy from

www.orava.org/vekn/thearchon1.5b.zip

and try it out. Let me know if it works for you :)

Please do not use this to run a tournament before making sure it actually works on your setup (OS & office software combo)!

For reference, the changes are:

- Fixed the data validation on Tournament Info cell B11 to be numeric 3-4
- Changed the INDIRECT formulas on the Table N sheets to use '.' instead of '!'
- Some tweaks to line heights etc to fix display bugs probably caused by .xls file import/export in OpenOffice
Last edit: 11 Feb 2014 14:30 by PetriWessman.
The following user(s) said Thank You: Lönkka

Please Log in or Create an account to join the conversation.

More
11 Feb 2014 15:35 - 11 Feb 2014 15:36 #59129 by Ankha

- Changed the INDIRECT formulas on the Table N sheets to use '.' instead of '!'

I've juste tested the archon using Office Plus 2010, this change breaks the archon.
If I change back the =SI(ESTVIDE('Tournament Info'!$B$11);"";INDIRECT("'Optimal Seating "&'Tournament Info'!$B$11-1&"R+F'.A7")) formula to
=SI(ESTVIDE('Tournament Info'!$B$11);"";INDIRECT("'Optimal Seating "&'Tournament Info'!$B$11-1&"R+F'!A7"))

it works again.

A way to make it work on both systems is still to be found.

EDIT: 'SI' stands for 'IF' and 'ESTVIDE' for ISEMPTY'. Thanks you Excel for localizing the formulas

Prince of Paris, France
Ratings Coordinator, Rules Director
Last edit: 11 Feb 2014 15:36 by Ankha.

Please Log in or Create an account to join the conversation.

More
11 Feb 2014 15:38 #59130 by Ankha
See if you can make it work using the ADDRESS function:

www.oooforum.org/forum/viewtopic.phtml?t=85679

Prince of Paris, France
Ratings Coordinator, Rules Director

Please Log in or Create an account to join the conversation.

More
Moderators: AnkhaKraus
Time to create page: 0.105 seconds
Powered by Kunena Forum