RE: Makro: Zugriff auf Tabelle im Textdokument
Hallo, > From: Wolfgang Jäth [mailto:jawo.ml.hams...@arcor.de] > Sent: Sunday, September 29, 2019 12:53 PM > To: users-de@openoffice.apache.org > Subject: Re: Makro: Zugriff auf Tabelle im Textdokument > Ich habe jetzt mal ein bisschen damit herum gespielt; Tool > war folgendes > Makro, welches *nicht* in einem der beiden Dokumente (odt / > ods) stand, > sondern (temporär) in einem dritten Dokument: Wie willst Du ein Makro, das in einem Dokument gespeichert ist in einem anderen Dokument anwenden? > > /dafür/ die Ursache zu finden; gibt sicher eine :-) ). Ja, das "ThisComponent"-Objekt. http://www.starbasicfaq.de/WorinbestehtderUnterschiedzwischenthisCo.html > > in OO evtl. ein zentrales Basic-Objekt gibt, welches alle akut > geöffneten Dokumente auflistet Stardesktop alle = StarDesktop.getComponents() enum = alle.createEnumeration() Do While enum.hasMoreElements() doc = enum.nextElement() 'doc ist jetzt eines der Desktopobjekte '(geöffnete Datei, Basic-DIE, Hilfefenster,..) 'tue etwas damut Loop 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: Spell check
https://forum.openoffice.org/en/forum/viewtopic.php?f=7=89052 On 30/9/19 9:29 am, John Skjerven wrote: I have been using Open Office for several years. Last week the Spell Check quick working. Now it indicates that all the words are incorrect instead of just one and then suggesting the correct spelling. How do I correct this? John Skjerven Home 480 473 4819 Cell 480 695 0777 2611 E Bear Creek Ln, Phoenix, AZ 85024 Cheers -- David Robley If I were you, who'd be me? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Spell check
I have been using Open Office for several years. Last week the Spell Check quick working. Now it indicates that all the words are incorrect instead of just one and then suggesting the correct spelling. How do I correct this? John Skjerven Home 480 473 4819 Cell 480 695 0777 2611 E Bear Creek Ln, Phoenix, AZ 85024
Re: Update All Links Question
Menu item Edit | Links | Update From the Help - "Updates the selected link so that the most recently saved version of the linked file is displayed in the current document." 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 sent 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. On 30/9/19 2:41 am, Vince@GMAIL wrote: With a Calc file already opened, is it possible to update all links? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Cheers -- David Robley Useless Invention: Battery-operated nuclear power plants. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Links Do Not Work in Calc
At 13:01 29/09/2019 -0400, Vince Bonly wrote: AOO 4.1.5 on DELL desktop; WIN10 Home x64 I don't know or understand how update Links, or update Styles, is supposed to work in Calc. Warning: I'm not sure I do, either. But I may be able to help. Each time a Calc file is opened, I am prompted for a Yes/No to up date All Links, or sometimes Y/N to update New Styles. Good-oh! That's helpful. In an opened Calc file I have selected a cell and pointed to a specific cell that is located in a different Calc file. ( e.g. ...) This is no longer working in several Calc files ("0" value is returned rather than the expected value contained within the external file & Cell). But, this /pointing to an external file's cell/ does work in a New Calc file, when pointing to the same external file sheet & cell. I hope that somebody can point me in the direction of or give me a description of how this is suppose to work, and perhaps enlighten me on the possibilities of why it is no longer working for several of my existing Calc files. One idea: the target document needs to have been saved after any changes before any values from it can be harvested in this way. In addition, I would appreciate receiving hints about the Update/Use Old Styles template prompts. Not sure about these. At 13:11 29/09/2019 -0400, Vince Bonly wrote: With a Calc file already opened, is it possible to update all links? o There is a facility at Tools | Cell Content > | Recalculate (or F9) which I imagine should do this, but I don't see that it does. I don't know why. o There is a an additional "Recalculate Hard" facility at Ctrl+Shift+F9, but I don't see that this operates as you might expect either. You might like to try it. o Here's a workaround: + Save the harvesting document if necessary, so as to preserve any changes. + Go to File | Reload. This will stimulate the interaction you see when opening such a document file and give you the chance to say "Yes". I suppose other possibilities are that your harvesting document has somehow become corrupt or - more likely - that your link is no longer accurate. Have you perhaps moved the target file, renamed a folder, or renamed the target file itself, perhaps to correct a misspelling? What happens if you re-create the link in the harvesting file from scratch? It's best to do this by clicking on the target cell instead of attempting to type the entire link, of course. 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
Update All Links Question
With a Calc file already opened, is it possible to update all links? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Links Do Not Work in Calc
AOO 4.1.5 on DELL desktop; WIN10 Home x64 _ I don't know or understand how update Links, or update Styles, is supposed to work in Calc. Each time a Calc file is opened, I am prompted for a Yes/No to up date All Links, or sometimes Y/N to update New Styles. In an opened Calc file I have selected a cell and pointed to a specific cell that is located in a different Calc file. ( e.g., entered in the cell: =('file:///C:/Users/Username/Documents/./filename.ods'#$'sheetname...'.J79 ). This is no longer working in several Calc files ( "0" value is returned rather than the expected value contained within the external file & Cell). But, this /pointing to an external file's cell/ does work in a New Calc file, when pointing to the same external file sheet & cell. I hope that somebody can point me in the direction of or give me a description of how this is suppose to work, and perhaps enlighten me on the possibilities of why it is no longer working for several of my existing Calc files. In addition, I would appreciate receiving hints about the Update/Use Old Styles template prompts. TNX. Regards, VinceB.
Re: Makro: Zugriff auf Tabelle im Textdokument
Am 28.09.2019 um 17:31 schrieb technik_...@jrsch.de: > > Am 28.09.2019 um 16:37 schrieb Wolfgang Jäth: >> Am 28.09.2019 um 08:29 schrieb technik_...@jrsch.de: >>> Hallo und danke noch mal. >>> >>> Leider funktioniert das auch nicht. Ich hatte das Makro schon nach den >>> Vorschlägen von Jörg angepasst, die praktisch das gleiche sind. >> Dann überprüf mal, ob deine Variablen (v. a. das "i") überhaupt passen; >> u. a. deswegen hab ich die Belegungen im Code gelassen. >> >> Setz mal einen Breakpoint auf die Zuweisung mit dem getByIndex, und lies >> die Variablen i und f aus. Dann machst du nacheinander 2 Einzelschritte, >> und schaust dir jeweils den Inhalt von myTable bzw. myCell an. Irgend wo >> da wird wohl was schief laufen, denke ich. > Hab ich schon gemacht. Und wie gesagt, das Feld wird ja angesteuert und > kann ausgelesen werden. Nur der Bildschirm springt nicht zu dem Feld. >> >>> Es scheint meine Installation ist defekt. Aber wo könnte der Fehler liegen? >> Glaub ich nicht; andere Makrobefehle funktionieren ja, wie du schrubst. > nicht ganz. Ich habe noch ein Problem, wenn ich ein Textdokument auf > habe und eine Tabellendokument drucken will wird das Textdokument > gedruckt. Ich habe jetzt mal ein bisschen damit herum gespielt; Tool war folgendes Makro, welches *nicht* in einem der beiden Dokumente (odt / ods) stand, sondern (temporär) in einem dritten Dokument: Sub Main Dim Doc As Object Dim Ident As String Dim Msg as String Doc = ThisComponent Ident = Doc.Identifier Select Case Ident Case "com.sun.star.sheet.SpreadsheetDocument" Msg = "Spreadsheet-Document" Case "com.sun.star.text.TextDocument" Msg = "Text-Document" Case Else Msg = "unknown document type : " & Ident End Select MsgBox(Msg) End Sub Je nachdem, welches Dokument ich direkt vorher zuletzt im Vordergrund hatte, bekam ich als Meldung mal "Spreadsheet-Document", mal "Text-Document", und manchmal auch "unknown document type : com.sun.star.text.WebDocument" (bin aber jetzt zu faul, auch noch /dafür/ die Ursache zu finden; gibt sicher eine :-) ). Kannst du mal prüfen, ob sich das bei dir genauso verhält? Ach ja, ich hatte das odt, das ods und das Makrofenster permanent parallel offen (und nix gespeichert, war ja nur für Testzwecke). Btw. kann es auch sehr gut sein, dass sich das Verhalten völlig ändert, wenn man das Makrofenster nicht geöffnet hat. Also bitte zum Vergleich /erst/ mal möglichst genau nachstellen. >Ich habe schon mal ein Update gemacht, aber das hat nichts > geändert. Vielleicht entferne ich mal OO ganz und das Userverzeichnis > und Java und installiere dann neu. Oder braucht OO noch andere Ressourcen? Wie gesagt, ich glaube nicht, dass deine Installation selbst kaputt ist, sondern dass es vielmehr an irgend einer Variablenbelegung o. ä. liegt. Dummerweise kenn ich mich mit OO-Basic wirklich nur sehr marginal aus, ich mach das meiste eigentlich in Calc, und da mit Formeln direkt. Daher kann ich dir nicht sagen (aber ich würde es eigentlich erwarten), ob es in OO evtl. ein zentrales Basic-Objekt gibt, welches alle akut geöffneten Dokumente auflistet, so dass du darüber gezielt auf das /gewünschte/ Dokument zugreifen kannst. *So* jedenfalls (immer aufpassen, dass du das gewünschte Dokument direkt vorher angeklickt hattest) ist das eine sehr mühselige weil fehlerträchtige Arbeit. Wolf 'und wahrscheinlich gäbe es den Typ irgendwo auch als Object, nicht nur als String; ich mag Stringvergleiche nicht ... :-/' gang -- Donald Trump ist ein großer Visionär, der seiner Zeit weit voraus ist: Er verbreitet schon jetzt den Slogan "make America great again", obwohl dieser erst in der Ära /nach/ ihm seine volle Bedeutung entfalten wird. - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Spell Check Issues
Sorry, that I mixed the lines --- If it works afterwards, ou know that the dictionar has been installed. Probably somebody else can give ou another hint ... --- is from me :-) Am 29.09.2019 um 09:54 schrieb Andrea: Am 28.09.2019 um 23:14 schrieb Welcome: I am not sure if standard.dic has been installed. Every word in my document is underlined in red. How can I determine if my dictionary has been installed and is working correctly. I am using Windows 10 and have installed OpenOffice version 4.1.7 Sent from Mail for Windows 10 Tra what Rory O'Farrell wrote: If it works afterwards, ou know that the dictionar has been installed. Probably somebody else can give ou another hint ... Start by renaming your existing OpenOffice user profile. As you are using Windows close OpenOffice and the Quickstarter. Open File Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer (sometimes called Windows Explorer) Address Bar and press Enter. Rename the "user" folder - "user.old" is a good choice. Start OpenOffice. This cures most spellcheck problems. The loss of spellcheck may be related to a crash of OpenOffice or overhasty close down of OO or the computer, before the internal buffers in the hard drive have flushed to disk, which can cause the OO User Profile to be improperly (or not at all) written. - 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: Spell Check Issues
Am 28.09.2019 um 23:14 schrieb Welcome: I am not sure if standard.dic has been installed. Every word in my document is underlined in red. How can I determine if my dictionary has been installed and is working correctly. I am using Windows 10 and have installed OpenOffice version 4.1.7 Sent from Mail for Windows 10 Tra what Rory O'Farrell wrote: If it works afterwards, ou know that the dictionar has been installed. Probably somebody else can give ou another hint ... Start by renaming your existing OpenOffice user profile. As you are using Windows close OpenOffice and the Quickstarter. Open File Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer (sometimes called Windows Explorer) Address Bar and press Enter. Rename the "user" folder - "user.old" is a good choice. Start OpenOffice. This cures most spellcheck problems. The loss of spellcheck may be related to a crash of OpenOffice or overhasty close down of OO or the computer, before the internal buffers in the hard drive have flushed to disk, which can cause the OO User Profile to be improperly (or not at all) written. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org