Re: Excel formula tool tip suggestion to match Microsoft's feature

[David]

Steve Greaves wrote:

Hi, team.
When building a formula in Excel, the tool tip does not go *BOLD,* as 
you type, unlike Microsoft's Excel.

May I suggest that this could be developed in a newer version?
Examples below:
Microsoft's has the BOLD type to help...



Developers don't visit here generally; see Reporting bugs or suggestions 
https://forum.openoffice.org/en/forum/viewtopic.php?f=6=13490


Since you are not subscribed to this list you may not see all the 
replies to your query. To subscribe to Apache OpenOffice mailing lists 
go to http://openoffice.apache.org/mailing-lists.html


As a courtesy I have forwarded a copy of this reply to you as well as to 
the mailing list. Do Not reply to me personally but just to the list at 
 - replies to my personal email address 
will be ignored.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Excel formula tool tip suggestion to match Microsoft's feature

[Steve Greaves]

Hi, team.
When building a formula in Excel, the tool tip does not go BOLD, as you type, 
unlike Microsoft's Excel.
May I suggest that this could be developed in a newer version?
Examples below:
 
Microsoft's has the BOLD type to help...

Re: Excel-Tabelle

[Semmel]

Liebe Magdalena,

Magdalena Feneberg schrieb am 06.04.2023 um 11:49:

Liebes Open Office Team,

ich hab ein Protokoll in Open Office Excel geschrieben. Das Protokoll
beträgt zwei Seiten.
Wenn ich den Druck anstoße werden immer 188 Seiten zum Drucken angezeigt -
also zwei beschriebene und 186 leere Seiten. Ich finde den Fehler nicht.
Was hab ich falsch gemacht, bzw. wie kann ich die leeren Seiten löschen?

Ich finde den Fehler nicht, den ich gemacht habe.

Danke für den Support.

Viele Grüße

Magdalena Feneberg


zunächst einmal der Hinweis, dass ich deine persönlichen Kontaktdaten
aus der Mail gelöscht habe und dir zugleich raten würde, deinen Footer
in der bisherigen Form zu eleminieren. Deine Angaben landen auch in der
Mailingliste, werden dort veröffentlicht und so für sehr viele und über
einen langen Zeitraum im Netz sichtbar bleiben.

_Zu deinem Problem:_

1. Es ist überaus schwierig, mit so wenigen Informationen eine Lösung
   zu nennen. Sofern dein Protokoll keinerlei kompromittierenden oder
   geheimen Daten beinhaltet, empfehle ich Dir, dieses bei einem
   "Upload-Service" (z.B. https://www.file-upload.net/ oder
   https://www.transferxl.com/de/ o.ä.) zu speichern und hier in der
   Mailingliste den entsprechenden Link auf dein Protokoll zu posten,
   so dass mehrere/ viele andere Helfer mal einen Blick auf das
   Dokument werfen können. (Der Umweg über den Upload-Service wäre
   nötig, da in der Mailingliste sämtlich Dateianhänge abgeschnitten
   werden und damit für die Helfer nicht "greifbar" sind.)
2. Du kannst mir (oder einem anderen Antwortgeber) die Datei auch an
   die persönliche Mailadresse senden und ich werfe mal einen Blick darauf.
3. Wenn Du selbst die Lösung suchen möchtest, prüfe bitte mal deine
   Schriftgröße und den Inhalt der Zeillen auf mögliche Leerzeichen.
   Wenn die Schrift sehr groß gewählt wurde oder viele Leerzeichen
   beinhaltet und damit über die (eigentlich) gewählte Seitenbreite/
   -länge hinaus gehen, werden zwangsläufig mehr Seiten gedruckt.
   Gleiches gilt für den Fall, wenn du (beabsichtigt oder
   versehentlich) nur ein einziges druckbares Zeichen in die Zelle z.
   B. AF212 (also eine Zelle sehr weit "hinten" in dem Dokument)
   gesetzt hast. OpenOffice glaubt dann, dass *alles* bis zu dieser
   Zelle (einschließlich) ausgedruckt werden soll und produziert
   dementsprechend viele Seiten.
4. Eine etwas andere Möglichkeit, sich diesem Problem zu nähern wäre
   die, dass du ein _neues_ Tabellendokument öffnest und dann die
   gewünschten, zu druckenden/ erforderlichen Zellen von Deinem
   Protokoll in den Kurzspeicher nimmst und diese dann in das neue
   Dokument wieder einfügst.
5. Unabhängig davon, was die Druckvorschau dir an Seiten angibt: Was
   geschieht, wenn du das wirklich ausdrucken lässt? Wie viele Seiten
   werden dann gedruckt?
6. Als letzter Vorschlag einer Problemlösung: Was geschieht, wenn Du
   unter   die auszudruckenden Zellen auf ein (zu
   druckendes) Minimum begrenzt (z.B. $D$1:$F$36)?

Schön wäre eine Rückmeldung von dir _*an die Liste*_ - mit möglichst
vielen Detailangaben, was du gemacht/ unternommen hast.

Liebe Grüße, Peter.

--
Hat eigentlich schon mal jemand durchgerechnet, was es kosten
würde, die Bundesregierung durch Fachkräfte zu ersetzen ?  :)

Re: Excel-Tabelle

[Dave]

... Ist OpenOffice Calc (nicht Microsoft Excel) das richtige Werkzeug,
um ein Protokoll zu verfassen? Ich würde einfach OpenOffice Writer
dafür verwenden

On Fri, 7 Apr 2023 at 09:07, H.-Stefan Neumeyer
 wrote:
>
> Am Donnerstag, 6. April 2023, 11:49:56 CEST sprach Magdalena Feneberg, und
> nicht Zarathustra:
>
> Moin Magdalena
> >
> > Ich finde den Fehler nicht, den ich gemacht habe.
> >
> Vielleicht ein druckbares Zeichen (Satzzeichen, Buchstabe, Zahl) auf der
> "letzten" Seite?
> So was ist m_i_r nämlich schon mal passiert. ;-)
>
> --
>  Gruß Stefan
>
> Mein Betriebssystem Debian/GNU Linux Sid (Debian unstable) + KDE-Plasma
> e-Mail mit KMail Version  Version 5.21.3 (22.12.3-1)
>
> "...was für eine deprimierend dämliche Maschine..."

-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Excel-Tabelle

[H.-Stefan Neumeyer]

Am Donnerstag, 6. April 2023, 11:49:56 CEST sprach Magdalena Feneberg, und 
nicht Zarathustra:

Moin Magdalena
> 
> Ich finde den Fehler nicht, den ich gemacht habe.
> 
Vielleicht ein druckbares Zeichen (Satzzeichen, Buchstabe, Zahl) auf der 
"letzten" Seite?
So was ist m_i_r nämlich schon mal passiert. ;-)

-- 
 Gruß Stefan

Mein Betriebssystem Debian/GNU Linux Sid (Debian unstable) + KDE-Plasma
e-Mail mit KMail Version  Version 5.21.3 (22.12.3-1)

"...was für eine deprimierend dämliche Maschine..."

signature.asc
Description: This is a digitally signed message part.

Excel-Tabelle

[Magdalena Feneberg]

Liebes Open Office Team,
 
ich hab ein Protokoll in Open Office Excel geschrieben. Das Protokoll 
beträgt zwei Seiten.
Wenn ich den Druck anstoße werden immer 188 Seiten zum Drucken angezeigt - 
also zwei beschriebene und 186 leere Seiten. Ich finde den Fehler nicht. 
Was hab ich falsch gemacht, bzw. wie kann ich die leeren Seiten löschen?
 
Ich finde den Fehler nicht, den ich gemacht habe.
 
Danke für den Support.
 
Viele Grüße
 
Magdalena Feneberg
Fritz-Pullig-Str. 6
53757 Sankt Augustin
e-mail: magdalena.feneb...@t-online.de
<mailto:magdalena.feneb...@t-online.de>
phone: 015120223383 
 


Re: excel

[Johnny Rosenberg]

Den tis 14 feb. 2023 kl 07:04 skrev Richard Rik
:

> Do you offer a free excel with apache?


No, I don't. Neither does Apache.
So what do Apache offer?
Free spreadsheet app – yes (called ”Calc”).
Free Excel – no, only Microsoft can offer such a thing since it's their
product, so ask them. They will most likely say no, but who knows?

>
>   If so have a question or two.
>

So no questions then, I guess.

> thank you



Kind regards

Johnny Rosenberg

Re: excel

[David Robley]

"We" on this list are merely users of Apache OpenOffice. AOO does have a 
spreadsheet component named Calc. You can find more information at 
https://www.openoffice.org/ which might answer your potential questions.


As you are not subscribed to this mailing list, you may not see all 
answers to your mail. As a courtesy I have sent a copy of my reply to 
you; please Do Not respond to me, but to the mailing list. to you


On 14/02/2023 13:19, Richard Rik wrote:

Do you offer a free excel with apache?  If so have a question or two.
thank you


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

excel

[Richard Rik]

Do you offer a free excel with apache?  If so have a question or two.
thank you

Re: Opening an excel file that is password protected

[Maurice Howe]

Oh, that's easy.
Send the file to a trusted friend and have him/her unravel it for you.

Maurice Howe

<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Mon, Jun 13, 2022 at 5:03 PM John Jay  wrote:

> Is there a way to open an excel file that has been password protected. I
> no longer have Excel so I can't remove the password that way. When I try to
> open the file in Spreadsheet it opens up a filter selection box. I have
> chosen several of the excel formats but nothing seems to work.
>
> Thanks
> John Jaworski
>
>

Re: Opening an excel file that is password protected

[Maurice Howe]

Oh, that's easy.
Send the file to a trusted friend and have him/her unravel it for you.

Maurice Howe

<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Mon, Jun 13, 2022 at 5:03 PM John Jay  wrote:

> Is there a way to open an excel file that has been password protected. I
> no longer have Excel so I can't remove the password that way. When I try to
> open the file in Spreadsheet it opens up a filter selection box. I have
> chosen several of the excel formats but nothing seems to work.
>
> Thanks
> John Jaworski
>
>

Opening an excel file that is password protected

[John Jay]

Is there a way to open an excel file that has been password protected. I no 
longer have Excel so I can't remove the password that way. When I try to open 
the file in Spreadsheet it opens up a filter selection box. I have chosen 
several of the excel formats but nothing seems to work.

Thanks
John Jaworski

OpenOffice vs Microsoft Excel and Word

[ROBERT KNIGHT]

Customer Service/Tech Support:

I am currently using (on a Mac) Microsoft Excel and Word, for all of my data 
and records.
Will OpenOffice allow me to migrate or transfer (accurately) data and info from 
Excel & Word to OpenOffice?

Thanks,
Bob
630-975-4212 cell
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Excel equivalent

[Girvin Herr]

On 5/3/21 8:48 AM, Brian Barker wrote:

Such users will also miss facilities present in the new product that 
they know nothing of. Here's an example. Suppose you want to 
concatenate the text in two adjacent spreadsheet cells into a single 
cell. In OpenOffice, you can merge the two cells - when OpenOffice 
will offer to combine the contents and even helpfully interpose a 
blank character - and then immediately unmerge them. The combined text 
ends up in the first cell. Of course you can achieve the same result 
in Microsoft Excel, but not (I believe) in the same way or indeed 
anywhere near as easily.


I might add that this feature is not in Calc alone. Writer tables can 
also merge and split cells. I have used it to create forms with varying 
width blocks. I am not sure if msWord tables do this.


Girvin



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Excel equivalent

[Brian Barker]

At 14:41 03/05/2021 +0100, Robin Lord wrote:

I don't agree open office calc is pretty much identical to excel, ...


All spreadsheet programs are similar, of course: they simply have to 
be. Is that what you mean by "pretty much identical"? My point was 
not to suggest that OpenOffice (Calc) and Microsoft Excel were 
particularly different, but to say that approaching any new product 
expecting it to be identical to another was ill advised. I feel that 
users sometimes expect facilities in a new product to appear just as 
they did in their previous experience and then reject the new product 
as wanting as soon as they find this not to be so. (The current 
questioner's use of the term "equivalent" suggested that he might 
have been guilty of this.)


