Rules fonts

Post Reply
pmakulski
Posts: 60
Joined: Mon Jun 06, 2011 6:07 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Rules fonts

Post by pmakulski »

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
User avatar
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

Post by jim wood »

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
Paul Segal
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

Re: Rules fonts

Post by Paul Segal »

Did you mean .xru sheets?
Paul
User avatar
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

Post by jim wood »

Them as well. :oops:
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
Post Reply