Bug 66377 - Feature request: Format As Table
Summary: Feature request: Format As Table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.0.1 rc
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
: 66378 66379 (view as bug list)
Depends on:
Blocks:
 
Reported: 2013-06-29 18:48 UTC by Luke
Modified: 2014-08-18 16:40 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
MS .xlsx file imports incorrectly (468.90 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-06-29 19:10 UTC, Luke
Details
Comparison of xlsx in Excel vs Calc 1-3 (376.59 KB, image/png)
2013-06-29 19:14 UTC, Luke
Details

Description Luke 2013-06-29 18:48:11 UTC
This bug was tested LibreOffice v4.1 RC1 running in windows 7 and XP. It appears that LibreOffice loses formatting when importing MS .docx files. I have attached an example.

Steps to reproduce the bug:
1. Open attached Demo-2012SummerOlympics.xlsx document in calc
2. Open attached Demo-2012SummerOlympics.xlsx document in Excel2010/Office 365
3. Compare the documents. 

Note item #1 from the screenshot that the rows should alternate from white to blue.
Comment 1 Luke 2013-06-29 19:10:21 UTC
Created attachment 81707 [details]
MS .xlsx file imports incorrectly
Comment 2 Luke 2013-06-29 19:14:36 UTC
Created attachment 81713 [details]
Comparison of xlsx in Excel vs Calc 1-3
Comment 3 Markus Mohrhard 2013-06-29 19:19:29 UTC
THis is the missing Format As Table feature that is currently developed as part of the GSoC project.
Comment 4 Markus Mohrhard 2013-06-29 19:20:35 UTC
*** Bug 66378 has been marked as a duplicate of this bug. ***
Comment 5 Markus Mohrhard 2013-06-29 19:21:21 UTC
*** Bug 66379 has been marked as a duplicate of this bug. ***
Comment 6 Joel Madero 2013-06-29 19:26:11 UTC
Marking as NEW as Markus has confirmed that it's being developed now. Markus - you happen to know who is developing it, then we can move to assigned.
Comment 7 Markus Mohrhard 2013-06-29 19:29:17 UTC
(In reply to comment #6)
> Marking as NEW as Markus has confirmed that it's being developed now. Markus
> - you happen to know who is developing it, then we can move to assigned.

If at all it should be kept in New. It is Kohei and my GSoC student so we are aware of the bug. Please don't assign this bug to the student.

IMO it is bad to force him to look and care bug reports at this stage as he should focus on the tasks he gets assigned by us.
Comment 8 Xisco Faulí 2014-03-31 15:55:41 UTC
This issue is still reproducible:
   - Libreoffice 4.1.5.3 Build ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24
   - Libreoffice 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f
   - Libreoffice 4.3.0.0.alpha0 Build ID: b6a43bcbbf9e9a5655fd36fd4c8ef72d585f67b0


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.