Such users will also miss facilities present in the new product that 
they know nothing of. Here's an example. Suppose you want to 
concatenate the text in two adjacent spreadsheet cells into a single 
cell. In OpenOffice, you can merge the two cells - when OpenOffice 
will offer to combine the contents and even helpfully interpose a 
blank character - and then immediately unmerge them. The combined 
text ends up in the first cell. Of course you can achieve the same 
result in Microsoft Excel, but not (I believe) in the same way or 
indeed anywhere near as easily.


... before I retired the only major difference I found was the 
number of rows in excel was much bigger, ...


You may have missed some of OpenOffice's advantages!

Brian Barker  



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Excel equivalent

[Robin Lord]

I don't agree open office calc is pretty much identical to excel, before I 
retired the only major difference I found was the number of rows in excel was 
much bigger, and even that may have changed in the 10 years since, I never now 
need to have millions of rows in a spreadsheet. Even when I did have the need 
it was because people were using excel in ways that they should not have done. 

On Mon, 3 May 2021, at 14:34, Brian Barker wrote:
> At 13:09 03/05/2021 +0100, Brian Barnard wrote:
> >Subject: Excel equivalent
> 
> It is a mistake to think that any software product is the equivalent 
> of any other. OpenOffice's spreadsheet function ("Calc") is not 
> offered as an equivalent of Microsoft Excel. It would be equally 
> unhelpful to approach Microsoft Excel as an equivalent of OpenOffice.
> 
> >In your spreadsheet handler ...
> 
> Er, it's OpenOffice's, not mine.
> 
> >... I recently tried to edit a column of literals (all numeric) but 
> >your find and replace would not replace the characters that I 
> >entered with the new ones. In the same column were alphabetic 
> >literals and I could replace these with no problem.
> 
> I cannot reproduce this. If you are handling literals which happen to 
> be entirely numeric, you should presumably take care to ensure that 
> they are stored in Text and not Number format. This is a matter of 
> knowing how to design a spreadsheet and how to enter and save values, 
> not about the facilities available. But in any case, I see that Find 
> & Replace will process individual digits even in numerical values, 
> even toggling values between Number and Text format as necessary. So 
> I do not see your difficulty and you may have to be clearer about 
> exactly what doesn't work for you.
> 
> >As a result of this I have had to buy Office 2019 and uninstall Open Office
> 
> Well, you are perfectly entitled to make such a decision - and you 
> are welcome to do so. But this is surely not a result of your failure 
> to solve your problem in OpenOffice. And if you are happy using 
> Microsoft Office, I'm not sure what help you are requesting from the 
> OpenOffice Users list. (And you don't have to remove OpenOffice in 
> order to install and use Microsoft Office anyway.)
> 
> I trust this helps.
> 
> Brian Barker
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
> 
> 


-- 
Best Regards

Robin

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Excel equivalent

[Brian Barker]

At 13:09 03/05/2021 +0100, Brian Barnard wrote:

Subject: Excel equivalent


It is a mistake to think that any software product is the equivalent 
of any other. OpenOffice's spreadsheet function ("Calc") is not 
offered as an equivalent of Microsoft Excel. It would be equally 
unhelpful to approach Microsoft Excel as an equivalent of OpenOffice.



In your spreadsheet handler ...


Er, it's OpenOffice's, not mine.

... I recently tried to edit a column of literals (all numeric) but 
your find and replace would not replace the characters that I 
entered with the new ones. In the same column were alphabetic 
literals and I could replace these with no problem.


I cannot reproduce this. If you are handling literals which happen to 
be entirely numeric, you should presumably take care to ensure that 
they are stored in Text and not Number format. This is a matter of 
knowing how to design a spreadsheet and how to enter and save values, 
not about the facilities available. But in any case, I see that Find 
& Replace will process individual digits even in numerical values, 
even toggling values between Number and Text format as necessary. So 
I do not see your difficulty and you may have to be clearer about 
exactly what doesn't work for you.



As a result of this I have had to buy Office 2019 and uninstall Open Office


Well, you are perfectly entitled to make such a decision - and you 
are welcome to do so. But this is surely not a result of your failure 
to solve your problem in OpenOffice. And if you are happy using 
Microsoft Office, I'm not sure what help you are requesting from the 
OpenOffice Users list. (And you don't have to remove OpenOffice in 
order to install and use Microsoft Office anyway.)


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Excel equivalent

[Joost Andrae]

Hi Brian,

a literal is a text. If you want to replace a number which is formatted 
as text by having a single quote as the first character then you can 
start the replace string with a single qoute ' to leave it as a literal.


Alternatively you can format this number string as text (menu item 
format cell)


In both cases search replaces the string accordingly

Kind regardsm Joost


Am 03.05.2021 um 14:09 schrieb Brian Barnard:

In your spreadsheet handler I recently tried to edit a column of literals
(all numeric) but your find and replace would not replace the
characters that I entered with the new ones.  In the same column were
alphabetic literals and I could replace these with no problem.  As a result
of this I have had to buy Office 2019 and uninstall Open Office





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Excel equivalent

[Brian Barnard]

In your spreadsheet handler I recently tried to edit a column of literals
(all numeric) but your find and replace would not replace the
characters that I entered with the new ones.  In the same column were
alphabetic literals and I could replace these with no problem.  As a result
of this I have had to buy Office 2019 and uninstall Open Office

Re: Probleme mit Excel Dateien

[Uwe Altmann]

Hi Dave

Am 17.12.20 um 18:02 schrieb Dave:
> ich öffne täglich .docx Dateien ohne Probleme, mit Openoffice und nicht mit
> Libreoffice

Möglicherweise aber nicht auf dem neuesten Apple-Betriebssystem 10.16 aka 
"BigSur"? Falls doch, wäre das hoch interessant, da das Internet voll ist von 
Leuten, bei denen das nicht klappt, sondern (wie bereits geschrieben) in einem 
Absturz von AOO endet.
--
Eine schöne Zeit
Uwe

/"Die Leute glauben nicht den Tatsachen, sondern das, was sie gerne glauben 
wollen, bis schliesslich die Tatsachen die Geduld verlieren und mit einer 
Katastrophe zuschlagen.“/ (Poul Anderson 1970)

-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

RE: Probleme mit Excel Dateien

[Jörg Schmidt]

Hallo Uwe, 

> -Original Message-
> From: Uwe Altmann [mailto:uwe.altm...@web.de] 
> Sent: Thursday, December 17, 2020 11:49 AM
> To: users-de@openoffice.apache.org
> Subject: Re: Probleme mit Excel Dateien
> 
> Hi
> 
> Am 16.12.20 um 18:36 schrieb Christoph Kurth:
> 
> > Ich kann leider mit meinem Mac (IOS Big Sur) keine XLSX 
> Dateien öffnen, es kommt ein Fenster mit vielen Daten aber 
> aber nicht was in der Datei zu lesen sein sollte.
> 
> Da hast Du noch Glück - meist stürzt AOO unter Big Sur bei 
> dem Versuch, OOXML-Dokumente wie .docx und .xlsx zu öffnen, 
> einfach ab [1]. Da hilft (zumindest derzeit) nur die 
> Verwendung von LibreOffice.

Mutmaßlich gibt es zu den Problemen von AOO & Big Sur keine völlig erschöpfende 
Antwort, aber da ich mich im Forum de.openoffice.info als Moderator auch dafür 
verantwortlich fühle bei schwer zu klärenden Fragen (wo also keine oder nur 
unbefriedigende Antworten kommen) zu versuchen den Fragern doch irgendwie Hilfe 
zu geben hat mich, als bekanntermaßen nicht mit MacOS Vertrauten, das Thema 
bereits in 2 Threads beschäftigt:
https://de.openoffice.info/viewtopic.php?f=3=75090
https://de.openoffice.info/viewtopic.php?f=3=75136

Vielleicht könntest Du dort (D)eine Einschätzung der Situation reinschreiben? 
(Du kannst dort auch ohne Anmeldung posten)

Der Unterschied der Forumsthreads zum Thread hier ist, das es im Forum ganz 
allgemein um AOO & Big Sur geht und nicht speziell um OOXML.
Natürlich ist in den dortigen 2 Threads auch ein Hinweis auf LO willkommen (es 
gibt auch schon Einen), wichtiger ist aber die Einschätzung zu AOO und Big Sur, 
weil die Anwender ja danach fragen.

(Wie Du siehst hatte ich selbst schon auf unserer dev-Liste gefragt und das 
auch im Forum verlinkt, nur auf der Liste ist soviel technisches Hin- und Her, 
das das für Anwender eigentlich fast ohne Nutzen ist.)




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: Probleme mit Excel Dateien

[Dave]

ich öffne täglich .docx Dateien ohne Probleme, mit Openoffice und nicht mit
Libreoffice

On Thu 17. Dec 2020 at 11:49, Uwe Altmann  wrote:

> Hi
>
> Am 16.12.20 um 18:36 schrieb Christoph Kurth:
>
> > Ich kann leider mit meinem Mac (IOS Big Sur) keine XLSX Dateien öffnen,
> es kommt ein Fenster mit vielen Daten aber aber nicht was in der Datei zu
> lesen sein sollte.
>
> Da hast Du noch Glück - meist stürzt AOO unter Big Sur bei dem Versuch,
> OOXML-Dokumente wie .docx und .xlsx zu öffnen, einfach ab [1]. Da hilft
> (zumindest derzeit) nur die Verwendung von LibreOffice.
>
> Was Du "Fenster mit vielen Daten" nennst ist entweder Datenmüll - oder die
> Einstellungen für den ACII-Import-Filter. Ohne nähere Angaben oder
> Screenshots schwer zu sagen.
>
> [1]
> https://blog.documentfoundation.org/wp-content/uploads/2020/12/AOO_crash.webm
> --
> Eine schöne Zeit
> Uwe
>
> /"Die Leute glauben nicht den Tatsachen, sondern das, was sie gerne
> glauben wollen, bis schliesslich die Tatsachen die Geduld verlieren und mit
> einer Katastrophe zuschlagen.“/ (Poul Anderson 1970)
>
> -
> To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-de-h...@openoffice.apache.org
>
>

Re: Probleme mit Excel Dateien

[Uwe Altmann]

Hi

Am 16.12.20 um 18:36 schrieb Christoph Kurth:

> Ich kann leider mit meinem Mac (IOS Big Sur) keine XLSX Dateien öffnen, es 
> kommt ein Fenster mit vielen Daten aber aber nicht was in der Datei zu lesen 
> sein sollte.

Da hast Du noch Glück - meist stürzt AOO unter Big Sur bei dem Versuch, 
OOXML-Dokumente wie .docx und .xlsx zu öffnen, einfach ab [1]. Da hilft 
(zumindest derzeit) nur die Verwendung von LibreOffice.

Was Du "Fenster mit vielen Daten" nennst ist entweder Datenmüll - oder die 
Einstellungen für den ACII-Import-Filter. Ohne nähere Angaben oder Screenshots 
schwer zu sagen.

[1] 
https://blog.documentfoundation.org/wp-content/uploads/2020/12/AOO_crash.webm
--
Eine schöne Zeit
Uwe

/"Die Leute glauben nicht den Tatsachen, sondern das, was sie gerne glauben 
wollen, bis schliesslich die Tatsachen die Geduld verlieren und mit einer 
Katastrophe zuschlagen.“/ (Poul Anderson 1970)

-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Probleme mit Excel Dateien

[technik_...@jrsch.de]

Hallo Christoph,

zuerst einmal braucht man einige Angaben mehr.

Ich gehe davon aus, dass du auf dem Mac OpenOffice auch installiert 
hast. Welche Version?


Wie öffnest du die Dateien, bzw. versuchts es?

Was genau für ein Fenster entsteht? Was steht darin?

Horst

Am 16.12.2020 um 18:36 schrieb Christoph Kurth:

