- Foro
- V:TES Discussion
- Generic V:TES Discussion
- Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice
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

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.
Replied by Lech on topic Re: Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice
Can't we just get archon in modern, open format ?
Always when you use shit m$ products, problems arise.
Always when you use shit m$ products, problems arise.






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.
11 Feb 2014 13:44 #59126
by PetriWessman
Replied by PetriWessman on topic Re: Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice
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.
- PetriWessman
-
Topic Author
- Offline
- Methuselah
-
Less
More
- Posts: 290
- Thank you received: 244
11 Feb 2014 13:45 #59127
by PetriWessman
Replied by PetriWessman on topic Re: Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice
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.
- PetriWessman
-
Topic Author
- Offline
- Methuselah
-
Less
More
- Posts: 290
- Thank you received: 244
11 Feb 2014 14:24 - 11 Feb 2014 14:30 #59128
by PetriWessman
Replied by PetriWessman on topic Re: Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice
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
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.
- PetriWessman
-
Topic Author
- Offline
- Methuselah
-
Less
More
- Posts: 290
- Thank you received: 244
11 Feb 2014 15:35 - 11 Feb 2014 15:36 #59129
by Ankha
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
Replied by Ankha on topic Re: Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice
I've juste tested the archon using Office Plus 2010, this change breaks the archon.- Changed the INDIRECT formulas on the Table N sheets to use '.' instead of '!'
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
Last edit: 11 Feb 2014 15:36 by Ankha.
Please Log in or Create an account to join the conversation.
11 Feb 2014 15:38 #59130
by Ankha
Replied by Ankha on topic Re: Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice
See if you can make it work using the ADDRESS function:
www.oooforum.org/forum/viewtopic.phtml?t=85679
www.oooforum.org/forum/viewtopic.phtml?t=85679
Please Log in or Create an account to join the conversation.
- Foro
- V:TES Discussion
- Generic V:TES Discussion
- Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice
Time to create page: 0.100 seconds
- You are here:
-
Home
-
Foro
-
V:TES Discussion
-
Generic V:TES Discussion
- Latest official Archon (1.5a) doesn't work on latest OpenOffice or LibreOffice