Ask Your Question

calc - % column off by *100 after opening an xlsx document

asked 2016-12-07 19:51:40 +0200

lemontree3417 gravatar image

For example, a column that is supposed to display percentile is showing: 9630.00% 9051.00% 1779.00% 9825.00% 7879.00% 8774.00% 462.00% 9754.00%

Are my settings off somewhere? (Using Calc Version: on Ubuntu 14.04)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-12-07 20:48:35 +0200

Lupp gravatar image

If the actual ("unformatted") value of a cell is 96.3 and the 'Numbers' format is set to percentage with two decimal places (code: 0.00" "%) the cell will correctly display 9630.00 %.
Your problem may be caused by an incorrectness either of the way Excel saved the file as xlsx (some sub-versions!) or of the way Calc opened it. The so called file formats are very different and errors will occur.
I don't think you can fix the problem by changing any settings. If you have an Excel you may open the fila again with it and save it as xls. Probably this can establish a correct understanding. Otherwise please post the format code displayed for the cells of your "% column" and report what you see if you change the 'Numbers' format of one of these cells (showing 9630.00 % e.g.) to 'General'. If the problem is restricted to some ranges I may be able to describe a fix then.

edit flag offensive delete link more


It looks like you are right. I asked a friend to open the file in Excel, and the values in those columns is actually 96.3 but formatted in a custom format that appears as percentage. I thought there might be something wrong with either calc or my settings but that's not the case.

lemontree3417 gravatar imagelemontree3417 ( 2016-12-07 21:11:55 +0200 )edit

@lemontree3417: what Excel version ?

rautamiekka gravatar imagerautamiekka ( 2016-12-08 19:51:22 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-12-07 19:51:40 +0200

Seen: 34 times

Last updated: Dec 07 '16