Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Version 2.3 is released
This version fixes a problem where the default cell formatting was not being applied when reading an Excel spreadsheet. This would typically be seen by the initial formatting in a cell not being honoured when read in (which can be seen in the table at the bottom of the tool's window). This should fix daplunk's problem with the columns not starting with BOLD text. Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
#461 |
Senior Member
Join Date: Jan 2016
Location: Adelaide, Australia
Posts: 2,294
|
Not sure if you can feel it... But i'm hugging you right now.
Realm Works - Community Links Realm Work and Hero Lab Videos Ream Works Facebook User Group CC3+ Facebook User Group D&D 5e Community Pack - Contributor General Hero Lab Support & Community Resources D&D 5e Community Pack - Install Instructions / D&D 5e Community Pack - Log Fault / D&D 5e Community Pack - Editor Knowledge Base Obsidian Obsidian TTRPG Tutorials |
#462 |
Senior Member
Join Date: Aug 2010
Location: Calgary, Alberta
Posts: 385
|
Keeping both of you, happy and productive should be a goal for the rest of us too.
|
#463 |
Member
Join Date: Mar 2018
Posts: 46
|
I created a file using the tool. So far so good. Now I go to import that to a realm and I get an error every time.
Code:
C++ Exception: Not in a span at line 1633 in file utility.cpp |
#464 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Quote:
Does your source data have HTML inside it? If so, is it all formatted properly? If you don't have any HTML, then I'll need to see the source file and the generated RWexport file to see what might be causing the problem. Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
|
#465 |
Member
Join Date: Mar 2018
Posts: 46
|
Quote:
I have the excel broken up so that for something like an actions, it has the title which is generally bold and italic in one field, and then the description in the next field. I put the bold and italic tags around those cell references. Code:
=IF(AK4<>"","<html><b><i>"&AK4&". </i></b>"&AL4&"</html>"&IF(DA4<>""," "&DA4,"")&IF(DG4<>""," "&DG4,"")&IF(DH4<>""," "&DH4,""),"") The additional lines are incase the description has more than one paragraph. So AK4 has "Multiattack" in the cell. AL4 has "The creature makes 2 attacks with its claws." in that cell. In this example the other cells are empty. |
|
#466 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
I can't remember exactly how embedded HTML works with Realm Works, but I don't think you need the "<html></html>" tags around the i and b tags to get it displayed in RW.
Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
#467 |
Member
Join Date: Mar 2018
Posts: 46
|
|
#468 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Can you shrink down your source file to just the line or lines that are causing the problem?
Do the cells that you are joining together (e.g. AK4) have the "<" symbol to be displayed? This will cause problems with the HTML. Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
#469 |
Member
Join Date: Mar 2018
Posts: 46
|
Quote:
Code:
=IF(AI2<>"","<html><b><i>"&AI2&". </i></b>"&AJ2&IF(IL2<>""," -"&IM2&" -"&IN2&" -"&IO2,"")&IF(BD2<>""," "&BD2,"")&IF(LF2<>""," -"&LG2&" -"&LH2,"")&IF(IF2<>""," "&IF2,"")&IF(AI2<>"","</html>",""),"") |
|
#470 |
|
|