Author Topic: Excell DO help  (Read 16642 times)

0 Members and 1 Guest are viewing this topic.

Offline X-IHH/Wallac Isilviere (Kasper)

  • Sovereign
  • ******
  • Posts: 1.607
  • Regency: 18
  • Gender: Male
  • Pontiff Wallac Isilviere, High Prefect of the IHH
Re: Excell DO help
« Reply #15 on: March 16, 2012, 05:58:01 PM »
Thx  :-[
His Holiness Wallac Isilviere, Pontiff of All Anuire, High Prefect of the Impregnable Heart of Haelyn

Offline DM B

  • Green Knight
  • Deity
  • Emperor
  • *
  • Posts: 5.210
  • Regency: 51
  • Gender: Male
    • Twilightpeaks.net - Hone of Ruins of Empire
Re: Excell DO help
« Reply #16 on: March 16, 2012, 10:18:44 PM »
Mark rows - say 151 to 165 - copy, insert copied cells. Done. You now have 15 more lines with correct formatting which also doesn't break any formulas.

How do I expand DO as to make space for say five more units ("gift" of 5 Irregulars from our beloved DM)? I can do the above copy paste but I would like to have more rows. I have only row 167 free to use now as row 168 is the Army Unit Total etc?

The DM will remember to add them to your DO if you can't.
DM Bjørn

Offline X-IHH/Wallac Isilviere (Kasper)

  • Sovereign
  • ******
  • Posts: 1.607
  • Regency: 18
  • Gender: Male
  • Pontiff Wallac Isilviere, High Prefect of the IHH
Re: Excell DO help
« Reply #17 on: March 16, 2012, 10:38:43 PM »
Mark rows - say 151 to 165 - copy, insert copied cells. Done. You now have 15 more lines with correct formatting which also doesn't break any formulas.

How do I expand DO as to make space for say five more units ("gift" of 5 Irregulars from our beloved DM)? I can do the above copy paste but I would like to have more rows. I have only row 167 free to use now as row 168 is the Army Unit Total etc?

The DM will remember to add them to your DO if you can't.

Thank for your consideration :-)


I seems to have managed even to find the annoying locations you have put them originally so you can have your fun. I'll move them this season if you'll allow me using wage war action anyway
His Holiness Wallac Isilviere, Pontiff of All Anuire, High Prefect of the Impregnable Heart of Haelyn

Offline DM B

  • Green Knight
  • Deity
  • Emperor
  • *
  • Posts: 5.210
  • Regency: 51
  • Gender: Male
    • Twilightpeaks.net - Hone of Ruins of Empire
Re: Excell DO help
« Reply #18 on: March 16, 2012, 11:29:15 PM »
They are your units, so you can move them :)
DM Bjørn

Offline X-IHH/Wallac Isilviere (Kasper)

  • Sovereign
  • ******
  • Posts: 1.607
  • Regency: 18
  • Gender: Male
  • Pontiff Wallac Isilviere, High Prefect of the IHH
Re: Excell DO help
« Reply #19 on: March 16, 2012, 11:34:18 PM »
They are your units, so you can move them :)

Aren’t you a dear?
His Holiness Wallac Isilviere, Pontiff of All Anuire, High Prefect of the Impregnable Heart of Haelyn

Offline X-Avanil/Aubrae Avan (Thorsten)

  • Former players
  • Sovereign
  • ******
  • Posts: 1.142
  • Regency: 35
  • Gender: Male
  • Princess Aubrae Avan
Re: Excell DO help
« Reply #20 on: March 24, 2012, 01:53:10 PM »
Quick question:

I have a text box in my DO where my descriptions are in. But I now notice that sometimes the words are broken up, lines are moved down and some letters disappear. This happens quite often with the letter S or O.

For example the following sentence

Quote
“Uh..” Carpinter replied eloquently."

in my textbox is broken up, so that it appears as following:

Quote
“Uh..” Carpinter replied el

quently"

What's with that?
Aubrae Avan,
Princess of Avanil, Duchess of Taeghas

Diplomacy is the art of letting someone else have your way.

Offline X-Avanil/Aubrae Avan (Thorsten)

  • Former players
  • Sovereign
  • ******
  • Posts: 1.142
  • Regency: 35
  • Gender: Male
  • Princess Aubrae Avan
Re: Excell DO help
« Reply #21 on: March 24, 2012, 01:58:06 PM »
Quick question:

I have a text box in my DO where my descriptions are in. But I now notice that sometimes the words are broken up, lines are moved down and some letters disappear. This happens quite often with the letter S or O.

For example the following sentence

Quote
“Uh..” Carpinter replied eloquently."

in my textbox is broken up, so that it appears as following:

Quote
“Uh..” Carpinter replied el

quently"

What's with that?


Following up on this, if I turn the offending letter into a capital version, the lines are once more restored and unbroken.
Aubrae Avan,
Princess of Avanil, Duchess of Taeghas

Diplomacy is the art of letting someone else have your way.

Offline X-Brosengae [Cloene] (Linde)

  • Former players
  • Noble
  • ****
  • Posts: 460
  • Regency: 19
  • Gender: Male
Re: Excell DO help
« Reply #22 on: March 24, 2012, 05:39:43 PM »
It is a trick to keep you busy editing text instead of plotting for world domination

Offline X-Avanil/Aubrae Avan (Thorsten)

  • Former players
  • Sovereign
  • ******
  • Posts: 1.142
  • Regency: 35
  • Gender: Male
  • Princess Aubrae Avan
Re: Excell DO help
« Reply #23 on: March 24, 2012, 05:40:56 PM »
It is a trick to keep you busy editing text instead of plotting for world domination

It's working.
Aubrae Avan,
Princess of Avanil, Duchess of Taeghas

Diplomacy is the art of letting someone else have your way.

Offline X-Osoerde (Alan)

  • The Dragon
  • Former players
  • Sovereign
  • ******
  • Posts: 1.394
  • Regency: 21
  • Gender: Male
Re: Excell DO help
« Reply #24 on: March 24, 2012, 06:46:39 PM »
Thorsten, seems very kooky to me.

Do the cells have "Wrap Text" turns on or off?
Yes, wyrmling, the meat is made all the more tender by armor...

Offline DM B

  • Green Knight
  • Deity
  • Emperor
  • *
  • Posts: 5.210
  • Regency: 51
  • Gender: Male
    • Twilightpeaks.net - Hone of Ruins of Empire
Re: Excell DO help
« Reply #25 on: April 30, 2012, 02:11:41 PM »
Can someone tell me where Cohesion went???
DM Bjørn

Offline X-Points East

  • Grand-Maester of the P&H
  • Former players
  • Regent
  • *****
  • Posts: 626
  • Regency: 15
Re: Excell DO help
« Reply #26 on: April 30, 2012, 08:40:36 PM »

Can someone tell me where Cohesion went???

OoC:

Cohesion can be found in the WAR worksheet.

« Last Edit: April 30, 2012, 08:56:30 PM by Points East/EL »

Offline DM B

  • Green Knight
  • Deity
  • Emperor
  • *
  • Posts: 5.210
  • Regency: 51
  • Gender: Male
    • Twilightpeaks.net - Hone of Ruins of Empire
Re: Excell DO help
« Reply #27 on: May 02, 2012, 11:04:08 AM »
I found it shortly after my post.

It's a very sensible location; but I need to be able to track cohesion (not hits) in the asset tab.
DM Bjørn