Allow rendering of excel sheets as a paragraph (MGNLXLS-1)

[MGNLXLS-2] Excel parsing and html rendering Created: 16/May/07  Updated: 16/Sep/15  Resolved: 18/May/07

Status: Closed
Project: Excel Renderer (closed)
Component/s: None
Affects Version/s: None
Fix Version/s: 1.0

Type: Sub-task Priority: Major
Reporter: Magnolia International Assignee: Magnolia International
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Template:
Date of First Response:

 Description   

Will use jexcelapi for this first impl



 Comments   
Comment by Magnolia International [ 16/May/07 ]

For the record, after some tests, using jexcelapi, the following was possible and rendered pretty well (but using inline styles)

  • rendering of a specific sheet from the document, by name or index.
  • formulas - at least basic ones seem to work well
  • background colors
  • cell style (bold, font color, font size)
  • multi line cells (we display them including the original linebreaks . i.e replacing lb with <br> tags)
  • spanning multiple rows/ columns

to check / see if we need to render and if it is possible at all:

  • floating boxes
  • cell "notes"
  • empty rows used for layout
  • empty columns or cells used for layout (ie text from previous cell overflowing)
  • images ?? (seems not worth the effort)
Comment by Magnolia International [ 18/May/07 ]

Borders are currently not supported; mostly because it is quite a burden to get them right from the excel format: unlike in css, the border definition is not specified on a single cell, but is also shared with the adjacent cells. (ie if cell A1 has a right border, then cell A2 will automatically have a left border)

Please open new issues if any of the above unsupported features would be necessary (floating boxes, notes, images, empty cells/rows/columns, overflowing text, images, or other) - testcases and patches are welcome as usual.

Comment by Michael Mühlebach [ 16/Sep/15 ]

This ticket was closed because former resolved tickets are deemed to be closed now. If this assumption is untrue in this particular case please feel free to reopen the ticket again.

Generated at Mon Feb 12 01:46:44 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.