Bug 66377 - Feature request: Format As Table, Excel Table Styles
Summary: Feature request: Format As Table, Excel Table Styles
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: high enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
: 66378 66379 89107 91329 112371 122109 122917 130637 149436 (view as bug list)
Depends on:
Blocks: Calc-Enhancements XLSX XLSX-DataRange
  Show dependency treegraph
 
Reported: 2013-06-29 18:48 UTC by Luke
Modified: 2023-07-21 05:04 UTC (History)
20 users (show)

See Also:
Crash report or crash signature:


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
Comparison of xlsx in Excel 2010 vs Calc 5.0 (231.94 KB, image/png)
2015-05-11 07:56 UTC, Timur
Details

Note You need to log in before you can comment on or make changes to this bug.
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
Comment 9 Luke 2015-05-11 06:43:20 UTC
*** Bug 89107 has been marked as a duplicate of this bug. ***
Comment 10 Luke 2015-05-11 06:53:33 UTC
*** Bug 81711 has been marked as a duplicate of this bug. ***
Comment 11 Timur 2015-05-11 07:56:25 UTC
Created attachment 115487 [details]
Comparison of xlsx in Excel 2010 vs Calc 5.0

There are some improvements in LO 5.0.
Comment 12 QA Administrators 2017-01-03 19:40:17 UTC Comment hidden (obsolete)
Comment 13 Luke 2017-01-04 02:00:36 UTC
Still not table formatting in Version: 5.4.0.0.alpha0+ (x64)
Build ID: bf80bbb7b75febc2769d6b64e6981224982f8fe2
Comment 14 QA Administrators 2018-01-05 03:41:51 UTC Comment hidden (obsolete)
Comment 15 Aron Budea 2018-05-16 23:51:50 UTC
Same in 6.1 alpha1.
Comment 16 Aron Budea 2019-03-08 06:03:49 UTC
*** Bug 112371 has been marked as a duplicate of this bug. ***
Comment 17 Aron Budea 2019-03-08 06:04:31 UTC
*** Bug 122917 has been marked as a duplicate of this bug. ***
Comment 18 Aron Budea 2019-03-08 06:04:45 UTC
*** Bug 122109 has been marked as a duplicate of this bug. ***
Comment 19 Gabor Kelemen (allotropia) 2019-04-16 14:26:51 UTC
*** Bug 91329 has been marked as a duplicate of this bug. ***
Comment 20 NISZ LibreOffice Team 2020-02-14 07:24:04 UTC
*** Bug 130637 has been marked as a duplicate of this bug. ***
Comment 21 Timur 2022-06-03 12:15:51 UTC
*** Bug 149436 has been marked as a duplicate of this bug. ***