Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[Solved] Question re: excel spreadsheets...
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Gentoo Chat
View previous topic :: View next topic  
Author Message
cgmd
Veteran
Veteran


Joined: 17 Feb 2005
Posts: 1585
Location: Louisiana

PostPosted: Thu Nov 09, 2006 12:54 pm    Post subject: [Solved] Question re: excel spreadsheets... Reply with quote

Hi, All...

I'm having trouble reading Excel spreadsheets on my gentoo laptop (both gnumeric & openoffice)...

Quote:
The content as it appears in excel:

Bal. Fwd.
$216,806.75
$0.00
$217,518.68
$235,038.78
$226,477.41
$307,625.75
$0.00
$15,110.00
$59,121.00
$1,950.00
$15,315.00
$12,844.98
$530.00
$4,551.73
$0.00
$66,799.50
$93,561.93
$45,787.95
$40,825.76
$24,129.10

Same information as it appears in gmumeric and openoffice:

Bal. Fwd.
2.17E+05
0.00E+00
2.18E+05
2.35E+05
2.26E+05
3.08E+05
0.00E+00
1.51E+04
5.91E+04
1.95E+03
1.53E+04
1.28E+04
5.30E+02
4.55E+03
0.00E+00
6.68E+04
9.36E+04
4.58E+04
4.08E+04
2.41E+04


I'm just a novice when it comes to spreadsheets, and I don't understand why this is happening.

Could someone please give me some help with this?

Thanks!
_________________
"Primum non nocere" ---Galen


Last edited by cgmd on Thu Nov 09, 2006 4:30 pm; edited 1 time in total
Back to top
View user's profile Send private message
anime-otaku
Apprentice
Apprentice


Joined: 24 Apr 2006
Posts: 181
Location: Germany

PostPosted: Thu Nov 09, 2006 1:35 pm    Post subject: Reply with quote

2,17E+05 indicates 2,17*10^05

10 power 5 or something like that (I don't know how to call it exactly in English)

Maybe the column is too small or the format is wrong. But the information seems to be right.
_________________
Gentoo compiles you to heaven

There are 10 kinds of people. Those who understands BINARY and those who don't.

Answer the unanswered posts
Back to top
View user's profile Send private message
timeBandit
Bodhisattva
Bodhisattva


Joined: 31 Dec 2004
Posts: 2672
Location: here, there or in transit

PostPosted: Thu Nov 09, 2006 2:08 pm    Post subject: Reply with quote

Your cell format in Excel did not carry over to Gnumeric/OOCalc for some reason. Usually that imports fine, I'm not sure why it wouldn't. Select all the affected cells, change the format to Currency and you'll see the values you expect.

Which version of Excel? Which version of OpenOffice? What file format (file type) did you use when you saved the spreadsheet from Excel (Excel 97, etc.)?
_________________
Plants are pithy, brooks tend to babble--I'm content to lie between them.
Super-short f.g.o checklist: Search first, strip comments, mark solved, help others.
Back to top
View user's profile Send private message
cgmd
Veteran
Veteran


Joined: 17 Feb 2005
Posts: 1585
Location: Louisiana

PostPosted: Thu Nov 09, 2006 3:14 pm    Post subject: Reply with quote

timeBandit wrote:
Quote:
change the format to Currenc


This does correct the format... Thanks for that suggestion.

The version of Excel used by the sender is 5.0, and the format is *.xls (those are the defaults within the acounting package generating the report).

On the other hand, is there a way to make gnumeric default to the currency format?

Thanks, again!
_________________
"Primum non nocere" ---Galen
Back to top
View user's profile Send private message
timeBandit
Bodhisattva
Bodhisattva


Joined: 31 Dec 2004
Posts: 2672
Location: here, there or in transit

PostPosted: Thu Nov 09, 2006 3:27 pm    Post subject: Reply with quote

cgmd wrote:
The version of Excel used by the sender is 5.0, and the format is *.xls (those are the defaults within the acounting package generating the report).
On the other hand, is there a way to make gnumeric default to the currency format?
(emphasis mine) Ah, that explains much.

XLS was understood, I was looking for the specific version of XLS, which you can select when saving a file from Excel (via the Save as Type selection in the Save dialog.). But if this file is generated by a third-party program, the fact that you lose some cell formatting suggests the file differs slightly from the Excel 5.0 format as understood by OpenOffice and Gnumeric.

I don't use Gnumeric, sorry, maybe someone else can help you with a default format--although I don't recall a way to set one in Excel or OpenOffice, so Gnumeric would be ahead of the curve there if it has that capability.
_________________
Plants are pithy, brooks tend to babble--I'm content to lie between them.
Super-short f.g.o checklist: Search first, strip comments, mark solved, help others.
Back to top
View user's profile Send private message
cgmd
Veteran
Veteran


Joined: 17 Feb 2005
Posts: 1585
Location: Louisiana

PostPosted: Thu Nov 09, 2006 3:56 pm    Post subject: Reply with quote

OK, then the other approach would be to require the sender to open the file in their current 2003 version of Excel and save it to a compatible format, before sending it. :wink:

Next question...

With which native Excel format, are the linux spreadsheet programs most happy?
_________________
"Primum non nocere" ---Galen
Back to top
View user's profile Send private message
Dan
Veteran
Veteran


Joined: 25 Oct 2005
Posts: 1301

PostPosted: Thu Nov 09, 2006 4:08 pm    Post subject: Reply with quote

I have no issues with conversion from office2003 or officexp excel.xls using openoffice 2.0
I use it daily..
Back to top
View user's profile Send private message
cgmd
Veteran
Veteran


Joined: 17 Feb 2005
Posts: 1585
Location: Louisiana

PostPosted: Thu Nov 09, 2006 4:29 pm    Post subject: Reply with quote

Very good... excel 2003 *.xls works fine.

timeBandit is correct. The 3rd party software is the culprit!
_________________
"Primum non nocere" ---Galen
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Gentoo Chat All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum