Ask Your Question

lemontree3417's profile - activity

2016-12-08 17:14:37 +0200 received badge  Popular Question (source)
2016-12-07 21:13:08 +0200 received badge  Scholar (source)
2016-12-07 21:11:55 +0200 commented answer calc - % column off by *100 after opening an xlsx document

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.

2016-12-07 19:51:40 +0200 asked a question calc - % column off by *100 after opening an xlsx document

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: 5.2.3.2 on Ubuntu 14.04)