News of xlsx4j

Does Docx4j /XLSX4J support Image Skew property?

In Row (sheet.xml) can F24 appear before B24.

My Excel is getting corrupted. Is this the reason?

<row r="24" ht="14.88188976377953" customHeight="true">
<c r="F24" s="3" t="s">
<v>1</v>
</c>
<c r="B24" s="1" t="s">
<v>2</v>
</c>
</row>

How to handle column + row merge together.

example : merging of A1, A2, B1, B4 cells.

Excel is getting corrupted if i insert
A1:A2
B1:B2
A1:B1
A2:B2

in merged cells.

<a:xfrm rot="18900000">

For the angles above 45 degrees the width and the height is getting interchanged after rotation and results in incorrect shape.

This behaviour is seen for angle above 45degrees. Rotation works fine for 0 - 45 degree.

Please suggest.

I have a bar chart (linked to Pivot table) in an xlsx, i need to change some values in that chart (via pivot table) and the updated chart needs to be exported as image, which i will need later to add it to a docx document, everything programmatically using docx4j.
I tried few ways, but no success.

Alternatively, it is also possible to copy the chart (with pivot) from Excel and paste to PPTX and ...

Hello,

Is there an easy way to apply a fill color to a cell? Im creating the cells with this code:

Code: Select all

private static Cell createCell(String content) {

        Cell cell = Context.getsmlObjectFactory().createCell();
       

        CTXstringWhitespace ctx = Context.getsmlObjectFactory().createCTXstringWhitespace();
        ctx.setValue(content);

        CTRst ctrst = new CTRst();
        ctrst.setT(ctx);

        cell.setT(STCellType.INLINE_STR);
        cell.setIs(ctrst); // add ctrst as inline string

        return cell;
      
    }


That i copied from some example here. Is there a way i can modify that to apply a fill color to ...

Hi.

When I open a xlsx file i got the following stack trace.


2019-06-12 09:21:56,924 INFO [org.docx4j.jaxb.Context] (main) java.vendor=Oracle Corporation
2019-06-12 09:21:56,924 INFO [org.docx4j.jaxb.Context] (main) java.version=1.8.0_212
2019-06-12 09:21:57,173 INFO [org.docx4j.jaxb.Context] (main) MOXy JAXB implementation intended..
2019-06-12 09:22:02,617 INFO [org.docx4j.jaxb.Context] (main) MOXy JAXB implementation is in use!
2019-06-12 09:22:02,932 INFO [org.docx4j.XmlUtils] (main) setProperty com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl
2019-06-12 09:22:02,933 INFO [org.docx4j.XmlUtils] (main) actual: com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl
2019-06-12 09:22:02,933 INFO [org.docx4j.XmlUtils] (main) setProperty com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl
2019-06-12 09:22:02,933 INFO [org.docx4j.XmlUtils] (main) actual: com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl ...

Jason,
First. Thank GOD for this project! This is an amazingly powerfull library. But I have some questions. It seems that initial creation of spreadsheets is quasi-complete. After creating a spreadsheet programmatically, I have to load it and then turn around and save it for it to be canonical. I discovered this when I tried to use Microsoft's Spreadsheet Compare tool to compare two different xls4j generated spreadsheets and the tool showed my workbooks as ...

I've have been able to create a Table in Word and perform cell merges (aka cell span, col span). But I am now using Docx4j (Xlsx4j) to create simple XLSX spreadsheets and need to perform a cell merge, but cannot find out how. I've searched google and he forums here. Does anyone know how? (a horizontal merge)

Thank you!

Can someone provide me a SIMPLE working example of how to setup and define a name on a cell?