CDR Tickets

Issue Number 4716
Summary Excel sorting issues - Glossary Concept Documents Modified Report
Created 2019-11-18 17:08:43
Issue Type Inquiry
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2019-11-19 14:16:57
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.252517
Description

We are having excel sorting issues using data from the Glossary Concept Documents Modified Report. We don't see the same problem on PROD. When we sort on the following three columns, the following error message is displayed and the sort is not completed. The problem appears to be the Last comment column.

Published?
Date Last Modified
Last Comment

Comment entered 2019-11-19 11:34:35 by Kline, Bob (NIH/NCI) [C]

I believe Margaret said in the Thursday meeting that this wasn't intended to be entered as an issue.

Comment entered 2019-11-19 11:59:00 by Kline, Bob (NIH/NCI) [C]

Oops! Wrong ticket. 😛

Comment entered 2019-11-19 14:16:57 by Kline, Bob (NIH/NCI) [C]

You can always select the range you want to sort in that situation. However, I went ahead and removed the merge of the note at the bottom of the report so that its display now spills over into the adjacent cells. Please try the sort again.

Comment entered 2019-11-20 10:18:27 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Comment entered 2020-02-26 15:45:13 by Osei-Poku, William (NIH/NCI) [C]

Verified on PROD. Thanks!

Attachments
File Name Posted User
Sorting_error.PNG 2019-11-18 17:08:24 Osei-Poku, William (NIH/NCI) [C]
SortingIssues.PNG 2019-11-18 17:08:24 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001626