https://bugs.documentfoundation.org/show_bug.cgi?id=162479
Bug ID: 162479
Summary: XLSX: Number Format stops being applied at a certain
point
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Given an XSLX file that is styled with one column set to a formatCode of
D-MMM-YY HH:MM:SS AM/PM, after a certain point it is no longer automatically
styled.
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: d6e8b0f3fc6e8af2b00cf4969fd0d2fa45b9a62e
CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
Steps to Reproduce:
1. Open sample file
2. Scroll to line 2522
3.
Actual Results:
Column B is no longer styled as numFormat frm B2522 onwards
Expected Results:
Column B is styled
<pre>
<row r="2521">
<c r="A2521" t="n"><v>2069092.0</v></c><c r="B2521" s="-30267"
t="n"><v>45519.42128321759</v></c><c r="C2521"
t="inlineStr"><is><t>access</t></is></c><c r="D2521"></c><c r="E2521"
t="inlineStr"><is><t>203.26.87.155</t></is></c><c r="F2521"
t="inlineStr"><is><t xml:space="preserve"> sarah Clintel </t></is></c><c
r="G2521" t="inlineStr"><is><t>[email protected]</t></is></c><c r="H2521"
t="inlineStr"><is><t>000074</t></is></c><c r="I2521"
t="inlineStr"><is><t>000048</t></is></c><c r="J2521" t="inlineStr"><is><t
xml:space="preserve">Beverly MORGAN </t></is></c><c r="K2521"
t="inlineStr"><is><t>PatientTracking</t></is></c><c r="L2521"
t="n"><v>491.0</v></c><c r="M2521" t="inlineStr"><is><t
xml:space="preserve"><?xml version="1.0"
encoding="UTF-8"?>
<hash>
</hash>
</t></is></c><c
r="N2521" t="inlineStr"><is><t>careright</t></is></c></row>
<row r="2522">
<c r="A2522" t="n"><v>2069093.0</v></c><c r="B2522" s="-30253"
t="n"><v>45519.42128321759</v></c><c r="C2522"
t="inlineStr"><is><t>access</t></is></c><c r="D2522"></c><c r="E2522"
t="inlineStr"><is><t>203.26.87.155</t></is></c><c r="F2522"
t="inlineStr"><is><t xml:space="preserve"> sarah Clintel </t></is></c><c
r="G2522" t="inlineStr"><is><t>[email protected]</t></is></c><c r="H2522"
t="inlineStr"><is><t>000049</t></is></c><c r="I2522"
t="inlineStr"><is><t>PN1811282</t></is></c><c r="J2522" t="inlineStr"><is><t
xml:space="preserve">Lady Smith </t></is></c><c r="K2522"
t="inlineStr"><is><t>CurrentAssessment</t></is></c><c r="L2522"
t="n"><v>139.0</v></c><c r="M2522" t="inlineStr"><is><t
xml:space="preserve"><?xml version="1.0"
encoding="UTF-8"?>
<hash>
</hash>
</t></is></c><c
r="N2522" t="inlineStr"><is><t>careright</t></is></c></row>
</pre>
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: d6e8b0f3fc6e8af2b00cf4969fd0d2fa45b9a62e
CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
