Hi,

Is it possible to put borders on the filled cells in exported excel document?

Thanks!

CommentFileSizeAuthor
#3 views_data_export-2027433-3.patch857 bytesLes Lim
#1 views_data_export-xls_headers.patch422 bytesLes Lim
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Les Lim’s picture

Les Lim
he/they
Primary language English
CreditAttribution: Les Lim commented
Category: Support request » Feature request
Issue summary: View changes
Status: Active » Needs review
FileSize
views_data_export-xls_headers.patch422 bytes

Excel will draw the spreadsheet with borders if we include a meta tag for ProgId that identifies the export as an Excel sheet. Patch attached.

Status: Needs review » Needs work

The last submitted patch, 1: views_data_export-xls_headers.patch, failed testing.

Les Lim’s picture

Les Lim
he/they
Primary language English
CreditAttribution: Les Lim commented
Status: Needs work » Needs review
FileSize
views_data_export-2027433-3.patch857 bytes

Same patch with updated tests.

Priti197’s picture

Priti197 CreditAttribution: Priti197 commented

#3 patch still not applying any borders in exported excel document. Any idea ?

SteffenR’s picture

SteffenR
Primary language English
Location Bremen
CreditAttribution: SteffenR commented

@Les Lim - thanks for supplyinga patch for this issue - i just tested this patch with office on my Mac / Office 2011 and it's working fine for me.

Steven Jones’s picture

Steven Jones CreditAttribution: Steven Jones commented
Status: Needs review » Postponed
Issue tags: +new formats

As per https://drupal.org/node/2204803

Les Lim’s picture

Les Lim
he/they
Primary language English
CreditAttribution: Les Lim commented

@Steven Jones: XLS is a currently supported format, though, not a new one.

Les Lim’s picture

Les Lim
he/they
Primary language English
CreditAttribution: Les Lim commented
Status: Postponed » Needs review

Setting back to "Needs review" for the moment.

Les Lim’s picture

Les Lim
he/they
Primary language English
CreditAttribution: Les Lim commented
Issue tags: -new formats

Removing tag.