ARMY LIST CALCULATOR

General discussion forum for anything related to Field of Glory Ancients & Medieval.

Moderators: hammy, Slitherine Core, Field of Glory Moderators, Field of Glory Design

nicofig
Field of Glory Moderator
Field of Glory Moderator
Posts: 743
Joined: Tue Aug 22, 2006 6:54 pm
Location: Toulon
Contact:

Post by nicofig » Mon May 05, 2008 6:08 pm

the version 2.5 corrected is online :

http://fieldofglory.fr/spip.php?article2

:wink:
ImageImage

ars_belli
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 540
Joined: Mon Feb 12, 2007 10:18 pm
Location: USA

Post by ars_belli » Mon May 05, 2008 7:19 pm

As always, thank you for your sterling efforts, Olivier! :D

Cheers,
Scott

Draka
Corporal - Strongpoint
Corporal - Strongpoint
Posts: 56
Joined: Fri Apr 11, 2008 11:03 pm
Location: Glendale, AZ

Post by Draka » Mon May 05, 2008 7:47 pm

Much appreciated .....

neilhammond
Master Sergeant - Bf 109E
Master Sergeant - Bf 109E
Posts: 465
Joined: Sun Jan 07, 2007 7:51 pm
Location: Peterborough, UK

Post by neilhammond » Mon May 05, 2008 7:49 pm

nicofig wrote:the version 2.5 corrected is online :
Hi,

The sort function isn't working correctly in the new version - it gives a merged cell message:

"This error only appears if you attempted to sort a range of previously merged cells, but not all cells in the sort range were merged or are not of the same size.
To avoid this behavior, unmerge all the merged cells in the range, or merge all the cells in the range to be the same as the largest merged cell grouping."

Neil

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Mon May 05, 2008 8:09 pm

it's work on my PC :cry: . I killed the merged cell and this must function fluently now.
The tournament version don't have this problem as I see.

nicofig
Field of Glory Moderator
Field of Glory Moderator
Posts: 743
Joined: Tue Aug 22, 2006 6:54 pm
Location: Toulon
Contact:

Post by nicofig » Tue May 06, 2008 4:46 am

It's corrected :wink:
ImageImage

Blathergut
Field Marshal - Elefant
Field Marshal - Elefant
Posts: 5699
Joined: Tue Jan 22, 2008 1:44 am
Location: Southern Ontario, Canada

Sorting by Order of March Gone?

Post by Blathergut » Sun May 11, 2008 7:07 pm

In previous versions, you could right-click on the first cell of the order of march, go to sort, then sort by order of march...but i don't see that now...was it removed?

Dan T.

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Mon May 12, 2008 9:18 am

No, you certainly have an empty cell in your line (usually that of the book order) put an "-" in this cell, or any symbol you like and the problem is corrected. :wink:
Rgds,
Olivier

Blathergut
Field Marshal - Elefant
Field Marshal - Elefant
Posts: 5699
Joined: Tue Jan 22, 2008 1:44 am
Location: Southern Ontario, Canada

Post by Blathergut » Mon May 12, 2008 10:18 am

it's the F version, with no book column...but at the very top there is a & b columns...maybe that is muddling it up?....when going to custom sort it only shows columns....not 'by order of march' like before

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Mon May 12, 2008 11:04 am

Ah, I see now :) You have two Choice.
1) Kill all the merged cell and delete the B column
2) Download the last version I've made after the message from neilhammond
rgds,
olivier

CLAVDIVS
Master Sergeant - Bf 109E
Master Sergeant - Bf 109E
Posts: 455
Joined: Tue Feb 19, 2008 10:24 pm
Location: it's a Local Village for Local's UK

Post by CLAVDIVS » Tue May 27, 2008 12:51 pm

Hi All :lol:,

just working on a Fatimid Egyptian army list How do you do a BG with 2/3 Heavy foot 7 1/3 Light foot in the army list Builder program please.
Yours in the Hobby "CB"

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Tue May 27, 2008 5:48 pm

