Bug 119342 - EDITING: Pasted HTML table into Calc can't optimize width
Summary: EDITING: Pasted HTML table into Calc can't optimize width
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Regressions-HarfBuzz
  Show dependency treegraph
 
Reported: 2018-08-18 09:38 UTC by Daniel Oakey
Modified: 2022-08-22 23:36 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel Oakey 2018-08-18 09:38:33 UTC
Description:
If I copy an HTML table from a web page, I can paste that table into Calc. However, if I right-click on the highlighted column headers and click "Optimal Width..." and click ok, the column will not optimize the width. The columns will likewise not auto-fit the width if I double click the column edges.

Steps to Reproduce:
1. Create a simple HTML table and save it to an file, ie: <table><tr><td>item 1</td><td>item 2</td></tr></table>
2. Open the HTML in your favorite internet browser
3. Highlight the text in the webpage and copy it to the cells in Calc
4. Attempt to set the columns to optimal width by double-clicking the edges between columns or by using the "Optimize Width" tool.

Actual Results:
Columns do not optimize width

Expected Results:
The columns should optimize width. Excel does not have this issue.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Comment 1 Daniel Oakey 2018-08-18 09:48:42 UTC
If any cells in a column contain text that will be interpreted as a number, the cells will optimize width to the width of that number. For example:

<table>
    <tr><td>item 1</td><td>item 2</td></tr>
    <tr><td>1</td><td>1</td></tr>
</table>
Comment 2 Heinz Repp 2018-08-23 08:04:39 UTC
Same bug bites me too: pasted table from Firefox to Calc, and optimze column width just resets columns to default width, leading to wrapped text and cut off numbers.
(Libreoffice 6.1.0.3 on Debian testing 64bit)
Comment 3 Heinz Repp 2018-08-23 08:07:53 UTC
Additional info: when I remove direct formatting from the pasted table, optimize column width works again like it should.
Comment 4 Xisco Faulí 2018-08-25 15:27:54 UTC
For testing this, I used https://www.w3schools.com/html/tryit.asp?filename=tryhtml_table

Regression introduced by:

author	Khaled Hosny <khaledhosny@eglug.org>	2016-11-02 23:52:06 +0200
committer	Khaled Hosny <khaledhosny@eglug.org>	2016-11-03 00:17:06 +0000
commit 8f2dd1df1d6cc94ebbc1149de72bc6d6dffa6533 (patch)
tree db496889434c484a87b13ffcc4650d65e6672129
parent c8be45889217c555e4bec92af838d0524ceba4e0 (diff)
Revert "Revert "Enable the new text layout engine by default""
This reverts commit 3950166877bf1308f9e449992e20b558342af825.
Comment 5 QA Administrators 2019-09-02 09:21:59 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2021-09-02 03:52:21 UTC Comment hidden (obsolete)
Comment 7 ⁨خالد حسني⁩ 2022-08-17 01:43:37 UTC
I can’t possibly imagine what in the HarfBuzz-based layout engine could affect something like this. I tested even Apache Open Office and it gives me the same behavior as LO; the last column from comment 4 optimizes but the other two don’t.

Please attach a Calc file where one can reproduce this, and specify the LO version and OS where this issue was not present.