Bug 150002 - LibreOfficeCalc does not work correctly with "<b>" tags in xls files
Summary: LibreOfficeCalc does not work correctly with "<b>" tags in xls files
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.4.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: MSO-XML2003
  Show dependency tree / graph
 
Reported: 2022-07-15 09:03 UTC by Pavel
Modified: 2023-12-01 22:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
card number (6.31 KB, application/vnd.ms-excel)
2022-07-18 14:06 UTC, Pavel 		Details
printscreen from excel (8.84 KB, image/png)
2022-07-18 18:51 UTC, raal 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Pavel 2022-07-15 09:03:21 UTC 
Description:
If program tries to open xls file with such kind of text <b>some text</b>, you cannot see it in the cell.

Steps to Reproduce:
1.Create some xls file with content like "<Row>
			<Cell ss:MergeAcross="11" ss:StyleID="Default">
				<ss:Data ss:Type="String"
				     xmlns="http://www.w3.org/TR/REC-html40">Correct text: <b>text to show</b> </ss:Data>
			</Cell>
		</Row>"
2. Open this file in Libreoffice Calc
3. See that "text to show" does not showed.

Actual Results:
File without correct text

Expected Results:
File with correct text like "Correct text: text to show"


Reproducible: Always


User Profile Reset: No



Additional Info:
Help - About LibreOffice
Comment 1 raal 2022-07-15 14:25:50 UTC 
Please attach test file. Thank you.
Comment 2 Pavel 2022-07-18 14:06:50 UTC 
Created attachment 181310 [details]
card number

card number = 101010101010 the digits not showed.
Comment 3 raal 2022-07-18 18:51:53 UTC 
Created attachment 181313 [details]
printscreen from excel
Comment 4 raal 2022-07-18 19:01:26 UTC 
Confirm with Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 28daee8a3252e03a67484dc8d3dd26fd73af4826
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 5 Pavel 2022-07-21 21:15:57 UTC 
Version: 7.3.4.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: ru-RU (ru_RU.UTF-8); UI: ru-RU
Ubuntu package version: 1:7.3.4~rc2-0ubuntu0.18.04.1~lo1
Calc: threaded

We have different versions. Ok, I will try to update software.
Comment 6 Kohei Yoshida 2023-11-03 00:15:35 UTC 
The <B> tag must be uppercase.  XML element names are case-sensitive, and the <b> tag (lowercase) technically is invalid.  If you change it to <B>, Calc will open it correctly.

Even in Excel, the card number does not have bold attribute applied when you use <b> (lowercase).  But if you change that to <B> (uppercase) Excel will display it in bold.
Comment 7 Kohei Yoshida 2023-12-01 22:36:57 UTC 
I'll mark this as NOTABUG per Comment 6.  The different behavior between Excel and Calc when handling invalid tags may be just a manifestation of different implementations.