Hello, you have an example in the read me! :wink:
You put in one line the HF and the LF on an other line and you affect the same order of march to the BG.
Olivier

OldenTired
Sergeant First Class - Elite Panzer IIIL
Sergeant First Class - Elite Panzer IIIL
Posts: 435
Joined: Tue Jan 22, 2008 4:53 am

Post by OldenTired » Wed Jun 18, 2008 10:34 pm

so no versions that work in open office yet?

lionheartrjc
Corporal - Strongpoint
Corporal - Strongpoint
Posts: 59
Joined: Sun Mar 02, 2008 3:01 pm

Swordsmen not Swordmen please

Post by lionheartrjc » Wed Jul 02, 2008 3:19 pm

In the army calculator, can Swordmen be replaced with Swordsmen (which is correct English)?

I just feel that this spelling mistake detracts from what is a superb tool. Given the poor standard of my French I am impressed that the tool works in English so well.

Ghaznavid
1st Lieutenant - 15 cm sFH 18
1st Lieutenant - 15 cm sFH 18
Posts: 800
Joined: Wed Aug 29, 2007 1:44 am
Location: Germany

Post by Ghaznavid » Thu Jul 03, 2008 9:27 am

OldenTired wrote:so no versions that work in open office yet?
Guess not, but it's not really difficult to make it work in OpenOffice yourself.

Code: Select all

1.) Format -> Sheet -> Show, then select: Donées
2.) Enter a '0' (zero) into cell N6
3.) Same sheet, cell B1, replace: ="Traduction!$A$1:"&ADDRESS_XL(COUNTA($Traduction.A$1:A$65536);COUNTA(Language_choices);1;TRUE())
with this:="Traduction.$A$1:"&ADDRESS(COUNTA($Traduction.A$1:A$65536);COUNTA(Language_choices);1;"Traduction")
4.) Insert -> Names -> Define:  'Zone_Traduction' from this: =INDIRECT_XL($Données.$B$1)
to this: =INDIRECT($Données.$B$1)
5.) Format -> Sheet -> Hide
Save and you are done. It should now work properly with both Excel and OpenOffice. At least it works for me using OO2.4x under Linux.
Karsten


~ We are not surrounded, we are merely in a target rich environment. ~

nicofig
Field of Glory Moderator
Field of Glory Moderator
Posts: 743
Joined: Tue Aug 22, 2006 6:54 pm
Location: Toulon
Contact:

Post by nicofig » Mon Jul 07, 2008 6:55 pm

The new version 2.5.10 is on ligne.
:D
ImageImage

7RiclionLys7
Corporal - Strongpoint
Corporal - Strongpoint
Posts: 56
Joined: Thu May 29, 2008 1:44 pm

Post by 7RiclionLys7 » Mon Jul 07, 2008 9:33 pm

Hi thank for post the new version ^^ ! But the document not be translate for every players !! EXEL is not possess by everybody. Could You ask to Olivier to do file in Open office or Acrobate Readers ^^

Thank you :)

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Mon Jul 07, 2008 10:15 pm

I have an open office version in test but as I don't have it , I wait the test return before to post it.
Olivier

olivier
Lieutenant Colonel - Fw 190A
Lieutenant Colonel - Fw 190A
Posts: 1124
Joined: Mon Nov 06, 2006 5:49 pm
Location: Paris, France

Post by olivier » Wed Jul 09, 2008 6:28 am

Hello,
Finally, I upload today an open office version. :D
Thanks to all who aid me with the conversion and test. :)
Olivier

Omar
Sergeant - Panzer IIC
Sergeant - Panzer IIC
Posts: 192
Joined: Wed Jan 23, 2008 8:19 pm

Post by Omar » Mon Oct 20, 2008 11:59 pm

I cant seem to find the English version of this? Every one on http://fieldofglory.fr/spip.php?article2 seems to be in french.

Post Reply

Return to “Field of Glory : Ancient & Medieval Era 3000 BC-1500 AD : General Discussion”