Hi,
I have built a complicated row definition in MR with thousands lines and I have to edit it from time to time by following certain logic rules according to our business operation change.
Instead of editing it in MR, I usually export and edit it in Excel in order to use certain Excel formula. Then I copy and paste it back to MR row definition screen.
When I format cells in Excel with colour, then copy and paste back to MR. It will keep the colour formatting.
However, when I try to export to Excel by copying and pasting, the colour formatting for cells will be gone in Excel...and I am sure I have chosen the right paste option to keep the formatting.
It will be so annoying to go through the colour formatting for hundreds lines each time when I edit the row definition.
I know I could keep an Excel file version which has the colour formatting and the latest editing detail so I can work on it every time instead of exporting it from MR, but am I missing out MR function? Or that is some limitation of MR?
Can anyone help?
Thanks.