Guten Tag !
Ich kann leider mit meinem Mac (IOS Big Sur) keine XLSX Dateien öffnen, es 
kommt ein Fenster mit vielen Daten aber aber nicht was in der Datei zu lesen 
sein sollte.
Was mache ich falsch ?
Danke !
Beste Grüße.
Christoph Kurth
Ringstraße 182
Funk: +491754356779
christoph.ku...@yahoo.de




-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org



-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Probleme mit Excel Dateien

[Christoph Kurth]

Guten Tag !
Ich kann leider mit meinem Mac (IOS Big Sur) keine XLSX Dateien öffnen, es 
kommt ein Fenster mit vielen Daten aber aber nicht was in der Datei zu lesen 
sein sollte.
Was mache ich falsch ?
Danke !
Beste Grüße.
Christoph Kurth
Ringstraße 182
Funk: +491754356779
christoph.ku...@yahoo.de




-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Open Office Excel

[Shari Lynn Smith]

Great! Glad the ending was a happy one.
Shari

On Wed, Aug 26, 2020, 1:13 AM  wrote:

> Thanks Shari for responding,
>
> I was able to sort it out with the help of RoryOF on the forum. Take a
> look for more details:
>
> https://forum.openoffice.org/en/forum/viewtopic.php?f=9=102846=497589#p497589
>
> All Best, Joelle
>
> On 2020-08-25 13:33, Web Shari wrote:
>
> > Are you receiving any error message?
> >
> > The size shouldn't effect it's ability unless you have hundreds of
> sheets. Emails also shouldn't make a difference.
> >
> > Shari
> >
> > On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote:
> >
> >> Hi,
> >>
> >> One of my Open Office Excel files is not opening. My other files are
> >> opening fine. It is a very big file with a list of emails. I wonder if
> >> the links are too heavy or complex? Not that I really know what I am
> >> talking about. Is there anything I can do to retrieve my data?
> >>
> >> All best, Joelle
> >
> > -
> > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> > For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Excel

[Andrew Pitonyak]

Excellent... And Rory is awesome...

⁣Sent from BlueMail ​

On Aug 26, 2020, 2:13 AM, at 2:13 AM, mermaidl...@gwi.net wrote:
>Thanks Shari for responding,
>
>I was able to sort it out with the help of RoryOF on the forum. Take a
>look for more details:
>https://forum.openoffice.org/en/forum/viewtopic.php?f=9=102846=497589#p497589
>
>All Best, Joelle
>
>On 2020-08-25 13:33, Web Shari wrote:
>
>> Are you receiving any error message?
>>
>> The size shouldn't effect it's ability unless you have hundreds of
>sheets. Emails also shouldn't make a difference.
>>
>> Shari
>>
>> On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote:
>>
>>> Hi,
>>>
>>> One of my Open Office Excel files is not opening. My other files are
>>> opening fine. It is a very big file with a list of emails. I wonder
>if
>>> the links are too heavy or complex? Not that I really know what I am
>>> talking about. Is there anything I can do to retrieve my data?
>>>
>>> All best, Joelle
>>
>> -
>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Excel

[mermaidlady]

Thanks Andrew for responding, 


I was able to sort it out with the help of RoryOF on the forum. Take a
look for more details:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9=102846=497589#p497589

All Best, Joelle

On 2020-08-25 14:47, Andrew Pitonyak wrote:


What is the documents file extension? I'm

How large is the file?

If you cannot do it, I might be able to convert it to an ods (calc) file for 
you. That said, excel may be able to write an ods file directly.

It is better, of course, if you do it yourself.

If AOO cannot do it, I might try LO (LibreOffice), sometimes, what fails in one works in the other. Kind of a least resort for a casual user I think. 


⁣Sent from BlueMail ​

On Aug 25, 2020, 1:33 PM, at 1:33 PM, Web Shari  wrote: 
Are you receiving any error message?

The size shouldn't effect it's ability unless you have hundreds of 
sheets. Emails also shouldn't make a difference.


Shari

On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote: Hi,

One of my Open Office Excel files is not opening. My other files are
opening fine. It is a very big file with a list of emails. I wonder if the 
links are too heavy or complex? Not that I really know what I am
talking about. Is there anything I can do to retrieve my data?

All best, Joelle 
-

To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Excel

[mermaidlady]

Thanks Shari for responding, 


I was able to sort it out with the help of RoryOF on the forum. Take a
look for more details:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9=102846=497589#p497589

All Best, Joelle

On 2020-08-25 13:33, Web Shari wrote:


Are you receiving any error message?

The size shouldn't effect it's ability unless you have hundreds of sheets. 
Emails also shouldn't make a difference.

Shari

On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote: 


Hi,

One of my Open Office Excel files is not opening. My other files are
opening fine. It is a very big file with a list of emails. I wonder if
the links are too heavy or complex? Not that I really know what I am
talking about. Is there anything I can do to retrieve my data?

All best, Joelle


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Excel

[Andrew Pitonyak]

What is the documents file extension? I'm


How large is the file?

If you cannot do it, I might be able to convert it to an ods (calc) file for 
you. That said, excel may be able to write an ods file directly.

It is better, of course, if you do it yourself.

If AOO cannot do it, I might try LO (LibreOffice), sometimes, what fails in one 
works in the other. Kind of a least resort for a casual user I think.




⁣Sent from BlueMail ​

On Aug 25, 2020, 1:33 PM, at 1:33 PM, Web Shari  wrote:
>Are you receiving any error message?
>
>The size shouldn't effect it's ability unless you have hundreds of
>sheets. Emails also shouldn't make a difference.
>
>Shari
>
>On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote:
>> Hi,
>>
>> One of my Open Office Excel files is not opening. My other files are
>> opening fine. It is a very big file with a list of emails. I wonder
>if
>> the links are too heavy or complex? Not that I really know what I am
>> talking about. Is there anything I can do to retrieve my data?
>>
>> All best, Joelle
>
>-
>To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Excel

[Web Shari]

Are you receiving any error message?

The size shouldn't effect it's ability unless you have hundreds of 
sheets. Emails also shouldn't make a difference.


Shari

On 8/23/2020 11:36 AM, mermaidl...@gwi.net wrote:

Hi,

One of my Open Office Excel files is not opening. My other files are
opening fine. It is a very big file with a list of emails. I wonder if
the links are too heavy or complex? Not that I really know what I am
talking about. Is there anything I can do to retrieve my data?

All best, Joelle


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Excel

[mermaidlady]

I will answer below in blue. 


On 2020-08-23 16:16, Steven Ahlers wrote:


Joelle,

Assuming it is a Calc file there are some pieces of information that would help 
us help you.

I created it with OpenOffice, the file says, 'Type: OpenDocument Spreadsheet'. 
Last modified 5/17/2020. I've been using OpenOffice for years, since before I 
got my current computer.

1) Do you get an error message when you try to open the file you're having 
problems with? If so what does it say?

There is no pop-up error message box, just a blank grey page with a spinning 
cursor. The green load in bar at the bottom has no activity. All I am able to 
do is close the file, but it warns me with a pop-up box, 'OpenOffice 4.1.7 is 
not responding, If you close the program, you might lose information.'

2) What operating system and version are you using?

Microsoft Windows 10 Home, 2004 version

3) How much RAM does your computer have?

4.00GB of RAM

4) What version of OpenOffice are you using?

I just uploaded the Open Office 4.1.7 this morning hoping that would help, I 
had the 4.1.5 just before that. Hope I didn't make things worse.

5) How much memory does OpenOffice have allocated for use?

I can't find online how to check this. When I try to open the file, the Task 
Manager says 'OpenOffice 4.1.7 (32bit)'. I have 25.5GB of free space on my C: 
drive. Not sure if this is helpful.

6) How big is the file you're trying to open?

84.9KB 


As a courtesy I have sent a copy of this message to you, if you're not 
subscribed to the users list you may not see all of the responses to your 
inquiry.

Please do not respond to my email address, respond to the users group email 
address: users@openoffice.apache.org

Thank you, I will try to make an account and log on.

Sent from my iPhone


On Aug 23, 2020, at 12:12 PM, mermaidl...@gwi.net wrote:

Hi,

One of my Open Office Excel files is not opening. My other files are
opening fine. It is a very big file with a list of emails. I wonder if
the links are too heavy or complex? Not that I really know what I am
talking about. Is there anything I can do to retrieve my data?

All best, Joelle

Re: Open Office Excel

[Steven Ahlers]

Joelle,

Do you mean an OpenOffice Calc file? If you do mean a M$ Excel file you will 
need to go to a Microsoft help site.

Assuming it is a Calc file there are some pieces of information that would help 
us help you.

1) Do you get an error message when you try to open the file you’re having 
problems with? If so what does it say?

2) What operating system and version are you using?

3) How much RAM does your computer have?

4) What version of OpenOffice are you using?

5) How much memory does OpenOffice have allocated for use?

6) How big is the file you’re trying to open?

As a courtesy I have sent a copy of this message to you, if you’re not 
subscribed to the users list you may not see all of the responses to your 
inquiry.

Please do not respond to my email address, respond to the users group email 
address: users@openoffice.apache.org


Sent from my iPhone

> On Aug 23, 2020, at 12:12 PM, mermaidl...@gwi.net wrote:
> 
> Hi,
> 
> One of my Open Office Excel files is not opening. My other files are
> opening fine. It is a very big file with a list of emails. I wonder if
> the links are too heavy or complex? Not that I really know what I am
> talking about. Is there anything I can do to retrieve my data?
> 
> All best, Joelle


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Open Office Excel

[mermaidlady]

Hi,

One of my Open Office Excel files is not opening. My other files are
opening fine. It is a very big file with a list of emails. I wonder if
the links are too heavy or complex? Not that I really know what I am
talking about. Is there anything I can do to retrieve my data?

All best, Joelle

Re: Calc: How to graph polynomial trend line like Excel?

[Regina Henschel]

Hi Mike,

helices schrieb am 13-Apr-20 um 18:51:

How can we create more complex trend lines in Calc, like the Polynomial
line in Excel?


Polynomial regression type is not implemented. You need to calculate it 
outside the chart and then add it as data series.


You might want to use an extension. Find more details in
https://bz.apache.org/ooo/show_bug.cgi?id=20819

Kind regards
Regina

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Calc: How to graph polynomial trend line like Excel?

[Peter Kovacs]

Mike,


I checked to day Excel 2016 and the main difference is that OpenOffice 
does not have a + Symbol.


Okay, maybe when you have the Graph selected, then you need to double 
click, to be able to manipulate the Graph itself.


And then you can select the line you want to add the trend line too.

And only then you see the trend line in the Menu.


By now I found the wiki article too:

https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Editing_charts


Hope that clarifies.

Best

Peter


Am 13.04.20 um 22:58 schrieb Mike Schleif:

Peter,

This does not work for me. I have not gotten anywhere with Insert 
Trend Line where there is any option to insert an equation.


Of course, devising my own equation is not the same as Excel doing it 
for me ...


What am I missing?

On Mon, Apr 13, 2020 at 3:33 PM Peter Kovacs <mailto:pe...@apache.org>> wrote:


Which Version do you use?

In 4.1.7 you can

1) select the Dots you want to add a trendline to.

2) right click

3) in the Menue select the trend line

4) select the Formula you want to add

5) if you click again, you can add the trendline formula to the
trendline.


I hope this helps.


Am 13.04.20 um 18:51 schrieb helices:
> How can we create more complex trend lines in Calc, like the
Polynomial
    > line in Excel?
>
> ~ Mike
>



--
If I can ever be of service to you; contact me at once.

I wish for you a truly extraordinary day ...

Best Regards,

Mike Schleif
612-235-6060 http://mdsresource.net http://tofree.me/GooglePlus 
http://www.linkedin.com/in/schleif http://facebook.com/MDSResource 
http://twitter.com/mikeschleif

Re: Calc: How to graph polynomial trend line like Excel?

[Peter Kovacs]

Which Version do you use?

In 4.1.7 you can

1) select the Dots you want to add a trendline to.

2) right click

3) in the Menue select the trend line

4) select the Formula you want to add

5) if you click again, you can add the trendline formula to the trendline.


I hope this helps.


Am 13.04.20 um 18:51 schrieb helices:

How can we create more complex trend lines in Calc, like the Polynomial
line in Excel?

