ARMY LIST CALCULATOR
Moderators: terrys, hammy, philqw78, Slitherine Core, Field of Glory Moderators, Field of Glory Design
-
- Master Sergeant - Bf 109E
- Posts: 465
- Joined: Sun Jan 07, 2007 7:51 pm
- Location: Peterborough, UK
Hi,nicofig wrote:the version 2.5 corrected is online :
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
-
- Field Marshal - Elefant
- Posts: 5875
- Joined: Tue Jan 22, 2008 1:44 am
- Location: Southern Ontario, Canada
Sorting by Order of March Gone?
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.
Dan T.
-
- Field Marshal - Elefant
- Posts: 5875
- Joined: Tue Jan 22, 2008 1:44 am
- Location: Southern Ontario, Canada
-
- Sergeant First Class - Elite Panzer IIIL
- Posts: 435
- Joined: Tue Jan 22, 2008 4:53 am
-
- Corporal - Strongpoint
- Posts: 59
- Joined: Sun Mar 02, 2008 3:01 pm
Swordsmen not Swordmen please
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.
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.
-
- 1st Lieutenant - 15 cm sFH 18
- Posts: 800
- Joined: Wed Aug 29, 2007 1:44 am
- Location: Germany
Guess not, but it's not really difficult to make it work in OpenOffice yourself.OldenTired wrote:so no versions that work in open office yet?
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
Karsten
~ We are not surrounded, we are merely in a target rich environment. ~
~ We are not surrounded, we are merely in a target rich environment. ~
-
- Corporal - Strongpoint
- Posts: 56
- Joined: Thu May 29, 2008 1:44 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.