I'm trying to create some documentation of my rules. To do this, I'm copying and pasting them into Excel.
(Why? I'm writing some nice english comments for each rule and want to be able to filter by Rules, Comments and Feeders).
To make my comments stand out, I have coloured various pieces.
But when I paste it into Excel, the colours disappear.
Strangely, when I paste it into Lotus Notes, or MS Word, or Wordpad, the colours stay.
So my work around is to paste into Word, then copy and paste into Excel. Gross, but it works.
Anybody know a better way?
9.5.2
Excel 2003
Rules fonts
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Rules fonts
Use xdi sheets for your rules. This way you won't have to copy anything in to excel.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Community Contributor
- Posts: 312
- Joined: Mon May 12, 2008 8:11 am
- OLAP Product: TM1
- Version: TM1 11 and up
- Excel Version: Too many to count
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Rules fonts
Them as well. 

Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7