AW: Zellenverschiebung, Referenzelle kommt nicht nach
Danke für den Hinweis, ich mache aber nichts Spezielles Zelle A2 wird auch in Zelle B5 angezeigt führe ich eine z.B. Leerzeile über A2 ein dann wird der Inhalt von A2 in A3. ABER Zelle B5 referiert immer noch auf Zelle A2, in der jetzt ein anderer Inhalt stehen kann. Zelle B5 müsste jetzt den Inhalt von Zelle A3 anzeigen evtl. ich speichere die Dateien als .xls nicht als odt, wie vorgeschlagen, um sie auch in Excel lesen zu können liegt evtl darin ein Fehler? Mit besten Grüssen Hermann -Original-Nachricht- Betreff: Re: Zellenverschiebung, Referenzelle kommt nicht nach Datum: 2023-12-09T23:29:34+0100 Von: "Günter Feierabend" An: "users-de@openoffice.apache.org" Hallo Hermann, > Am 2023-12-08 um 19:01 schrieb primav...@t-online.de: > > Hallo, ich benötige Hilfe, > > wenn ich in Open Office Calc eine Zelle verschiebe evtl. durch neue Zeile > darüber, dann geht eine Referenzelle, die auf diese Quell Zelle referiert > nicht mit, d.h. ich muss mit Hand nachjustierten, das konterkariert den > ganzen Sinn und Zweck eine Tabellen Kalkulation > wie kann ich das bitte korrigieren oder richtig einstellen > beste Grüsse, Hermann Dein Problem kann ich hier nicht nachstellen. Es funktioniert alles, wie es soll. Ich kann Zeilen oder Spalten oder Tabellen einfügen, verschieben oder löschen - Bezüge bleiben stets erhalten. Vielleicht machst Du etwas Spezielles und solltest dies ausführlicher schildern? Gruß Günter - 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: Fußnotennummerierung per Dokument
Hallo Konrad, also mit Endnoten funktioniert das, jetzt habe ich eine durchgehende Nummerierung für das gesamte Buch. Ich musste neben jeden Fußnotenanker eine neue Endnote einfügen, und den Inhalt von ersterer in die zweite einfügen, danach alle Fußnoten gelöscht und nur noch die Endnoten übrig gelassen. Kleiner Tip: Man kann in OpenOffice das Dokument im Menü "Fenster" zweimal (oder gar mehrmals) öffnen. Das erleichtert die Arbeit erheblich, weil man zwei verschiedene Stellen gleichzeitig im Blick behält. Viele Grüße Dave On Sun, 10 Dec 2023 at 11:22, Dave wrote: > Lieber Konrad, > > funktioniert leider nicht. Wenn man die Fußnoten ans Seitenende setzt, > geht das, also eine durchgehende Nummerierung für das ganze Dokument (statt > einem Neuanfang pro Seite oder pro Kapitel). Sobald man aber im Menü die > Fußnoten ans Ende des Dokuments setzt, beginnt die Nummerierung bei jedem > Kapitel neu. > > Vielleicht muss ich von vornherein mit "Endnoten" statt mit Fußnoten > arbeiten. Ich schau mal, ob das vielleicht eine Lösung ist. > > Ein weiteres Problem, das ich schon mal hatte, aber jetzt nach dem Wechsel > von Dokumentenende zu Seitenende und wieder zurück wieder verschwunden ist: > die Fußnoten gingen nach unten über die Seite hinaus! Also der Seitenrand > wurde nicht respektiert. > > Ich melde mich wieder, wenn es mit den Endnoten bessere Ergebnisse gibt. > > Habe mit OpenOffice einige Bücher formatiert, im Prinzip geht wirklich > alles super! > > Ebenfalls einen schönen Sonntag wünsche ich dir von Tunis aus. > > Best > Dave > > > On Sat, 9 Dec 2023 at 19:40, Dave wrote: > >> Liebe Unterstützer, >> >> bin selbst eigentlich fit in OpenOffice, stolpere aber doch über die >> Fußnotennummerierung. Sie beginnt bei jedem Kapitel neu. Unter "Tools -> >> Footnotes/Endnotes" gibt es das Dropdown-Menü "Counting per page" bzw. >> "Counting per document". Wenn ich letzteres anklicke und das Menü schließe >> und wieder öffne steht dann doch "Counting per page". >> >> Kann mir jemand helfen? Wäre echt dankbar! >> >> Schöne Grüße aus Tunis >> Dave >> >
Re: OpenOffice locked up
On Sun, 10 Dec 2023, Linda Hull wrote: Rod Christ, I think that's a smart move for now. MS hasn't cooked up their best upgrade yet this time. Linda On Sun, Dec 10, 2023 at 5:25 AM Rod Christ wrote: Thanks, but I had Best Buy uninstall it. The link provides overly complicated instructions. Ctrl+Alt+Del, choose process and 'end task'. Seems more straightforward. I wonder how much gooing to Best Buy cost in gas, technician's charges? Not to mention time. Not a big fan of Windows 11 but this kind of foul-up happens sometimes with OpenOffice, quite rare though, in my experience. (I don't use Quickstarter which may, I think, sometimes cause OO to get stuck.) fjd On Sun, Dec 10, 2023 at 3:24 AM Linda Hull wrote: Dear Rod Christ, I don't have Windows 11, but here is "How To Know Which Process Is Using a File in Windows 11?" It uses Resource Manager natively, or something which you can download called 'Handle'. With either one, you can kill the processes you want to kill. https://www.partitionwizard.com/partitionmagic/know-which-process-is-using-file-win-11.html Linda On Sat, Dec 9, 2023 at 8:58 PM fjd wrote: On Sat, 9 Dec 2023, Rod Christ wrote: You do not understand. The program is LOCKED on my screen. I cannot use any of its features, I cannot close or open any windows within the program. I cannot shut it down, I cannot delete it. It is a s useless as tits on an alligator. UNDERSTAND?? I believe you didn't understand the instructions. Go to the Start Menu in Windows - tell us if you don't know what this is. And note it's part of Windows, not of OpenOffice. Note there's probably a simpler way to do the following but I'm not mainly a Windows user and this should work (first read through these instructions before executing any of them): (0) to shut down OpenOffice, enter 'ctl + alt + delete' keys at once, choose 'task manage'; find OpenOffice; right-click; choose 'end task'; you can close 'task manager' if you want. (I don't know if Dick Groskamp has a better way?) then: (1) type 'cmd' (no quotes) (2) click 'run as an administrator' (3) write or copy the command Dick Groskamp gave you, making sure to enter your actual username. (4) then restart OpenOffice. report back with questions, results, etc. Felmon On Sat, Dec 9, 2023 at 10:23 AM Dick Groskamp wrote: Try to renew your userprofile. Close OpenOffice and the Quickstarter (if enabled) Go to C:\Users\[your username]\AppData\Roaming\OpenOffice\4 There is a folder called user. Rename that folder to something else, for instance "user_old" Go back and restart OpenOffice. It will make a new folder user. This method often solves strange problems :-) On 2023/12/09 15:04:14 Rod Christ wrote: I recently upgraded to a new Lenovo laptop with Windows 11. I also downloaded OpenOffice ver. 4.1.14. It has never been stable. When I finish a document (mostly easy spreadsheets0 I cannot reopen the document. The program goes back and must restore and reload ALL prior documents before I can access any of the docs. That was a pain in the neck, but things worked. Today, it required "defragging" all prior documents again, but stalled and locked up totally. It has not started a recovery on ANY of the docs and locked up entirely. The things I had done previously were expendable so I decided to uninstall and reinstall. That does not work. The "rebuilding" panel is not responding to closing with an X, - or resize. Likewise, the larger window does not respond. All I can do is go back and work on other pages, mail, facebook, etc. I thought closing all open windows and restarting would help but that did not work either. What can I do to get past this logjam?Thanks, Rod Christ 563/258-1849 email is cozum...@gmail.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Davis Verbum sat sapienti. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Davis Verbum sat sapienti. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: OpenOffice locked up
Rod Christ, I think that's a smart move for now. MS hasn't cooked up their best upgrade yet this time. Linda On Sun, Dec 10, 2023 at 5:25 AM Rod Christ wrote: > Thanks, but I had Best Buy uninstall it. > > On Sun, Dec 10, 2023 at 3:24 AM Linda Hull > wrote: > > > Dear Rod Christ, > > > > I don't have Windows 11, but here is "How To Know Which Process Is Using > a > > File in Windows 11?" It uses Resource Manager natively, or something > which > > you can download called 'Handle'. With either one, you can kill the > > processes you want to kill. > > > > > > > https://www.partitionwizard.com/partitionmagic/know-which-process-is-using-file-win-11.html > > > > Linda > > > > On Sat, Dec 9, 2023 at 8:58 PM fjd wrote: > > > > > On Sat, 9 Dec 2023, Rod Christ wrote: > > > > > > > You do not understand. The program is LOCKED on my screen. I cannot > use > > > any > > > > of its features, I cannot close or open any windows within the > > program. I > > > > cannot shut it down, I cannot delete it. It is a s useless as tits on > > an > > > > alligator. UNDERSTAND?? > > > > > > I believe you didn't understand the instructions. > > > > > > Go to the Start Menu in Windows - tell us if you don't know what this > > > is. And note it's part of Windows, not of OpenOffice. > > > > > > Note there's probably a simpler way to do the following but I'm not > > > mainly a Windows user and this should work (first read through these > > > instructions before executing any of them): > > > > > > (0) to shut down OpenOffice, enter 'ctl + alt + delete' keys at once, > > > choose 'task manage'; find OpenOffice; right-click; choose 'end task'; > > > you can close 'task manager' if you want. > > > > > > (I don't know if Dick Groskamp has a better way?) > > > > > > then: > > > > > > (1) type 'cmd' (no quotes) > > > (2) click 'run as an administrator' > > > (3) write or copy the command Dick Groskamp gave you, making sure to > > > enter your actual username. > > > (4) then restart OpenOffice. > > > > > > report back with questions, results, etc. > > > > > > Felmon > > > > > > > > > > > On Sat, Dec 9, 2023 at 10:23 AM Dick Groskamp > > wrote: > > > > > > > >> Try to renew your userprofile. > > > >> Close OpenOffice and the Quickstarter (if enabled) > > > >> > > > >> Go to C:\Users\[your username]\AppData\Roaming\OpenOffice\4 > > > >> There is a folder called user. Rename that folder to something else, > > for > > > >> instance "user_old" > > > >> > > > >> Go back and restart OpenOffice. It will make a new folder user. > > > >> This method often solves strange problems :-) > > > >> > > > >> On 2023/12/09 15:04:14 Rod Christ wrote: > > > >>> I recently upgraded to a new Lenovo laptop with Windows 11. I also > > > downloaded OpenOffice ver. 4.1.14. It has never been stable. When > I > > > >> finish > > > a document (mostly easy spreadsheets0 I cannot reopen the > document. > > > The > > > program goes back and must restore and reload ALL prior documents > > > >> before I > > > can access any of the docs. That was a pain in the neck, but > things > > > >>> worked. > > > Today, it required "defragging" all prior documents again, but > > stalled > > > >> and > > > locked up totally. It has not started a recovery on ANY of the > docs > > > and > > > locked up entirely. The things I had done previously were > expendable > > > >> so I > > > decided to uninstall and reinstall. That does not work. The > > > >> "rebuilding" > > > panel is not responding to closing with an X, - or resize. > Likewise, > > > >> the > > > larger window does not respond. All I can do is go back and work > on > > > >> other > > > pages, mail, facebook, etc. I thought closing all open windows and > > > restarting would help but that did not work either. What can I do > to > > > >> get > > > past this logjam?Thanks, Rod Christ 563/258-1849 email is > > > cozum...@gmail.com > > > >>> > > > >> > > > >> > - > > > >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > > > >> For additional commands, e-mail: users-h...@openoffice.apache.org > > > >> > > > >> > > > > > > > > > > -- > > > Davis > > > > > > Verbum sat sapienti. > > > > > > - > > > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > > > For additional commands, e-mail: users-h...@openoffice.apache.org > > >
Re: OpenOffice locked up
Thanks, but I had Best Buy uninstall it. On Sun, Dec 10, 2023 at 3:24 AM Linda Hull wrote: > Dear Rod Christ, > > I don't have Windows 11, but here is "How To Know Which Process Is Using a > File in Windows 11?" It uses Resource Manager natively, or something which > you can download called 'Handle'. With either one, you can kill the > processes you want to kill. > > > https://www.partitionwizard.com/partitionmagic/know-which-process-is-using-file-win-11.html > > Linda > > On Sat, Dec 9, 2023 at 8:58 PM fjd wrote: > > > On Sat, 9 Dec 2023, Rod Christ wrote: > > > > > You do not understand. The program is LOCKED on my screen. I cannot use > > any > > > of its features, I cannot close or open any windows within the > program. I > > > cannot shut it down, I cannot delete it. It is a s useless as tits on > an > > > alligator. UNDERSTAND?? > > > > I believe you didn't understand the instructions. > > > > Go to the Start Menu in Windows - tell us if you don't know what this > > is. And note it's part of Windows, not of OpenOffice. > > > > Note there's probably a simpler way to do the following but I'm not > > mainly a Windows user and this should work (first read through these > > instructions before executing any of them): > > > > (0) to shut down OpenOffice, enter 'ctl + alt + delete' keys at once, > > choose 'task manage'; find OpenOffice; right-click; choose 'end task'; > > you can close 'task manager' if you want. > > > > (I don't know if Dick Groskamp has a better way?) > > > > then: > > > > (1) type 'cmd' (no quotes) > > (2) click 'run as an administrator' > > (3) write or copy the command Dick Groskamp gave you, making sure to > > enter your actual username. > > (4) then restart OpenOffice. > > > > report back with questions, results, etc. > > > > Felmon > > > > > > > > On Sat, Dec 9, 2023 at 10:23 AM Dick Groskamp > wrote: > > > > > >> Try to renew your userprofile. > > >> Close OpenOffice and the Quickstarter (if enabled) > > >> > > >> Go to C:\Users\[your username]\AppData\Roaming\OpenOffice\4 > > >> There is a folder called user. Rename that folder to something else, > for > > >> instance "user_old" > > >> > > >> Go back and restart OpenOffice. It will make a new folder user. > > >> This method often solves strange problems :-) > > >> > > >> On 2023/12/09 15:04:14 Rod Christ wrote: > > >>> I recently upgraded to a new Lenovo laptop with Windows 11. I also > > downloaded OpenOffice ver. 4.1.14. It has never been stable. When I > > >> finish > > a document (mostly easy spreadsheets0 I cannot reopen the document. > > The > > program goes back and must restore and reload ALL prior documents > > >> before I > > can access any of the docs. That was a pain in the neck, but things > > >>> worked. > > Today, it required "defragging" all prior documents again, but > stalled > > >> and > > locked up totally. It has not started a recovery on ANY of the docs > > and > > locked up entirely. The things I had done previously were expendable > > >> so I > > decided to uninstall and reinstall. That does not work. The > > >> "rebuilding" > > panel is not responding to closing with an X, - or resize. Likewise, > > >> the > > larger window does not respond. All I can do is go back and work on > > >> other > > pages, mail, facebook, etc. I thought closing all open windows and > > restarting would help but that did not work either. What can I do to > > >> get > > past this logjam?Thanks, Rod Christ 563/258-1849 email is > > cozum...@gmail.com > > >>> > > >> > > >> - > > >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > > >> For additional commands, e-mail: users-h...@openoffice.apache.org > > >> > > >> > > > > > > > -- > > Davis > > > > Verbum sat sapienti. > > > > - > > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > > For additional commands, e-mail: users-h...@openoffice.apache.org >
Re: Fußnotennummerierung per Dokument
Lieber Konrad, funktioniert leider nicht. Wenn man die Fußnoten ans Seitenende setzt, geht das, also eine durchgehende Nummerierung für das ganze Dokument (statt einem Neuanfang pro Seite oder pro Kapitel). Sobald man aber im Menü die Fußnoten ans Ende des Dokuments setzt, beginnt die Nummerierung bei jedem Kapitel neu. Vielleicht muss ich von vornherein mit "Endnoten" statt mit Fußnoten arbeiten. Ich schau mal, ob das vielleicht eine Lösung ist. Ein weiteres Problem, das ich schon mal hatte, aber jetzt nach dem Wechsel von Dokumentenende zu Seitenende und wieder zurück wieder verschwunden ist: die Fußnoten gingen nach unten über die Seite hinaus! Also der Seitenrand wurde nicht respektiert. Ich melde mich wieder, wenn es mit den Endnoten bessere Ergebnisse gibt. Habe mit OpenOffice einige Bücher formatiert, im Prinzip geht wirklich alles super! Ebenfalls einen schönen Sonntag wünsche ich dir von Tunis aus. Best Dave On Sat, 9 Dec 2023 at 19:40, Dave wrote: > Liebe Unterstützer, > > bin selbst eigentlich fit in OpenOffice, stolpere aber doch über die > Fußnotennummerierung. Sie beginnt bei jedem Kapitel neu. Unter "Tools -> > Footnotes/Endnotes" gibt es das Dropdown-Menü "Counting per page" bzw. > "Counting per document". Wenn ich letzteres anklicke und das Menü schließe > und wieder öffne steht dann doch "Counting per page". > > Kann mir jemand helfen? Wäre echt dankbar! > > Schöne Grüße aus Tunis > Dave >
Re: Beschädigte Datei entfernen.
Am Samstag, dem 09.12.2023 um 22:42 +0100 schrieb Lucifer Diabolo: > Könnte ein Problem des BS sein. > Welches? -- MfG Sebastian Leimkühler - To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-de-h...@openoffice.apache.org
Re: Zellenverschiebung, Referenzelle kommt nicht nach
Hallo, kann es sein, dass der Bezug auf die Referenzzelle ein oder zwei Dollarzeichen $ enthält - also z.B. $B$2 ? Das würde bewirken, dass dieser Bezug sich nicht ändert. Siehe auch hier: https://help.libreoffice.org/6.1/de/text/scalc/guide/relativ_absolut_ref.html?DbPAR=CALC#bm_id3156423 Mit freundlichen Grüßen Alois Klotz primav...@t-online.de schrieb am 08.12.2023 um 19:01: Hallo, ich benötige Hilfe, wenn ich in Open Office Calc eine Zelle verschiebe evtl. durch neue Zeile darüber, dann geht eine Referenzelle, die auf diese Quell Zelle referiert nicht mit, d.h. ich muss mit Hand nachjustierten, das konterkariert den ganzen Sinn und Zweck eine Tabellen Kalkulation wie kann ich das bitte korrigieren oder richtig einstellen beste Grüsse, Hermann
Re: OpenOffice locked up
Dear Rod Christ, I don't have Windows 11, but here is "How To Know Which Process Is Using a File in Windows 11?" It uses Resource Manager natively, or something which you can download called 'Handle'. With either one, you can kill the processes you want to kill. https://www.partitionwizard.com/partitionmagic/know-which-process-is-using-file-win-11.html Linda On Sat, Dec 9, 2023 at 8:58 PM fjd wrote: > On Sat, 9 Dec 2023, Rod Christ wrote: > > > You do not understand. The program is LOCKED on my screen. I cannot use > any > > of its features, I cannot close or open any windows within the program. I > > cannot shut it down, I cannot delete it. It is a s useless as tits on an > > alligator. UNDERSTAND?? > > I believe you didn't understand the instructions. > > Go to the Start Menu in Windows - tell us if you don't know what this > is. And note it's part of Windows, not of OpenOffice. > > Note there's probably a simpler way to do the following but I'm not > mainly a Windows user and this should work (first read through these > instructions before executing any of them): > > (0) to shut down OpenOffice, enter 'ctl + alt + delete' keys at once, > choose 'task manage'; find OpenOffice; right-click; choose 'end task'; > you can close 'task manager' if you want. > > (I don't know if Dick Groskamp has a better way?) > > then: > > (1) type 'cmd' (no quotes) > (2) click 'run as an administrator' > (3) write or copy the command Dick Groskamp gave you, making sure to > enter your actual username. > (4) then restart OpenOffice. > > report back with questions, results, etc. > > Felmon > > > > > On Sat, Dec 9, 2023 at 10:23 AM Dick Groskamp wrote: > > > >> Try to renew your userprofile. > >> Close OpenOffice and the Quickstarter (if enabled) > >> > >> Go to C:\Users\[your username]\AppData\Roaming\OpenOffice\4 > >> There is a folder called user. Rename that folder to something else, for > >> instance "user_old" > >> > >> Go back and restart OpenOffice. It will make a new folder user. > >> This method often solves strange problems :-) > >> > >> On 2023/12/09 15:04:14 Rod Christ wrote: > >>> I recently upgraded to a new Lenovo laptop with Windows 11. I also > downloaded OpenOffice ver. 4.1.14. It has never been stable. When I > >> finish > a document (mostly easy spreadsheets0 I cannot reopen the document. > The > program goes back and must restore and reload ALL prior documents > >> before I > can access any of the docs. That was a pain in the neck, but things > >>> worked. > Today, it required "defragging" all prior documents again, but stalled > >> and > locked up totally. It has not started a recovery on ANY of the docs > and > locked up entirely. The things I had done previously were expendable > >> so I > decided to uninstall and reinstall. That does not work. The > >> "rebuilding" > panel is not responding to closing with an X, - or resize. Likewise, > >> the > larger window does not respond. All I can do is go back and work on > >> other > pages, mail, facebook, etc. I thought closing all open windows and > restarting would help but that did not work either. What can I do to > >> get > past this logjam?Thanks, Rod Christ 563/258-1849 email is > cozum...@gmail.com > >>> > >> > >> - > >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > >> For additional commands, e-mail: users-h...@openoffice.apache.org > >> > >> > > > > -- > Davis > > Verbum sat sapienti. > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org