search

yalelibrary / YUL-DC

Preliminary issue tracking for Yale University Libraries Digital Collections project
3 stars 0 forks source link

[BUG] Excel download row 1 blank #2923

Closed sshetenhelm closed 2 months ago

sshetenhelm commented 2 months ago

Story When a staff member downloads an excel file from the parent_objects table in Management using the Excel button, the excel file that is delivered has a blank row for row 1. The blank row appears to contain a bunch of merged cells.

We would like row 1 of the spreadsheet to contain the usual column header information (oid, admin_set, etc.) in individual cells.

This issue does not occur when downloading CSVs.

Acceptance

jpengst commented 2 months ago

It looks like the first row contains the title of the document (it should be in the middle of the cell). I'm also not seeing any merged cells. Can anyone else confirm?

laurenb33 commented 2 months ago

Hey @jpengst - that's correct. It appears that the first row is just one large cell and the title shows when I highlight it: Image

jpengst commented 2 months ago

OK, thanks for checking! Do we have any examples of "The blank row appears to contain a bunch of merged cells."? I'm not seeing that behavior on my end

sshetenhelm commented 2 months ago

Example of row 1 = merged cell

jpengst commented 2 months ago

Ohhh, OK! Sorry, I thought a merged cell meant that all the data was merged into 1 cell. I'm not too familiar with Excel, if you haven't noticed haha

jpengst commented 2 months ago

PR: https://github.com/yalelibrary/yul-dc-management/pull/1437

K8Sewell commented 2 months ago

Deployed to Test with release v2.72.0

K8Sewell commented 2 months ago

Looking good on Test. Will promote to UAT.

Image

sshetenhelm commented 2 months ago

Works as expected on UAT! Thank you!

Ready to close