CDR Tickets

I've created this ticket to capture our notes related to the upcoming Office 365 Pilot. I've added everyone as a watcher, so if you prefer not to be included feel free to remove yourself.

For patient summaries, some of the formatting when copy/pasting QC reports is not preserved:

• Keypoint heading do not show up in bold

• Keypoint boxes are not shown as boxes. Those are shown as simple lists instead.

• For nested lists the bullets aren't adjusted based on the level of indentation.

• Background color for Image replacement boxes is not preserved, the text isn't centered.

• Permanent comments are dropped (Breast cancer treatment for patients), comments, however, are kept but bold and itatlics styling is removed.

• Formatting for HP summary wasn't preserved at all.

Some of these things may be configurable but aren't working the same when compared to Office 2010.

It appears that for smaller summaries (i.e. CDR62902) the formatting for HP documents is mostly preserved. Table formatting, however is not.

I was able to load our Word Macros and run Victoria's macro in Word 365 after updating and saving our 'CDR Footer' template in Normal.dot.
The speed of running the macros is far from impressive but I guess it's OK at least for that small document I've used.

I'll have to figure out how we can setup the Macros so they are loaded automatically and how to customize Word to add shortcut icons for the macros.

It appears that about 150kB (XML document size) is the limit for which the formatting of a copy/paste will be preserved. This results in about 15% (ca 100 summaries) not being able to be processed in Word.

I was able to create a shortcut to one of our summary macros to the Quck Access Toolbar.

I was also able to run the Word Macro that creates the TOC, however, it included every single citation reference as part of the TOC. This behavior may need some additional work.

I have good news. Erika has the O365 version installed on her workstation now and I was able to test the copy/paste process again. Almost all of the problems earlier reported weren't showing up anymore and even for our largest summary all of the formatting was preserved. I looked through a few summaries with tables, images, lists, etc, and it all looked much better compared to using the MyApps version of Word.

The only issue that I noticed were some comments that were displayed with a grey background on the QC report were showing up without the grey background but the formatting (italic/bold) was preserved.

I forgot to mention: Creating a table of content, which included the references on the MyApps version, works fine on the locally installed version and it's a lot faster, too.

A small caveat: I didn't want to keep Erika from giving up her computer for me to test for too long so I have only tested this using IE as the browser. The results may differ when using one of the other browsers.

Volker, did you have a chance to try any of the Word macros on Erika's machine?

No, I did not because the Word Macros were already working properly when I used the MyApps version and therefore I did not specifically test those.

Victoria and I tested Word 2016 installed on a loaner laptop and came across two very minor issues related to spacing:

1. Some lost white space around headings. This was inconsistent, and seemed to most often happen around images. I will attach the Melanoma Treatment Patient summary as an example (see comments where white space was lost when copying/pasting from the QC report into Word).

2. Some instances of missing spaces around links. We've seen this in the current version of Word (see OCECDR-3894), so it is not new. But I figured this was still worth reporting. There's one example of this in the Melanoma Treatment patient summary and one example in the Genetics of Prostate summary, which I will attach.

We did not see the comment issue - I saw comments with a gray background and comments without a gray background. Maybe that's a sporadic thing, too?

I'm planning to borrow the same loaner laptop again after the holidays. Then, I'd like to try running some Word macros (with Volker's help) just to be sure they work okay on the desktop version, too.

I didn't notice the spacing issue for headings around images but I did notice that headings immediately following a list had less space above the heading in Word compared to the HTML output.

Let me know when you want to setup the macros on the laptop. It should be fairly simple to set it up.

Robin, if you have time tomorrow we could probably try to setup the macros on the loaner laptop.

Yes, tomorrow sounds good!

Robin and I were able to setup the loaner laptop with our CDR macro collection and run Robin's summary conversion macro successfully.

Closing ticket.