Ask Your Question
1

on open xls file asume some text as number [closed]

asked 2013-03-07 21:49:49 +0100

neoroot gravatar image

updated 2015-10-27 01:39:14 +0100

Alex Kemp gravatar image

on open xls file asume some text as number on like 001, on version 3.4.X -> 3.6.5.2 Fedora 16 -> Fedora 18 Install RPM form libreoffice.org

some ideas to prevent that ?

original 001,026,0003, afrfrer on libre office 1,26,3, afrfrer

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-27 01:39:23.629118

2 Answers

Sort by » oldest newest most voted
0

answered 2013-03-07 22:28:48 +0100

qubit gravatar image

Hi @neoroot,

Are you saying that when you open an XLS file with LibreOffice 3.6 that some cells formatted as text are being interpreted as numbers instead?

Please download the latest release (currently 4.0.1) and see if the bug is still present in that version. If you still have an issue, please post a copy of the XLS file here (please remove any private/personal information first) and we can take a quick look.

edit flag offensive delete link more
0

answered 2013-03-18 17:06:39 +0100

neoroot gravatar image

documents from office work fine, now i can reproduce this incidence only with php html excel files, css :style=vnd.ms-excel.numberformat:@;

edit flag offensive delete link more

Comments

Hi @neoroot, What do you mean by "php html excel files"?

Do you mean Excel files that have been exported as HTML?

qubit gravatar imagequbit ( 2013-03-19 04:54:55 +0100 )edit

Question Tools

Stats

Asked: 2013-03-07 21:49:49 +0100

Seen: 190 times

Last updated: Mar 18 '13