Reply to thread

Message

<blockquote data-quote="Yarthok" data-source="post: 4421358" data-attributes="member: 64890">Thanks for all the hard work! This has made 4e char generation a breeze for my rpg group. &nbsp;I made a Ranger character and noticed one of the ranger encounter powers was misspelled. &nbsp;&quot;Thunertusk Boar Strike&quot;....Loses some of it's thunder <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":D" title="Big grin&nbsp; &nbsp; :D"&nbsp; data-smilie="8"data-shortname=":D" />Cell $Encounter.E10&nbsp;I have converted your worksheet to work for openoffice (at least for my ranger). Most of the changes made involve specifying FALSE in tables or changing blank table cells to have some value (zero), and mostly on the 'Race Overview' sheet. I'm not a openoffice guru, but it appears that oocalc is strict about requiring explicit conversion between text and numbers, so in a few places I needed to use VALUE(x) to get oocalc to convert strings to numbers. I don't own excel, so I don't know if my changes would break your version. This conversion was easier than v11, maybe it gets easier with practice. &nbsp;Again, thanks for the excellent work. Looking forward to the next version!</blockquote>

[QUOTE="Yarthok, post: 4421358, member: 64890"] Thanks for all the hard work! This has made 4e char generation a breeze for my rpg group. I made a Ranger character and noticed one of the ranger encounter powers was misspelled. "Thunertusk Boar Strike"....Loses some of it's [B]thunder[/B] :D Cell $Encounter.E10 I have converted your worksheet to work for openoffice (at least for my ranger). Most of the changes made involve specifying FALSE in tables or changing blank table cells to have some value (zero), and mostly on the 'Race Overview' sheet. I'm not a openoffice guru, but it appears that oocalc is strict about requiring explicit conversion between text and numbers, so in a few places I needed to use VALUE(x) to get oocalc to convert strings to numbers. I don't own excel, so I don't know if my changes would break your version. This conversion was easier than v11, maybe it gets easier with practice. Again, thanks for the excellent work. Looking forward to the next version! [/QUOTE]

Verification