Re: Einfache Formel
Danke, ich hab das jetzt noch nicht probiert, aber die Antwort ist fenomenal. Abends wenn ich Zeit habe, probiere ich es und, natürlich, gebe Erfolgsbericht. Danke Dieter El dom., 26 ago. 2018 7:33, Wolfgang Jäth escribió: > Am 25.08.2018 um 22:23 schrieb Lucifer El Diabolo: > > BS ist W 8 > > > > OO ist 4.3.1 laeuft sehr gut > > > > Guten Abend, > > > > Ich moechte den Wert einer Zelle in Tabelle 1 in eine Zelle in Tabelle 2 > > kopieren und bekomm die Formel nicht hin. > > > > Ich dachte an =a1 ;$Tabelle1 > > > > Das geht nicht, da fehlt ein Komma, Doppelpunkt oder Klammern oder sonst > > was. Bitte sehr um Nachhilfe. > > Gib einfach in die betreffende Zelle ein Gleichheitszeichen ein, und > klick dann mit der Maus in die Zelle, welche als Quelle dienen soll. > Anschließend drückst du die Enter-Taste, und die Formel steht korrekt in > der Zelle drin D. h. genau genommen tut sie das schon, sobald du mit der > Maus nur irgend wo hin klickst. Solange du die Eingabe noch nicht > beendet hast, kannst du mit der Maus beliebig herum klicken, also auch > auf ein anderes Tabellenblatt gehen, oder sogar ein anderes Dokument (muss > halt nur offen sein). > > Zu beachten ist lediglich, dass bei Adressen mit Pfadangaben prinzipiell > eine absolute Adressangabe erzeugt wird (die "$"-Zeichen vor den > Spaltenbuchstaben und Zeilennummern usw.). Diese "$" muss man je nach > Bedarf (z. B. um die Formel in andree Zellen zu kopieren) ggf. manuell > entfernen. > > Wolfgang > -- > Durch Donald Trump ist mir endgültig klar geworden: Es ist > nicht der Turm von Pisa, der schief steht, es ist die Welt! > > > - > To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-de-h...@openoffice.apache.org > >
Re: Page number creation using recently downloaded Open Office 4.1.5
On 26/8/18 4:52 pm, 許哲崇 wrote: My suggestion is that the first page also need the page number. Your suggestion doesn't make sense, the Original Poster don't want a number on the first page for obvious reasons. Rory O'Farrell 於 2018年8月26日 週日 上午3:10 寫道： On Sat, 25 Aug 2018 18:26:23 + Donald Nathan wrote: Hello all, After a recommendation from Peter Kovacs, I'm presenting my question to you. I'm a student at Norwich University (VT) and just downloaded new version of Open Office 4.1.5. I'm creating a report and don't want a page number on the first page. I've gone through the steps to place the page number on the page but when I right click the number, the 'fields' choice I am looking for is not shown, see below. Thanks for your time! Donald [cid:bc76dfca-fee6-4a11-91ac-ee5e029bec06] Have you inserted a number (a digit, plain and simple) or used /Insert /Fields /PageNumber? This latter is how you should do it. Your first page should use Page Style First Page, with, on its Organiser tab, the following style set to use Default (or whatever other page style you desire). The Page Numbering tutorial at https://forum.openoffice.org/en/forum/viewtopic.php?f=71=1221 will be helpful. -- Rory O'Farrell - 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: Password-locked document
I suggest you rewrite the document before you pay the expert. Martin Groenescheij 於 2018年8月25日 週六 上午11:30 寫道： > > > On 25/8/18 7:24 am, Judge Gayle Hamilton wrote: > > Hi, > > > > I am currently locked out of a document that I am needing to print and I > do not know the password. > > It's like being locked out of your home when you lost your key. > > > I am unsure of how a password was set for this document as it has not > happened before. > > Passwords aren't set automatically, even it the tick box is accidentally > ticked when you save your > document you still need to enter the password twice. > The fact that something didn't happen before is no guarantee that it > will not happen in the future. > > > How can I unlock the document? > > Well if you're locked out from your home you call a Locksmith, when > you're locked out from your > document you can hire a expert, but they can be quite expensive and > there is no guarantee that > the will be able to break the encrypted password. > > > > > Also, how can I be sure this does not happen in the future? > > Pay more attention when a menu pops up > > > > > Thank you > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
Re: Page number creation using recently downloaded Open Office 4.1.5
My suggestion is that the first page also need the page number. Rory O'Farrell 於 2018年8月26日 週日 上午3:10 寫道： > On Sat, 25 Aug 2018 18:26:23 + > Donald Nathan wrote: > > > Hello all, > > > > > > After a recommendation from Peter Kovacs, I'm presenting my question to > you. > > > > > > I'm a student at Norwich University (VT) and just downloaded new version > of Open Office 4.1.5. I'm creating a report and don't want a page number on > the first page. I've gone through the steps to place the page number on the > page but when I right click the number, the 'fields' choice I am looking > for is not shown, see below. > > > > Thanks for your time! > > > > Donald > > > > [cid:bc76dfca-fee6-4a11-91ac-ee5e029bec06] > > Have you inserted a number (a digit, plain and simple) or used /Insert > /Fields /PageNumber? This latter is how you should do it. Your first page > should use Page Style First Page, with, on its Organiser tab, the > following style set to use Default (or whatever other page style you > desire). > > The Page Numbering tutorial at > https://forum.openoffice.org/en/forum/viewtopic.php?f=71=1221 > will be helpful. > > > -- > Rory O'Farrell > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