~ Mike



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Calc: How to graph polynomial trend line like Excel?

[helices]

How can we create more complex trend lines in Calc, like the Polynomial
line in Excel?

~ Mike

Re: Sharing Excel

[Peter Kovacs]

Did you do the following?

1. send unsubscribe message.

2. system will answer with a mail.

3. answer the mail. IMPORTANT: sender has to be the subscribed address.

4. now the bot will confirm that you are unsubscribed


Am 24.01.20 um 05:49 schrieb Mord.Sith Jenn:

I have unsubscribe 25 damn times... Please take me off this mailing!!

On Fri, Jan 17, 2020, 3:28 PM Sarah Staddon 
wrote:


Hello
My son lives away and we are trying to share an excel spreadsheet to work
together on a diary fitness and dieting.
Can you please tell me how to do this?
Many thanks
Sarah Staddon


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Sharing Excel

[Mord.Sith Jenn]

I have unsubscribe 25 damn times... Please take me off this mailing!!

On Fri, Jan 17, 2020, 3:28 PM Sarah Staddon 
wrote:

> Hello
> My son lives away and we are trying to share an excel spreadsheet to work
> together on a diary fitness and dieting.
> Can you please tell me how to do this?
> Many thanks
> Sarah Staddon

Re: Sharing Excel

[Sarah Staddon]

Hi

Thanks very much for your help.

I didn't explain myself very well. I do actually want to share and for us both 
to edit "live". I use something similar at work, with a colleague.  We both add 
figures each day for others to view. I didn't know how it was set up. I was 
sent a link and this open in my browser. 

Will have a go with OneDrive, or similar.

Fingers crossed!!

Sarah
On Saturday, 18 January 2020 Steven Ahlers  wrote:
Forwarding to OP. I was going to suggest the same thing.



Sent from my iPhone

> On Jan 17, 2020, at 8:15 PM, Alan B  wrote:
> 
> Sarah,
> 
> Another method, that would allow working on the spreadsheet without sending
> a copy back and forth and back again, would be to save it online and share
> it using a service like OneDrive, Google Drive, DropBox and others.
> 
> The idea is you both use the same file so if you edit at 3pm and your son
> at 4pm he sees your edits and vice versa without having to check email to
> see if an updated version of the file is in the inbox.
> 
> I offer this suggestion because you wrote "share a file" which I'm thinking
> means you both want to work with the same file so you can see each other's
> progress.
> 
> If that's not your goal then Wade's suggestion is certainly the simpler
> option.
> 
>> On Fri, Jan 17, 2020 at 4:28 PM Sarah Staddon 
>> wrote:
>> 
>> Hello
>> My son lives away and we are trying to share an excel spreadsheet to work
>> together on a diary fitness and dieting.
>> Can you please tell me how to do this?
>> Many thanks
>> Sarah Staddon
> 
> 
> 
> -- 
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011

Re: Sharing Excel

[Steven Ahlers]

Forwarding to OP. I was going to suggest the same thing.



Sent from my iPhone

> On Jan 17, 2020, at 8:15 PM, Alan B  wrote:
> 
> Sarah,
> 
> Another method, that would allow working on the spreadsheet without sending
> a copy back and forth and back again, would be to save it online and share
> it using a service like OneDrive, Google Drive, DropBox and others.
> 
> The idea is you both use the same file so if you edit at 3pm and your son
> at 4pm he sees your edits and vice versa without having to check email to
> see if an updated version of the file is in the inbox.
> 
> I offer this suggestion because you wrote "share a file" which I'm thinking
> means you both want to work with the same file so you can see each other's
> progress.
> 
> If that's not your goal then Wade's suggestion is certainly the simpler
> option.
> 
>> On Fri, Jan 17, 2020 at 4:28 PM Sarah Staddon 
>> wrote:
>> 
>> Hello
>> My son lives away and we are trying to share an excel spreadsheet to work
>> together on a diary fitness and dieting.
>> Can you please tell me how to do this?
>> Many thanks
>> Sarah Staddon
> 
> 
> 
> -- 
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Sharing Excel

[Alan B]

Sarah,

Another method, that would allow working on the spreadsheet without sending
a copy back and forth and back again, would be to save it online and share
it using a service like OneDrive, Google Drive, DropBox and others.

The idea is you both use the same file so if you edit at 3pm and your son
at 4pm he sees your edits and vice versa without having to check email to
see if an updated version of the file is in the inbox.

I offer this suggestion because you wrote "share a file" which I'm thinking
means you both want to work with the same file so you can see each other's
progress.

If that's not your goal then Wade's suggestion is certainly the simpler
option.

On Fri, Jan 17, 2020 at 4:28 PM Sarah Staddon 
wrote:

> Hello
> My son lives away and we are trying to share an excel spreadsheet to work
> together on a diary fitness and dieting.
> Can you please tell me how to do this?
> Many thanks
> Sarah Staddon



-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

Re: Sharing Excel

[Wade Smart]

Sarah, just have him email it to you and you will open it.
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Fri, Jan 17, 2020 at 3:28 PM Sarah Staddon
 wrote:
>
> Hello
> My son lives away and we are trying to share an excel spreadsheet to work 
> together on a diary fitness and dieting.
> Can you please tell me how to do this?
> Many thanks
> Sarah Staddon

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Sharing Excel

[Sarah Staddon]

Hello
My son lives away and we are trying to share an excel spreadsheet to work 
together on a diary fitness and dieting.
Can you please tell me how to do this?
Many thanks
Sarah Staddon

Opening Excel with images on Open Office 4.1.6

[Renata Souto Neves]

Hi there,

I’m a user of Open Office 4.1.6 and I’m having problems opening xls files with 
inserted images. 

When I open any type of Excel file with Open Office on Windows,  I see the 
images like this: https://prnt.sc/oyn5fl <https://prnt.sc/oyn5fl>

And in the original file the images are like this: https://prnt.sc/oyn7s9 
<https://prnt.sc/oyn7s9> 

Here's the original file as a reference: 
https://www.dropbox.com/s/cgxyt0c3si2ao6s/test.xlsx?dl=0 
<https://www.dropbox.com/s/cgxyt0c3si2ao6s/test.xlsx?dl=0> 

Could you help me fixing this problem, so that when I open Open Office I can 
see all the images correctly? 

Thank you. 



Renata Souto Neves
Digital Manager

r...@gauchere-paris.com 

---
GAUCHERE 
188, rue de Rivoli 
75001 Paris - France

Phone: +33 1 40 26 41 82
Mobile: +33 6 42 68 42 92

www.gauchere-paris.com <https://gauchere-paris.com/>   
www.instagram.com/gauchereparis <https://www.instagram.com/gauchereparis/>  

Re: Issue with the excel sheet

[Brian Barker]

At 11:25 24/05/2019 +, Prabir Chakrabarti wrote:
>I have been using "openoffice" for a few years now & find it very useful for 
>most my works. It is true though that I still need to explore it thoroughly to 
>use all features correctly.

Any facility worth its salt will require learning in order to use it fully.

>For the last 2/3 years I find some issues while using the spreadsheet [excel 
>sheet] to file my I T returns.

I don't know what an "IT return" is: is this Indian for an income tax return?

>The IT return form consist of  4 - 5 inter connected sheets.

So this is a form provided to you, not a spreadsheet you have created yourself 
- right?

>Data filled in some of the cells are picked up automatically by designated 
>cells and Taxes / Deductions & finally taxes payable are calculated. This is 
>where the problem occurs. Some odd cell would fail to transfer data for 
>calculation.

My guess is that the forms have been constructed in such a way that they work 
properly only in Microsoft's proprietary spreadsheet product, Excel. One 
possibility is that the form contains macros, since the macro language used by 
OpenOffice (Calc) is different from that used by Microsoft Excel. The fact that 
macros are involved is confirmed at the Government of India's web site:
https://www.incometaxindiaefiling.gov.in/downloads/incomeTaxReturnUtilities .

You may well think that for a government to require that its citizens can use 
its facilities fully only by purchasing a specific piece of commercial software 
is inappropriate. And you would not be alone; see
https://www.thehindubusinessline.com/opinion/microsoft-and-your-tax-returns/article20704989.ece1
 .

Your solution is one of:

o Complain to your member of parliament.

o Ask the Indian government to purchase you or provide access for you to 
Microsoft Office.

o Purchase a licence for and use Microsoft Office.

o Obtain access to an installation of Microsoft Office, perhaps at work (if 
this is permitted), in a library, or wherever, and fill in your form there.

