View previous topic :: View next topic |
Author |
Message |
supersonic Guest
|
Posted: Mon Apr 03, 2006 7:48 am Post subject: Nombre de ligne maximum dépassé |
|
Voici ce que j'obtiens qu'on j'importe un fichier excel un peu volumineux
Quelqu'un aurait-il une idée sur comment fixer ça?
D'avance merci |
|
Back to top |
|
|
pluby The Architect
Joined: Jun 16, 2003 Posts: 11949
|
Posted: Mon Apr 03, 2006 8:18 am Post subject: |
|
I don't know how to say this is French, but NeoOffice Calc documents are limited to only 32,000 rows and the error message says that the any rows greater than this number have been ignored during the import of the Excel file.
Patrick |
|
Back to top |
|
|
amayze The Merovingian
Joined: Oct 24, 2005 Posts: 561 Location: Edinburgh, Scotland
|
Posted: Mon Apr 03, 2006 8:26 am Post subject: |
|
[translation]
Here is what I get when I try to import a rather large Excel file.
[screenshot]
Does anybody know how to fix it?
Thank in advance
[/translation]
At a guess I'd say its because Excel can handle larger sheets than Neooffice.
The error message says it really: " The maximum number of lines has been exceeded"
If you can split your large spreadsheet across several smaller sheets with fewer rows and columns it should work.
Andy
[translation]
À une conjecture je dirais que son parce que Excel peut manipuler de plus grandes feuilles que Neooffice. Le message d'erreur l'indique vraiment: "le nombre maximum des lignes a été dépassé"
Si vous pouvez dédoubler votre grand bilan à travers plusieurs plus petites feuilles avec peu de rangées et colonnes il devrait fonctionner.
Andy
(Translation by google and 15 year old 'O' grade French - hope its OK) |
|
Back to top |
|
|
sardisson Town Crier
Joined: Feb 01, 2004 Posts: 4588
|
Posted: Tue Apr 04, 2006 6:39 am Post subject: |
|
FYI, OOo 2 (and thus Neo 2 Alpha, when it arrives), have a greater row/column limit...I forget how high, but it's closer to the limit in "recent" Excel versions.
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki |
|
Back to top |
|
|
ovvldc Captain Naiobi
Joined: Sep 13, 2004 Posts: 2352 Location: Zürich, CH
|
Posted: Tue Apr 04, 2006 9:27 am Post subject: |
|
sardisson wrote: | FYI, OOo 2 (and thus Neo 2 Alpha, when it arrives), have a greater row/column limit...I forget how high, but it's closer to the limit in "recent" Excel versions. |
65530 (64k) or something. The same as existing Excel versions. The forthcoming Excel will alledgedly allow for even larger sheets. But it will be a while before it is released .
Best wishes,
Oscar _________________ "What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi |
|
Back to top |
|
|
|