| View previous topic :: View next topic |
| Author |
Message |
Koon
Retired Dev
Joined: 10 Dec 2002
Posts: 518
|
 Posted: Wed Oct 08, 2003 3:32 pm Post subject: |
 |
|
Funny, now I reopen the file and it reads "2,05581236092013E+035" in numeric cells... Looks like something is garbled in the XLS filter. Also all date cells contain "22/08/398". Odd.
-K |
|
| Back to top |
|
 |
xlyz
Veteran
Joined: 27 Oct 2002
Posts: 1470
Location: Italy
|
| Posted: Wed Oct 08, 2003 3:44 pm Post subject: |
|
|
| Koon wrote: | After some tests, it appears that oocalc is not working properly : when I open an MSOffice-97 XLS file all numeric cells contain "2,08177384521281E+035" (appear as "2,08E+035") rather than the real content. I have problems with dates too... All these files worked properly in vanilla-OO 1.0.x.
Anyone having the same problems with XLS files in oocalc ? Or is it due to localization problems ? Otherwise the build works really fine.
-K |
same problem here (don't know which xls version are) |
|
| Back to top |
|
|
Redeeman
l33t
Joined: 25 Sep 2003
Posts: 958
Location: Portugal
|
| Posted: Wed Oct 08, 2003 3:52 pm Post subject: |
|
|
| i run the file you sent perfectly |
|
| Back to top |
|
|
Koon
Retired Dev
Joined: 10 Dec 2002
Posts: 518
|
| Posted: Wed Oct 08, 2003 3:57 pm Post subject: |
|
|
Maybe the problem is only in localized versions...
xlyz : do you use a LANGUAGE-localized version of ximian-oo (like say, in Italian) ?
redeeman : do you use a non-localized build ?
Test file :
http://usda.mannlib.cornell.edu/data-sets/crops/89002/table55.xls
Should look like this (Google converter)
But most numerals contain 2,07528347413964E+033 on my ximian-oo...
-K |
|
| Back to top |
|
|
kKDu
Apprentice
Joined: 18 Aug 2003
Posts: 187
|
| Posted: Wed Oct 08, 2003 4:08 pm Post subject: |
|
|
I have this problem with my german localized version.
Gnumeric open the file correct, but OO-ximian shows 1,51792919648429E+033
Another problem is in the word processor with the bullets. They are all angular bins (and one is a cobweb  ) |
|
| Back to top |
|
|
Redeeman
l33t
Joined: 25 Sep 2003
Posts: 958
Location: Portugal
|
| Posted: Wed Oct 08, 2003 4:08 pm Post subject: |
|
|
no i just builded it, fair and square, i dont have any problems, if you want, i have the athlon-xp package, which works on p3 too (tested)
you could try that if you wanted, i just cant host, but if you give me ftp information or something 
if i can help with something, just tell! |
|
| Back to top |
|
|
Koon
Retired Dev
Joined: 10 Dec 2002
Posts: 518
|
| Posted: Wed Oct 08, 2003 4:16 pm Post subject: |
|
|
OK, so it looks like localized versions (French, German...) suffer of the XLS conversion bug, and the non-localized version does not show the problem.
Suka : any hint ?
Other ximian-oo users can confirm that localized versions are hit and non-localized versions are immune by running the test file above.
-K |
|
| Back to top |
|
|
xlyz
Veteran
Joined: 27 Oct 2002
Posts: 1470
Location: Italy
|
| Posted: Wed Oct 08, 2003 4:27 pm Post subject: |
|
|
| mine is plain english, no localization |
|
| Back to top |
|
|
Phlaegel
Apprentice
Joined: 22 May 2003
Posts: 156
|
| Posted: Wed Oct 08, 2003 6:57 pm Post subject: |
|
|
I'm getting a break here...
| Code: |
-------------
../../unxlngi4.pro/bin/mksvconf ../../unxlngi4.pro/inc/svconf.h
char = signed char
short = signed short
int = signed int
long = signed long
sizeof(char) = 1
sizeof(short) = 2
sizeof(int) = 4
sizeof(long) = 4
sizeof(float) = 4
sizeof(double) = 8
sizeof(void *) = 4
LITTLEENDIAN (Intel, VAX, PowerPC)
Stack waechst nach unten
STACKALIGNMENT : 1
can not read address (nil)
Segmentation fault
dmake: Error code 139, while making '../../unxlngi4.pro/inc/svconf.h'
dmake: '../../unxlngi4.pro/inc/svconf.h' removed.
---* TG_SLO.MK *---
ERROR: Error 65280 occurred while making /var/tmp/portage/openoffice-ximian-1.1.0/work/oo_1.1_src/tools/source/solar
!!! ERROR: app-office/openoffice-ximian-1.1.0 failed.
!!! Function src_compile, Line 472, Exitcode 1
!!! Build failed!
|
I'm building on an athlon xp 1800... any ideas? I've tried removing distcc from make.conf, and cutting my CFLAGS down to "-mcpu=athlon-xp -O2 -pipe" with no success. |
|
| Back to top |
|
|
suka
Developer
Joined: 22 Apr 2002
Posts: 383
|
| Posted: Wed Oct 08, 2003 10:21 pm Post subject: |
|
|
And another update to the latest ximian patches and icons, get it here:
http://www.t0.or.at/~zaurus/openoffice-ximian-1.1.0-r2.tar.gz
My top point of this release is that it removes the need for one more of our patches 
Here is the Changelog from Ximian:
| Code: | Changes in this release:
+ features
+ new, sized, alpha fixed icons (Tigert, Jimmac)
+ scroll-wheel quickhelp less annoying (Michael)
+ system-zlib, system-getopt (from Mdk, Rene)
+ bug fixes
+ relocate now prunes stale .dpcc files (Michael)
+ problems in toolbox customize (Michael)
+ --with-system-gcc fix (Michael, Robin Cook)
+ print-scale fix (Dan Williams, Michael)
+ File->New i18n fix (Michael)
|
|
|
| Back to top |
|
|
mdl313
n00b
Joined: 11 May 2003
Posts: 63
Location: New York
|
| Posted: Thu Oct 09, 2003 9:12 am Post subject: |
|
|
| Quote: | | And another update to the latest ximian patches and icons, get it here: |
.....but does it do anything for the "cut & paste" bug in oocalc? The other thread on this issue seems to have hit a wall. |
|
| Back to top |
|
|
suka
Developer
Joined: 22 Apr 2002
Posts: 383
|
| Posted: Thu Oct 09, 2003 9:15 am Post subject: |
|
|
| mdl313 wrote: | | .....but does it do anything for the "cut & paste" bug in oocalc? The other thread on this issue seems to have hit a wall. |
Nope, as it is so difficult to at least find out, why it hits some and some others not, it is even more difficult to find the actual bug... |
|
| Back to top |
|
|
Paule.Green
n00b
Joined: 14 Aug 2002
Posts: 42
Location: paris
|
| Posted: Thu Oct 09, 2003 9:56 am Post subject: |
|
|
i compilled OO-Ximian with french localisation and confirm the XLS conversion bug for me...
@tom |
|
| Back to top |
|
|
Redeeman
l33t
Joined: 25 Sep 2003
Posts: 958
Location: Portugal
|
| Posted: Thu Oct 09, 2003 10:11 am Post subject: |
|
|
omg!
i just found out that it dont use the CFLAGS you have set! it uses mcpu=pentiumpro wtf?! i want athlon
is it the ebuild or teh openoffice that does it? |
|
| Back to top |
|
|
cryos
Retired Dev
Joined: 08 Mar 2003
Posts: 242
Location: US
|
| Posted: Thu Oct 09, 2003 10:15 am Post subject: |
|
|
I don't know if others are getting problems with symbol fonts either? I built r1 of the ebuild and all my symbols in equation editor were messed up on my laptop and desktop. Both normal builds, no localisation I just changed the dictionary to UK.
Also in Calc any cells formatted as currency £12.45 or whatever get garbled and come out as something to e33. This also happens in normal OOo too, but the symbol font is fine in vanilla OOo on the same system... |
|
| Back to top |
|
|
Koon
Retired Dev
Joined: 10 Dec 2002
Posts: 518
|
| Posted: Thu Oct 09, 2003 12:03 pm Post subject: |
|
|
Latest news on the XLS converter bug :
I have this on the build I compiled myself (french-localized) and on the generic build (non-localized) on http://www.update.uu.se/~adde/oo/ !!
So it might not be build-related, but rather due to specificities on the test environment. Since some Italian, French and German users have trouble with this, I think it might be due to the i18n on the test environment...
Can people having the problem confirm what language their DE is running, and people not having the problem confirm they use the default english locale ?
-K |
|
| Back to top |
|
|
Kirschsaft
n00b
Joined: 05 Jul 2003
Posts: 22
|
| Posted: Thu Oct 09, 2003 12:04 pm Post subject: |
|
|
| Koon wrote: | OK, so it looks like localized versions (French, German...) suffer of the XLS conversion bug, and the non-localized version does not show the problem.
Suka : any hint ?
Other ximian-oo users can confirm that localized versions are hit and non-localized versions are immune by running the test file above.
-K |
Nope, I have the problem with incorrect XLS-import already in an unlocalized RC4-ximian-oo (the dates in a file s.b. sent me were kind of random). I thought it was because of the high optimization level I am using (I use -O4 in CFLAGS). I haven't tried a 1.1 ximian-oo (neither German or unlocalized) yet, but a vanilla-oo under Windows opened the file normally.
EDIT: my locale settings:
| Code: | LANG=de_DE@euro
LC_CTYPE="de_DE@euro"
LC_NUMERIC="de_DE@euro"
LC_TIME="de_DE@euro"
LC_COLLATE="de_DE@euro"
LC_MONETARY="de_DE@euro"
LC_MESSAGES="de_DE@euro"
LC_PAPER="de_DE@euro"
LC_NAME="de_DE@euro"
LC_ADDRESS="de_DE@euro"
LC_TELEPHONE="de_DE@euro"
LC_MEASUREMENT="de_DE@euro"
LC_IDENTIFICATION="de_DE@euro"
LC_ALL= |
|
|
| Back to top |
|
|
GoinBald
n00b
Joined: 19 Apr 2003
Posts: 39
Location: Canada
|
| Posted: Thu Oct 09, 2003 12:12 pm Post subject: Thanks |
|
|
Hello Suka,
Thanks this rocks!
1.1-rc2 was the first that I could make on my machine.
She's a beaut!
Thank you, Thank you, Thank you, 
Jesse |
|
| Back to top |
|
|
Koon
Retired Dev
Joined: 10 Dec 2002
Posts: 518
|
| Posted: Thu Oct 09, 2003 3:10 pm Post subject: |
|
|
After some more tests, it doesn't look like the Excel import bug(s) are locale-related (tested with a POSIX-locale user, same problem)...
I give up...  If someone has an idea why this seems to hit only a few users... A few things on my config : Gnome 2.2 (2.4 being compiled), AthlonXP, 2.4.20-gentoo-r2, bug reproduced with custom-build (LANGUAGE=33) and with downloaded build from www.update.uu.se (no LANGUAGE).
-K |
|
| Back to top |
|
|
Redeeman
l33t
Joined: 25 Sep 2003
Posts: 958
Location: Portugal
|
| Posted: Thu Oct 09, 2003 3:39 pm Post subject: |
|
|
| no idea, sorry, i am thinking about build the 1.1.0-r2 |
|
| Back to top |
|
|
george
n00b
Joined: 12 Jun 2002
Posts: 67
Location: UK
|
| Posted: Thu Oct 09, 2003 6:09 pm Post subject: |
|
|
| suka wrote: | | mdl313 wrote: | | .....but does it do anything for the "cut & paste" bug in oocalc? The other thread on this issue seems to have hit a wall. |
Nope, as it is so difficult to at least find out, why it hits some and some others not, it is even more difficult to find the actual bug... |
I don't know what anyone else is doing to try and isolate this bug but as I can try a maximum of one idea per day on my slow PC don't hold your breath waiting for me to crack it
For the record, as well as the cut & paste bug in my latest build, I also have the import bug. No locale used and also USE="-nls". Deep joy.
I've lost track now but is there a binary <=i686 which has neither bug?
I'll try the new ebuild next just in case anything changes for me. |
|
| Back to top |
|
|
Phlaegel
Apprentice
Joined: 22 May 2003
Posts: 156
|
| Posted: Fri Oct 10, 2003 7:27 am Post subject: |
|
|
The nptl patch fixed this error for me. The ebuild didn't apply it as I don't have nptl in my use flags.
| Phlaegel wrote: | I'm getting a break here...
| Code: |
-------------
../../unxlngi4.pro/bin/mksvconf ../../unxlngi4.pro/inc/svconf.h
char = signed char
short = signed short
int = signed int
long = signed long
sizeof(char) = 1
sizeof(short) = 2
sizeof(int) = 4
sizeof(long) = 4
sizeof(float) = 4
sizeof(double) = 8
sizeof(void *) = 4
LITTLEENDIAN (Intel, VAX, PowerPC)
Stack waechst nach unten
STACKALIGNMENT : 1
can not read address (nil)
Segmentation fault
dmake: Error code 139, while making '../../unxlngi4.pro/inc/svconf.h'
dmake: '../../unxlngi4.pro/inc/svconf.h' removed.
---* TG_SLO.MK *---
ERROR: Error 65280 occurred while making /var/tmp/portage/openoffice-ximian-1.1.0/work/oo_1.1_src/tools/source/solar
!!! ERROR: app-office/openoffice-ximian-1.1.0 failed.
!!! Function src_compile, Line 472, Exitcode 1
!!! Build failed!
|
I'm building on an athlon xp 1800... any ideas? I've tried removing distcc from make.conf, and cutting my CFLAGS down to "-mcpu=athlon-xp -O2 -pipe" with no success. |
|
|
| Back to top |
|
|
Kirschsaft
n00b
Joined: 05 Jul 2003
Posts: 22
|
| Posted: Fri Oct 10, 2003 9:42 am Post subject: |
|
|
Something I found out about the Excel-Bug:
It seems to happen only with files from a specific Excel-version, since the the xls-file loads perfect in Gnumeric (nothing new). But, when I save this file now in Gnumeric again using the "Excel 97/2000/XP"-format it opens perfectly in ximian-oo.  |
|
| Back to top |
|
|
Redeeman
l33t
Joined: 25 Sep 2003
Posts: 958
Location: Portugal
|
| Posted: Fri Oct 10, 2003 1:06 pm Post subject: |
|
|
| the -r2 ebuild doesent compile here, maybe its because i didnt use nptl in my use this time, i will try mugg with it |
|
| Back to top |
|
|
Lovechild
Advocate
Joined: 17 May 2002
Posts: 2858
Location: Århus, Denmark
|
| Posted: Fri Oct 10, 2003 1:33 pm Post subject: |
|
|
| Okay, just for kicks let's see if this mother compiles with GCC 3.4... |
|
| Back to top |
|
|
|
Desktop Environments
