Needs review
Project:
Excel Serialization
Version:
2.1.x-dev
Component:
Code
Priority:
Normal
Category:
Feature request
Assigned:
Unassigned
Issue tags:
Reporter:
Created:
6 Jun 2019 at 18:03 UTC
Updated:
3 Aug 2025 at 10:34 UTC
Jump to comment: Most recent, Most recent file
Comments
Comment #2
br0kenComment #3
br0kenComment #4
br0kenComment #5
l0keWe had a long discussion regarding the approach and agreed on the next things:
strposandunserializeViewsExcelStyledFieldCellFormatterInterfaceso it can be processed in Ecoder.Comment #6
br0kenAfter hours of debugging I gave up because everything in Views infrastructure tries to cast a string type to the data and that seems logical since we're going to render things. Even if we manage to return an object after applying
display,style,rowandfieldViews plugins the theserializerservice will not be able to normalize the object we've preserved.This is not a trivial scenario because we need to jump back from an encoder to a field formatter. Right now I don't see an acceptable way to implement this solution without having ugly
strpos+unserialize.Comment #7
l0keConsidering the proposed solution works and except for the hack with
strposandunserializelooks good to me marking as RTBC.In the end, good enough is enough.
Comment #8
br0kenComment #9
rosinegrean commentedComment #10
br0kenThis patch provides full flexibility in manipulating by a worksheet, cell, and its value. See attached documentation.
Comment #11
bahbka commentedAdjusted #10 to be applied to the latest stable version.
Comment #12
theemstra commentedCleaning old issues from previous releases.
We can include it, when someone provides a MR or patch that can be applied to current codebase, we'll test and merge!
Comment #15
mably commentedImplemented some basic Excel formatters (string, datetime, timestamp) that add new configuration options allowing to collapse/hide columns, define horizontal alignment, set font bold or italic.
Any feedback will be greatly appreciated.
Comment #16
mably commentedJust added an ExcelImageFormatter allowing to insert images into your exported Excel files:
Comment #18
mably commentedThis can now be tested in the new Excel Serialization Extras sandbox module.