[Bug 58719] New: Horizontal alignment is not rendered correctly in Safari for IOS

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 58719] New: Horizontal alignment is not rendered correctly in Safari for IOS

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58719

            Bug ID: 58719
           Summary: Horizontal alignment is not rendered correctly in
                    Safari for IOS
           Product: POI
           Version: 3.13-FINAL
          Hardware: Other
                OS: other
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]

Assigning styles which apply horizontal alignment appears correctly in Excel,
but not in Safari for IOS.  Test code below produces output which has a left
and right alignment applied to different cells, but they render as left
alignment in both cases when viewed in Safari for IOS:

...
public void test(){
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheetA = wb.createSheet("sheet_a");
        Row row0 = sheetA.createRow(0);

        XSSFCellStyle styleA = wb.createCellStyle();
        styleA.setAlignment(HorizontalAlignment.LEFT);
        XSSFCellStyle styleB = wb.createCellStyle();
        styleB.setAlignment(HorizontalAlignment.RIGHT);

        Cell cellA0 = row0.createCell(0);
        cellA0.setCellStyle(styleA);
        cellA0.setCellValue("asdf");
        Cell cellB0 = row0.createCell(1);
        cellB0.setCellStyle(styleB);
        cellB0.setCellValue("qwerty");

        try{
            FileOutputStream fileOut = new
FileOutputStream("exampleFile.xlsx");
            wb.write(fileOut);
            fileOut.close();
        } catch (IOException ioe){
            ioe.printStackTrace();
        }
    }
...

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 58719] Horizontal alignment is not rendered correctly in Safari for IOS

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58719

--- Comment #1 from Javen O'Neal <[hidden email]> ---
How does the XML compare between what's generated by POI and what's generated
by Excel, LibreOffice, or OpenOffice?

How does a file that is created in Excel, with horizontally aligned cells look
in Safari for iOS?

I don't have an iOS device, so I can't test this to determine if this is a bug
in Safari or POI. Can Safari natively display OpenXML files? That's cool.
Firefox and Chrome can't.

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 58719] Horizontal alignment is not rendered correctly in Safari for IOS

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58719

Javen O'Neal <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 58719] Horizontal alignment is not rendered correctly in Safari for IOS

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58719

--- Comment #2 from Jun Whang <[hidden email]> ---
Created attachment 33338
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33338&action=edit
Original test file which displays improperly in Safari

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 58719] Horizontal alignment is not rendered correctly in Safari for IOS

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58719

--- Comment #3 from Jun Whang <[hidden email]> ---
Created attachment 33339
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33339&action=edit
Original example file opened in Excel, then saved with a different name

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 58719] Horizontal alignment is not rendered correctly in Safari for IOS

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58719

Jun Whang <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #4 from Jun Whang <[hidden email]> ---
I ran a recursive diff between the contents of the two files; I notice that the
MS version has theme assets but the overall structure looks similar otherwise.
When viewing the file level diffs, they have numerous deltas but I'm not sure
which ones are meaningful.  Please let me know if you want me to zip up the
delta reports and attach it to this bug.


I attached the original test file as well as a version of that file saved by MS
Excel.  The differences in behavior are:

--Original test file created via test program in initial description
(exampleFile.xlsx):
- displays correctly in MS Excel (one cell left aligned, other cell right
aligned)
- displays correctly in Google Drive viewer
- on download request, renders *incorrectly* in Safari with both cells left
aligned.

--Test file created from MS Excel by saving original test XSLX
file(exampleFile_Excel_saved.xlsx):
- displays correctly in MS Excel (one cell left aligned, other cell right
aligned)
- displays correctly in Google Drive viewer
- on download request, renders in Safari *correctly* with one cell left
aligned, other cell right aligned.


It appears Safari can display this content; with the exception of this issue,
more complex content appears to be rendering correctly.  I'm checking the
functionality by uploading the XLSX file to a google drive location.  Selecting
the file displays the content in Google's browser renderer, but choosing to
download the file is when Safari appears to take over to render the file.

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 58719] Horizontal alignment is not rendered correctly in Safari for IOS

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=58719

ithan <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]