Re: What file format to use for xlsx file?
On Sat, 27 Jan 2024 11:31:50 -0800 (PST) SUSEN KAY wrote: > I need to open some xlsx files and I can't figure out what file format to use. > > I go to "spreadsheet" and then click on my file xlsx to open, but I am then > asked to pick a file format and none of them seem to work. > > Can you help me please? > > Take care, > > Susen If OpenOffice is quibbling about the file tye nd asking for an import filter, it is possible the files have been corrupted, as OpenOffice would normally open these without query. Another possibility is that they are miss-labeled Excel files, stored not in internal xlsx format, but as comma separated files; there may be a filter offered for such. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: What file format to use for xlsx file?
Susen, .xlsx is a proprietary file format for M$’s spreadsheet program. The easiest way I’ve found to deal with them is to convert them to .ods (open document spreadsheet format) through the online tool available at https://www.zamzar.com/. I believe they will convert five files at a time for free. Sent from my iPhone > On Jan 27, 2024, at 2:38 PM, SUSEN KAY wrote: > > I need to open some xlsx files and I can't figure out what file format to > use. > > I go to "spreadsheet" and then click on my file xlsx to open, but I am then > asked to pick a file format and none of them seem to work. > > Can you help me please? > > Take care, > > Susen
What file format to use for xlsx file?
I need to open some xlsx files and I can't figure out what file format to use. I go to "spreadsheet" and then click on my file xlsx to open, but I am then asked to pick a file format and none of them seem to work. Can you help me please? Take care, Susen
Opening xlsx files errors
Hi I am using the latest win 32 v4.114 but opening an xlsx file with many sheets you get missing cells and fields. However I tried to use a xlsx to ods online conversion and it seems to be better than your converter and without missing or lost data. The link is https://cloudconvert.com/xlsx-to-ods Please incorporate this as it will save a lot of headache. I spent the whole day trying to sort out the errors... and finally decided to convert it online instead. Regards Naeem -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Re: Xlsx
Wir sind nicht das Entwicklerteam, sondern einfache User, die sich gegenseitig unter die Arme greifen ... On Tue, Dec 3, 2019 at 1:05 AM Thomas Egger wrote: > Guten Tag, > > Bitte bei der Entwicklung das xlsx-Format mit einbinden. > > Egger Thomas > Oberwalchen 33b > 83301 Traunreut >
Xlsx
Guten Tag, Bitte bei der Entwicklung das xlsx-Format mit einbinden. Egger Thomas Oberwalchen 33b 83301 Traunreut
OO Calc and XLSX file text duplication
I have been sent a rather complex protected XLSX spreadsheet with 1,053 formulae. They work fine. Three cells have a text string. When I open the XLSX file with OO, these three strings are twice as long as they should be (concatenated to themselves). I had the author (who is using Excel) save and send me a copy with file type XLS, and OO does not have the problem with this file. So it appears to me that OO is has a glitch with XLSX file types. Is anyone interested in this problem? Unfortunately, I do not have a recent copy of Excel. Bob
Re: How save .xlsx -files
Hi - The OOXML format has been around for a decade and MSFT continues to tweak it ever so slightly. They also make changes to XLS, XLSB and the other binary formats. This is done at every release both Windows and Mac. Does LO read XLSX? Regards, Dave Sent from my iPhone > On May 21, 2017, at 7:37 AM, Rory O'Farrell <ofarr...@iol.ie> wrote: > > On Sun, 21 May 2017 13:08:43 +0200 > M Henri Day <mhenri...@gmail.com> wrote: > >> 2017-05-19 20:57 GMT+02:00 knut.heijkenskj...@telia.com < >> knut.heijkenskj...@telia.com>: >> >>> Hallo OpenOffice >>> I would like to save EXCEl-files in the .xlsx-version - how can that be >>> done? >>> My friends are using MS-office, latest version... >>> / knut.heijkenskj...@telia.com >>> >> >> Just a heads up, Knut, but *LibreOffice* has no problem saving >> spreadsheet files in the Microsoft .xlsx format >> >> MVH >> >> Henri > > What can an .xlsx file do that an .xls cannot? Why bother changing formats? > The MS applications that read .xlsx can all read .xls, and OpenOffice's > native .ods formats. > > Tell your MS-using friends to master their package instead of driving it > blindly, > > -- > Rory O'Farrell <ofarr...@iol.ie> > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How save .xlsx -files
2017-05-19 20:57 GMT+02:00 knut.heijkenskj...@telia.com < knut.heijkenskj...@telia.com>: > Hallo OpenOffice > I would like to save EXCEl-files in the .xlsx-version - how can that be > done? > My friends are using MS-office, latest version... > / knut.heijkenskj...@telia.com > Just a heads up, Knut, but *LibreOffice* has no problem saving spreadsheet files in the Microsoft .xlsx format MVH Henri
Re: How save .xlsx -files
On Fri, 19 May 2017 20:57:34 +0200 (CEST) "knut.heijkenskj...@telia.com" <knut.heijkenskj...@telia.com> wrote: > Hallo OpenOffice > I would like to save EXCEl-files in the .xlsx-version - how can that be done? > My friends are using MS-office, latest version... > / knut.heijkenskj...@telia.com > -- Not possible using OpenOffice; the MS applications that can read .xlsx files can also read .xls and .ods files which OO can make (.ods is its default) -- Rory O'Farrell <ofarr...@iol.ie> - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
How save .xlsx -files
Hallo OpenOffice I would like to save EXCEl-files in the .xlsx-version - how can that be done? My friends are using MS-office, latest version... / knut.heijkenskj...@telia.com -- - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Passwort geschütze XLSX-Datei
Hallo, > From: Alois Klotz [mailto:alois.kl...@salzburg.at] > ich bin der Sache mal genauer nachgegangen: > Zusammengefasst nach Tests mit Office 2013 und 2003: > > xls-Dateien mit Passwort machen in LO Probleme, wenn sie mit > Excel 2013 > gespeichert wurden Mmmh ... > - sie lassen sich problemlos öffnen, wenn sie mit > Excel 2003 erstellt wurden. Offensichtlich verwenden neuere Versionen > von Excel für xls-Dateien eine andere > Verschlüsselungsmethode, die LO/OO > nicht unterstützt. > > xlsx-Dateien mit Passwort lassen sich in LO/OO öffnen. Kann ich so nicht nachvollziehen. Mit welcher OO(!)-Version lassen sich solche Dateien denn öffnen? Ich bekomme bei OOo 3.3 und AOO 4.1.1 den Filterdialog zu sehen (als faktisches Zeichen das OO nicht damit umgehen kann). Gruß Jörg - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Passwort geschütze XLSX-Datei
Hallo, du hast recht: OpenOffice 4.1.2 kann xlsx mit Passwort nicht öffnen - LibreOffice (mit Version 5.x getestet) schon. MfG Alois Jörg Schmidt schrieb am 31.01.2016 um 10:43: Hallo, From: Alois Klotz [mailto:alois.kl...@salzburg.at] ich bin der Sache mal genauer nachgegangen: Zusammengefasst nach Tests mit Office 2013 und 2003: xls-Dateien mit Passwort machen in LO Probleme, wenn sie mit Excel 2013 gespeichert wurden Mmmh ... - sie lassen sich problemlos öffnen, wenn sie mit Excel 2003 erstellt wurden. Offensichtlich verwenden neuere Versionen von Excel für xls-Dateien eine andere Verschlüsselungsmethode, die LO/OO nicht unterstützt. xlsx-Dateien mit Passwort lassen sich in LO/OO öffnen. Kann ich so nicht nachvollziehen. Mit welcher OO(!)-Version lassen sich solche Dateien denn öffnen? Ich bekomme bei OOo 3.3 und AOO 4.1.1 den Filterdialog zu sehen (als faktisches Zeichen das OO nicht damit umgehen kann). Gruß Jörg - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Passwort geschütze XLSX-Datei
Hallo, ich bin der Sache mal genauer nachgegangen: Zusammengefasst nach Tests mit Office 2013 und 2003: xls-Dateien mit Passwort machen in LO Probleme, wenn sie mit Excel 2013 gespeichert wurden - sie lassen sich problemlos öffnen, wenn sie mit Excel 2003 erstellt wurden. Offensichtlich verwenden neuere Versionen von Excel für xls-Dateien eine andere Verschlüsselungsmethode, die LO/OO nicht unterstützt. xlsx-Dateien mit Passwort lassen sich in LO/OO öffnen. MfG Alois Martin Jenniges schrieb am 30.01.2016 um 14:47: Hallo, kann es nicht sein, dass diejenigen passwortgeschützten Dokumente auch mit OO oder LO erstellt wurden ? mit freundlichem Gruss Martin Am 28.01.2016 um 23:46 schrieb H.-Stefan Neumeyer: Am Dienstag, 26. Januar 2016, 14:09:46 schrieb Jörg Schmidt: Hallo Jörg Warum funktioniert es dann in OpenOffice z.B. bei passwortgeschützten *.doc-Dateien? Warum funktioniert es in LibreOffivce auch mit z.B. passwortgeschützten *.xlsx-Dateien? Ich kenne es nicht anders, als daß sich in meinem Fall LibreOffice kommentarlos nach dem Paßwortdialog beendet (bzw. der Paßwortdialog ohne Reaktion beendet wird), wenn ich ein unter MS Office 2010 erstelltes, paßwortgeschütztes Dokument öffnen will. Das ist schon seit Jahren bei allen von meinem zeitweiligen Arbeitgeber übermittelten Dokumenten so. Habe das gerade mit einer 08/15-Excel-Tabelle unter LO (L0 5.0.5~rc1-1) gegengepüft. In der anderen Richtung ist Office 2013 nicht in der Lage mit LibreOffice erstellte, paßworgeschützte Dateien zu öffnen. Bricht mit zwei Arten von Fehlermeldungen ab. Ich empfehle alternativ z.B. eine beliebige Linuxdistribution mit halbwegs aktuellem LibreOffice da gehen auch passwortgeschützte *.xlsx-Dateien auf. Aktuell gerade getestet mit LO 4.4.3.2 Naja, nur wegen LibroOffice ein Linux installieren halte ich für overkill. An die zahlreichen Probleme und Fragen, die sich aus der völlig anderen Betriebssystem-Philosophie ergeben würden, mag ich da erst garnicht denken. Von LibreOffice gibt es auch auf Windows installierbare Pakete. - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Passwort geschütze XLSX-Datei
Hallo, kann es nicht sein, dass diejenigen passwortgeschützten Dokumente auch mit OO oder LO erstellt wurden ? mit freundlichem Gruss Martin Am 28.01.2016 um 23:46 schrieb H.-Stefan Neumeyer: Am Dienstag, 26. Januar 2016, 14:09:46 schrieb Jörg Schmidt: Hallo Jörg Warum funktioniert es dann in OpenOffice z.B. bei passwortgeschützten *.doc-Dateien? Warum funktioniert es in LibreOffivce auch mit z.B. passwortgeschützten *.xlsx-Dateien? Ich kenne es nicht anders, als daß sich in meinem Fall LibreOffice kommentarlos nach dem Paßwortdialog beendet (bzw. der Paßwortdialog ohne Reaktion beendet wird), wenn ich ein unter MS Office 2010 erstelltes, paßwortgeschütztes Dokument öffnen will. Das ist schon seit Jahren bei allen von meinem zeitweiligen Arbeitgeber übermittelten Dokumenten so. Habe das gerade mit einer 08/15-Excel-Tabelle unter LO (L0 5.0.5~rc1-1) gegengepüft. In der anderen Richtung ist Office 2013 nicht in der Lage mit LibreOffice erstellte, paßworgeschützte Dateien zu öffnen. Bricht mit zwei Arten von Fehlermeldungen ab. Ich empfehle alternativ z.B. eine beliebige Linuxdistribution mit halbwegs aktuellem LibreOffice da gehen auch passwortgeschützte *.xlsx-Dateien auf. Aktuell gerade getestet mit LO 4.4.3.2 Naja, nur wegen LibroOffice ein Linux installieren halte ich für overkill. An die zahlreichen Probleme und Fragen, die sich aus der völlig anderen Betriebssystem-Philosophie ergeben würden, mag ich da erst garnicht denken. Von LibreOffice gibt es auch auf Windows installierbare Pakete. - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Passwort geschütze XLSX-Datei
Am Dienstag, 26. Januar 2016, 14:09:46 schrieb Jörg Schmidt: Hallo Jörg > > Warum funktioniert es dann in OpenOffice z.B. bei passwortgeschützten > *.doc-Dateien? Warum funktioniert es in LibreOffivce auch mit z.B. > passwortgeschützten *.xlsx-Dateien? > Ich kenne es nicht anders, als daß sich in meinem Fall LibreOffice kommentarlos nach dem Paßwortdialog beendet (bzw. der Paßwortdialog ohne Reaktion beendet wird), wenn ich ein unter MS Office 2010 erstelltes, paßwortgeschütztes Dokument öffnen will. Das ist schon seit Jahren bei allen von meinem zeitweiligen Arbeitgeber übermittelten Dokumenten so. Habe das gerade mit einer 08/15-Excel-Tabelle unter LO (L0 5.0.5~rc1-1) gegengepüft. In der anderen Richtung ist Office 2013 nicht in der Lage mit LibreOffice erstellte, paßworgeschützte Dateien zu öffnen. Bricht mit zwei Arten von Fehlermeldungen ab. > > Ich empfehle alternativ z.B. eine beliebige Linuxdistribution mit > halbwegs aktuellem LibreOffice da gehen auch passwortgeschützte > *.xlsx-Dateien auf. Aktuell gerade getestet mit LO 4.4.3.2 > Naja, nur wegen LibroOffice ein Linux installieren halte ich für overkill. An die zahlreichen Probleme und Fragen, die sich aus der völlig anderen Betriebssystem-Philosophie ergeben würden, mag ich da erst garnicht denken. Von LibreOffice gibt es auch auf Windows installierbare Pakete. -- Gruß Stefan Debian GNU/Linux "Sid" (unstable) Desktop KDE Plasma KDE-PIM 4.14.10 Abscheußlichkeit hat einen neuen Namen: KDE Plasma - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Passwort geschütze XLSX-Datei
Am Montag, 25. Januar 2016, 18:48:44 schrieb harald.umla...@googlemail.com: Hallo Harald > > ich habe eine Passwort geschützte .XLSX Datei erhalten. > > Das Passwort ist mir bekannt, dennoch kann ich die Datei mit > OpenOffice Version 4.1.2 leider nicht öffnen. > > Hätten Sie eine Tipp für mich. > So etwas wird grundsätzlich nicht funktionieren, weil 1. Der Paßwortschutz in MS-Office und OOo auf völlig verschiedenen Algorhitmen basieren. 2. Die Techniken von MS-Office ein "Betriebsgeheimnis" sind und damit nicht offen liegen. Damit sind praktische alle Möglichkeiten versperrt das nachzubauen was MS im Bezug auf Paßwörter macht. 3. IMHO so eine Möglichkeit den Sinn des Paßwortschutzes generell unterlaufen würde. Es wird Dir nichts anderes übrige bleiben als das/die Dokument(e) auf einem Rechner mit MS Office zu öffnen und dort o_h_n_e Paßwortschutz zwischenspeichern. Danach mit OOo öffnen und ein neues Paßwort vergeben. Bei der Rückübertragung an MS Office dann der Wege in umgekehrter Reihenfolge. -- Gruß Stefan Debian GNU/Linux "Sid" (unstable) Desktop KDE Plasma KDE-PIM 4.14.10 Abscheußlichkeit hat einen neuen Namen: KDE Plasma - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Passwort geschütze XLSX-Datei
Sehr geehrte Damen und Herren, ich habe eine Passwort geschützte .XLSX Datei erhalten. Das Passwort ist mir bekannt, dennoch kann ich die Datei mit OpenOffice Version 4.1.2 leider nicht öffnen. Hätten Sie eine Tipp für mich. Viele Grüße Harald Umlauft
OpenOffice può aprire file docx e xlsx?
Salve, ho scaricato qualche giorno fa il vostro programma, molto interessante. Ho cercato di aprire file docx e xlsx, ma non riesco. Invece, i file doc e xls si aprono. OpenOffice può aprire file docx e xlsx? Grazie mille e cordiali saluti, Massimo Angeli (Italia)
Re: OpenOffice può aprire file docx e xlsx?
[ English: answering and redirecting to support channels in Italian ] Buonasera Massimo, confermo che OpenOffice apre anche file DOCX e XLSX. Può usare File - Apri, o fare tasto destro sul file e poi Apri con... per assegnarli ad OpenOffice. Questa mailing list (users) è in inglese. Per il supporto utenti in italiano deve usare la mailing list italiana http://mail-archives.apache.org/mod_mbox/openoffice-utenti-it/ o il forum italiano https://forum.openoffice.org/ Cordiali saluti, Andrea Pescetti. Il 05/08/2015 ams5106 ha scritto: Salve, ho scaricato qualche giorno fa il vostro programma, molto interessante. Ho cercato di aprire file docx e xlsx, ma non riesco. Invece, i file doc e xls si aprono. OpenOffice può aprire file docx e xlsx? Grazie mille e cordiali saluti, Massimo Angeli (Italia) - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenOffice può aprire file docx e xlsx?
On 8/5/2015 2:51 AM, ams5...@virgilio.it wrote: Salve, ho scaricato qualche giorno fa il vostro programma, molto interessante. Ho cercato di aprire file docx e xlsx, ma non riesco. Invece, i file doc e xls si aprono. OpenOffice può aprire file docx e xlsx? Grazie mille e cordiali saluti, Massimo Angeli (Italia) Credevo che sì fosse possibile aprire i file docx e xlsx con le ultime versioni di OO. Da quale sito l'hai scaricato? Dovresti scaricarlo solo dal sito openoffice.org. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office
2015-01-22 18:10 GMT+01:00 Stephen Knudsen yodocto...@gmail.com: Problem summary: I was sent a spreadsheet saved in *.xlsx format, but I do NOT have Microsoft Excel on my HP machine. When I attempt to open this file using Open Office, it locks up Open Office and pretends to load the spreadsheet indefinitely (with CPU resources hogged to the tune of 24% . WTF?) Tried to rename the offending *.xlsx file to a different extension, an ods file extensionbut my Win7 does not allow me using save as to do this What is the problem here? And what is the workaround? I always drag them to the trash and drop them there. Then I ask the sender to send the files in another format, such as PDF or ODF (usually the sender doesn't know what ODF is so it usually ends up with a PDF). Solves the problem for me… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -Stephen Knudsen
Re: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office
G'day! My machine runs W8.1 and has no trouble opening .xslx or .docx files using AOO 4.1.1. Just checked it again. Perhaps there is something not related to the different software that is causing the problem? On 23/01/2015 5:00 AM, Johnny Rosenberg wrote: 2015-01-22 18:10 GMT+01:00 Stephen Knudsen yodocto...@gmail.com: Problem summary: I was sent a spreadsheet saved in *.xlsx format, but I do NOT have Microsoft Excel on my HP machine. When I attempt to open this file using Open Office, it locks up Open Office and pretends to load the spreadsheet indefinitely (with CPU resources hogged to the tune of 24% . WTF?) Tried to rename the offending *.xlsx file to a different extension, an ods file extensionbut my Win7 does not allow me using save as to do this What is the problem here? And what is the workaround? I always drag them to the trash and drop them there. Then I ask the sender to send the files in another format, such as PDF or ODF (usually the sender doesn't know what ODF is so it usually ends up with a PDF). Solves the problem for me… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -Stephen Knudsen - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office
Problem summary: I was sent a spreadsheet saved in *.xlsx format, but I do NOT have Microsoft Excel on my HP machine. When I attempt to open this file using Open Office, it locks up Open Office and pretends to load the spreadsheet indefinitely (with CPU resources hogged to the tune of 24% . WTF?) Tried to rename the offending *.xlsx file to a different extension, an ods file extensionbut my Win7 does not allow me using save as to do this What is the problem here? And what is the workaround? -Stephen Knudsen
RE: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office
You can rename a file in the File Explorer, but that is not going to be helpful. Leave it named .xslx for the greatest possible success. As Rory suggests, you can try the Kingsoft (now WPS Office) 30-day freee trial to see if that will open the file successfully. WPS office is strongly-focused on interoperability with the Microsoft Office formats. You can also try the free Excel on the Web in your browser. You will need a OneDrive account, if you don't have one yet. Then you can upload Office files to OneDrive and then open and work with them in your browser. It is best to have Windows 7 or later on your HP machine. - Dennis PS: For any follow-up, please reply to users @ openoffice.apache.org where other experts may have advice and others can learn the solutions to common problems. The OpenOffice Forums have an extensive knowledge base at https://forum.openoffice.org/, -Original Message- From: Rory O'Farrell [mailto:ofarr...@iol.ie] Sent: Thursday, January 22, 2015 09:27 To: users@openoffice.apache.org Cc: Stephen Knudsen Subject: Re: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office On Thu, 22 Jan 2015 10:10:34 -0700 Stephen Knudsen yodocto...@gmail.com wrote: Problem summary: I was sent a spreadsheet saved in *.xlsx format, but I do NOT have Microsoft Excel on my HP machine. When I attempt to open this file using Open Office, it locks up Open Office and pretends to load the spreadsheet indefinitely (with CPU resources hogged to the tune of 24% . WTF?) Tried to rename the offending *.xlsx file to a different extension, an ods file extensionbut my Win7 does not allow me using save as to do this What is the problem here? And what is the workaround? -Stephen Knudsen You can try using www.zamzar.com who offer a free online conversion service. It is also possible that LibreOffice or Kingsoft Office may open the file. -- Rory O'Farrell ofarr...@iol.ie - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Problem with Opening Microsoft *.xlsx Spreadsheets with Open Office
On Thu, 22 Jan 2015 10:10:34 -0700 Stephen Knudsen yodocto...@gmail.com wrote: Problem summary: I was sent a spreadsheet saved in *.xlsx format, but I do NOT have Microsoft Excel on my HP machine. When I attempt to open this file using Open Office, it locks up Open Office and pretends to load the spreadsheet indefinitely (with CPU resources hogged to the tune of 24% . WTF?) Tried to rename the offending *.xlsx file to a different extension, an ods file extensionbut my Win7 does not allow me using save as to do this What is the problem here? And what is the workaround? -Stephen Knudsen You can try using www.zamzar.com who offer a free online conversion service. It is also possible that LibreOffice or Kingsoft Office may open the file. -- Rory O'Farrell ofarr...@iol.ie - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: xlsx
For reference: Hello and good day! Have a problem with the Excel format xlsx. The files take forever until they open. Why might that be? 've Attached such a file. Mfg.
Re: xlsx
On Mon, 02 Jun 2014 08:00:52 -, Robert Schmidt robertschm...@w-s-d.at wrote: Hallo und guten Tag! Habe mit den Excelformat xlsx ein Problem. Die Dateien brauchen ewig bis sie sich öffnen. Woran kann das liegen? Deutsch-sprachige Mailingliste finden Sie hier: users...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
OpenOffice 4.0.1 / Problem with xlsx file
Hallo, we are using OpenOffice 4.0.1 With Calc we can open xlsx files generated by Excel 2010. But when we generate a xlsx file with TIA Portal from Siemens, we cannot open it with OpenOffice. It works with Excel 2010. Thank you for any advice.
Re: AOO can't open .xlsx spreadsheet at Cornell site
Dick Hoffman wrote: https://issues.apache.org/ooo/show_bug.cgi?id=123429 since this is definitely a performance bug. Thanks for opening a bug on this. I don't understand the comment from Andreas Säger; does that mean no action will be taken on the bug? It's simply an analysis of the pathological characteristics of this document. This is needed as a first step in investigating why OpenOffice is slow in opening it. Regards, Andrea. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
Dick Hoffman wrote: I upgraded to AOO 4.0.1, so out of curiosity I tried to access the .xlsx file at the Cornell site. Results were the same; after about 20 minutes the progress bar showed about 25% of the file loaded and I had to use the Windows Task Manager to terminate soffice.bin to stop it. It opens normally for me with 4.0.1; however, it takes unacceptably long (13 minutes in my case). I opened https://issues.apache.org/ooo/show_bug.cgi?id=123429 since this is definitely a performance bug. Regards, Andrea. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
2013/9/26 Dick Hoffman old...@ix.netcom.com On 9/25/2013 7:54 PM, Kay Schenk wrote: On Tue, Sep 24, 2013 at 2:58 PM, Dick Hoffman old...@ix.netcom.com wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/http://www.birds.cornell.edu/**clementschecklist/download/ h**ttp://www.birds.cornell.edu/**clementschecklist/download/http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman --** --**- To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org users-unsubscribe@**openoffice.apache.orgusers-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-help@openoffice.apache.org users-help@openoffice.**apache.org users-h...@openoffice.apache.org No suggestions and yes AOO 4.0.x has a problem with it. I downloaded it as well. I hope it doesn't contain personal data. If it does, I will delete it. On the other hand, if it doesn't, can we use it as an attachment to an issue? This would be helpful to troubleshoot this problem. Thanks. The spreadsheet at the Cornell site doesn't contain any personal data; it can be used for troubleshooting purposes, or any other. I've had various suggestions and received several remedies. To summarize: the .xlsx file can apparently be read in OO 3.1.1 (someone who was able to do so saved it as a .ods and sent it on to me); the .xlsx file apparently can be read in AOO 4.0.1 (someone who was able to do so offered to save it as a .ods and send it on to me); yes, the .csv file can be taken into AOO or Excel to create an equivalent spreadsheet but you lose the color coding that is in the .xlsx which helps when scrolling through the data and the references from the second sheet of the .xlsx file don't seem to be present in the .csv file. I now have a version of the Cornell file in .ods format that serves my purposes. Thanks to all of you for your comments and suggestions. What a great group of people you are! Dick Hoffman Cleveland Heights, OH Dick, it takes about ten seconds to launch this file in LibreOffice 4.1.1.2 on my machine running 64-bit Linux Mint 15 Henri
Re: AOO can't open .xlsx spreadsheet at Cornell site
On Thu, Sep 26, 2013 at 12:31 PM, Kay Schenk kay.sch...@gmail.com wrote: On Wed, Sep 25, 2013 at 6:28 PM, Rob Weir robw...@apache.org wrote: On Tue, Sep 24, 2013 at 5:58 PM, Dick Hoffman old...@ix.netcom.com wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman Hi Dick, I can confirm the problem you report with AOO 4.0.0. But I then tried with AOO 4.0.1, a newer version which should be officially released soon. It was able to load that XLSX file. It was slow, but it did fully open. When I saved it as an ODS file, OpenOffice's native format, subsequent opens were much faster. I can send you the ODS version if you want. Or you can try again with AOO 4.0.1 once that releases. Regards, -Rob @Rob -- what OS are you using, given Julian's comment on this as well. Windows 7, 32-bit. I tried 4.0.1., Linux-32, and well basically gave up at the (about) 25% load status. For me it stopped there as well. I took a phone call, and when I checked again the document was open. Check your CPU and see if it is still showing the soffice process as active. -Rob I will try again. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- - MzK Truth is stranger than fiction, but it is because Fiction is obliged to stick to possibilities. Truth isn't. -- Following the Equator, Mark Twain - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
RE: AOO can't open .xlsx spreadsheet at Cornell site
I opened that 32,000+ row Cornell file as an XLSX in 15 to 20 seconds. To peek at it, I turn CELL WRAP on, and saw that some cells had massive amts of text. I'm running W/7 on a 5 or 6 year old HP. Maurice -Original Message- From: Rob Weir [mailto:robw...@apache.org] Sent: Thursday, September 26, 2013 1:01 PM To: users@openoffice.apache.org Subject: Re: AOO can't open .xlsx spreadsheet at Cornell site On Thu, Sep 26, 2013 at 12:31 PM, Kay Schenk kay.sch...@gmail.com wrote: On Wed, Sep 25, 2013 at 6:28 PM, Rob Weir robw...@apache.org wrote: On Tue, Sep 24, 2013 at 5:58 PM, Dick Hoffman old...@ix.netcom.com wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman Hi Dick, I can confirm the problem you report with AOO 4.0.0. But I then tried with AOO 4.0.1, a newer version which should be officially released soon. It was able to load that XLSX file. It was slow, but it did fully open. When I saved it as an ODS file, OpenOffice's native format, subsequent opens were much faster. I can send you the ODS version if you want. Or you can try again with AOO 4.0.1 once that releases. Regards, -Rob @Rob -- what OS are you using, given Julian's comment on this as well. Windows 7, 32-bit. I tried 4.0.1., Linux-32, and well basically gave up at the (about) 25% load status. For me it stopped there as well. I took a phone call, and when I checked again the document was open. Check your CPU and see if it is still showing the soffice process as active. -Rob I will try again. --- -- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- -- --- MzK Truth is stranger than fiction, but it is because Fiction is obliged to stick to possibilities. Truth isn't. -- Following the Equator, Mark Twain - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4142 / Virus Database: 3604/6700 - Release Date: 09/26/13 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
Alexandro Colorado: I have found issues with the XLSX formats which doent follow a unique convention, XLSX that have been auto-generated or generated programatically differ from the ones programatically generated. This also look like a very poorly designed table, LOL, whiteknights are so annoying. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
On 25Sep 2013, at 7:54 PM, Kay Schenk kay.sch...@gmail.com wrote: No suggestions and yes AOO 4.0.x has a problem with it. I downloaded it as well. I hope it doesn't contain personal data. If it does, I will delete it. 1. AOO won't open it on OSX. 2. MS Office had no problem [surprise?] 3. I'm pretty sure there is no personal data in the file. -- j...@jt-mj.net http://jt-mj.net We do precision guesswork. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
On 24Sep 2013, at 11:08 PM, Joe Conner joeconner2...@gmail.com wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel suffice. Note that you can also download a CSV version which I suspect would import with no hassle. Has anyone tried? -- j...@jt-mj.net http://jt-mj.net We do precision guesswork. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
On Tue, Sep 24, 2013 at 5:58 PM, Dick Hoffman old...@ix.netcom.com wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman Hi Dick, I can confirm the problem you report with AOO 4.0.0. But I then tried with AOO 4.0.1, a newer version which should be officially released soon. It was able to load that XLSX file. It was slow, but it did fully open. When I saved it as an ODS file, OpenOffice's native format, subsequent opens were much faster. I can send you the ODS version if you want. Or you can try again with AOO 4.0.1 once that releases. Regards, -Rob - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
AOO can't open .xlsx spreadsheet at Cornell site
I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
I have found issues with the XLSX formats which doent follow a unique convention, XLSX that have been auto-generated or generated programatically differ from the ones programatically generated. As I looked into the file, it seems that the amount of rows is greater than the amount AOO support. This also look like a very poorly designed table, so the CSV is completely useless. I think this was generated as an afterthought rather than as a propper datasource. On Tue, Sep 24, 2013 at 4:58 PM, Dick Hoffman old...@ix.netcom.com wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/**clementschecklist/download/http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman --**--**- To unsubscribe, e-mail: users-unsubscribe@openoffice.**apache.orgusers-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-help@openoffice.apache.**orgusers-h...@openoffice.apache.org -- Alexandro Colorado Apache OpenOffice Contributor http://www.openoffice.org 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614
Fwd: AOO can't open .xlsx spreadsheet at Cornell site
It opens in LibreOffice. I can send you an .odt offline if you wish. Original Message Subject:AOO can't open .xlsx spreadsheet at Cornell site Date: Tue, 24 Sep 2013 17:58:59 -0400 From: Dick Hoffman old...@ix.netcom.com Reply-To: users@openoffice.apache.org To: users@openoffice.apache.org I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org