o (Probably best, along with No. 1) Install a Java Runtime Environment (if you 
don't already have it) an use the alternative "Java Utility" also available 
from the Government of India's Income Tax Department.

I trust this helps.

Brian Barker

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Issue with the excel sheet

[prabir chakrabarti]

Dear Sir


I have been using " openoffice "  for a few years now & find it very useful for 
most my works.
It is true though that I still need to explore  it thoroughly to use all 
features correctly.

For the last 2/3 years I find some issues while using the spreadsheet [excel 
sheet] to file my I T returns. 


The IT return form consist of  4 - 5 inter connected  sheets. Data filled in 
some of the cells  are picked up automatically by designated cells and Taxes / 
Deductions & finally taxes payable arecalculated.

This is where the problem occurs.  Some odd cell would fail to transfer data 
for calculation. I can send a formwith dummy data to explain , if you agree. 


I will appreciate your response.

Thank you.
P. Chakrabarti

Re: TOO MANY CRASHES, I GIVE UP AFTER MANY YEARS OF SATIFACTION I'M GOING BACK TO EXCEL

[Wade Smart]

Why cant this list block non-registered users?

-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

On Wed, Nov 7, 2018 at 2:51 PM pat mcnamara
 wrote:
>
>
>
> Sent from Mail for Windows 10
>

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: TOO MANY CRASHES, I GIVE UP AFTER MANY YEARS OF SATIFACTION I'M GOING BACK TO EXCEL

[Howard Blum]

It's likely a Windows issue and not an OO issue.

On Wed, Nov 7, 2018 at 12:51 PM pat mcnamara <
outlook_d120253acf079...@outlook.com> wrote:

>
>
> Sent from Mail for
> Windows 10
>
>

-- 
Howard Blum
Pro Mobile Notary
PO Box 834
Novato, CA 94948
415-898-4130
http://pro-mobile-notary.com

TOO MANY CRASHES, I GIVE UP AFTER MANY YEARS OF SATIFACTION I'M GOING BACK TO EXCEL

[pat mcnamara]

Sent from Mail for Windows 10

RE: Excel Tabellen

[Jörg Schmidt]

Hallo, 

> -Original Message-
> From: Ute Leuband-Niendorf [mailto:kegel...@gmail.com] 
> Sent: Monday, September 17, 2018 4:17 PM
> To: users-de@openoffice.apache.org
> Subject: Excel Tabellen
> 
> Guten Tag, Ich habe Open Office 4.1.5 und kann einfach nicht Excel 
> Dateien mit der Endung xlsx richtig öffnen, d.h. Verknüpfungen werden 
> nicht aktualisiert. Meine Bekannte hat das gleiche Open Office und da 
> funktioniert alles. In den Einstellungen habe ich schon 
> gesucht, - Excel 
> zur OP und umgekehrt ist aktiviert -. Vielleicht können Sie mir einen 
> Tip geben. Vielen Dank im voraus.

wenn Verknüpfungen beim Öffnen nicht aktualisiert werden ist deren 
Aktualisierung mutmaßlich nicht aktiviert, also aktivieren Sie unter:

Extras-Einstellungen-OpenOffice Calc-Aktualisiering-Verknüpfungen beim Laden 
aktualisieren

entweder "Immer"

oder "auf Nachfrage"


Gruß
Jörg


-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Excel Tabellen

[Ute Leuband-Niendorf]

Guten Tag, Ich habe Open Office 4.1.5 und kann einfach nicht Excel 
Dateien mit der Endung xlsx richtig öffnen, d.h. Verknüpfungen werden 
nicht aktualisiert. Meine Bekannte hat das gleiche Open Office und da 
funktioniert alles. In den Einstellungen habe ich schon gesucht, - Excel 
zur OP und umgekehrt ist aktiviert -. Vielleicht können Sie mir einen 
Tip geben. Vielen Dank im voraus.


Mfg. Ute Leuband-Niendorf

Re: Excel

[David Belina]

Excel for an iPad requires a subscription to Microsoft Office 360.

On August 10, 2018 at 9:45:12 AM, Matthias Seidel (matthias.sei...@hamburg.de) 
wrote:

Am 10.08.2018 um 15:52 schrieb Andrew Pitonyak:  
>  
>  
>  
>  
> My assumption is that you are not really asking how to install Excel,  
> since that is a Microsoft product and this is a mailing list for  
> OpenOffice products... I assume, therefore, that you desire to install  
> Apache OpenOffice and that you desire to use Calc.  
>  
> The only answer as of now assumes that you really want to install  
> Excel and says "sorry, we do not support that here".  
>  
> So, despite the fact that I rarely use apple products, and most of my  
> interactions with iPads and iPhones have been very negative, perhaps I  
> should answer.  
>  
> If you look here:  
>  
> https://discussions.apple.com/thread/8198018  
>  
> It states that the only way to install apps on your pad is to use the  
> App store and that neither OpenOffice nor LibreOffice are on the app  
> store.  

He could install Office 700, which is an OpenOffice port for iOS.  

There is a free edition (Lite):  
https://itunes.apple.com/app/office-700-lite/id1177936371?mt=8  

and a payed version for $3,99:  
https://itunes.apple.com/us/app/office-700/id1097657424?mt=8  

These ports are from the same guy who makes AndrOpen Office for Android.  

Regards,  
   Matthias  

>  
> If you really do want excel:  
>  
> https://itunes.apple.com/us/app/microsoft-excel/id586683407?mt=8  
>  
> There is apparently another app called "Numbers" that is well rated,  
> but I did not look into it.  
>  
>  
>  
> On 2018-08-09 21:52, Michael Lass wrote:  
>> Sent from my iPad Please help me get Excel hooked up to my I pad  
>> or is this possible?  
>> Thank you very much !  
>> -  
>> 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: Excel

[Matthias Seidel]

Am 10.08.2018 um 15:52 schrieb Andrew Pitonyak:
>
>
>
>
> My assumption is that you are not really asking how to install Excel,
> since that is a Microsoft product and this is a mailing list for
> OpenOffice products... I assume, therefore, that you desire to install
> Apache OpenOffice and that you desire to use Calc.
>
> The only answer as of now assumes that you really want to install
> Excel and says "sorry, we do not support that here".
>
> So, despite the fact that I rarely use apple products, and most of my
> interactions with iPads and iPhones have been very negative, perhaps I
> should answer.
>
> If you look here:
>
> https://discussions.apple.com/thread/8198018
>
> It states that the only way to install apps on your pad is to use the
> App store and that neither OpenOffice nor LibreOffice are on the app
> store.

He could install Office 700, which is an OpenOffice port for iOS.

There is a free edition (Lite):
https://itunes.apple.com/app/office-700-lite/id1177936371?mt=8

and a payed version for $3,99:
https://itunes.apple.com/us/app/office-700/id1097657424?mt=8

These ports are from the same guy who makes AndrOpen Office for Android.

Regards,
   Matthias

>
> If you really do want excel:
>
> https://itunes.apple.com/us/app/microsoft-excel/id586683407?mt=8
>
> There is apparently another app called "Numbers" that is well rated,
> but I did not look into it.
>
>
>
> On 2018-08-09 21:52, Michael Lass wrote:
>> Sent from my iPad Please help me get Excel hooked up to my I pad
>> or is this possible?
>> Thank you very much !
>> -
>> 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
>




smime.p7s
Description: S/MIME Cryptographic Signature

Re: Excel

[Andrew Pitonyak]

My assumption is that you are not really asking how to install Excel, 
since that is a Microsoft product and this is a mailing list for 
OpenOffice products... I assume, therefore, that you desire to install 
Apache OpenOffice and that you desire to use Calc.


The only answer as of now assumes that you really want to install Excel 
and says "sorry, we do not support that here".


So, despite the fact that I rarely use apple products, and most of my 
interactions with iPads and iPhones have been very negative, perhaps I 
should answer.


If you look here:

https://discussions.apple.com/thread/8198018

It states that the only way to install apps on your pad is to use the 
App store and that neither OpenOffice nor LibreOffice are on the app 
store.


If you really do want excel:

https://itunes.apple.com/us/app/microsoft-excel/id586683407?mt=8

There is apparently another app called "Numbers" that is well rated, 
but I did not look into it.




On 2018-08-09 21:52, Michael Lass wrote:

Sent from my iPad Please help me get Excel hooked up to my I pad
or is this possible?
Thank you very much !
-
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: Excel

[David Robley]

This mail list is for support for Apache OpenOffice. A quick web search 
suggests there is a version of Excel for IPad; perhaps look on the App 
Store.



On 10/08/18 11:22, Michael Lass wrote:


Sent from my iPad Please help me get Excel hooked up to my I pad or is this 
possible?
Thank you very much !
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org




Cheers
--
David Robley

If at first you don't succeed, then Sky Diving is not for you!
 



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Excel

[Michael Lass]

Sent from my iPad Please help me get Excel hooked up to my I pad or is this 
possible?  
Thank you very much !
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: adding up columns in excel

[LTS Tools, Inc]

Ticking the "Detect special number" box worked! Thank you!
 
Thank you,
Carol
LTS Tools, Inc
40 Conway St
South Deerfield, Ma 01373
413-775-3026 phone
In a message dated 4/3/2018 12:54:28 AM Eastern Standard Time, 
mar...@groenescheij.com writes:

 


On 03/04/18 12:04 AM, LTS Tools, Inc wrote:
> Hello,
> 
> I am trying to download an excel spread sheet from ebay. Every time I do, the 
> column with prices has an apostrophe before the number so I cannot add up the 
> columns. My older version didn't do this. Please help!

If you download a Excel file that the problem is with the Excel file.
If you copy data into into an OpenOffice file or open a csv file into 
OpenOffice tick the 'Detect special number" box in the Import window.

> 
> Thank you,
> Carol
> LTS Tools, Inc
> 40 Conway St
> South Deerfield, Ma 01373
> 413-775-3026 phone

Re: adding up columns in excel

[Brian Barker]

At 10:04 02/04/2018 -0400, Carol Noname wrote:

adding up columns in excel


If you are adding up columns in Microsoft Excel, you may need to look 
elsewhere for help. Perhaps you mean in an OpenOffice spreadsheet?


I am trying to download an excel spread sheet from ebay. Every time 
I do, the column with prices has an apostrophe before the number so 
I cannot add up the columns.


If you mean that you can see the apostrophes in the cells themselves, 
that is very odd. But you probably mean that when a cell value is 
displayed in the Input Line it shows with a leading apostrophe: that 
is a standard part of spreadsheet behaviour. This indicates that what 
you have in a cell with a numeric format (including a currency one) 
is actually text - which may look like a number - and not a genuine 
number. This may be because the author has intentionally entered text 
instead of numbers, has entered currency amounts in what is not the 
standard currency for his or her locale, or because of the way in 
which you have incorporated the material into your spreadsheet document.


If the distinction between number and text which looks like a number 
is not obvious, just consider your (US) zip code, which you quote as 
"01373". That is text. If it were a number, you could quote it 
instead as 1373 - but you cannot. If it were a number, you could read 
it as "one thousand, three hundred [and] seventy-three" - but you'd 
never do that. If it were a number, there would be some special 
significance in the postal location that happened to have exactly 
twice its value - 02746 - but there isn't. After all, it is called a 
"zip code", not a "zip number". So there *is* a use for text which 
happens to look like a number - not what you want here.



My older version didn't do this.


I hope it did, as this is correct spreadsheet behaviour. This 
spreadsheet document may be different from previous ones, or you may 
have incorporated the material in a different way.



Please help!


o If you are pasting material into a spreadsheet, you should see the 
Text Import window. Tick the "Detect special numbers" box and your 
text values will be converted to genuine numbers. (This works for 
currency values as well as for numbers.) But this won't help if you 
are actually downloading and opening a spreadsheet document, as you say.


When you have text values in your spreadsheet, there are various ways 
to convert them to real numbers:


o You can use the VALUE() function to derive the values you need into 
a separate column. If you wish, you can then paste them back over the 
originals, but using Edit | Paste Special (or Ctrl+Shift+V) instead 
of ordinary Paste, and ensuring the Formulae is *not* ticked in the 
Paste Spacial dialogue. You may need to format the cells as Currency 
in order to add or replace the currency symbol.


o Select the material. Go to Data | Text to Columns... . (The "Detect 
special numbers" box should be ticked.) Your text values will be 
converted to numbers.


But here is an interesting trick: you can add the text values without 
converting them to numbers. If you want to add up, say, the values in 
A1 to A99, you might use the formula

=SUM(A1:A99)
As you have found, if you use that with your text values masquerading 
as numbers, it will not work. How about incorporating the VALUE() 
function to convert the values on the fly? You might try

=SUM(VALUE(A1:A99))
- but that doesn't work either, as the VALUE() function cannot take a 
range as its parameter. But what does work is this: enter

=SUM(VALUE(A1:A99))
as the formula in the cell, but instead of pressing Enter or the 
(green tick mark) Accept button in the Input Line to complete the 
entry, press Ctrl+Shift+Enter. This creates an array formula, which 
does work. (You will need the result cell to be formatted as Currency 
for its value to behave correctly.) Note that when you have done 
this, your formula will appear in the Input Line surrounded by braces, i.e. as

{=SUM(VALUE(A1:A99))}
- but you *cannot* achieve the effect by entering these yourself: you 
must instead use Ctrl+Shift+Enter to complete the formula.


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: adding up columns in excel

[Martin Groenescheij]

On 03/04/18 12:04 AM, LTS Tools, Inc wrote:

Hello,
  
I am trying to download an excel spread sheet from ebay. Every time I do, the column with prices has an apostrophe before the number so I cannot add up the columns. My older version didn't do this. Please help!


If you download a Excel file that the problem is with the Excel file.
If you copy data into into an OpenOffice file or open a csv file into 
OpenOffice tick the 'Detect special number" box in the Import window.


  
Thank you,

Carol
LTS Tools, Inc
40 Conway St
South Deerfield, Ma 01373
413-775-3026 phone



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

adding up columns in excel

[LTS Tools, Inc]

Hello,
 
I am trying to download an excel spread sheet from ebay. Every time I do, the 
column with prices has an apostrophe before the number so I cannot add up the 
columns. My older version didn't do this. Please help!
 
Thank you,
Carol
LTS Tools, Inc
40 Conway St
South Deerfield, Ma 01373
413-775-3026 phone

Formeln bei Konversion in Excel

[technik_...@jrsch.de]

Hallo,

ich habe eine Tabellenkalkulation, die ich in excel exportieren muss.

in einer Zelle der Tabelle IMP steht:

=SUMMEWENN($Compte.$F$2:$F$1048576;$A2;$Compte.$G$2:$G$1048576)

nach Speichern und wieder öffnen steht

=SUMMEWENN($Compte.$#REF!$#REF!:$#REF!$#REF!;$A3;$Compte.$#REF!$#REF!:$#REF!$#REF!)

Lässt sich das beheben oder muss man damit leben. Der andere kann kein 
Openoffice nutzen.


Horst


-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

[Johnny Rosenberg]

2017-09-09 4:46 GMT+02:00 zahra a <nasrinkhaks...@gmail.com>:

> hi.
> sorry because i answered this message very late!
> libreoffice supports visual basic (vba) and we dont need to buy it!
>

Really? How did they make Microsoft agree with that?


>
> hope that help, God bless you and his infinite mercy be for you.
>
> On 7/1/17, Johnny Rosenberg <gurus.knu...@gmail.com> wrote:
> > 2017-06-29 21:55 GMT+02:00 QCIT3 MMisonora <mmiqc...@outlook.com>:
> >
> >> Hi there,
> >>
> >> I am a new user to OpenOffice and was wondering if when I write lets say
> >> a
> >> spreadsheet with macros on it and sent to someone who would have to open
> >> that file in Excel cause they don't use OpenOffice, would the macros
> >> still
> >> work or would it not work like when one opens an Excel file with macros
> >> and
> >> it doesn't work.
> >>
> >> Thanks,
> >>
> >> Emma
> >>
> >
> > Most things related to Basic (the programming language) will work in
> Excel
> > too, but as soon as you want to do spreadsheet related things, it won't
> > work at all, unless you simulate all that UNO stuff by writing your own
> > objects for them in Excel, but you will need to create a lot of objects…
> :P
> >
> > If Apache OpenOffice supported VBA (Visual Basic for Applications), then
> > you'd have to buy it, just like you buy MS Office.
> >
> >
> >
> > Kind regards
> >
> > Johnny Rosenberg
> >
> >
> >
> >>
> >>
> >> Sent from Outlook<http://aka.ms/weboutlook>
> >>
> >
>
>
> --
> we have not sent you but as a mercy to the creation.
> holy quran, chapter 21, verse 107.
> in the very authentic narration is:
> imam hosein is the beacon of light and the ark of salvation.
> best website for studying islamic book in different languages
> al-islam.org
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
>
>

Re: Help OpenOffice is Taking Half an Hour to Load Excel Files?????????

[zahra a]

hello.
i think that you should change tools, options, memory but be careful
and search about the best settings for it!
hope that help, God bless you!

On 6/29/17, QCIT3 MMisonora <mmiqc...@outlook.com> wrote:
> Hi there,
>
> I am a new user to OpenOffice and am trying to get some files with VBA
> macros that were originally written in Excel to open onto OpenOffice.
> However, it is taking about half an hour to load just one file, so I am
> wondering why it is taking so long as well as how I can fix it.
>
>
> Thanks
>
> Emma Parola
>


-- 
we have not sent you but as a mercy to the creation.
holy quran, chapter 21, verse 107.
in the very authentic narration is:
imam hosein is the beacon of light and the ark of salvation.
best website for studying islamic book in different languages
al-islam.org

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

[zahra a]

hi.
sorry because i answered this message very late!
libreoffice supports visual basic (vba) and we dont need to buy it!

hope that help, God bless you and his infinite mercy be for you.

On 7/1/17, Johnny Rosenberg <gurus.knu...@gmail.com> wrote:
> 2017-06-29 21:55 GMT+02:00 QCIT3 MMisonora <mmiqc...@outlook.com>:
>
>> Hi there,
>>
>> I am a new user to OpenOffice and was wondering if when I write lets say
>> a
>> spreadsheet with macros on it and sent to someone who would have to open
>> that file in Excel cause they don't use OpenOffice, would the macros
>> still
>> work or would it not work like when one opens an Excel file with macros
>> and
>> it doesn't work.
>>
>> Thanks,
>>
>> Emma
>>
>
> Most things related to Basic (the programming language) will work in Excel
> too, but as soon as you want to do spreadsheet related things, it won't
> work at all, unless you simulate all that UNO stuff by writing your own
> objects for them in Excel, but you will need to create a lot of objects… :P
>
> If Apache OpenOffice supported VBA (Visual Basic for Applications), then
> you'd have to buy it, just like you buy MS Office.
>
>
>
> Kind regards
>
> Johnny Rosenberg
>
>
>
>>
>>
>> Sent from Outlook<http://aka.ms/weboutlook>
>>
>


-- 
we have not sent you but as a mercy to the creation.
holy quran, chapter 21, verse 107.
in the very authentic narration is:
imam hosein is the beacon of light and the ark of salvation.
best website for studying islamic book in different languages
al-islam.org

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

[Johnny Rosenberg]

2017-06-29 21:55 GMT+02:00 QCIT3 MMisonora <mmiqc...@outlook.com>:

> Hi there,
>
> I am a new user to OpenOffice and was wondering if when I write lets say a
> spreadsheet with macros on it and sent to someone who would have to open
> that file in Excel cause they don't use OpenOffice, would the macros still
> work or would it not work like when one opens an Excel file with macros and
> it doesn't work.
>
> Thanks,
>
> Emma
>

Most things related to Basic (the programming language) will work in Excel
too, but as soon as you want to do spreadsheet related things, it won't
work at all, unless you simulate all that UNO stuff by writing your own
objects for them in Excel, but you will need to create a lot of objects… :P

If Apache OpenOffice supported VBA (Visual Basic for Applications), then
you'd have to buy it, just like you buy MS Office.



Kind regards

Johnny Rosenberg



>
>
> Sent from Outlook<http://aka.ms/weboutlook>
>

Re: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

[Rory O'Farrell]

On Thu, 29 Jun 2017 19:55:55 +
QCIT3 MMisonora <mmiqc...@outlook.com> wrote:

> Hi there,
> 
> I am a new user to OpenOffice and was wondering if when I write lets say a 
> spreadsheet with macros on it and sent to someone who would have to open that 
> file in Excel cause they don't use OpenOffice, would the macros still work or 
> would it not work like when one opens an Excel file with macros and it 
> doesn't work.
> 
> Thanks,
> 
> Emma

Different underlying code engines, so different macro structures.  Use the one 
program on all computers if you expect macros to work.  There is no reliable 
workaround.

.- 
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: Would Macros Made In OpenOffice Work If Someone Opened It On Excel???????????????

[Andrew Pitonyak]

On 2017-06-29 15:55, QCIT3 MMisonora wrote:

Hi there,

I am a new user to OpenOffice and was wondering if when I write lets
say a spreadsheet with macros on it and sent to someone who would 
have

to open that file in Excel cause they don't use OpenOffice, would the
macros still work or would it not work like when one opens an Excel
file with macros and it doesn't work.

Thanks,

Emma


It is very very unlikely that it would work because the internal object 
models for manipulating a document are different. If all your macro does 
is say print a number using the print statement or message box, 
probably; but I hvae not tested it.


Andrew Pitonyak

Help OpenOffice is Taking Half an Hour to Load Excel Files?????????

[QCIT3 MMisonora]

Hi there,

I am a new user to OpenOffice and am trying to get some files with VBA macros 
that were originally written in Excel to open onto OpenOffice. However, it is 
taking about half an hour to load just one file, so I am wondering why it is 
taking so long as well as how I can fix it.


Thanks

Emma Parola

Re: Excel Datei

[Detlef Nannen]

Hallo Martin,

ich verweise auf meine erste Antwort und muss leider hinzufügen, dass AOO 
in diesen Fällen dann nicht das richtige Werkzeug ist.


--
Grüßle
Detlef




-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Excel Datei

[Jörg Schmidt]

Hallo, 

> From: Martin Jenniges [mailto:martinjenni...@skynet.be] 

> mich interessiert noch, warum OO das xlsx-Format-Speichern 
> nicht anbietet.
> 
> Ist das Format nicht offen ?

Dieses Format ist offen, auch sind Filter dafür von der OpenSource-Gemeinde 
entwickelt worden, maßgeblich im Projekt:
http://osb-alliance.de/working-groups/projekte/ooxml-filter

Leider ist es AOO infolge bisher nicht gelungen diese Filter zu integrieren, 
weil manpower fehlt bzw. weil die Entwickler andere Dinge als wichtiger ansahen.



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: Excel Datei

[Martin Jenniges]

Hallo,

warum OO auch in xlsx-Format speichern sollte: weil es ein sinnvolles 
Feature für die User wäre


zB wenn ne Firma eben die eingereichten Daten in xlsx haben will; oder 
ein Professor, oder andere; wenn diese  "Bitte" missachtet wird, kann es 
Ärger für den User geben


OO hat ja meines Wissen auch die anderen Excelformate unterstützt

Gruss
Martin



Am 26.05.2017 um 12:52 schrieb Detlef Nannen:

Hallo Martin,

ja, LibreOffice (LO) kann das. LO ist eie Abspaltung von OpenOffice 
und wird getrennt von Apache OpenOffice entwickelt. Wegen 
unterschiedlicher Lizenzmodelle kann Apache nicht einfach die 
entsprechenden Bausteine von LO übernehmen um xlsx speichern zu 
können. Aber wie vorhin Michael schrieb, warum nicht einfach .ods 
verwenden?





-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Excel Datei

[Detlef Nannen]

Hallo Martin,

ja, LibreOffice (LO) kann das. LO ist eie Abspaltung von OpenOffice und 
wird getrennt von Apache OpenOffice entwickelt. Wegen unterschiedlicher 
Lizenzmodelle kann Apache nicht einfach die entsprechenden Bausteine von LO 
übernehmen um xlsx speichern zu können. Aber wie vorhin Michael schrieb, 
warum nicht einfach .ods verwenden?


--
Ein sonniges Wochenende wünscht Euch allen
Detlef




Am 26. Mai 2017 12:22:23 nachm. schrieb Martin Jenniges 
<martinjenni...@skynet.be>:



Hallo

laut einer Internetseite kann LibreOffice im xlsx-Format speichern

https://www.computerwoche.de/a/dokumente-konvertieren-in-openoffice,2489147

Gruss
Martin



Am 26.05.2017 um 10:23 schrieb Detlef Nannen:

Hallo,

Apache OpenOffice Calc kann keine Datei im xlsx-Format speichern.
Ich speichere diese Dateien eben im xls-Format ab, hatte bisher keine
Probleme deswegen. Ungereimtheiten könnten bei der Darstellung von
Grafiken, Farben und Diagrammen entstehen, das liegt aber nicht
unbedingt am Format, sondern daran dass Excel in neueren Versionen
mehr darstellen kann, was in Versionen vor xlsx noch nicht möglich war.




-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org





-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Excel Datei

[Martin Jenniges]

Hallo

laut einer Internetseite kann LibreOffice im xlsx-Format speichern

https://www.computerwoche.de/a/dokumente-konvertieren-in-openoffice,2489147

Gruss
Martin



Am 26.05.2017 um 10:23 schrieb Detlef Nannen:

Hallo,

Apache OpenOffice Calc kann keine Datei im xlsx-Format speichern.
Ich speichere diese Dateien eben im xls-Format ab, hatte bisher keine 
Probleme deswegen. Ungereimtheiten könnten bei der Darstellung von 
Grafiken, Farben und Diagrammen entstehen, das liegt aber nicht 
unbedingt am Format, sondern daran dass Excel in neueren Versionen 
mehr darstellen kann, was in Versionen vor xlsx noch nicht möglich war.





-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Excel Datei

[Detlef Nannen]

Hallo,


wie weit xlsx offen ist vermag ich nicht zu sagen.

Ich v e r m u t e schlicht, dass bisher noch niemand der Programmierer Zeit
gefunden hat, sich darum zu kümmern, da andere Dinge eine höhere Priorität
haben.

Wir hier auf der Liste sind nur User die anderen Usern helfen, so weit es
geht.


-- 
Grüßle
Detlef



Am 26. Mai 2017 um 12:07 schrieb Martin Jenniges <martinjenni...@skynet.be>:

> Hallo Detlev,
>
> mich interessiert noch, warum OO das xlsx-Format-Speichern nicht anbietet.
>
> Ist das Format nicht offen ?
>
> Gruss
> Martin Jenniges
>
>
>
> Am 26.05.2017 um 10:23 schrieb Detlef Nannen:
>
>> Hallo,
>>
>> Apache OpenOffice Calc kann keine Datei im xlsx-Format speichern.
>> Ich speichere diese Dateien eben im xls-Format ab, hatte bisher keine
>> Probleme deswegen. Ungereimtheiten könnten bei der Darstellung von
>> Grafiken, Farben und Diagrammen entstehen, das liegt aber nicht unbedingt
>> am Format, sondern daran dass Excel in neueren Versionen mehr darstellen
>> kann, was in Versionen vor xlsx noch nicht möglich war.
>>
>>
>
> -
> To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-de-h...@openoffice.apache.org
>
>

Re: Excel Datei

[Dr. Michael Stehmann]

Am 26.05.2017 um 12:07 schrieb Martin Jenniges:
> Hallo Detlev,
> 
> mich interessiert noch, warum OO das xlsx-Format-Speichern nicht anbietet.
> 
> Ist das Format nicht offen ?
> 

1. Welches Format?

Den ISO- oder den ECMA-Standard? Oder das, was MS tatsächlich umsetzt
und wenn, in welcher Version?

2. ~ 6000 Seiten Spezifikation sind nicht 'mal eben locker implementiert.

3. Nur meine persönliche Meinung: Lesen ist ja noch ok, aber warum
sollen wir beim Speichern nicht unseren eigenen und älteren Standard
(ODF) bevorzugen? Den hat sogar MS 'mal einigermaßen unterstützt.

Gruß
Michael




signature.asc
Description: OpenPGP digital signature

Re: Excel Datei

[Martin Jenniges]

Hallo Detlev,

mich interessiert noch, warum OO das xlsx-Format-Speichern nicht anbietet.

Ist das Format nicht offen ?

Gruss
Martin Jenniges



Am 26.05.2017 um 10:23 schrieb Detlef Nannen:

Hallo,

Apache OpenOffice Calc kann keine Datei im xlsx-Format speichern.
Ich speichere diese Dateien eben im xls-Format ab, hatte bisher keine 
Probleme deswegen. Ungereimtheiten könnten bei der Darstellung von 
Grafiken, Farben und Diagrammen entstehen, das liegt aber nicht 
unbedingt am Format, sondern daran dass Excel in neueren Versionen 
mehr darstellen kann, was in Versionen vor xlsx noch nicht möglich war.





-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Excel Datei

[Detlef Nannen]

Hallo,

Apache OpenOffice Calc kann keine Datei im xlsx-Format speichern.
Ich speichere diese Dateien eben im xls-Format ab, hatte bisher keine 
Probleme deswegen. Ungereimtheiten könnten bei der Darstellung von 
Grafiken, Farben und Diagrammen entstehen, das liegt aber nicht unbedingt 
am Format, sondern daran dass Excel in neueren Versionen mehr darstellen 
kann, was in Versionen vor xlsx noch nicht möglich war.


--
Grüßle
Detlef



Am 26. Mai 2017 9:54:26 vorm. schrieb Georg Fandrich 
<fandrich_ge...@t-online.de>:



Guten Tag.

Ich habe, wie vorgeschlagen, eine xsl. Datein mit open Office calc
geöffnet, bearbeitet, nur der Versuch als xslx.Datei zu speichern klappt
nicht. Das Pull down Menü zeigt mir weder Excel 2010 noch eine andere
xlsx. möglichkit an. MfG.gf


-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org





-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Excel Datei

[Georg Fandrich]

Guten Tag.

Ich habe, wie vorgeschlagen, eine xsl. Datein mit open Office calc 
geöffnet, bearbeitet, nur der Versuch als xslx.Datei zu speichern klappt 
nicht. Das Pull down Menü zeigt mir weder Excel 2010 noch eine andere 
xlsx. möglichkit an. MfG.gf



-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Downloading EXCEL files into Open Office

[Johnny Rosenberg]

2016-07-11 22:08 GMT+02:00 Mark Wallendjack <walle...@hotmail.com>:

> When download EXCEL files, they don't recognize my Open Office spreadsheet
> program.


Spreadsheet files don't recognise anything, they are just files. Apache
OpenOffice however, recognise certain file types, Excel files are among
those. Also your operating system recognise them, if you set it up
properly. I don't know how to do that in your operating system since I
don't know which one you have, but I'm sure it's very easy.



>   Is there a way to do that?  I certainly don't want to buy Microsoft
> Office for the privilege!
>
>
> Thanks - a new Open office user.
>
>
> Mark
>

Re: Downloading EXCEL files into Open Office

[Rory O'Farrell]

On Mon, 11 Jul 2016 20:08:44 +
Mark Wallendjack <walle...@hotmail.com> wrote:

> When download EXCEL files, they don't recognize my Open Office spreadsheet 
> program.  Is there a way to do that?  I certainly don't want to buy Microsoft 
> Office for the privilege!
> 
> 
> Thanks - a new Open office user.
> 
> 
> Mark

Set a File Association for .xls files to open using OpenOffice.  How to do this 
depends on your Operating System, whose instructions you should check.


-- 
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

Downloading EXCEL files into Open Office

[Mark Wallendjack]

When download EXCEL files, they don't recognize my Open Office spreadsheet 
program.  Is there a way to do that?  I certainly don't want to buy Microsoft 
Office for the privilege!


Thanks - a new Open office user.


Mark

Excel to open office problem

[Adrian Ban]

Hello I have a problem where I have a file in excel on the PC and I'm
opening in open office on mac.  On the PC excel there are drop down menus
for certain blocks, but when I open it in OpenOffice spreadsheet on mac,
there are no drop down menus. What do I do to get that to work?

Thank you,

Adrian Ban

Re: Unsinnig ? Calc-CSV ungleich Excel-CSV ?

[RA Stehmann]

On 31.10.2015 12:36, Martin Jenniges wrote:
> Hallo Michael,
> 
> also einen Standard für die Codierung einer CSV gibts nicht; das habe
> ich aus der Wikipediaseite bez CSV.

Genau das ist das Problem im Umgang mit CSV: CSV ist kein
standardisiertes Format, sondern eher die generelle Beschreibung einer
Arbeitsweise.

Ein sinnvoller Export ist nur dann möglich, wenn man genau weiß, was der
Import erwartet. Das gilt beispielsweise auch für Anführungszeichen zur
Markierung von Zeichenketten.

Und selbst dann, wenn man die Erfordernisse des Imports genau kennt,
sollte man nach dem Export durch Reinschauen in die Datei noch penibel
kontrollieren, ob man diesen Erfordernissen beim Export gerecht geworden
ist.

Ansonsten aber ist CSV in vielen Fällen eine sinnvolle Vorgehensweise.

Gruß
Michael





signature.asc
Description: OpenPGP digital signature

Re: Unsinnig ? Calc-CSV ungleich Excel-CSV ?

[Martin Jenniges]

Hallo Michael,

also einen Standard für die Codierung einer CSV gibts nicht; das habe 
ich aus der Wikipediaseite bez CSV.


Im Internet habe ich eine englische Seite gefunden, die beschreibt, wie 
man am Mac die Codierung auf UTF-16 stellt.

mit dieser Codierung soll es weniger Probleme mit Indesign geben.

Gestern habe ich eine alte Csv mit nem Editor geöffnet und da waren die 
Zellinhalte der ersten Zeile in Anführungszeichen, also so "n1","n2" usw


wenig später habe ich eine neue Csv generiert und da war die erste Zeile 
ohne Anführungszeichen


Aber welche Auswirkung sowas auf Indesign hat, keine Ahnung bis jetzt

Vielleicht schreib ich diesbezüglich in einem Indesign-Forum

viele Grüsse
Martin

Am 29.10.2015 um 17:27 schrieb RA Stehmann:

On 29.10.2015 13:50, Martin Jenniges wrote:

Hallo Horst,

meine Frage war ja, ob es unterschiede zwischen Excel- und Calc-csvs gibt.

Da hab ich mich was mehr mit beschäftigt und erkannt, dass wegen der
Codierungen ziemliche Unterschiede gibt.


Man kann aus der gleichen Tabelle sehr unterschiedliche CSVs gewinnen,
je nachdem welche Separatoren man wählt, wie man das Zeilenende markiert
etc.. Natürlich kann auch die Zeichencodierung eine Rolle spielen,
obwohl UTF8 eigentlich Standard sein sollte.

Wer wissen will, welches CSV er erzeugt hat, sollte es sich am besten in
einem Editor anschauen.

Gruß
Michael






-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Unsinnig ? Calc-CSV ungleich Excel-CSV ?

[technik]

Hallo,
schau dir mal die Dateien im Texteditor oder notepad an, die Brauchbare 
und die nicht brauchbare. Vielleicht sind Komma oder Semikolon oder 
Anführugnstriche benötigt oder auch eine andere Schriftcodierung.


Horst

Am 22.10.2015 um 13:53 schrieb Martin Jenniges:

Hallo,

bisher habe ich per Calc csv-Dateien erzeugt, um sie dann in Adobe 
Indesign in dessen Datenzusammenführung zu nutzen.


Jahrelang gabs keine Probleme, bis vor ca 14 Tagen, als ich eine neue 
csv generierte und nutzte: Indesign produzierte Fehler.
Ein Kollege meinte, bei Calc-csv wäre er eher vorsichtig...; daraufhin 
nutzte ich Excel zur Generierung der csv und mit der gabs in Indesign 
keine Probleme.


Jetzt frage ich mich, welchen Unterschied denn Calc-csv und Excel-csv 
haben.
Ich denke dabei eher an die Codierung (Unicode, utf7, utf8...) und 
nicht an die Separatoren wie Komma und Semikolon


Weiss von Euch jemand was zu der Frage ?

mit freundlichem Gruss
Martin Jenniges

-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org




-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Unsinnig ? Calc-CSV ungleich Excel-CSV ?

[Martin Jenniges]

Hallo,

bisher habe ich per Calc csv-Dateien erzeugt, um sie dann in Adobe 
Indesign in dessen Datenzusammenführung zu nutzen.


Jahrelang gabs keine Probleme, bis vor ca 14 Tagen, als ich eine neue 
csv generierte und nutzte: Indesign produzierte Fehler.
Ein Kollege meinte, bei Calc-csv wäre er eher vorsichtig...; daraufhin 
nutzte ich Excel zur Generierung der csv und mit der gabs in Indesign 
keine Probleme.


Jetzt frage ich mich, welchen Unterschied denn Calc-csv und Excel-csv haben.
Ich denke dabei eher an die Codierung (Unicode, utf7, utf8...) und nicht 
an die Separatoren wie Komma und Semikolon


Weiss von Euch jemand was zu der Frage ?

mit freundlichem Gruss
Martin Jenniges

-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Unsinnig ? Calc-CSV ungleich Excel-CSV ?

[Martin Jenniges]

Hallo Regina,

Am 22.10.2015 um 15:41 schrieb Regina Henschel:

Hallo Martin,

Martin Jenniges schrieb:

Hallo,

bisher habe ich per Calc csv-Dateien erzeugt, um sie dann in Adobe
Indesign in dessen Datenzusammenführung zu nutzen.

Jahrelang gabs keine Probleme, bis vor ca 14 Tagen, als ich eine neue
csv generierte und nutzte: Indesign produzierte Fehler.


Hat OpenOffice oder Indesign ein Update erhalten?
Ja, anfang des Jahres erhielt ich einen neuen Mac mit OS Yosemite; da 
hab ich dann das neue OO installiert. auf dem alten Mac war vermutlich 
OO 3.4




Ein Kollege meinte, bei Calc-csv wäre er eher vorsichtig...; daraufhin
nutzte ich Excel zur Generierung der csv und mit der gabs in Indesign
keine Probleme.


Dann musst du wahrscheinlich in Calc eine andere Codierung benutzen.



Jetzt frage ich mich, welchen Unterschied denn Calc-csv und Excel-csv
haben.
Ich denke dabei eher an die Codierung (Unicode, utf7, utf8...) und nicht
an die Separatoren wie Komma und Semikolon

Weiss von Euch jemand was zu der Frage ?


Ich habe mal Excel 2010 ausprobiert. Wenn ich nicht irgendwo eine 
Einstellung übersehen habe, macht Excel überhaupt kein Unicode beim 
Export. Schreib mal ein Deutsch-Griechisch-Wörterbuch als csv in 
Excel; das gibt nur Fragezeichen. In Calc kannst du die Kodierung 
wählen. Also guck was Indesign haben möchte und stelle es dann bei 
Calc ein.
Hm, auf der Suche nach Ursache und Lösung des Problemes im Internet habe 
ich eine englische Anleitung zum Konvertierung der Codierung in utf-16 
gefunden; laut Autor soll das Probleme mit Indesign lösen.


Ich wollte aber trotzdem wissen, welche Unterschiede es gibt.

Ich muss mal suchen, ob Adobe Angaben zu der csv-Codierung gibt. bisher 
hiess es immer, einfach aus csv...




Hat sich dein Kollege jemals angeschaut, was Excel produziert, wenn 
man den ANSI-Bereich verlässt?

weiss ich nicht. gehört es denn zu der Thematik ?


Mit freundlichen Grüßen
Regina

-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org




viele Grüsse
Martin

-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Unsinnig ? Calc-CSV ungleich Excel-CSV ?

[Regina Henschel]

Hallo Martin,

Martin Jenniges schrieb:

Hallo,

bisher habe ich per Calc csv-Dateien erzeugt, um sie dann in Adobe
Indesign in dessen Datenzusammenführung zu nutzen.

Jahrelang gabs keine Probleme, bis vor ca 14 Tagen, als ich eine neue
csv generierte und nutzte: Indesign produzierte Fehler.


Hat OpenOffice oder Indesign ein Update erhalten?


Ein Kollege meinte, bei Calc-csv wäre er eher vorsichtig...; daraufhin
nutzte ich Excel zur Generierung der csv und mit der gabs in Indesign
keine Probleme.


Dann musst du wahrscheinlich in Calc eine andere Codierung benutzen.



Jetzt frage ich mich, welchen Unterschied denn Calc-csv und Excel-csv
haben.
Ich denke dabei eher an die Codierung (Unicode, utf7, utf8...) und nicht
an die Separatoren wie Komma und Semikolon

Weiss von Euch jemand was zu der Frage ?


Ich habe mal Excel 2010 ausprobiert. Wenn ich nicht irgendwo eine 
Einstellung übersehen habe, macht Excel überhaupt kein Unicode beim 
Export. Schreib mal ein Deutsch-Griechisch-Wörterbuch als csv in Excel; 
das gibt nur Fragezeichen. In Calc kannst du die Kodierung wählen. Also 
guck was Indesign haben möchte und stelle es dann bei Calc ein.


Hat sich dein Kollege jemals angeschaut, was Excel produziert, wenn man 
den ANSI-Bereich verlässt?


Mit freundlichen Grüßen
Regina

-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org

Re: Macro compatibility to Excel

[Rory O'Farrell]

Having started writing a macro, you will get good help from  the user forums
in English at
https://forum.openoffice.org/en/forum/
and in French at
https://forum.openoffice.org/fr/forum/



On Thu, 8 Oct 2015 13:00:18 +0100
Rory O'Farrell <ofarr...@iol.ie> wrote:

> On Thu, 8 Oct 2015 09:50:18 +
> Adam AUTUORI <askeri...@hotmail.fr> wrote:
> 
> > Hello. I want to code an ods macro into OpenOffice to make my work easier 
> > at my bakery.
> > 
> > Is the OpenOffice Basic dialect would be compatible to Excel to assure 
> > portability to any calc application ? Thanks a lot 
> 
> Some simple macros may run unchanged, but anything beyond he simple/almost 
> trivial will need rewriting as the macro languages differ dramatically.  Best 
> information on OpenOffice macros is in the books by Andrew Pitonyak, 
> downloadable from
> http://www.pitonyak.org/oo.php
> 
> 
> -- 
> 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
> 
> 


-- 
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

Macro compatibility to Excel

[Adam AUTUORI]

Hello. I want to code an ods macro into OpenOffice to make my work easier at my 
bakery.

Is the OpenOffice Basic dialect would be compatible to Excel to assure 
portability to any calc application ? Thanks a lot 

Re: Macro compatibility to Excel

[Johnny Rosenberg]

2015-10-08 11:50 GMT+02:00 Adam AUTUORI <askeri...@hotmail.fr>:

> Hello. I want to code an ods macro into OpenOffice to make my work easier
> at my bakery.
>
> Is the OpenOffice Basic dialect would be compatible to Excel to assure
> portability to any calc application ? Thanks a lot 



Well, I think the MS Office Basic dialect is Microsoft's property, so I am
pretty sure that will never happen, unless Microsoft gives it away for free
for some weird reason...


Kind regards

Johnny Rosenberg

Excel problem

[ALINGA 2]

Hello,
I found a mistake. See file in the attachment.
BR
Algis

Susikniso open office Excel.ods
Description: application/vnd.oasis.opendocument.spreadsheet

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: problem with import of excel file, cells contain new lines

[Brian Barker]

At 11:28 19/02/2015 +0100, Uwe Brauer wrote:
By the way, when I perform this operations for one cell say C2 and 
then want to enhance it to the whole column, it seems that I can 
only do it by dragging the boundary of the cells with the mouse. Is 
this correct?


No. Dragging the fill handle (not the cell boundary) is indeed one, 
often convenient way. But others are copying and pasting, as well as 
using Edit | Fill  | Down. For these, you will need to select the 
target range, but you can easily do that using click at one end and 
Shift+click at the other.


I am asking since the original file in question has a column of 300 
rows and using the mouse proved to be very very slow, but 
clean(C2:C300) did not work neither.


Actually, you can use formulae like that, where a function operates on a range:
o Select the first cell of the target range.
o Enter the formula.
o To complete the formula, don't press Enter or click the green 
arrow. Instead, press Ctrl+Shift+Enter. The formula (visible in the 
Input Line) has now grown enclosing braces, as

{=CLEAN(C2:C300)}
- but note that you cannot type the braces yourself. This is called 
an array formula.


(By the way, I think I'd established that CLEAN() wouldn't work for 
you: three applications would be necessary to remove all five tab 
characters and you would still have the remaining space and 
non-breaking space to deal with if you wanted to process the values 
as numbers.)


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: problem with import of excel file, cells contain new lines

[Uwe Brauer]

 Brian == Brian Barker b.m.bar...@btinternet.com writes:

At 18:29 18/02/2015 +0100, Uwe Brauer wrote:
I run for example clean(C2) and it returns Err:522. C is the column with 
the problems

That means that your formula is circular. I'm guessing that you have
tried putting =CLEAN(C2) into C2 itself. Apart from the fact that this

Right! I did this because I thought: if I copy the cell in a new column, and
then want to replace the old one with the new one, I will have a
problem: the new one depends on the old one and then everything gets
deleted.  But as you explain below: that can be avoided, thanks for
pointing it out.


By the way, when I perform this operations for one cell say C2 and then
want to enhance it to the whole column, it seems that I can only do it
by dragging the boundary of the cells with the mouse. Is this correct?

I am asking since the original file in question has a column of 300 rows
and using the mouse proved to be very very slow, but clean(C2:C300) did
not work neither.

Any comments?

 deletes that value to are trying to recover, it suggests that you want
the value in C2 to be a CLEANed version of the value in C2 -
which is a CLEANed version of what is in C2! The formula refers back
to itself repeatedly, and the calculation can never end.

If you were to use a formula to achieve what you need, you would have
to put it into a spare column. You could choose to copy the results
back into the original cells, but you would need to use Paste Special
instead of ordinary paste and to deselect Formulae in the Paste
Special dialogue so as to freeze the results.

I trust this helps.

Thanks indeed it does.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: problem with import of excel file, cells contain new lines

[Manuel Andres Ramirez]

El 19/02/15 a las 05:28, Uwe Brauer escribió:

deletes that value to are trying to recover, it suggests that you want
 the value in C2 to be a CLEANed version of the value in C2 -
 which is a CLEANed version of what is in C2! The formula refers back
 to itself repeatedly, and the calculation can never end.

 If you were to use a formula to achieve what you need, you would have
 to put it into a spare column. You could choose to copy the results
 back into the original cells, but you would need to use Paste Special
 instead of ordinary paste and to deselect Formulae in the Paste
 Special dialogue so as to freeze the results.

 I trust this helps.

Thanks indeed it does.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org




Maybe, as Andrew sugested in the list , the search and replace could be
the solution.

Try this.

First, select the column C
Call the search and replace option in the edit menu.
In Search box fill with \n\t\t\t\t\t..
In Replace box left empty

Click to open the more options
mark option Only in current selection (I'm using a spanish versión, so
I don't remember the correct words in english)
mark oprtion Regular expression

Click Replace all

The pattern \n\t\t\t\t\t.. correspond to the weird caracters in cells
of column C, if this pattern change, maybe this solution need a fix.


Try it, and we'll see.


SECOND VERSION..

Searching a little deep. I Found that you can use [:cntrl:] in search box, to 
erase all non printable characters. Doesn't matter if the pattern change.

Maybe this is the easy way to solution Uwe's problem.

Bye





--

Manuel Andrés Ramírez P.
Administrador Informático
GNU/Linux Registered User:412887
Visite:www.getgnulinux.org/es/

Yo Tengo mi Office Legal y no pagué por su licencia

El placer más noble es el júbilo de comprender
(Leonardo Da Vinci)


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: problem with import of excel file, cells contain new lines

[Manuel Andres Ramirez]

El 19/02/15 a las 11:18, Brian Barker escribió:

At 10:53 19/02/2015 -0500, Manuel Andres Ramirez wrote:
Searching a little deep. I Found that you can use [:cntrl:] in search 
box, to erase all non printable characters. Doesn't matter if the 
pattern change. Maybe this is the easy way to solution Uwe's problem.


Nice idea. This removes the line break and the tab characters but 
sadly not the final space and non-breaking space.


Brian Barker




Brian, are you sure. I've tested and only remain de values inside the 
cells of column C.


All nonprintable characters must be deleted.

Are the regular expressión marked? in the search and replace dialog.


--

Manuel Andrés Ramírez P.
Administrador Informático
GNU/Linux Registered User:412887
Visite:www.getgnulinux.org/es/

Yo Tengo mi Office Legal y no pagué por su licencia

El placer más noble es el júbilo de comprender
(Leonardo Da Vinci)


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: problem with import of excel file, cells contain new lines

[Uwe Brauer]

 Manuel == Manuel Andres Ramirez manuelandr...@aim.com writes:

El 17/02/15 a las 10:06, Brian Barker escribió:
At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote:
 El 17/02/15 a las 06:00, Uwe Brauer escribió:
I periodically receive excel files (generated by Office 2010 I
 think, but saved in the old binary format). Some of these columns
 cause me problems, since they seem to contain spaces and even
 newlines. I could correct that manually, but since the file
 contains hundred of lines this is cumbersome. So the question is
 whether there exist any formatting function which could resolve the
 issue.

 You can use TRIM() or LIMPIAR() in spanish function over the
 column C and correct the spaces or tabs.


Thanks but.

I run for example clean(C2) and it returns Err:522

C is the column with the problems


smime.p7s
Description: S/MIME cryptographic signature

Re: problem with import of excel file, cells contain new lines

[Brian Barker]

At 08:51 18/02/2015 -0500, Manuel Andres Ramirez wrote:

El 17/02/15 a las 10:06, Brian Barker escribió:

At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote:

El 17/02/15 a las 06:00, Uwe Brauer escribió:
I periodically receive excel files (generated 
by Office 2010 I think, but saved in the old 
binary format). Some of these columns cause 
me problems, since they seem to contain 
spaces and even newlines. I could correct 
that manually, but since the file contains 
hundred of lines this is cumbersome. So the 
question is whether there exist any 
formatting function which could resolve the issue.


You can use TRIM() or LIMPIAR() in spanish 
function over the column C and correct the spaces or tabs.


I tried TRIM(), but this seemed to do nothing 
in this case. It would not remove the tabs or 
line breaks or non-breaking spaces; it could 
remove the ordinary spaces, but only when they 
were trailing - so only if the non-breaking spaces had already been removed.


Sorry, I tested with libreoffice in spanish and 
use LIMPIAR() function, so I translated wrongly 
as TRIM(), but now I realize that the correct function is CLEAN()


Aha! You can see that my Spanish is non-existent!


Try with CLEAN() over the Uwe attachment.


In fact I had already tried using CLEAN() without 
success. I found that CLEAN() would remove the 
line break but only two tab characters at a time, so something like

=CLEAN(CLEAN(CLEAN(C1)))
was necessary even to remove all five tab 
characters. But that still left the space and the 
final non-breaking space. Applying TRIM() did not 
remove those, nor would VALUE() ignore them, so 
that transpired to be a dead end.


Brian Barker  



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org