Re: [libreoffice-users] paragraph style
Hi, I meet this behavior from time to time. To fix the ill-behaved paragraph, I do this: 1. Ctrl+M to clean the possible manual formatting 2. Set Body Text style 3. Set the wanted style again. To-date, this has always worked here. YMMV. Best, -- Jean-Francois Nifenecker, Bordeaux Le 27/03/2024 à 03:29, Thomas Blasejewicz a écrit : On 2024/03/06 19:23, Thomas Blasejewicz wrote: Good evening I am working on a book and applied * chapter styles * heading styles and a few not so important other styles. Question: The chapter style specifies a certain font and font size, plus italic. For each chapter the little dialog box in the left upper corner shows the style name, font name and font size I specified. However I noticed, that for some chapters even though style name etc. is as I specified, the actually used font and font size are different. Trying Ctrl+M and then applying my style does NOT help. Why is it, that a certain style produces two different appearances? What can I do to get the same style for all chapters. That will be required later when I set up an table of contents. Using: Libreoffice 7.4.2.3, Windows 10, the text is in English, but includes a few Chinese characters Yes, I did ask this before Everything (almost) went fine for a while, now the problem reappeared. Among all the chapter headings just ONE refuses to use the specified font etc. Reapplying the style does not help. Deleting either the heading alone or some text around it does not help either. When I tried to edit = delete the style, I got the error message that doing so will delete ONE OF THE USED styles, which then will affect all other places where that style is used. -> Well, I know only the heading style and naturally the page style. If there is something else somewhere, how do I find out what that is - and how do I correct it? Thank you -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Wizard vs Custom spreadsheet
Hello Andrei, I would go the conditional formatting (CF) path: 1. you prepare two styles, one for each situation. The "Wizard" style is set as protected, the "Custom" is not. 2. you create a CF and associate the target cell to each possible value to a given style above. Then you protect the sheet. According to the source value, the target cell is protected or not. HTH, -- Jean-Francois Nifenecker, Bordeaux Le 01/03/2024 à 12:10, Radocea Andrei a écrit : Dear all, I have the following problem to solve: In a spreadsheet in one cell, the calculation table version is requested: "Wizard" or "Custom". - If the version is "Wizard", then in another cell, the target cell, a preset value is displayed, without the possibility of modification.- If the version is "Custom", then a value desired by the user can be entered from the keyboard in the target cell. Seemingly simple, but maybe not. Can I get some advice? Thank you Andrei -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Question on getting a list of all the macro commands
Hello Mike, Le 29/11/2020 à 18:33, Michael D. Setzer II a écrit : Does a file with them exist in full or part. nope. Well, not that I know of. The LibO API (application programming interface) is a quite complex beast. Was recently looking thru menus and found something interesting that I had not noticed before. Data / Calculate / Formula to Value I did a test, and it did what I wanted, so recorded the macro. The LibreOffice macro recorder is a *very* limited tool, which has nothing to see with some other Office suite recorder. The LibO recorder just records your actions in the GUI (keyboard and mouse actions) and translates them using a special object, the Dispatcher. The resulting code has very little to see with actual macro code you might write to accomplish the very same actions in "purer" Basic. This doesn't mean the recorder is useless. I use it everytime I need a quickly automated process. But don't rely on it to manage (not so) complex processes. If you want to delve in Basic macro coding, as an English-speaking user you should read Andrew Pitonyak's books. Check Andrew's website here: https://www.pitonyak.org/oo.php. His macro document is a collection of predefined macros, while his book is more elaborated. Both are highly recommended reads! For a quick start, you might also find the 9 reference sheets available from the LibO extension pages handy: https://extensions.libreoffice.org/?Tags%5B%5D=173 HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Icons in message box
Le 17/12/2018 à 21:09, Luuk a écrit : I do see the question mark. So do I. If I change the MB_ICONQUESTION constant for the MB_ICONSTOP, I see the Stop icon as well. Official (TDF) LibreOffice 5.4.6.2 under Linux Lint 18.x Cinnamon. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Auto-closing user dialogue (macro, Basic)
Hi Johnny, Le 09/12/2018 à 19:02, Johnny Rosenberg a écrit : Hi! For some reason I can't figure this out… I have made a simple dialogue with two buttons and a numeric field. Those buttons triggers two different subroutines that does two different things and then closes the entire dialogue. I want the dialogue to close automatically after ten seconds if neither of the buttons have been pushed. The remaining time is to be displayed in the numeric field mentioned above. However, I couldn't find a way to trig a function ”when nothing else happens”. Here's what I want to do: Dialogue opens. User does nothing, so a subroutine is called checking the remaining time and displays it in the numeric field. User still doesn't do anything and the above repeats until remaining time is zero, then the dialogue is closed. Any suggestions? Not sure if that can be of help. Have a look at that page: https://documentation.libreoffice.org/en/english-documentation/macro/ get the Dialogs RefCard (https://documentation.libreoffice.org/assets/Uploads/Documentation/en/MACROS/RefCards/LibOBasic-6-Dialogs-Flat-A4-EN-v103.pdf). The Non-Modal dialog part might give you some ideas. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] corrupt letter on display
Hi James, Le 22/11/2018 à 05:17, James a écrit : Repost with better title. :-) I use lubuntu-18.10. Sometimes, a letter gets corrupted but I only see it in libreoffice. This example the 'p' displays as a ',': http://lockie.ca/lubuntu_/libreoffice.jpg I've also seen it when '2' displays garbled. Any ideas about how to track down what software has the problem? It seems you're using the Lubuntu (ie, Ubuntu) LibreOffice version, which is different from the "official" TDF LibreOffice one. At times, the packaged versions within Linux distributions may introduce unwanted effects that the official version doesn't suffer of. I'd first encourage you to download and install the said official version and test with it. If you get the same problems, come back and report here. Dowload link: https://www.libreoffice.org/download/download/ How-to install: https://wiki.documentfoundation.org/Documentation/Install/Linux (look at the Debian / Ubuntu / Mint section) Best regards, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] vertical placement of charts while saving to pdf is wrong
Hi Fred, Le 21/10/2018 à 19:56, Frédéric a écrit : My graphs move vertically when I save my sheets to pdf. I spent hours searching why but cannot find any clue. All properties look fine (FrameRect, OriginalSize, BoundRect, VisibleArea, Position, Size). I do not know where to search. No help on internet either. Am I the only one? I tried to make an simple example but cannot reproduce exactly what I have on my big file. One think I noticed is the following, when I click on the chart, I can see the 8 blue handles and also the coutour of the chart as dashed line and the dashed contour is not superimposed with the blue handles but shifted by a few lines up (see attached image). Normally they match. (no attachments on that list) I have the impression that the charts are shifted when I duplicate a worksheet... Are the charts anchored to page or to cell? I'd suggest always anchoring them to cell. Do you save as PDF using the UI or through a macro? Given your first paragraph, I'd suppose you're using a macro, aren't you? If so, how do you process the export? Cheers, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Personas
Dave, Le 27/09/2018 à 20:25, DaveB a écrit : Sadly, it did not work. My results are in-line with your previous message. I have had situations where it didn't work at once but did finally. The symptom is, indeed, that the Expert settings are not saved. Here's my current setting: libreoffice_4_light_ambience/header.png;libreoffice_4_light_ambience/header.png;#00;#F5F5F5 (guess which Firefox theme I have chosen ;) [...] I changed the directory and file name to exactly match yours. My path = /home/dave/.config/libreoffice/4/user/gallery/Persona/MyPersona/MyHeader.png /!\ this should read: /home/dave/.config/libreoffice/4/user/gallery/personas/MyPersona/MyHeader.png -> "personas" with a lower case initial and with a final S my bad /o\ Should work on your side now. Sorry for the misleading. Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Personas
Hi Dave, Le 27/09/2018 à 16:38, DaveB a écrit : Hi Folks, Firefox Personas (renamed Themes) no longer work in LO and there is a proposal [1] to deprecate or replace them. However, I have 2 in my LO profile on Windows, which I would like to have them in LO on a new Linux install. I have copied the images into the equivalent Linux directory and edited the advanced configuration file, but I cannot get LO under Linux to show either of the personas. Obviously there is something else it is necessary to configure. Any thoughts or pointers would be welcome. I'm using personas under Linux without problem (LibO 5.4.6.2). Here's how I do that. FWIW I don't temper with the configuration file, just using the advanced configuration options. 1. The personas are stored as subdirs within the user's profile, Gallery/Persona directory. Say I add a "MyPersona" subdir there. In this subdir, I add the persona graphic file (for instance, a .png). Say its name is MyHeader.png. 2. In LibO, Tools > Options, LibreOffice, Advanced, Open expert configuration. 3. I enter "persona" (without quotes) in the search bar. LibO finds the org.openoffice.Office.Common > Misc branch, with two keys: Persona and PersonaSettings 4. Set Persona to "own" (without quotes) 5. Set PersonaSettings to follow the sequence mask: ;;; Where : the path to your header file within the personas profile subdir. Using the example above would give MyPersona/MyHeader.png : same as for header file name. You may repeat using the header file name. : RGB in hex with a "#" prefix. For a black front color, it gives: #00 This color is used for menu character painting. : same as for front color. AFAIK, unused. 6. Wrap up The whole string in this example would give: MyPersona/MyHeader.png;MyPersona/MyHeader.png;#00;#F5F5F5 Once validated, the new theme is propagated to new documents (the current file environment is not changed yet). To get to these grips, I read a blog article that I'm totally unable to find right now. Too bad I couldn't cite the author. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] side by side tables
Hello Gary, an alternative to Brian's suggestion: nesting tables! Say you want three side-by-side tables: -- Insert a 3 column/1 row table. -- In each cell of this table, insert a new table, fit as you need. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Issues with macro recorder??
Hello Michael, Le 04/09/2018 à 14:08, Michael D. Setzer II a écrit : Second issue was it deleted two different columns. When recording clicked on the column with mouse, and deleted each column. Record didn't record anything of clicking on the columns, but just the delete command. Added a goto cell and got that to work as well. the recorder has no prior knowledge about the active cell. You have to set it before any other action. -> When I use the recorder to act upon cells/columns/rows, I usually start with Ctrl+Home to set things clearly, then I move the active cell to the wanted place (for quick moves you may try using the cell name field). HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] How to access ConvertToURL from automation?
Hello, Le 10/09/2018 à 17:39, dCipher a écrit : Hi I use VFP to automate tasks using LibreOffice. The documentation lists a Basic function ConvertToURL() but I do not know how to access this function via automation. Can anyone tell me how this is done? Currently I just created a VFP function to do the task but I would like to know if it is possible to access the OpenOffice version. What is VFP? Best regards, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Basic pseudo object code no reachable when defined into a basic library...
Hello Patrick, (response in English that transcripts my private email in French) Le 20/07/2018 à 17:37, Patrick Gelin a écrit : Note : The Erase function call look's to run perfectly ... Why don't you use the usual Set MyObject = Nothing This is just a question. I'm not sure about the actual difference between both approaches. So I need to add a specific modul in pseudo object library with factories ... Don't you think that having an object factory in each class module would be easier to maintain? Or is this impractical? Best regards, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Basic pseudo object code no reachable when defined into a basic library...
Hi Patrick, typo spotted in the Initialize sub : Private Sub Class_Initialize() _valute = 1 End Sub instead of Private Sub Class_Initialize() _value = 1 End Sub Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Insert current date
Hi Philip, Le 21/05/2018 à 13:10, Philip Jackson a écrit : Note: the macro recorder is not available until you've activated the corresponding option in Tools > Options > LibreOffice > Options, Enable macro recording. This will be (in some versions ?) Tools > Options > LibreOffice > Advanced, Enable macro recording. Ahem. Yes, I stand corrected /o\ Anyway, Robert's solution is much faster! Best regards, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Insert current date
Hello Robert, Le 21/05/2018 à 14:50, Robert Großkopf a écrit : there is no macro needed. Open a Writer-document Go to Tools > Customize > Keyboard Type in "Functions": 'Date' Now look for a free Shortcut-Key, for example Ctrl+7. Click "Modify" on the right. Click "Save". Now you could insert the current date with Ctrl+7. OMG! How did I overlook that? Many thanks Robert! All the best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Insert current date
Hello Peggy, Le 21/05/2018 à 10:37, Peggy a écrit : Years ago in Word Perfect there was a feature that allowed me to use a shortcut key (even picking from a menu would be good) that inserted today's date. Does Libre Writer have this feature? I've never written a macro and the couple of instructions I've seen look complicated. If there is no feature for this, would their be a way to write a macro for the tecnically challenged? While in Calc there's no need for a macro (the Ctrl + ; (semicolon) shortcut will do ;) such is not the case in Writer, yet. So, yes, you need to create a macro then connect a keyboard shortcut to it. The process is quite simple if you use the macro recorder. Here's how (longer to write than to execute) : 1. Creating the macro using the macro recorder Note: the macro recorder is not available until you've activated the corresponding option in Tools > Options > LibreOffice > Options, Enable macro recording. a. Open an empty Writer document b. Goto Tools > Macro > Record macro (a macro recorder toolbar is displayed: you'll press the "Stop recording" button when you're done) c. Hit Ctrl+F2 to call the Insert Fields dialog, d. in the Document thumbnail select: Type = Date Select = Date Format = select the wanted format e. Clic Insert, then Close f. Clic the "Stop recording" button g. A dialog opens that allows you to save the macro code. Enter a name for your macro in Macro Name Save macro in : select MyMacros > Standard > Module1 Click Save (a sample of the macro code is given below) 2. Connecting the macro execution with a keyboard shortcut a. Tools > Customize, Keyboard thumbnail Shortcut Keys = choose an appropriate shortcut (Ctrl + ; might do...) Category = LibreOffice Macros -> MyMacros -> Standard -> Module1 Function = select the macro created at step 1 above b. Check the "Writer" radio button (the shortcut will be available in Writer only), then Modify which makes the shortcut appear in the Keys panel. c. Validate OK From now on, pressing Ctrl + ; in Writer inserts the current date. 8< --- sub InsertCurrentDate dim document as object dim dispatcher as object rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") dim args1(5) as new com.sun.star.beans.PropertyValue args1(0).Name = "Type" args1(0).Value = 0 args1(1).Name = "SubType" args1(1).Value = 1 args1(2).Name = "Name" args1(2).Value = "" args1(3).Name = "Content" args1(3).Value = "0" args1(4).Name = "Format" args1(4).Value = 10036 ' args1(5).Name = "Separator" args1(5).Value = " " dispatcher.executeDispatch(document, ".uno:InsertField", "", 0, args1()) end sub >8 HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: How do I use a singleton in LibO basic?
Le 28/02/2018 à 18:03, ptoye a écrit : Thank you so much for this. I had no idea that you had first to get a context - I hadn't found this in the documentation (but will now have another look). It's working fine now. I found this completely by chance when looking into this macro expander thingy. Then when you asked about a singleton I remembered I had met one once :) From the other side of the pond, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How do I use a singleton in LibO basic?
Hi Peter, an example using the macro expander which is a singleton as well, defined as : "/singletons/com.sun.star.util.theMacroExpander" 8< --- Dim oContext as Object 'context object Dim oMacroExpand as Object 'macro expander Dim Result As String oContext = getProcessServiceManager().DefaultContext oMacroExpand = oContext.getValueByName("/singletons/com.sun.star.util.theMacroExpander") Result = oMacroExpand.ExpandMacros("$UNO_USER_PACKAGES_CACHE") --- >8 the above example is working here in this context. HTH, -- Jean-Francois Nifenecker, Bordeaux - Mail original - De: "ptoye" <l...@ptoye.com> À: users@global.libreoffice.org Envoyé: Mercredi 28 Février 2018 12:51:50 Objet: [libreoffice-users] How do I use a singleton in LibO basic? I want to use one of the API singletons (com.sun.star.util.thePathSettings since you ask) but I can find nothing in the documentation telling me how to create the (only) instance so I can get some of the properties. As I understand singletons, they have a hidden constructor, and some form of creator method which ensures that only one instance exists. But the documentation for the singleton does not have any such method. I've tried various syntactic forms to create one, none of which has worked. Can some kind soul please put me out of my misery? I know that I can use PathSettings, but this is deprecated, and I prefer to be up-to-date. I'm using LibO 5.4.5.1 if that helps. - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://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? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] writer vs calc behaviour in LO 6.0.1.1
Hi, Le 24/02/2018 à 20:03, Dave Stevens a écrit : I'm using the version in the subject line on Linux Mint. In calc if I insert the date using the insert menu and the date option I get a cell with today's date, formatted comprehensibly. If I do the same thing in Writer I can't, the option isn't there. I must (as far as I know) choose field then date. That gives me text that looks like "Date (fixed)" which is not what I want. I can do a print preview and see that it will render as one might wish but that's not what I want. I really want to be able to simply insert today's date as a character string. I think the behaviour I'm seeing breaks wysiwyg. Can anyone tell me a simple way to insert the data as characters rather than a field? not exactly what you're looking for, but here we go: as the shortcut to get a date in a Calc cell is Ctrl + ; you might duplicate that behaviour in Writer. Here's how: create a new shortcut that does that, too. In Writer: 1. Go to Tools > Customize 2. Select the Keyboard tab 3. Check that Writer is the option selected (top right radiobutton) 4. In the Shortcut keys panel, select the Ctrl + ; shortcut 5. Select : category: Insert function: Date 6. Click Modify The selected shortcut appears in the Keys panel 7. OK From now on, hitting Ctrl + ; in Writer inserts a date field (yes, sorry). Now, if you want to actually insert a string, you'll need a macro : 1. Add the following macro to MyMacros & Dialogs.Standard.Module1 (for instance) 8< Sub InsertTodaysDate() Dim oVCur As Object 'visible cursor Dim oWCur As Object 'writing cursor Dim l_Str As String 'get the date l_Str = CStr(Date) 'get the view cursor oVCur = ThisComponent.CurrentController.ViewCursor 'set a writing cursor at the visible cursor place oWCur = oVCur.Text.CreateTextCursorByRange(oVCur) 'write... oWCur.String = l_Str End Sub 'InsertTodaysDate --- >8 2. Set the shortcut (as shown above) to the said macro, with category: select LibreOffice Macros > MyMacros > (your macro library) > (your macro module) function: your macro name Now Ctrl + ; inserts todays date at the cursor position. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Automatically generating and updating many similar documents
Hi Steve! Le 15/02/2018 à 04:40, Steve Edmonds a écrit : Thanks so much for that. This allows me to make abridged (some parts left out) manuals by just picking the sections I want from a complete manual and all numbering and table of contents adjusts correctly. Hmm. Cross references don't necessarily survive. For this need, you should use another trick with sections: hiding sections according to the context (some variable/user field value). One single document with several possible outputs. This is very well described by Bruce Byfield in his book "Designing with LibreOffice" (see "Hiding with sections", p187 sqq) http://designingwithlibreoffice.com/ HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Automatically generating and updating many similar documents
Hello R. Le 04/02/2018 à 11:52, R. Diez a écrit : A friend of mine writes datasheets and user manuals for many similar devices with Microsoft Word 2010. Many sections (legalese, company logo, some device features) are exactly the same across many documents. Maintaining so many copies of the same text is a pain. If you want to fix or enhance something, you have to manually update many copies in many documents. Just to clarify: these are not just short database fields, but complete text sections with subsections, full formatting, etc. This is a quite common need. LibO Writer has a helper for that: linked sections. In LibO Writer a Section is just that: a text portion which can be set differently from the other parts of the text. For instance, using a section allows to have a multi-columns part between full width text parts. Here, we're using the section links possibilities. 1. Create a new document using Writer and put in it each an every recurring piece of text. Format that text exactly as you wish it to appear. 2. Enclose each piece of text within its own section: -- select the text -- menu Insert > Section 3. Give the section a nameful name and that's it (click Insert). You notice that the section is surrounded with pale grey lines. When the cursor is in the section, the status bar shows the section name (on the right). Save the document (probably better have it in some fixed place as it will be used as a reference by the others.) Let's say its name is RefDoc.odt Open a document which must contain some text part as the one stored in RefDoc.odt. Let's call it Target.odt. Open Target.odt 1. Create an empty section here also. Put the cursor in some empty paragraph, the Insert > Section 2. Give the section a nameful name 3. Go to the dialog Link area and check Link. Use the Browse button and select RefDoc.odt created above. 4. In the Section list you see the list of the sections present in RefDoc.odt. Select the wanted section. Click Insert You're done! The new Target.odt section now holds the reference text, including its formatting. Note that the new section in Target.odt may be password protected. This might be of interest when manipulating legal documents for instance. From now on, any change in the source RefDoc.odt sections text will be propagated to the linked section of the target documents. HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] avoiding recalculate on loading of Calc files
Hello, Le 08/02/2018 à 17:41, Luuk a écrit : make sure this is not checked (before saving): Data/Calculate/AutoCalculate When re-opening, there should not be an automatic recalclulation I'd add that this setting is document-based: you may have spreadsheets with automatic calculations set and others without. Best Regards -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Window corruption in macro editor
Peter, Le 07/02/2018 à 12:17, ptoye a écrit : The window in the macro editor keeps being corrupted. Most of the time a portion of the top left-hand corner of the editing window seems to be trying to mirror the text in the rest of the window (if you see what I mean). But sometimes the corruption starts at the top left-hand corner of the object catalog as well as is the screenshot below. It happens very frequently and seems to happen when I either move the mouse into the window or click on something. I can recover by minimising and restoring the window, but as it happens once every few minutes it's a right PITA. Has anyone else here seen anything like this? If it makes any difference, the macro is for a Base file. The OS is Windows 7. Could be some video artefact. Did this happen suddenly? You could uncheck the video acceleration check and see what is gives. I'm using the macro editor heavily under Windows 7 and Debian Linux 8.1 without any problem (using LO 4.3.x, 5.4.x and 6.0.0. No problem so far). BTW, what is the version of LibO? Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macros : For Each Cell in LibreOffice Basic ?
Hi Tom, Le 23/01/2018 à 09:35, stgmdn a écrit : I have to create a macro that read through a defined cell range, and for each cell, will assign it to a variable (to compare it to another cell), then it goes on the next cell. In my researches, I found that we can do this with a For Each Cell in VBA for Excel, but i can't seem to find the code that would do the same thing in LibreOffice Basic. Yes, you're clear :) I can see two ways to achieve your goal : 1. Browsing the cell range 2. Browsing the cell range data 1. Browsing a cell range You have to create an enumerator which will give you the means to browse the range. The enumerator cannot be directly created from the range: you'll need a "range of ranges" (see below) in which you insert the range to browse object. 8< -- Dim MyRanges As Object 'a range of ranges Dim MyEnum As Object 'the enumerator Dim TheCell As Object 'each of the individual cells MyRanges = ThisComponent.createInstance("com.sun.star.sheet.SheetCellRanges") MyRanges.insertByName("some arbitrary name", MyRangeToBrowse) MyEnum = MyRanges.Cells.CreateEnumeration Do While MyEnum.hasMoreElements TheCell = MyEnum.NextElement 'do smthg with the cell object Loop -- >8 Note that empty cells in the range will NOT be made avalaible (they are skipped by the enumerator). 2. Browsing cell range data Once you've got the range to browse object, just refer to its .DataArray property and play with it. You'll have to use an external array as a buffer. 8< -- Dim MyArray As Variant 'buffer array MyArray = MyRangeToBrowse.DataArray 'MyArray is set according to the range dimensions 'do smthg with the array items 'and finish with: MyRangeToBrowse.DataArray = MyArray -- >8 Note that the .DataArray property (thus MyArray as well) is a nested array : items are referred to as MyArray(i)(j), NOT as MyArray(i, j) HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Macros : ByVal doesn't work with parameters in a class object modul ...
Hi Patrick, Le 06/01/2018 à 10:58, Patrick Gelin a écrit : Below is a complet macro to manage Vectors of variants (With french coments) . I've got a problem with unitary test (Cf. Sub Main) because call to procedure 'v.Ajouter(duolet)' use always passage by reference instead of a passage by value (ByVal) ! For all that, I delicately manage a passage by value in my function... I tested with a call to New operator in order to build specifics instances at each call, like this : duolet = new __TDuolet duolet.key = "MONTAGNE" duolet.Item = 3 v.Ajouter(duolet) And it's fine, the duolet variable is a new one instance. But I don't want the caller do all this stuff. I would like easier way to do ... This v.Ajouter(ByVal duolet) won't do. The ByVal specifier is only present at the declaration level, not the calling one. You could just add a CreateDuolet() function to create the Duolets, like this : Function CreateDuolet(ByRef pKey As String, pItem As Variant) As __TDuolet Dim MyDuolet As __TDuolet MyDuolet.key = pKey MyDuolet.item = pItem CreateDuolet = MyDuolet End Function (note : this function is not a class member) Then, the caller has just to specify: duolet = CreateDuolet("MONTAGNE", 3) v.Ajouter(duolet) or you might also simply call v.Ajouter(CreateDuolet("MONTAGNE", 3)) BTW, I've noticed some glitches elsewhere, eg: in the _Expend() method, you've declared isPresserved as Optional but never test for its presence or not in the method body. This might lead to strange results, don't you think? [BTW, BTW, shouldn't the method be called "_Expand" instead of "_Expend"?] HTH, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Why are the people who answer users' questions are not getting counted?
Le 26/12/2017 à 14:49, Sophie a écrit : Some contributors are really happy with their badges, this is not a TDF work, but it's done by the ASK bot. What Mike is doing is different, he his prominently displaying the names of the contributors and send them (if they want) a sticker to thank them for their contributions. And I've seen many of the contributors happy and proud with their stickers, there is a fair collection of their feedback on the social media. Glad if people are glad! Obviously the YMMV is really variable. But I stand with my own opinion ;-) All the best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Why are the people who answer users' questions are not getting counted?
Hi, Sophie, (better late than never) Le 11/12/2017 à 10:09, Sophie a écrit : @all, so to be positive, what could be and should be the way to count people giving support on all the users' mailing lists in the project? Nabble could give some help and I'll see with Mike if it's possible to integrate it to his badge system. Would there be other ways or other area that seems to be not supported? I'm often wondering what this badge/reward thing is all about. Who cares ? My contribution to mailing lists is not meant for any reward at all. If a user wants to say "thanks", so be it, that's all. Second, I'm more often than once asking myself for help here and there. I'm glad to get answers and to say thanks (even though I happen to forget...), so answering to others is just a return from the help I've got before. Again, this badging thing is beyond me. I see no need for TDF to lose time and energy in this area. YMMV Best, -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Help with VLOOKUP requested
Budge, Le 21/07/2017 à 12:15, Budge a écrit : I have a formula VLOOKUP(E2,Sheet2.A2:B690,2,0) in cell J2 which fills in J2 with the value corresponding to the number in E2 which is looked up from a table in sheet2. My problem is that when I copy this formula down column J the E2 changes to E3 which is correct, but the table defined by Sheet2.A2:B690, which should be fixed, has the addresses changed also. How may I fix the lookup table when I copy the file down a column please? Add "$" symbols where it pertains. In your case, your formula should look like: VLOOKUP(E2,Sheet2.$A$2:$B$690,2,0) Note that, when entering a formula, the F4 key (newer versions of LO) or Shift+F4 combination (older versions) could help. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] [macros] How to create a timer ?
Maurizio, Andrew, thanks for the pointers you posted. This will help me finding out. I guess the "simplest" way would be to call a Python script from Basic. Thanks again to both of you. You've put me on the way. Greetings from the other side of the pond, -- Jean-Francois Nifenecker, Bordeaux -- 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] [macros] How to create a timer ?
All, I'm looking for a way to create a timer in LibO Basic as a reminder to accomplish some task. The timer would be started when the document is opened, then would send a message to the user if he has not accomplished a particular task (eg validating a particular dialog) when a delay expires (eg 2 hrs). In fact I'm in need of several timers for the same document to handle as many different delays/tasks. Can anyone point me to some direction as I'm currently in the dark? Thanks in advance. Best regards, -- Jean-Francois Nifenecker, Bordeaux -- 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] Can LO build a TOC from a PDF file?
Hello Gilles, Le 09/07/2017 à 19:20, Gilles a écrit : Hello, This PDF file <https://www.legifrance.gouv.fr/download_code_pdf.do?cidTexte=LEGITEXT06074228=pdf> has no Table of Contents, and I was wondering if LO could grab all the headers and build a TOC. In order to create a PDF with a TOC/index you'll have to set heading styles to the appropriate paragraphs. Opening a PDF with LibO won't go anywhere as the tool for that is Draw which can't set styles for a text processor. I can't see a way to do that quickly, I'm afraid: a copy/paste from the PDF document to Writer is possible but you'll have to fix a lot of things (eg. useless carriage returns) and apply heading styles by hand. On a 400+ pages document this a big PITA. Hopefully someone else will come with brighter ideas. Bien cordialement, -- Jean-Francois Nifenecker, Bordeaux -- 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] [calc] Get a list of conditional formattings
Gabriele, Le 09/07/2017 à 10:12, Gabriele Ponzo a écrit : Please consider filling it in bugzilla as feature request, after a quick look if someone else already did it. Done. Bugzilla #109035. I've never been there, but I've been told it's a beautiful area. it is, just like many places in Italy are (dunno many of them but I appreciated all the ones I visited so far). All the best, -- Jean-Francois Nifenecker, Bordeaux -- 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] [calc] Get a list of conditional formattings
Hi Regina, Le 09/07/2017 à 00:18, Regina Henschel a écrit : You can get all conditions from the saved file. In case you use "ODF 1.2. extended" the conditions are written in the LO-specific element . In addition some of the conditions are written in attributes as defined by ODF 1.2. In case you use ODF 1.2, only attributes are used, so that not all kind of conditions are possible. Not sure I'll go the file-unpacking route but this might be a way. In the API look for "Condition..." in the com::sun::star::sheet module reference (in the SDK). For the ODF 1.2 strict way, you can look at https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Conditional_Formats Thanks a lot for your insights. I'll have a look. You might consider to write all hints and explanations more human readable into a separate (hidden?) sheet. In fact this is the aim. BTW, as documenting is a key point of spreadsheets develepment, I think this conditional formatting listing could/should be made available somewhere in the UI, à-la range names insert. Thanks again, Cheers from France, -- Jean-Francois Nifenecker, Bordeaux -- 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] [calc] Get a list of conditional formattings
Gabriele, Le 08/07/2017 à 23:30, Gabriele Ponzo a écrit : I'm on the smartphone at the moment, but I'm quite sure the UI does list the conditional formatting existing on a sheet or in a file. It should be in a specific sub menu item to manage such feature. I clearly remember from my last lessons (I'm a teacher of LO) that there is a dialog window showing them all. Isn't it enough for your need? I probably didn't make myself clear enough: I know of the UI you're talking about. I'm in need of some way to list them all separately on a document of some sort. Thanks anyway. I'll read about Regina's hints which seem to do what I need. All the best, -- Jean-Francois Nifenecker, Bordeaux -- 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] Get a list of conditional formattings
Hi, (official LibO 5.x under win7 and Linux Debian 9) I'm developping in a corporate environment a number of spreadsheets using Calc. In many of those, I'm using conditional formatting, sometimes quite heavily. As I want to precisely document the ins and outs of the spreadsheets for the users and future maintainers, I'm looking for a way to list those conditional formattings. Any hint would be appreciated about a way to do this, which means with macros, of course, as the UI doesn't seem to give any other way. I haven't found any hint in the API but might certainly have overlooked smthg. TIA. Best regards, -- Jean-Francois Nifenecker, Bordeaux -- 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: Apostrophe prepended to MM/DD/YYYY
Hi Tom, Le 11/10/2016 19:10, Tom Davies a écrit : Can find get rid of the ' marks to make the values revert to 'numbers/dates' rather than being forced into being text? Nope. But you may fix that after the import process has run without having to relaunch it. -- Just select the offending column -- Go to Data > Text to columns. You'll get into a dialog similar to the text import one. -- Go to the lower panel and select the column by clicking its heading. -- In the Column type list, select the appropriate format for the data. Here, it would be Date (YMD). -- Click OK. You're done. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] New LibreOffice Book
Hi Bruce! how strange: I was wondering lately how your book was going... Le 24/03/2016 18:22, Bruce Byfield a écrit : On Thursday, March 24, 2016 08:04:58 AM CVAlkan wrote: The book is also featured on Jean Hollis Weber's site http://www.taming-libreoffice.com/2016/03/new-book-designing-with-libreoffic e/ since she appears to be one of the editors/reviewers. Thanks for the kind words! Jean commissioned the book through her nonprofit, Friends of OpenDocument. She has also worked long hours to copy edit and proofread, and, more recently, to promote. I couldn't have had a better editor, and the book is much improved for her involvement. I'm glad you had it put together. As already said, your book is really filling a big gap and shows the actual strengths of LibreOffice. This will tremendously help trainers introducing our office suite of choice in a very concrete manner. I've placed an order for the printed book :) and I am looking forward to get my hands on it. In the meantime, I've downloaded the ods files so that I can have a first look (I prefer printed matter when it comes to big documents; electronic version is, IMO, not very suited to thorough reading). Thanks, thanks, thanks, Keep on the very good job! Greetings from the other side of the pond, -- Jean-Francois Nifenecker, Bordeaux -- 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] linking cells between different calc books.
Hi, I'd add the following option which might help as well: o Edit > Links, Update -- Jean-Francois Nifenecker, Bordeaux -- 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] CHanger le chemin des modeles
Bonjour, [EN version follows] Le 19/01/2015 14:45, AdminSys a écrit : Windows 2008 R2 server Windows Seven LibreOffice 4.2.6 Ce que je veux faire : Centraliser mes modèles sur une ressource partagée. vous vous adressez à une liste de discussion anglophone.Il est donc probable que vous n'aurez guère de réponses. Je vous conseille de vous abonner à une liste francophone (ex: us...@fr.libreoffice.org) pour obtenir une aide plus ciblée dans votre langue. En espérant avoir aidé, --- Windows 2008R2 sever Windows Seven LibreOffice 4.2.6 I want to do: Centralize my models on a shared resource. [the EN word for modèle is template] you're talking to an English-speaking discussion list. Thus you won't get that many answers to your FR garbage. I encourage you to subscribe to a French-speaking list (eg: us...@fr.libreoffice.org) so that you get a more to the point solution to your question. HTH, -- Jean-Francois Nifenecker, Bordeaux 07.52.63.25.54 -- 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] LOBase connected to SQLite3
Hi, Le 16/12/2014 14:21, Pertti Rönnberg a écrit : My question is: is it possible to connect LOBase to SQLite3? Yes, it is. You'll have to use an ODBC driver that you can get here: http://www.ch-werner.de/sqliteodbc/ And if so, how shall it be done -- where can I find a guide? Is the process similar as when connecting to MySQL? It is *much* easier ;) Don't forget to download the SQLite Browser tool as well as it is very good at working on your SQLite databases. See: https://github.com/sqlitebrowser/sqlitebrowser/releases/download/v3.4.0/sqlitebrowser-3.4.0-win32.exe You'll have to configure the ODBC driver to point to the directory where your database resides. Now, start LibreOffice Base and select ODBC HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] mongodb and base
Le 22/11/2014 16:34, Rob Jasper a écrit : I used to work for Bell Labs, and they had as standard (!) perforation the US 3 + the US 4 holes, and we just added Europe's 4 holes, so in total there were 11 holes... hole-y cow! -- Jean-Francois Nifenecker, Bordeaux -- 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] [Base] Can we connect a macro to a report?
Hi, I've got a working report in Base (connected to a Query, the data source being a Calc sheet). This is an accounting report that groups data according to some code in a column. A subtotal amount is accumulated for each group. I'm being asked to add this subtotal in letters as well. I've also got a macro that does just that, translating numbers into letters. But, to date, I haven't found any mean to connect a report field to a macro. I've looked at custom functions and can't find any option anywhere. So my question is: is this possible? And, if it is, how? Thanks in advance, -- Jean-Francois Nifenecker, Bordeaux -- 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: [Base] Can we connect a macro to a report?
Le 14/11/2014 21:22, Andreas Säger a écrit : It is possible to use Calc as reporting engine. Hit F4 and drag your query onto a spreadsheet cell. When the database content changed, click any cell in that import range and call menu:DataRefresh. The page layout is a bit tricky but with Calc's page preview you can build amazing cell grid reports with sufficient formatting options, calculations, conditional formattings, simple interactive filters, sort orders and charts. Thank Andreas, I know of that feature but I fail to see how, using Calc data range, I can impose (random) page breaks when the group column value changes. -- Jean-Francois Nifenecker, Bordeaux -- 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: LibreOffice Still?
Hi Charles, Le 30/09/2014 16:32, Charles-H. Schulz a écrit : Where I disagree with you is that there are people who think that fresh is unstable and not even a testing branch... but so be it. IIRC, this is probably because this is how things were previously introduced on the previous website inception. Cheers, -- Jean-Francois Nifenecker, Bordeaux -- 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] rtf files
Hi, Le 29/09/2014 04:26, Tim Lloyd a écrit : FYI I removed 4.3 and installed 4.1. The problem is not apparent with the older version. I have some old versions stored away so I can drill down and find when exactly this problem occurs and report to the bugzilla (I can't see anything obvious there). Let me know if we are on the same page. FYI, the older versions are available here: http://downloadarchive.documentfoundation.org/libreoffice/old/ -- Jean-Francois Nifenecker, Bordeaux -- 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] Convertir csv en ods
Le 28/09/2014 13:19, Jean-Francois Nifenecker a écrit : Bonjour, sorry, this message was intended for the FR users list. Please discard. -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc - combobox in a cell?
Hi, Le 22/09/2014 21:50, csanyipal a écrit : is it possible in Libreoffice Calc 4.2.6.3 Build az.: 4.2.6.3 Arch Linux build-4 to get in a cell a drop-down list or listbox - combobox with a few values that one can select? Data Validity, then for the Allow option select either List or Cell range. List: enter the items you want displayed Range: enter the wanted items list in a cell range on any sheet, the select this range. You may use named ranges as well. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] set different header/footer for even/odd pages
Le 18/09/2014 09:03, Rafnews a écrit : Hi, I would like to set different headers and footers according to page types. for example: page 1: should have no footer or header as it's a front cover page 2 is blank so no footer or header page 3: since this page, all ODD pages should have a particular header and footer (not the same as EVEN pages) page 4: since this page, all EVEN pages should have a particular header and footer (not the same as ODD pages) In fact, i'm looking for something like in MS Office i used before however i don't know if it's possible in LibreOffice 4.3.1. Yes it is! Of course it is! Tom's pointers are good. As a summary, you'll need using styles. This style thingy is the cornerstone of LibreOffice Writer, Draw and Impress, still very useful with Calc as well. Remember, using Writer, 95% of questions have the style word as an answer. For your needs, you'll have to create or adjust the four following page styles: -- one style for the first page (there's one preset that you might want to edit to your liking). Its next property will have to be set to the blankpage style below. -- one style for blank pages(let's call it blankpage) (its easy to create one, see the docs). As the blank page will be an even page, its next proprerty will have to be set to the oddpage style below. -- one style for the odd pages (let's call it oddpage). Its next property will have to be set to the evenpage style below. -- one style for the even pages (let's call it evenpage). Its next property will have to be set to the oddpage style above. Once these exist, dealing with subsequent pages is a breeze: the next properties take care of the page changes. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Open the file where you finished
Hi, Le 18/09/2014 23:00, Семён Дядькин a écrit : When opening the file always displays the first page. Expected behavior: Is it possible to open the file from the location at which the work was finished? It is very convenient. Just enter your identity data into the options page: Tools Options LibreOffice, User Data. Just setting your intials should suffice. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Footnotes
Hi Brian, Le 08/09/2014 13:43, Brian Barker a écrit : I'm not sure a note that doesn't relate to any point in the text makes sense, but ... neither am I You may have to tinker with spacing in the footnote itself. And I don't guarantee what will happen to the automatic numbering of any other footnotes: you may have to resort to manual numbering of those. Very clever! I've tested this hint and it works very nicely (I've added the DT autotext for testing the footnote contents). The other footnotes numbering stays normal. Great hint! Thanks a lot! -- Jean-Francois Nifenecker, Bordeaux -- 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] shortcut keys for LibreOffice under Linux
Le 14/08/2014 04:31, Thomas Blasejewicz a écrit : I also thought about that already, although I have currently no idea how to change that keyboard behavior. BUT ... if that were true ..would / should LibreOffice not behave in the same way under Ubuntu (Unity desktop), Xubuntu (XFCE) and Mint (Cinnamon)? it depends. It's a hardware question and the interpretation of the F5 key for brightness management is up to a special driver which the maker provides, or not. On my Thinkpad and under Debian Wheezy, all special keys are working. When I tested earlier versions of otker distos this wasn't the case. If I revall correctly (this is an old PC of my daugther), I borrowed it a few years back when I had to spend a week away from home. At that time the PC was running Windows Vista and I used LibreOffice in that environment, but do not remember any such behavior ... Usually nowadays, laptops have a Fn labelled key (lower left part of the keyboard) that allows switching from Special functions keys (brightness, volume, etc.) to normal function keys. On my Thinkpad, the default behaviour is special functions keys. To get the normal function keys I'd have to press the Fn+Function key combination which I found annoying. Fortunately, this behaviour may be toggled in the Thinkpad BIOS, which I did. Now, pressing a function key alone gives me the normal function result and to get any of the extended functionalities I have to press the Fn+Function key combination. -- Jean-Francois Nifenecker, Bordeaux -- 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: Base questions
Le 04/08/2014 14:51, dave boland a écrit : How does switching to Firebird solve the issue of an embedded, all in memory database? I would be happy if LO offered an option (when creating a db) to use embedded model or the split model. Any embedded DB engine (HSQL or Firebird or any other) won't solve the Base [R]DBMS embedding problems. Only external DB engines can be reliable. Using an external DBMS is up to you. Base/LibO can be setup accordingly. -- Jean-Francois Nifenecker, Bordeaux -- 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: Base questions
Le 04/08/2014 18:59, dave boland a écrit : I'm getting a little confused. My understanding is that there are really two issues here. One is that LO Base is RAM resident - all updates are held in RAM until saved by the user, or the program is closed. Correct? If so, this situation will expose the user to data loss between saves. There are two components here: the DB engine (eg HSQLDB) and the front-end (ie LO-Base). In embedded mode, running Base stats the DB engine and opens the wanted database. In this situation, yes, database updates are set to ram until the database is saved, either voluntarily or when Base is shut down. And yes, any flaw in *any* piece of software running while Base and the DB also run, can create DB loss. The other issue is that LO Base uses an embedded database, which means that the data files and the GUI, reports, etc. are combined into one file that can be corrupted. The suggestion is to use a split system where the data files are separate from the other files. Correct? If so, at best, the data may be a little safer, but forms, queries, etc. can still be corrupted. Yes, this is what split-mode is all about. A database like MySQL and mariadb cache the updates and then write them to disk every 1/2 to full second (or however configured). Seems like a good idea. So I come back to my suggestion earlier today - LO Base needs to give the user the opportunity to specify what they want - RAM or file based, single file or multiple files. Would that be difficult to do? WRT HSQL it's just a couple settings away: (1) in LO global settings (Tools/Options, Advanced page) specify where the external HSQLDB engine is stored (Class Path button) - Add archive: points to the hsqldb.jar - Add Folder: points to the directory where hsqldb.jar is stored (lib dir) Then make sure to check the test button These setings are stored in the user profile /config directory. (2) in Base, DB creation wizard - at step 1 : select JDBC database - at step 2 : specify the DB address settings Datasource URL : hsqldb:file:d:/somedir/mybase/basetest;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false JDBC Driver class: org.hsqldb.jdbcDriver Test with the Test Class button. These settings are stored in the RegistryModifications.xcu file. To me, the main difficulty lies in the backup of these settings (config dir and RegistryModifications.xcu and the .odb file), so that you may change PC without hassle. Unless I'm missing the obvious, it is not the case currently. -- Jean-Francois Nifenecker, Bordeaux -- 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] Intermittent Calc Issues
Hi, Le 05/08/2014 05:25, Gregory Forster a écrit : Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. As your problems seem to arise while using the keyboard (the mouse symptom seems related to the shift key being seen as pressed), I'm wondering if your laptop keyboard has no problem. Did you test LO and your spreadsheet on some other hardware? -- Jean-Francois Nifenecker, Bordeaux -- 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] Base questions
Hi Dave, Le 31/07/2014 21:22, dave boland a écrit : All, Was reading the FAQ at https://wiki.openoffice.org/wiki/FAQ_%28Base%29 and came upon some insight that worries me. Under the heading So why should I avoid 'embedded databases'? it goes on to say the normal Base file is not reliable, so use a split file, the points to Microsoft docs. My questions are: 1. How robust are embedded Base files created by the GUI? Not much, because when Base is running, the whole DB is in memory. Any crash (from any origin) may corrupt the DB and make it completely unreadable. A daily backup is necessary. 2. If they are not that reliable, what is the LO Base procedure to create a split database? 3. Anything else I need to know? Can you read French? I've written a document about just that. Title How to get rid of the Base HSQLDB embedded mode. My sources were various wikis, forums and mailing lists messages (EN and FR) that I reviewed, rephrased and assembled. If anyone is interested in translating from FR, it's ok by me (there are 39 pages in all and there remains one or two draft paragraphs). The current license is CC-BY-SA. Feel free to contact me in PM. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Base questions
Le 31/07/2014 21:35, Rob Jasper a écrit : If the normal Base file is not reliable, why do we have it in the first place? Either we (the community) must make it reliable, or we should abandon it and come with a reliable alternative. Not reliable is in fact not very acceptable. The documentation should describe when to use, and when not to use base. Simply generalizing in the FACs is not the right way to go, I think. Base is a very useful and versatile tool which deserves much attention. So, abandoning it would be a very bad idea, if you ask me. Dunno about the current developments (wrt FireBird embedding) but I do like Base for many uses: -- HSQL embedded mode: demo-ing, modelling, personal DBs, front-end to Calc spreadsheets or even text files -- HSQL file mode: everything else (professional single-user or multi-user DBs). In this situation, Base is a good front-end that could become excellent, if the devs where to focus on that (I've got no information here). The main question is how to switch from embedded mode to file mode? which I had a hard time figuring out. Fortunately, the web is you friend ;) -- Jean-Francois Nifenecker, Bordeaux -- 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] Text in an IF function
Hi, Le 29/07/2014 17:43, Ian Whitfield a écrit : I came across a situation today where I need to test text - ie I need to test for a month's name. If the referenced cell (say it's A1) contains a month name : =IF(A1=AUG;doYes;doNo) If the referenced cell contains a date formatted to display as a month name (namely ), then: =IF(MONTH(A1)=8;doYes;doNo) HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Trouble with LO Writer templates
John, Le 26/07/2014 18:05, john herron a écrit : Having trouble understanding (and managing) the hyerarchical workings of Writer templates. In a template I call Memoranda_Dbl, I have a style named Text Body. Property Settings: Organizer: Name=Text Body; Next Style = Text Body; Linked with = Default Style Indents Spacing: Line Spacing 1.5; Indent Before/After and Space Above/Below = 0.00 (same as Default Style) IMHO, when I produce the next Text Body paragraph (by typing Enter) I should get a paragraph with settings equal to the previous paragraph. But, what does LO do when in the document I attempt to produce a new paragraph? Your screenshots would be more readable if you'd set the unprintable characters as visible (Ctrl+F10). -- Jean-Francois Nifenecker, Bordeaux -- 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] Trouble with LO Writer templates
Le 26/07/2014 18:44, Jean-Francois Nifenecker a écrit : Your screenshots would be more readable if you'd set the unprintable characters as visible (Ctrl+F10). Well, yes and no. I read way too fast. Is it possible to download a copy of your document? -- Jean-Francois Nifenecker, Bordeaux -- 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] Compatibility issue opening an .xlsx file with calc: Err:509
Hi, Le 30/06/2014 18:40, Xbot a écrit : I have a compatibility issue opening an .xlsx file with calc (LO 4.2.5.2): instead of different choices in a pull-down menu, I only get Err:509 when for example I click on the arrow . Just have a glance at this document: https://joinup.ec.europa.eu/elibrary/case/complex-singularity-versus-openness so that you get an idea of the mess that's behind .xlxs (resp. .docx) and the burden which is on the LibO programmers shoulders to be compatible with the said mess. I've attached the xlsx file, hope it helps. Note that this list can't accept attachments. Please upload your file to some repository so that others here can reach it. -- Jean-Francois Nifenecker, Bordeaux -- 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] How to ensure all new text entered into a document is different font, without changing the old font settings of the document?
Hi, Le 07/06/2014 15:54, quickbooks office a écrit : How to ensure all new text entered into a document is different font, without changing the old font settings of the document? That is the document has questions in it, with lets say Times New Roman. When I type the answers in, the font remains Times New Roman. But I want it so that all new text entered to be Segoe Print without changing the font of the text already existing in the document (i.e. the questions) Short answer: Styles. Long(er) answer: if, as I understood, you've got one paragraph for the question and you enter the answer in another paragraph (or several), just do this: 0. Display the Style and formatting toolbar (F11) which is *the* tool to have at hand when using Writer 1. The question and answer paragraphs are given each a separate paragraph style Right-click New, then set the paragraph style properties (eg the font name and size) Say you've now got two paragraph styles: Questions and Answers with the appropriate formatting settings. Setting a paragraph style is easy: the current paragraph (the one with the caret in it) receives the style settings when you double-click the style name in the Styles and formatting toolbar. 2. Configure the Question paragraph style (again: right-click this style name in the Style and formatting toolbar and select Modify) In the Organizer thumbnail, set the Next Style property to the Answers style. This means that any time you hit Enter (end-of-paragraph) after having typed a question (with the Questions style set), Writer creates a new paragraph with the Answers style already set. Note: by default a paragraph style Next Style property is set to itself so that you get a sequence of paragraphs with the same paragraph style. Now, if you enter the answers within the *same* paragraph as a question, you'll need a *character* style specifically for the answer portion of the text: in the Style and Formatting toolbar, select the character style toolbutton then create a new style for the answer characters. Then, any time you enter the answer text, just select this text and double-click the Answer character style to set the newly entered text. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Spell Check Dictionary
Mark, you didn't acknowledge my answer to your previous similar question in this mailing list (05/18). Le 21/05/2014 01:55, Mark LaPierre a écrit : Is there a setting somewhere that I've missed that will allow the use of a local dictionary? Is this a known bug? Here's what I suggested: 8 --- Have you ticked the following checkbox: Tools Options, Language Settings Writing Aids, User-defined dictionaries, Standard [All]? This done, LibO should behave --- 8 HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] ignore all during spellcheck
Hi Thomas, LibO 4.1.4-2, official with Debian Wheezy Xfce. Le 18/05/2014 04:36, Thomas Blasejewicz a écrit : When I perform a spellcheck (either in English or German), the spellchecker frequently comes across terms that are NOT in the dictionary, I do NOT wish to add and therefore would like to ignore all instances in the document. HOWEVER .. the spellchecker NEVER accepts this command ignore all. Even if it shows me one box (sentence), which contains 2-3 instances of a particular term and I click on this ignore all, the same term 2-3 words to the right is again flagged as misspelled and shown in red. Naturally, when the spellchecker moves further down and finds that term again, it will mark it here too as misspelled. I have tested you text above within my FR Writer window and run the (FR) spellchecker, ignoring once or ignoring all the EN words. As a result: -- in the end, the text is not underlined in red anymore -- typing a previously ignored all word (eg the) doesn't underline it in red again (for the session duration). So, in short: WAD here. I guess there's some mismatch in your LibO installation. Double check the language options once again. If nothing is noticeable, then your LibO user profile might be corrupted. Try and rename it just to make sure (with LibO and its quickstarter closed). (I have also trouble with having the spellchecker remember terms added to the dictionary ...) Tick the following checkbox: Tools Options, Language Settings Writing Aids, User-defined dictionaries, Standard HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Which components do you use most?
Le 11/05/2014 23:53, Virgil Arrington a écrit : I'm curious to find out what components of LO are used most by the people on this list. I think it helps to know different folks' area of experience. It might also help us in learning new ways to integrate the different components. Writer: 75% Calc:40% Draw:15% Impress: 10% Base:10% Math: 0% That's more than 100%? Probably because I'm working more than that as well ;-) -- Jean-Francois Nifenecker, Bordeaux -- 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] Draw problems
Hi Girvin, Le 09/05/2014 23:45, Girvin Herr a écrit : Then I tried using Draw in stand-alone mode (not as an embedded object) to export the figure as a jpeg or png file and inserting that file into the document. I changed the Draw page margins to the 2 by 7.5 figure in order to exclude all but the figure. However, these export functions only allow full page saves, not the small 2 high by 7.5 wide figure I need. When inserting the file into the document, I get a lot of white space and my figure is tiny. On this very problem, you'll notice that the export dialog has a Selection checkbox in the lower left part. To export a selected part of a drawing to some third-party format, which is what you're looking for, do: 1. Select the drawing (part) you're willing to export. If you want the whole drawing, then just Edit Select all (Ctrl + A) 2. Open the Export dialog and tick the Selection checkbox. And you're done! Your new image is now without any white space clutter. Note: the Selection checkbox doesn't retain its state. You'll have to check it again when exporting another drawing. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Imported document becomes corrupted, when edited.
Hi Ian, Le 03/05/2014 16:08, Ian McCarthy a écrit : I have a document - https://www.dropbox.com/s/qp6rf6edhuui8qb/SpeyElectrics.v16.odt It consists of a number of pages, the first two should have only writing on them, then there are some line drawings, then a page with an annotated image (page 6), followed by some more diagrams. I am having a number of problems. When I reopen the document after editing some of the draw lines and other objects. Things have leapt to other pages. When I attempt to select multiple objects so I can group them, when I press the shift key and click, I end up on the image page page 6 When I select a line, the line tool bar does not appear. I have to draw a new open line and then by selecting that I can get the line drawing tools icons (to add and delete points etc), and I may then be able to edit the line I wanted to edit. Is it something special about this document, or is this a more general problem. I see the same problems here with your document. (LibO 4.1.4 from TDF, Debian Whezy). What do I do to fix it? IMO, you've got way too many diagrams/drawing objects in your Writer document. I guess this is what creates the problems. I sometimes add drawing items in .odt documents, but very few at a time (2-3 lines or boxes at best), this without any problem so far. Anyway, I'd suggest drawing with a dedicated drawing tool, such as... Draw ;) Then you'd get a copy of the drawings into your .odt document. You might: -- copy and paste the drawings from Draw to Writer (group the drawing objects that go together first) -- insert drawings as OLE objects -- insert drawings as pictures (in Draw, you'd export the drawings to .png first) Just pick your preferred option. BTW, the existing diagrams can be copied and pasted from Writer do Draw: you haven't lost anything :) HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] OST to PST Conversion Recovery software.
Le 02/05/2014 12:38, DavidMabery a écrit : Caught up with unusable OST files and looking for ways to convert it to PST spam -- Jean-Francois Nifenecker, Bordeaux -- 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: Upgrade Problem on Windows
Le 30/04/2014 01:57, Urmas a écrit : After I specified that LO be installed on volume D: the installer still requires 427MB on C: Because the temporary directory for your user account resides there. This dir is used by the installer for decompression of the msi and its temp storage needs. Is there any way to avoid using C:? Change the temporary directory drive as already suggested: . You can relocate the Windows Installer folder (by creating a directory junction) and the temporary folder (by setting TEMP environental variable). There are several tutorials available in the Internet. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Manifeste
Bonjour, suite à des échanges en privé, j'ai actualisé et amélioré mon manifeste, joint en version 1.7. En particulier j'ai ajouté un paragraphe à propos du support. Merci à Nicolas Abel. Toutes les remarques, critiques et suggestions sont appréciées. Amicalement, -- Jean-Francois Nifenecker, Bordeaux -- 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: Modifying Styles
Dunno if you're talking to me or to the OP, anyway, here goes :) Le 04/04/2014 18:01, CVAlkan a écrit : Just a thought: In the Tools|Options dialog, there is a section under LibreOffice|General titled Document Status. Under that is a check box labelled: Allow to save document even when the document is not modified On your installation, is that box checked or unchecked? On my PC, this is unchecked, as it is by default after LibO install. -- Jean-Francois Nifenecker, Bordeaux -- 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] MSO for iPad, big deal or big yawn
Le 01/04/2014 17:01, Tom Davies a écrit : Hi :) A ZdNet article titled (obviously) Office for iPad, big deal or big yawn allows people to vote and so far the big yawn side is winning. HoooRaaah! ;) The big yawn side appears to largely be supporting OpenSource. http://www.zdnet.com/debate/office-for-ipad-big-deal-or-big-yawn/10137467/ I haven't got any smartphone, so I'm just wondering: what use for office software on such a small screen as a smartphone one? Is the software usable at all? -- Jean-Francois Nifenecker, Bordeaux -- 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] Modifying Styles
Le 30/03/2014 18:55, Dale Erwin a écrit : I was beginning to think I was going crazy. I tried to modify 2 page styles in three different documents so that I could copy from one to the other without destroying the format. After several attempts, I was still getting a different format when I copied from one file to another. It turns out that if you don't save the document, the changes to the style are also not saved. The odd part of this is that it is possible to close the file with no prompt for saving changes. Now if I make a change to the text of a document, then try to close the file, I will get a prompt to either save or discard my changes, but I got no such prompt after changing styles with no change to the text. Even more odd is that the save option is greyed out (inactive) unless a change has been made and it is not greyed out after changing a style even without changing text. LibO v.4.1.4 (from TDF) under Debian Wheezy I can't reproduce this behaviour: Writer save button is activated after I import page styles from another document. -- Jean-Francois Nifenecker, Bordeaux -- 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] Master Documents, Office Suites, and the Underwood
Le 26/03/2014 04:48, Brian Barker a écrit : Your history as a programmer is relevant - but leads me to an opposite conclusion. +1 Styles are another way of separating data and presentation which is a long standing programming mantra. A programmer should be interested in that. -- Jean-Francois Nifenecker, Bordeaux -- 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] Master Document
Le 25/03/2014 22:32, Dale Erwin a écrit : Yes, but there is more to it than just the first word and the last word. The first word is straightforward enough, except that sometimes it might consist of more than just one word. But the last word does not refer to the actual last word on the page, but the last headword of a dictionary entry which also might sometimes consist of more than one word. But it's moot since there are no such fields available. You need to: 1. Set a character style to the dictionary headwords as already suggested in this thread, 2. Then, using a macro (can't see any way to do that with standard tools in Writer), 2.a. search forward from the beginning of the page for the very first character sequence on a page with that style - you've found the first word 2.B. similarly from the end of the page, search backwards for the very last character sequence formatted using that style - you've found the last word. And that's it. Well, I'm completely unable to write any such piece of code but no doubt this can be done, though the devil might be in some details. -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc: limit number of columns and rows
Le 15/03/2014 17:25, Lore a écrit : Dear all, a spreadsheet has thousands of lines and hundreds of columns. Most users (like me) don’t need that many cells. Is there any way to limit the amount of lines and rows in a specific file? what for? AFAIK the software uses only memory necessary for the current used cells. IOW, unused cells cost nothing. -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc: limit number of columns and rows
Le 15/03/2014 20:29, Lore a écrit : It is actually an usability improvement I’m after. If you are using a mouse with an inertial scrolling (such as an Apple mouse or trackpad) and you want to get to the end of your sheet, you can do a strong stroke with your finger. Problem is, you don’t get to the end of your used field, most of the time you end up in the middle of nowhere among unused cells…. It would be nice to limit the size of your sheet then… Wouldn't it be much easier to use the keyboard? IE, Ctrl+End will set the active cell to the bottom right angle of the used cell area. I'm fond of keystrokes because, among other qualities, they don't break the workflow... YMMV. -- Jean-Francois Nifenecker, Bordeaux -- 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] averaging with missing values
Le 15/02/2014 16:59, william drescher a écrit : Can anyone suggest a way of getting the average without needing to manually count the values ? Create your own averageif() function with a formula: SUMIF() / COUNTIF() -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc: help with VLOOKUP
Le 15/02/2014 18:20, Pikov Andropov a écrit : How do you name an array? (1) Select the array (2) Menu Insert Names Define (3) Enter the name of your choice (no spaces allowed) and hit OK. From now on, using the array in a formula is equivalent to the absolute reference to this array. EG: you select A1:B2 and name it my_array You may write formulae using the $A$1:$B$2 or the my_array syntax (note that you must not use quotes when dealing with array names in formulae). That is: =SUM($A$1:$B$2) or =SUM(my_array) give the same result HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc: help with VLOOKUP
Le 15/02/2014 21:14, Pikov Andropov a écrit : Data Define Range There, you define a dataset which can be further managed for data retrieval, sorting, filtering, mailing... -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc: help with VLOOKUP
Le 15/02/2014 22:06, Jean-Francois Nifenecker a écrit : Le 15/02/2014 21:14, Pikov Andropov a écrit : Data Define Range There, you define a dataset which can be further managed for data retrieval, sorting, filtering, mailing... The column headers are seen as field names and the other rows as records. -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc: help with VLOOKUP
Le 14/02/2014 23:06, Carl Paulsen a écrit : A few hints for vlookups: I find I usually want to add hard references for the array so that it always looks at the intended rows of the array. To do that, you need to add $ before each cell reference in the array. So if the array of the function is A1:C100, I enter it as $A$1:$C$100. This forces vlookup to always look at those cells regardless of what row the calculation is happening on. Another way of achieving that is to name the array. This has my preference because a named array makes formulae easier to understand. Finally, be mindful of the implications of the sort order variable in the function. If it is 1 or TRUE, the array must be sorted ascending, and the function returns the nearest value below or before the looked up value. If you want to force it to return only exact matches and/or don't want to or can't sort the array, be sure to set sort order to 0 or FALSE. +1 to all of these. The 0 (FALSE) parameter is the one I always use by default for the reason you stated (getting an error when no match is found). -- Jean-Francois Nifenecker, Bordeaux -- 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] Error
Le 13/02/2014 21:43, Angela Turkington a écrit : I am receiving a message the following disk images could not be downloaded when I attempt to download libreoffice. Can you please contact me ot correct this. Where (what website) are you downloading from? The official download (international) website is: http://www.libreoffice.org/download Some languages have a dedicated download page/website. EG for French: http://fr.libreoffice.org/telecharger/ HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Fit Text to Contour
Hi Cliff, Le 11/02/2014 18:36, Cliff Scott a écrit : Ok. I haven't used Draw very much at all. F2 was the key. Interesting that if I use the Fontworks Gallery in Writer then the Fontwork functions will let me modify that to my hearts content. The only thing I can't do is to enter the free form line and get text to associate with it. Have a look at that: http://cjoint.com/?0BlsQiybolW I've created and duplicated a free form line with a text. The line above is raw, just after text creation. The line at the bottom is after applying the Fontwork effects (I have hidden the line using the S-y tool. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Fit Text to Contour
Le 10/02/2014 16:59, Cliff Scott a écrit : One question remains: Is there a way to put the text on a free form line or only on the shapes the Fontwork Button dialog box has? Yes, of course. Just draw a line by hand and associate (enter) the text you want. While it is selected, call the Fontwork tool. There, do *not* use the upper rounded shapes. Instead, use directly one of the four tools just below to setup the text along the line you drew. You should achieve what you're looking for. -- Jean-Francois Nifenecker, Bordeaux -- 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] Fit Text to Contour
Hello Cliff, Le 11/02/2014 03:29, Cliff Scott a écrit : Tried that and somehow I'm missing something important. I draw a line using the Freeform Line tool from the Draw toolbar. I then use the text tool from the Draw toolbar to enter text. Nope. You select the line and hit F2, so that the text box associated with the line opens, then you enter the text :) I guess I didn't make me clear enough. Perhaps the verb associated is not the right one... This takes me back to the same problem as I had initially, how do I get the text to be associated with the line. Writer will not let me select both the text box and the line at the same time. Could you give me a detailed step by step what works on your system? Thanks. see above. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] Fit Text to Contour
Better late than never... Le 24/01/2014 04:39, Cliff Scott a écrit : I'm trying to use Draw to make up some text to put around pictures in Writer. The help says: Adjust to contour - Adapts the text flow so that it matches the contours of the selected drawing object. For the life of me I can't figure how to connect the text to a shape. I have a text box with text in it and a curve that I drew, but to get the text to follow that curve seems beyond me. I've selected the shape and gone to the menu Format/Text and selected adjust to contour as it says to do, but nothing happens. You'll get what you're looking if you add the Fontwork *toolbutton* (not Fontwork Toolbar) by: a. Tools Customize. b. In Toolbars page select the toolbar you want to add the button to then click Add. c. In the new dialog, select the Format category, Fontwork command. Validate Now you've got the right tool to get going. Usage: 1. draw a line or a shape. 2. enter the associated text to the line/shape, as usual 3. click the Fontwork button and enjoy! HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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: Connect Base to External HSQLDB
Hello Alex, Le 06/02/2014 07:16, Alex Thurgood a écrit : Note that this part didn't work for me on Mac, it provokes an error in LO's component loader or service manager (don't remember which now), or at least, that was the case for 4.0 and 4.1. well... this *did* work fo me under WinXP and I never had a Mac to test :( Any Apple-maniac suggestion would be fine :) -- Jean-Francois Nifenecker, Bordeaux -- 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] Connect Base to External HSQLDB
Le 06/02/2014 05:50, Mark LaPierre a écrit : Hey all, I have HSQLDB installed here: /home/database/back/hsqldb/lib/hsqldb.jar I want the Base front end here: /home/database/recipe/recipe.odb On the LibreOffice Database Wizard: 1. Select Database I select the radio button: [Connect to an existing database] I select [JDBC] in the section box and then click [Next] 2. Set up JDBC connection I fill in [data source URL]: jdbc:[../back/hsqldb/lib/hsqldb.jar] What do I put in the [JDBC driver class] box? The HSQLDB documentation suggests that there is a JDBC driver in the hsqldb.jar file but that doesn't work. I assume that the HSQLDB package contains a driver.jar somewhere. What should I put in for the JDBC driver class path? (some terms below freely translated from my FR environment) -- data source (URL) hsqldb:file:path to the .odb;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false In path to the .odb above do not specify the .odb extension. Sset the defaults above as you prefer; these work for me. -- JDBC driver class org.hsqldb.jdbcDriver -- A question: did you set the class path and configuration for Java? If not, go to Tools/Options, LibreOffice / Java. Check that Use a Java setup is checked, then add the Java environment setup on the PC. Once this is set, click Class path In the new dialog: (1) Add an archive Point to the hsqldb.jar on your PC (mine is C:\Program Files\hsqldb-2.2.8.\lib) (2) Add a file Point to the above \lib subdir You should be up and running. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] *Persistent* System Level Custom Options?
Le 03/02/2014 21:03, iveand a écrit : I am not looking to add interactive features to LibreOffice, but simply to adjust some of the default settings on a system wide level.If I could bundle these as an extension that would be just fine to deploy.I could even have the .xml file (I would guess an .xcu?) of my unique settings static, and the extension would just put it in place and update whatever needs modifying to point to it?I think I am making some progress as I found this link:https://wiki.openoffice.org/wiki/Non-code_extensionsIn that link is this information:Extension support in the Configuration Manager I'd suggest a simple method: install LibO on a clean machine. Set it up to your liking then save the user profile from this machine. All you've got to do afterwards is to restore the saved user profile to each and every new install. Then everyone has got the same in-house settings. I'm using this very method to do exactly that. Under Windows, I combine this with ActiveSetup so that I get an automatic user-setting: I save the user profile somewhere on the PC (in a subdir of ProgramFiles/LibreOffice) and configure ActiveSetup to go and copy these settings to the new user profile. And that's it. -- Jean-Francois Nifenecker, Bordeaux -- 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] *Persistent* System Level Custom Options?
Le 03/02/2014 21:03, iveand a écrit : I am not looking to add interactive features to LibreOffice, but simply to adjust some of the default settings on a system wide level.If I could bundle these as an extension that would be just fine to deploy.I could even have the .xml file (I would guess an .xcu?) of my unique settings static, and the extension would just put it in place and update whatever needs modifying to point to it?I think I am making some progress as I found this link:https://wiki.openoffice.org/wiki/Non-code_extensionsIn that link is this information:Extension support in the Configuration Manager I'd suggest a simple method: install LibO on a clean machine. Set it up to your liking then save the user profile from this machine. All you've got to do afterwards is to restore the saved user profile to each and every new install. Then everyone has got the same in-house settings. I'm using this very method to do exactly that. Under Windows, I combine this with ActiveSetup so that I get an automatic user-setting: I save the user profile somewhere on the PC (in a subdir of ProgramFiles/LibreOffice) and configure ActiveSetup to go and copy these settings to the new user profile. And that's it. -- Jean-Francois Nifenecker, Bordeaux -- 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: paypal
Hi, Le 19/11/2013 04:29, NoOp a écrit : It's irritating as hell. It makes LO look as if a donation is required (even though it says otherwise) and IMO is a bit of an embarrassment when referring LO to others. Several have commented were sure to mention that AOO doesn't require this nonsense. here, if I go to http://www.libreoffice.org/ I click on the big round Download LibreOffice Now! button, this gets me to http://www.libreoffice.org/download where I can select the download I want which starts (almost) immediately. No donation is required AFAICS. There's a donation option below with the following introductory text: LibreOffice is Free Software and is made available free of charge. Your donation, which is purely optional, supports our worldwide community. If you like the software, please consider a donation. This is all ok for me. So, unless there's some other entry point which introduces a donation before the download, I can see no problem. Or am I mistaken? -- Jean-Francois Nifenecker, Bordeaux -- 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] CALC convert text to numbers
Le 10/11/2013 22:57, Oogie McGuire a écrit : I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. This will do quite easily: Call the menu Data / Numbers as text (freely translated from my FR install) then just click OK in the window that opens without changing anything. This should do the trick. Another way I often use when the import is made on a regular basis, is to create what I call an exploitation sheet. You create a new spreadsheet and insert data there from the spreadsheet you got from the import. The formulas will then look like ='file:///home/jf/Documents/Imports/MyImport.ods'#$'Sheet1'.A2 Then copy down and right and you're set. What is interesting is that you may add some data handling when linking the cells: you may have =CNUM('file:///home/jf/Documents/Imports/MyImport.ods'#$'Sheet1'.A2) which would automagically convert the text data into numerical data without having to bother each and every time a new import comes. You may also ignore any superfluous column, and so on. For the ease of use, make sure to have both spreadsheets in the same directory. Note that: -- this works only if the imported data is consistent (same columns at the same place) and the data file must be uniformly named. -- the imported data must be in a real file on disk. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] CALC convert text to numbers
ooops! forgot to specify the first step: 1. select the column to set as numbers first. Le 11/11/2013 07:03, Jean-Francois Nifenecker a écrit : 2. do that: Call the menu Data / Numbers as text (freely translated from my FR install) then just click OK in the window that opens without changing anything. This should do the trick. -- Jean-Francois Nifenecker, Bordeaux -- 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] CALC convert text to numbers
Le 11/11/2013 07:44, Brian Barker a écrit : At 07:03 11/11/2013 +0100, Jean-Francois Nifenecker wrote: Call the menu Data / Numbers as text (freely translated from my FR install) ... In English, that's Data | Text to Columns... . thanks! -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc IF problem
Le 20/10/2013 21:01, Paul a écrit : On Sun, 20 Oct 2013 18:10:32 +0100 Brian Barker b.m.bar...@btinternet.com wrote: Chacun à son goût, of course. Exactly. The actual expression is: des goûts et des couleurs [ça ne se discute pas] literal EN: Tastes and colours [that's not debatable] :-) -- Jean-Francois Nifenecker, Bordeaux -- 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] Calc Function Wizard - IF Result differences
Hi, Le 19/10/2013 14:36, Hylton Conacher (ZR1HPC) a écrit : The initial formula is: =IF(0G4=$G$20,G4*$F$20,IF($G$20G4=$J$20,(G4-$G$20)*$I$20+($F$20*$G$20),IF($J$20G4=$M$20,(G4-$G$20-$J$20)*$L$20+(($G$20*$F$20)+($J$20*$I$20),IF($M$20G4=$P$20,(G4-$G$20-$J$20-$M$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20),IF(G4$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20)) this is waaay too convoluted to be easily checked. There must be an answer and or my formula syntax is wrong unbeknown to me. Sure, there is. As your request looks very much like your previous one, I highly encourage you to read Brian's answer to that one: it's filled will good advice. IOW, when you can write your problem down using common speech (not some spreadsheet language), I'm sure you'll turn having found the solution by yourself. - I share Brian's idea about using VLOOKUP() through a 3 lines set of data. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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] How to create fillable PDF forms in Writer?
Le 09/09/2013 15:25, Tanstaafl a écrit : Is there a good step by step for this somewhere? easy ;) Creation 1. Create the form using Writer and save it 2. Export it as a PDF, no special option required Usage Using AdobeReader is possible but note that you can't save the filled pdf form. You have to print the form. Obviously, Adobe wants us to purchase their tools g Using third-party tools (eg FoxItReader under MS Windows, many tools under GNU/Linux), you may save the filled form, and even change the data afterwards if necessary. Is this tutorial ok ;) ? -- Jean-Francois Nifenecker, Bordeaux -- 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: GIMP - was: CNET is claiming the best free MSO alternative is not LO
Le 09/06/2013 21:45, Jay Lozier a écrit : I think you described the typical computer users. They only know a couple applications and use them even if they are not good for the situation. I suppose it is tempting, if the only tool you have is a hammer, to treat everything as if it were a nail. (Abraham Maslow) -- Jean-Francois Nifenecker, Bordeaux -- 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] CNET is claiming the best free MSO alternative is not LO
Hi, jumping in the bandwaggon.. Le 08/06/2013 18:33, Jay Lozier a écrit : I think there is a basic agreement that at least 25% of the features in MSO could be eliminated and no one would notice. I would not be surprised if LO and AOO could eliminate about 20% of the features without anyone noticing. I am suggesting any features be eliminated just that all office suites could probably go on a feature diet and actually improve their products. Just that some need a more rigorous diet than others. An idea I've been having for 20+ years now is: how about an office automation tool (wordprocessor, spreadsheet, whatever) that would come with the bare minimal features (define: bare minimal) and could be enhanced by adding features through a plugin system à la LibreOffice extensions? This way, anyone could tailor the software to their exact needs and the tools devs would focus on dedicated areas to add features. -- Jean-Francois Nifenecker, Bordeaux -- 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