Bug 93115 - FILESAVE: When a cell contains superscript or subscript, saving as xlsx causes all the text to be superscript/subscript
Summary: FILESAVE: When a cell contains superscript or subscript, saving as xlsx cause...
Status: RESOLVED DUPLICATE of bug 92296
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.4 rc
Hardware: All Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
: 97592 (view as bug list)
Depends on:
Blocks:
 
Reported: 2015-08-04 07:47 UTC by Kevin Suo
Modified: 2016-02-05 12:40 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
test file with superscript and subscript in cells (9.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-08-04 07:47 UTC, Kevin Suo
Details
screenshot showing the format change (245.79 KB, image/png)
2015-08-04 07:53 UTC, Kevin Suo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2015-08-04 07:47:24 UTC
Created attachment 117636 [details]
test file with superscript and subscript in cells

When a cell contains superscript or subscript, saving as xlsx will cause all the text within the cell become superscript/subscript.

Steps to reproduce:

1. Save the attached ods file as xlsx format.

2. Reopen the xlsx file.
--> All the text within the cell become superscript/subscript.

Version: 5.0.0.4
Build ID: cf112dc905650fb985306a7a03d2fe3fcc6c978f
Locale: zh-CN (zh_CN)
Win 7 X86
Comment 1 Kevin Suo 2015-08-04 07:53:24 UTC
Created attachment 117637 [details]
screenshot showing the format change
Comment 2 m_a_riosv 2015-08-04 08:55:27 UTC
Hi @Kevin,

not reproducible
Win7x64Ultimate
Version: 4.4.5.2 Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99

Opens fine in Version: 5.0.0.5 (x64) the file saved as xlsx with 4.4.3.2,

The file saved with 5.0.0.5/5.1 shows the issue opening with any version.

But is reproducible, saving with
Version: 5.0.0.5 (x64) Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
and with master.
Version: 5.1.0.0.alpha1+ (x64) Build ID: bb697b4c7bd694c6b81ed2a4cc9471cb5573b592
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-07-31_22:24:
Comment 3 Kevin Suo 2015-08-04 13:05:11 UTC
Fix OS to Windows All. Not confirmed in others OS yet.
Comment 4 raal 2015-09-23 11:39:23 UTC
 8e51a1a65893ccebe8650345883836f200513215 is the first bad commit
commit 8e51a1a65893ccebe8650345883836f200513215
Author: Norbert Thiebaud <nthiebaud@gmail.com>
Date:   Thu Jun 4 08:47:59 2015 -0500

    source cc5baa41fee257498661320e24169bb3f05391fb

    source cc5baa41fee257498661320e24169bb3f05391fb
    source 7a66dbe982623be620ad6ac426fe689a434e5f51
    source 3dfe2fc394ca1e168e800ffcc3ac0f69b4eeb173
    source a878ffae876610bf7522d79685b6e07191a88214
    source 511499b3ba08024e3d6853f096ad1d96f96b216d
    source 27491725a689d98e6b327bd1faaf4258b923783f
    source 936a49646738452f7331ed9a47ac015db9ee7295
    source ab81e3bff2a1844be67209bc8947d539edbaf8e6
    source e1ebdf38969a17af9453f674c81663187411597d
    source 4c665178f49952138835fd318edef8978ac806e3
    source 3fd5f8919ec2256c70ff26c14cb9f8065c5cb2f1
    source 0c129aa3df35a056ec739579002b2fc958fb3a48
    source 4906ecb8210a8cf1b7befcfde7f867bed5d6ce43
    source 50128d02c2883d04e12b8e6857aa1b8bef479b08
    source ac55ac11f66c9b8b44dc8281d6236d9e6d68ddd1
    source e4d4ee607efc8ec0e2284f661fd32f0e2ad99e76
    source 23c0e00b50f7fae7a82134ef064eabf9514a941b
    source d425cc7c73a8ad3d693216742d75b0f7f1bf5f89
    source 0c3b96790da88fb22b5e932f9a4abaeb330b610a
    source 5ffe469a9e9c5b86dbdcbe556d23cd789a9f3a55
    source 8865ed2efecd03722d10e522265f31c99b13b2bb
    source 686034d5ced19ea2a16127ba3f5af49e7f9e1b35
    source 0f8f60f2bef959389d45b2dd0a535cd8848ed8e9

:040000 040000 9e7155375a28a9f4df4fff010ae7d730fea5e305 2bcd67321dca9f0639b5c9ef1dcf24b67a6acead M      instdir


git bisect log
# bad: [575cd25f0560684895018d8fcfb1818dd4dd1c9b] source ab465b90f6c6da5595393a0ba73f33a1e71a2b65
# good: [f449493ae11ac76cc7396bddeaa624a60c565936] source 57d6b92b69a31260dea0d84fcd1fc5866ada7adb
git bisect start 'libreoffice-5-0-branch-point' 'oldest'
# good: [da12357c491a0dce5acc0bd1f00c26f89d8f20e6] source c1b9402d49a7cd4bec383f28d397d9d89541f0e0
git bisect good da12357c491a0dce5acc0bd1f00c26f89d8f20e6
# good: [2783cac5d1f18f44ce31f52eb7ae2f0ea17d0c96] source 5d7a203bdae1940e4846c4c42f5d733e4ffa4160
git bisect good 2783cac5d1f18f44ce31f52eb7ae2f0ea17d0c96
# good: [c6b55917df3df447007dbb29dd84f24d1203cfb3] source 5b8acf459e4a6728ea656e7abd5dfb08ad2ae345
git bisect good c6b55917df3df447007dbb29dd84f24d1203cfb3
# good: [ac46cb21db25e4b49f28bbe57f5846dbca57e486] source dbf1e124c7fef7cae5392959ab6a697a3a89c609
git bisect good ac46cb21db25e4b49f28bbe57f5846dbca57e486
# bad: [eece862e921f0369dbf20571080344aa56577fd0] source 6fbda0905d4e721392038bfad9e173e180f788ee
git bisect bad eece862e921f0369dbf20571080344aa56577fd0
# bad: [c0741086019d0a6a28865a6b29edbd6e149cc034] source 182c202d6d3fd9422bf3628a2fa4ccd7ab955c5e
git bisect bad c0741086019d0a6a28865a6b29edbd6e149cc034
# bad: [168b1c2ab59630bb290e04123188b68ad4ed0af4] source ceac38106de4f2657e854d5e1d657d6df9321032
git bisect bad 168b1c2ab59630bb290e04123188b68ad4ed0af4
# bad: [66933de7b1b8079f6906a517daa62f96e9b52388] source c74631a0ffd32d3e0794fdd861582ca5b1d55b45
git bisect bad 66933de7b1b8079f6906a517daa62f96e9b52388
# bad: [343482dc0497e11a7237168d4ede17803cc1786e] source 70c4355ffd494dffb59818c225b4a3343476e9a6
git bisect bad 343482dc0497e11a7237168d4ede17803cc1786e
# skip: [383068b4dde6bac406b0b37b06df7a204ec12b93] source 7ac254048a5698e046bbb7deccd171cb3777af61
git bisect skip 383068b4dde6bac406b0b37b06df7a204ec12b93
# good: [6d76639463289ac123a7c83935ed708cbbc4b1f8] source 667910530deb61563d4812db0995da94e25220e5
git bisect good 6d76639463289ac123a7c83935ed708cbbc4b1f8
# good: [2b9a67625c131d4116e9025ae6b13a86a3642121] source c975bee3a7db0d318d1e460312be2922a09c7cea
git bisect good 2b9a67625c131d4116e9025ae6b13a86a3642121
# bad: [8e51a1a65893ccebe8650345883836f200513215] source cc5baa41fee257498661320e24169bb3f05391fb
git bisect bad 8e51a1a65893ccebe8650345883836f200513215
# first bad commit: [8e51a1a65893ccebe8650345883836f200513215] source cc5baa41fee257498661320e24169bb3f05391fb
Comment 5 Andras Timar 2015-11-03 21:31:52 UTC
bisected:
commit 8865ed2efecd03722d10e522265f31c99b13b2bb
Author: yogesh.bharate001 <yogesh.bharate@synerzip.com>
Date:   Mon Apr 27 15:08:16 2015 +0530

    tdf#90812: rPr is not exported after roundtrip.
Comment 6 Andras Timar 2015-11-04 14:53:54 UTC
In fact it is a duplicate of bug 92296.

*** This bug has been marked as a duplicate of bug 92296 ***
Comment 7 Robinson Tryon (qubit) 2015-12-15 11:03:33 UTC
Migrating Whiteboard tags to Keywords: (bibisected)
[NinjaEdit]
Comment 8 raal 2016-02-05 12:40:58 UTC
*** Bug 97592 has been marked as a duplicate of this bug. ***