Ask Your Question

Why is Calc 4.3 corrupting my Excel spreadsheets? v2 [closed]

asked 2014-10-29 02:51:44 +0200

stephanip gravatar image

updated 2015-08-29 21:16:03 +0200

Alex Kemp gravatar image

This is a repeat, because the first time I was not allowed to upload a file.

I recently upgraded to 4.3 and used a spreadsheet like I always have for the past decade. Only now Calc is mangling the structure. When I finally figured out what was going one, I had lost days of work. I can't upload the original but here is a simplified example.

RankBefore.xls and after RankAfter.xls

In Lo 4.2 and Excel, changing the rank sort, preserves the structure of the spreadsheet. Doing it in LO 4.3 scrambles everything. In larger spreadsheets the consequences are much more severe.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 18:40:28.469511


What action did you actually apply to the range B1:C5 of 'RankBefore.xls' (or B2:C5 labels excluded)? The sheet in 'RankAfter.xls' Has exactly the same content in this range. Why did you label the row with =B2+B4 of the sheet in 'RankBefore.xls' as 'Total Hours Top'? ...

I just want to be sure about the details. No doubt there is a bug1

Lupp gravatar imageLupp ( 2014-10-30 18:18:03 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-10-30 16:10:13 +0200

Smile4ever gravatar image

Please file a bug report on and describe what you do exactly (like you did here). Thanks!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-10-29 02:51:44 +0200

Seen: 95 times

Last updated: Oct 30 '14