[libreoffice-users] Re: Numbering formulas in Writer
Here are the AutoText dialog panel you should see in your local, these for en-US with 4.4.3.2 release. http://nabble.documentfoundation.org/file/n4147974/Edit_AutoText_dialog.png http://nabble.documentfoundation.org/file/n4147974/Edit_AutoText_dialog_FormulaNumbering.png -- View this message in context: http://nabble.documentfoundation.org/Calc-Cutting-and-Pasting-Ranges-tp4147923p4147974.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Cutting and Pasting Ranges
Am 05.05.2015 um 12:48 schrieb James E Lang: I had a troubling experience that I want to share. Cut Paste from a range of cells on one sheet (e.g. Sheet4.A1:AL418) to a location on another sheet (e.g. Sheet2.XA1) leaves formulas that reference a range of cells (e.g. Sheet4.P$3:P$1230) that is partially but not entirely within the Cut range as they were with no warning. This action left me scratching my head for a while. The examples are from real life. The desirable action would be to issue a warning but I doubt that would be practical. In this case there were something in the vicinity of 16000 formulas that failed to get converted. Thank goodness for the ability to undo multiple steps. [Tutorial] Absolute, relative and mixed references https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=2443 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Numbering formulas in Writer
Many places I am told that inserting formula numbering is quite simple. Write fn in a new line and press the F3 key. In my copy of LibreOffice 4.4.2.2 (Windows) I am not able to do this. Instead I get a message that LibreOffice did not find autotext for the short cut fn or something like that. (It works in my copy of OpenOffice 3.2). I think it has to do with some settings somewhere but am not able to find out where. Some suggestions? Kolbjoern -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Numbering formulas in Writer
@Kolbjørn, A default user profile has a correctly defined AutoText entry for Formula Numbering assigned the FN shortcut. Suggest you clear your per-user profile and have another go. https://wiki.documentfoundation.org/User_Profile You could also verify the shortcut is assigned in a Writer module session from the Edit - AutoText menu dialog, or use its shortcut Ctrl+F3 to launch. Expand the Standard section, and locate the Formula Numbering entry. It can be edited from the E=mc^2 default--as well as adjusting the numbering format. Stuart -- View this message in context: http://nabble.documentfoundation.org/Calc-Cutting-and-Pasting-Ranges-tp4147923p4147950.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Download Problem
Am 05.05.2015 um 00:04 schrieb Don Kessler: Tried a couple times to download and update to V 4.3.7_x86.msi and keep getting error: The signature of this program is corrupt or invalid Any remedy? Don Download from https://www.libreoffice.org/download/libreoffice-fresh/ and nowhere else. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to get rid of This document is in read only mode bar
Am 03.05.2015 um 08:41 schrieb Keith Bates: The version of LO that ships with Ubuntu 15.04 is 4.4.2. Since upgrading Ubuntu the other day I have noticed that forms- which are meant to open in read-only mode- now come with a big yellow bar which says This document is in read only mode with a big button to press to enter Edit mode. Is there a way to get rid of this thing permanently? Thanks The following is a dirty hack to hide this nasty subwindow (and possibly others). Store it somewhere in My Macros. Open a form in editable mode. menu:ToolsCustomizeEvents, Save in: the respective document Bind the macro to event View created. Save, close, reload the form document. Sub hidePanelWindows(e) Dim CompWin, acRole, cHeight, wins, i, w, ac wait(1000) CompWin = e.Source.CurrentController.Frame.ComponentWindow acRole = com.sun.star.accessibility.AccessibleRole.PANEL cHeight = com.sun.star.awt.PosSize.HEIGHT wins() = CompWin.getWindows() for i = 1 to uBound(wins()) w = wins(i) ac = w.AccessibleContext if ac.AccessibleRole = acRole then w.setPosSize(0,0,0,0,cHeight) endif next End Sub The macro hides all subwindows of certain type. Let me know if the macro hides any wanted items which may happen. Hope this helps, Andreas -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc: Cutting and Pasting Ranges
Thank you Andreas. Basically I was inadvertently attempting to do something I ought not to do. I was cutting and pasting from a range of cells (Sheet4.A1:AM418) to a different sheet. Some of those cells contained references to a PARTIALLY embedded range of cells (Sheet4.P$3:P$1230). After the cut and paste operation, the data from 416 of the 1228 referenced cells in the embedded range has been relocated while the data in the other 812 referenced cells remain where they were. LO Cannot be expected to read my mind WRT my intent in my internally inconsistent operation. My only issue was that I was not alerted that I was making this error. When I saw that I was getting wrong results I undid the cut and paste. When I finally spotted what I'd done wrong I was able to revise the formulas by simply deleting rows 419 through 1230 before performing the cut and paste once again. In this instance that was the correct action to take. I'm so happy that I spotted the incorrect values in calculated cells right away but it could have been disastrous. Upon detection of this inconsistency I would have expected LO to have displayed a notification dialog with one option being to cancel the operation. As I indicated, I made a major boo-boo. I doubt many others have done the same but I hope my experience helps somebody else, -- Jim -Original Message- From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Tue, 05 May 2015 9:55 Subject: [libreoffice-users] Re: Calc: Cutting and Pasting Ranges Am 05.05.2015 um 12:48 schrieb James E Lang: I had a troubling experience that I want to share. Cut Paste from a range of cells on one sheet (e.g. Sheet4.A1:AL418) to a location on another sheet (e.g. Sheet2.XA1) leaves formulas that reference a range of cells (e.g. Sheet4.P$3:P$1230) that is partially but not entirely within the Cut range as they were with no warning. This action left me scratching my head for a while. The examples are from real life. The desirable action would be to issue a warning but I doubt that would be practical. In this case there were something in the vicinity of 16000 formulas that failed to get converted. Thank goodness for the ability to undo multiple steps. [Tutorial] Absolute, relative and mixed references https://forum.openoffice.org/en/forum/viewtopic.php?f=75t=2443 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Numbering formulas in Writer
Den 05.05.2015 18:48, V Stuart Foote skreiv: @Kolbjørn, A default user profile has a correctly defined AutoText entry for Formula Numbering assigned the FN shortcut. Suggest you clear your per-user profile and have another go. https://wiki.documentfoundation.org/User_Profile Thank you for answering. I uninstalled LibreOffice a couple of days ago and renamed my user profile before reinstalling LibreOffice. And yes, I remembered to delete the quickstarter too. (I prefer to rename instead of adding a new profile). You could also verify the shortcut is assigned in a Writer module session from the Edit - AutoText menu dialog, or use its shortcut Ctrl+F3 to launch. Expand the Standard section, and locate the Formula Numbering entry. It can be edited from the E=mc^2 default--as well as adjusting the numbering format. Stuart Well, the only available file here is My autotext. Perhaps I have misunderstood something? If I click on the button Autotext I can select Import …. But what to import and from where? As I am a bit curious I tried this function on 3 different computers, same result: No autotext found for the shortcut fn. LibreOffice 4.4.2.2 / Windows 7. LibreOffice 4.1.3 / Windows 8.1 (laptop). LibreOffice 4.3.4.1 / Windows 8.1 Kolbjoern -- View this message in context: http://nabble.documentfoundation.org/Calc-Cutting-and-Pasting-Ranges-tp4147923p4147950.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Numbering formulas in Writer
Den 05.05.2015 20:11, Andrew Pitonyak skreiv: I always did this using a numerical sequence field; the same field type used for numbering tables. Yes, I use this method, but would like to activate the method mentioned in my mail. Kolbjoern On May 5, 2015 12:08 PM, =?ISO-8859-1?Q?Kolbj=F8rn_Stuest=F8l?= kolbjo...@stuestoel.no wrote: Many places I am told that inserting formula numbering is quite simple. Write fn in a new line and press the F3 key. In my copy of LibreOffice 4.4.2.2 (Windows) I am not able to do this. Instead I get a message that LibreOffice did not find autotext for the short cut fn or something like that. (It works in my copy of OpenOffice 3.2). I think it has to do with some settings somewhere but am not able to find out where. Some suggestions? Kolbjoern -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Numbering formulas in Writer
I always did this using a numerical sequence field; the same field type used for numbering tables. On May 5, 2015 12:08 PM, =?ISO-8859-1?Q?Kolbj=F8rn_Stuest=F8l?= kolbjo...@stuestoel.no wrote: Many places I am told that inserting formula numbering is quite simple. Write fn in a new line and press the F3 key. In my copy of LibreOffice 4.4.2.2 (Windows) I am not able to do this. Instead I get a message that LibreOffice did not find autotext for the short cut fn or something like that. (It works in my copy of OpenOffice 3.2). I think it has to do with some settings somewhere but am not able to find out where. Some suggestions? Kolbjoern -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Fwd: HIGHLIGHTING IN WRITER
Sorry -- of course I'm actually using 4.4.2.2 -- Forwarded message -- From: roballjr robal...@gmail.com Date: Tue, May 5, 2015 at 5:18 PM Subject: HIGHLIGHTING IN WRITER To: users@global.libreoffice.org I'm using 4.4.22. The highlighting function is almost totally unreliable. Whether I use the F8 key or just try to use the mouse button, it takes two or three passes to get highlighting of more than several letters to hold long enough to cut or copy. This is a real pain if you write longer documents on which you to do a lot of editing. Am I the only one having this problem? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] HIGHLIGHTING IN WRITER
I'm using 4.4.22. The highlighting function is almost totally unreliable. Whether I use the F8 key or just try to use the mouse button, it takes two or three passes to get highlighting of more than several letters to hold long enough to cut or copy. This is a real pain if you write longer documents on which you to do a lot of editing. Am I the only one having this problem? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] HIGHLIGHTING IN WRITER
roballjr wrote: I'm using 4.4.22. The highlighting function is almost totally unreliable. Whether I use the F8 key or just try to use the mouse button, it takes two or three passes to get highlighting of more than several letters to hold long enough to cut or copy. This is a real pain if you write longer documents on which you to do a lot of editing. Am I the only one having this problem? No problem here, with LibreOffice 4.4.2.2 on Windows Vista. Whenever I've had problems like that, it's usually been one of: - If using a laptop, my wrist brushing against the touchpad (acting as a click, so clearing the selection; some of them are very sensitive) - Something leaning on the keyboard or mouse - Faulty keyboard or mouse - Faulty or poor quality USB hub between PC and keyboard or mouse If it's the touchpad causing the problem, the tap to click feature can sometimes be disabled. In Windows, look for a touchpad icon next to the clock, or the Mouse settings in Windows' Control Panel. Exact details vary depending on the device, so it's difficult to be more specific than that. If nothing is anywhere near the keyboard or mouse at the time, there could be a hardware fault generating spurious clicks / key presses. If the keyboard or mouse is connected via a hub, unplug the hub and connect the keyboard and mouse directly into USB sockets on the PC / laptop; if that works, you need a new/better hub (or just don't use it, if you don't need to). Otherwise, disconnect your current keyboard and mouse (not so easy if it's a laptop though!) and connect replacements to see if that helps. The replacements don't have to be brand new just to check if that's the problem, as long as they're known to work properly. You may be able to borrow from another PC, or someone else if you don't have any spare. Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc: Cutting and Pasting Ranges
I had a troubling experience that I want to share. Cut Paste from a range of cells on one sheet (e.g. Sheet4.A1:AL418) to a location on another sheet (e.g. Sheet2.XA1) leaves formulas that reference a range of cells (e.g. Sheet4.P$3:P$1230) that is partially but not entirely within the Cut range as they were with no warning. This action left me scratching my head for a while. The examples are from real life. The desirable action would be to issue a warning but I doubt that would be practical. In this case there were something in the vicinity of 16000 formulas that failed to get converted. Thank goodness for the ability to undo multiple steps. -- Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
