Re: [libreoffice-users] Re: FODT Write Error. The file could not be written.
Francesco Ongaro writes: > Thanks Piet, > > your knowledge on the matter is really helpful! > > Seeing your advice I can only imagine how many errors my templates > contains. > > Just two questions: > > - How do you validate your FODT files? I just loaded the FODT file in Emacs, and it indicated some errors. > > - Do you have a preferred documentation reference for generating FODT > files? You may look at http://opendocumentformat.org/developers/ I did check the file against the OpenDocument documentation. http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2.pdf and related documents. -- Piet van Oostrum WWW: http://piet.vanoostrum.org/ PGP key: [8DAE142BE17999C4] -- 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] Re: FODT Write Error. The file could not be written.
Francesco Ongaro writes: > > By removing the whole 'FooterTable_Row' it successfully saves an FODT. > > By removing 'style:family="table-cell"' it successfully saves an FODT. > You should put the table-related styled (style:family="table*") inside the rather than the . is meant to be used for named styles that the user can select through the user interface, for example the Styles and Formatting side bar, or the Styles menu. The user interface doesn't have named table column, row or cell styles. On the other hand is for styles that are directly set in an object. With these changes (and the corrections to the XML in my previous message), it works.) -- Piet van Oostrum WWW: http://piet.vanoostrum.org/ PGP key: [8DAE142BE17999C4] -- 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] FODT Write Error. The file could not be written.
For a start, there are XML errors in your document: Line 122: style:contextual-spacing is not an allowed attribute. Line 133: style:family="4.1354inn" is wrong. It seems the style:family is mixed up with some measurement. Line 153: There is a secondelement. There should be only one of these. Line 162: The element must not be empty. Add an element. -- Piet van Oostrum WWW: http://piet.vanoostrum.org/ PGP key: [8DAE142BE17999C4] -- 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] edit autocorrection options
Thomas Blasejewicz writes: > Now I can change the contents and after newly adding the "(c)" (which I > still cannot find anywhere in the preexisting lists), Please note that the replacement lists are language specific, plus there is a list for [ALL]. So it might be that the replacement for (c) is in the English list, but your default language is not English. -- Piet van Oostrum WWW: http://piet.vanoostrum.org/ PGP key: [8DAE142BE17999C4] -- 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] Calc error?
Harvey Nimmo writes: > I'm running LO on OpenSuse and I wonder if anyone alse can confirm this > error on calc. > > Multiplying 2048.28*.146 yields correctly 295.54488, but when rounding > down to 2 decimal places, 295.55 is displayed (instead of > 295.54)(either using ROUND(2048.28*.146,2) or with field format. > 2048.28*.146 = 299.04888 not 295.54488 -- Piet van Oostrum WWW: http://piet.vanoostrum.org/ PGP key: [8DAE142BE17999C4] -- 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] Re: Adding keyboard shortcut
Dave Howorth writes: > On Sun, 9 Dec 2018 01:19:15 + > Tom Davies wrote: > >> Hi :) >> The crucial part is at the end of Stuart's email. Apparently you can >> modify the action of "backspace" by following his advice. >> Regards from >> a Tom :) > > Rich doesn't want to modify Backspace; he doesn't want to do anything > with backspace. > > He doesn't want to modify Delete either; he simply wants to assign an > additional key to have the same action (i.e. Delete, *not* Backspace) > That action is called 'Delete Contents' (as you can see on the Del key in the list). However, if you assign ^D to this function, the Del key might lose it, unless this is working at the OS level. It seems that LO only allows at most one shortcut key for each function. -- Piet van Oostrum WWW: http://piet.vanoostrum.org/ PGP key: [8DAE142BE17999C4] -- 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] Page Numbers in TOC
Ian Whitfield <whitfi...@blinkmail.co.za> writes: > Hi All > > I have been watching this thread and hoping a problem I have with this > might be mentioned!! > > I produce a monthly "Journal" and also make use of the TOC to list the > contents. It works fairly well (with a bit of editing) but the one > problem I have is as follows. > > The first two pages of the SLA document are the Front Cover and the > Inside of the Front Cover so my actual content starts on the third Page. > However Scribus' TOC works on the actual Page Count so all the listed > pages are two pages out and I need to edit each line of the TOC to > correct this. Is there any way for the TOC to be set to do this > automatically? > Are you talking about Scribus or LibreOffice (LO)? This list is about LO. If you mean LO, then you should use a different page style for the first two pages and reset the page count on the third one. -- Piet van Oostrum <pie...@vanoostrum.org> WWW: http://piet.vanoostrum.org/ PGP key: [8DAE142BE17999C4] -- 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: Urgent LibreOffice 5.2.5.1.
Tom Davies <tomc...@gmail.com> writes: > Hi :) > I'm not sure how to clear the error-log. Does it appear when you start-up > LibreOffice? Sometimes when you start LibreOffice it asks if you want to > recover the document you were last working on. Sometimes there's a list of > several documents to recover. Most times if you just cancel that message > the documents are completely up-to-date and all fine. > regards from > Tom :) > That usually means LO did not close properly the last time it was run. Just cancel and the list should be empty. -- Piet van Oostrum <pie...@vanoostrum.org> WWW: http://piet.vanoostrum.org/ PGP key: [8DAE142BE17999C4] -- 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: Libre Writer - special characters
V Stuart Foote <vstuart.fo...@utsa.edu> writes: > Dave-3 wrote >> That's interesting. If I try every possible combination of this method >> with Writer under Win 7, all I get is a lower case x. It this something >> peculiar to Linux or OSX? > > Added for the 5.1.0 release. It works with all OS, see tdf#73691 > <https://bugs.documentfoundation.org/show_bug.cgi?id=73691> , with some > adjustments for locale. > > Just verified the +x functions as intended on Windows 7 sp1 (a Right > Alt key, will end up as AltGr on some keyboard mappings for some locals, but > the l-Alt should always work). > > Try with a reset user profile. On MacOS it is ALT+CMD+X -- Piet van Oostrum <pie...@pietvanoostrum.com> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: must press enter/return thrice to force new paragraph (sometimes)
Dwain Alford wrote: > hello, > > i had this same problem with open office. i don't understand. i set style > prefs and added some new > ones. there is a problem with the new one i call block 0.5. i also created a > new default document. > i set line spacing to single and no bottom paragraph spacing. seems this is > where the problem > begins. > > the new default document: > > i type a line. press enter/return twice and the cursor stays under the line > until i press enter/ > return again. then the problem goes away, until later in the document or not > again. hit or miss. > > the block 0.5 settings are based on the text body indent settings. the > before and after text is > set at 0.5. i highlight all of the text to be blocked and double click the > style setting. the > second and third paragraphs change, and the first one does not change. > > i have attached a test document to see if anyone else gets the same result. > i typed a two line > paragraph and the same press three times to force a paragraph is still a > problem. i have > duplicated this on the windows os as well. i can't remember if i had the > same problem when i was > using linux or not. > > sure would like to resolve this problem. [...] > cheers, > dwain > x[DELETED ATTACHMENT force paragraph test.odt, Open Doc] I set the reply to the libreoffice users list, as the developers list wasn't the proper one. I looked inside your document, and it appears that the first paragraph is inside a list, with the paragraph as its only list item. And it is a list with no bullet and no number. I have no idea how you got this. But that's why it behaves differently. So I clicked in that paragraph, and then clicked on the "Toggle Bulleted List" Icon. Then a bullet appears, which you obviously don't want. So click on this icon again to remove the bullet. After this the paragraph behaves normally. By the way, I didn't see any "block 0.5" style in the document. All the paragraphs had "Default Style". -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Default font in LO calc
Ian Whitfield wrote: > > Next I tried starting a new Spreadsheet, changing to the Font and size I > want, (which is what I've been doing for a couple of years or so), and > then saving this as a Template with the name 'Default'. I then close > down the program and re-start it and it comes up with Liberation Sans 10 > still *GRR!!!* That's not enough. You also have to designate it as the default template. The name doesn't do that. Go to File > Template > Manage Templates, select the template and set it as the default template. See my posting. > > This should be one change in the Options Menu - "Set Default Font and > Size". Why all these hoops to jump through! > It's no wonder some people leave LO for other programs!! Next time, somebody wants an option to set the default page size, or the default background color, or ... Putting it all in a template is much easier than having options for everything -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Default font in LO calc
Ian Whitfield wrote: > Thanks All > > But still no joy!! Why does this have to be so difficult!!?? None of the > ideas about using the Side-Bar do anything that makes any sense. > > So I thought I would try Paul's idea and try and edit the Default > Template but I can find no reference in the Drop-Down options in the > Menu Bar for Templates or Edit Templates. So where do you find this and > edit it?? > > This should be as easy to do as it is in Scribus!!! Why make things so > difficult?? > It had been posted before, but I'll repeat: (This is LO 5.3.0.3 on Mac) File > New > Spreadsheet Side Bar > Styles and Formatting (or Format > Styles > Styles and Formatting) > Cell Styles (icon) > Default Right Click Modify.. Set your font and font size > OK File > Templates > Save as Template Enter a name (e.g. Default), select category "My Templates", check "Set as default template" > Save In other versions you might have to do File > Templates < Manage Templates, Filter Spreadsheets, to set the template as default. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Default font in LO calc
Philip Jackson wrote: [...] > If I prepare a new blank spreadsheet with my preferred font and save it > as a new template, whenever I open a new spreadsheet by File > New > > Templates > Spreadsheets tab > select my new template > click Open, I > get a new blank spreadsheet with my fonts I selected. So this is > available as a workaround but it involves a lot of clicks just to get > what is needed. More clicks than it takes to change the font in the > default spreadsheet. If that template is set as default template then all that is not necessary. Just File > New > Spreadsheet will create a new spreadsheet based upon the template. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Default font in LO calc
Ian Whitfield wrote: > *Thanks Bruce* > > BUT that does not work!! > > Top Right Icon is 'Properties' not 'Styles and Formatting' and it is > showing the Font and Size I want. > > But when I select 'New Spreadsheet' the "default" Liberation Sans 10 > still comes up!! > > I don't want or need a Template I just want the Font and size that I > selected to be the Default for all new Spreadsheets!! > If you want to change the default font, and setting the default template is the way to do it, why would you not want that? -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Bar chart
love sidhu wrote: > Hi All, > > I am working with libreoffice writer and I want to make an interactive pdf > form template having different fields, mostly created using developer mode. > > Problem facing: > Most fields I am able to create but I wish to know whether is it possible > to create a bar chart > which changes it's values as per the user inputs after* we export it in pdf > format* ? Other fields(like text box etc) can be filled in pdf format but i > didn't find any information regarding barchart. > > P.S. - Any help will be highly appreciated. > P.P.S.- I have attached the pdf and odt format for better understanding. > Thanks > Lovepreet > Attachments are not allowed on this mailing list. They are removed. You can either post your attachment somewhere in the cloud and include links, or use the Nabble interface (see http://www.libreoffice.org/get-help/nabble/). -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: XML document
Alexander Thurgood wrote: > Le 17/08/2016 à 18:35, Tom Morton a écrit : > > Hi Tom, > > > This is impossible tho. If I deleted these sections I would have had to > > have > > deleted them separately as they were not together. And also if I had of > > deleted them, the footnotes would have disappeared also? I would have had > > to > > have highlighted each paragraph and deleted them and made sure I didn't > > delete the citation... I remember perfectly saving my paper, exiting Libre > > Office Writer and then going to bed. There's just no way. > > > > I'm not saying that there wasn't a problem with LibreOffice, who knows > it could well have been a "Heisenbug"-type scenario that only occurs in > some specific, seemingly random circumstances - e.g. saving to network > drive where the connection fails, saving to USB key, power surge/outage, > etc. As I wrote in a previous message, I saved one of my documents as MS 2003 XML, and it was severely broken. A large part was missing, so this doesn't seem an intermittent bug, but something structural. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: XML document
I tried to save one of my own documents as MS 2003 XML, and it also contains only a part of my original document. Apparently the MS 2003 XML output filter is severely broken, and it should be repaired, or at least be disabled as long as it in this state. There probably isn't a good enough unit test for it in the build process. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: XML document
Alexander Thurgood wrote: > Le 17/08/2016 à 14:52, Tom Morton a écrit : > > Hi Tom, > > I opened the XML file in Word 15.24 for Mac OSX > It only contains 2 pages (492 words). > > I opened your ODT file in LO530 alpha (my own master build) > It too only contains 2 pages. (483 words) > > Both documents are substantially identical. > > Alex That was MY ODT file, which apparently reached the original folder :) -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Tom Morton shared "Dissertation" with you
Tom Morton \(via Dropbox\) wrote: > Hi there, > > Tom Morton (tws.mor...@gmail.com) invited you to edit the folder " > Dissertation " on Dropbox. > > Tom said: > "Hello, > > I was writing my dissertation yesterday using Libre Office Writer. I > accidentally saved it as 2003 XML document. > > I had written 3000+ words and now I can not get the words back. > > However, when I open the document in Libre Office Writer, It comes up saying > that there is 3000+ words in the word count and 6 pages in the properties > but I can only see headers, some footnotes and two small paragraphs. My hand > in is on monday and I'm having a nightmare right now. > > if i open the document in anything other than Libre Office Writer, it only > appears in formula or code. > > I am going to attach the document now. > > Thanks for your help in advance. " > > Go to folder[1] > > Enjoy! > The Dropbox team > > [1]: https://www.dropbox.com/l/scl/PhCWhej6ONTpdPrSFdlZ5g?text=1 I looked into the file, and when I open it in LO (5.2), it indeed says 3362 words, 20511 characters. But that is just a number stored in the file. As soon as you do something (like add a space), it has to recalculate the number of words and it comes down to 292 words, 2980 characters. I looked inside the xml file, and that really is all there is. There is no other hidden or invisible text. So if this xml file is all you have, I am afraid the rest is lost. I saved it as ODT in the folder but I don't know if that will reach you also or if it is just a local copy for myself. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Problem Installing Dictionaries
Jonathan Allen wrote: > Hi All, > > I'm having problems installing the English dictionaires into LO. This is > with LO on a fully up-to-date Fedora 23 laptop. The .oxt file downloads > and appears to start. Then I get a valid but empty pop-up screen with just > an 'OK' button, while the blue progress bar flashes on a fairly rapid but > intermittent basis. Otherwise LO is completely unresponsive and needs to > 'Force Quit' to back out. This happens both as 'root' and an ordinary user. > > How can I move forward from here and install the dictonaries so that the > spell-check and thesaurus options start working? I have seen that happen also on Mac OS X. When opening a .oxt file, LO hangs. Better go to Tools > Extension Manager > Add. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Numbers and Pages files
Alexander Thurgood wrote: > Le 10/08/2016 à 09:28, MENGUAL Jean-Philippe a écrit : > > Hi, > > > > > Does an extension exist to open documents written with Pages or Numbers > > utility (Mac office suite)? > > > > You should be able to open them in LibreOffice without having to install > any extensions - which versions of Pages or Numbers are you using ? > > Alex > > PS : Having just tried to drag and drop a Numbers 3.6.2 (OSX 10.11.4) > document onto a running LO5142, I see that that doesn't work. Hmm. > Only older versions of these can be imported. Apple seems to keep the document structure of newer versions secret. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] python macros article
Jim Byrnes wrote: > A while ago I read an article about updates to python uno in LO to make > it easier to use. At the time I didn't have the time to really pursue > it and forgot to bookmark it. Now I can't find it again. > > Does anyone maybe have a link to such an article? > > Thanks, Jim https://conference.libreoffice.org/assets/Conference/Aarhus/Slides/MatthewFrancisPyUNO.pdf http://nabble.documentfoundation.org/PyUNO-usability-improvements-td4151556.html -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Data Range in Calc
Mike Scott wrote: > On 08/07/16 02:01, Pat Brown wrote: > > Mike, the problem is that when I double click on the chart and I right > > click, none of the options is "Data Ranges". The closest I can come is > > "Data Table.." This is what has been frustrating me. I wonder if it > > would help to re-install LO as there may have been some sort of > > corruption during my last install. I am using version 5.1.3.2 on Win 7 Pro. > > 5.1.4.2/mint here. But it's behaved the same for as long as I remember. > > OTOH, I'm charting a set of cells within the spreadsheet. If I > double-click the chart, and select "View" from the menu bar, then "Data > Table" is a greyed-out option. I have not the foggiest idea what it does > -- the help system unhelpfully tells me: > >"Opens the Data Table dialog where you can edit the chart data. > >The Data Table dialog is not available if you insert a chart that is >based on a Calc sheet or on a Writer table." > > But if I double-click the chart and then R-click somewhere on it, I get > different menus depending on what's been clicked (background, grid, > point, trend line), but they /all/ finish with chart type, data ranges, > copy, paste. > If you double-click on the chart, then there is Format > Data Ranges in the normal menu (and a lot more). -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: How to NOT turn (c) into a symbol
Thomas Blasejewicz wrote: > Tools -> Autocorrect options -> "Replace" by language: > All -> no entries > English -> (C) -> deleted -> no change > Default - Japanese -> deleted -> no change > German/Germany -> deleted -> no change > German/Austria -> no fitting entry* > German/Belgium -> no fitting entry > German/Lichtenstein -> no fitting entry > German/Luxembourg -> no fitting entry > German/Switzerland -> no fitting entry > > *"no fitting entry" means: there IS the item ".*(c)", but that is > NOT what I am typing. .*(c) looks like a regular expression. I don't know exactly what the interpretation of it is when doing autocorrection but I would suspect that these should also be deleted. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: about libreoffice fonts and persian and arabic diacritics.
CVAlkan wrote: > I know for a fact that there are others on this list who are familiar with > and have accomplished what he is trying to do, so if we can get him squared he -> she, him -> her -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Creating a thick line in Libre Draw and Writer
Piet van Oostrum wrote: > Kruno wrote: > > > I find inserting horizontal line quite odd and I avoid it... > > > > So you write a paragraph and then go Insert → Horizontal rule and your > > paragraph font size shrinks to 6 pt. Why? > > > Maybe the format for the Horizontal Style has a font size of 6pt in your > settings. > > > If there is necessity for linking bottom border to a paragraph with > > small font size or such, why doesn't 'Insert → Horizontal rule' inserts > > new (empty) paragraph instead? Why change format of a paragraph which is > > not intended to bi changed with action which is not intended for > > changing content's formatting? > > I would also have expected Insert Horizontal Line to start a new paragraph. > Instead it changes the current paragraph to paragraph style Horizontal Line. > Not nice. Actually, thinking about it: THIS IS DEAD WRONG! Insert a horizontal line should definitely NOT mean: change the whole paragraph layout, including fonts, line spacing, indentation, font color, background color, etc. Suppose you have your carefully defined paragraph style, now you want to insert a horizontal line below the text, not as part of the text. Now the whole paragraph style changes to the predefined Horizontal Line style. That's not what I mean with Insert horizontal line. So it should either insert a new paragraph with only a horizontal line, or it should add a horizontal line to the current paragraph by changing its bottom border attribute only. The latter option robs you of the possibility of styling the line in advance. Of course you can just hit RETURN first, and that's what I do when I insert a horizontal line. I must admit that I almost never insert horizontal lines, except in tables. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Creating a thick line in Libre Draw and Writer
Kruno wrote: > I find inserting horizontal line quite odd and I avoid it... > > So you write a paragraph and then go Insert → Horizontal rule and your > paragraph font size shrinks to 6 pt. Why? > Maybe the format for the Horizontal Style has a font size of 6pt in your settings. > If there is necessity for linking bottom border to a paragraph with > small font size or such, why doesn't 'Insert → Horizontal rule' inserts > new (empty) paragraph instead? Why change format of a paragraph which is > not intended to bi changed with action which is not intended for > changing content's formatting? I would also have expected Insert Horizontal Line to start a new paragraph. Instead it changes the current paragraph to paragraph style Horizontal Line. Not nice. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Creating a thick line in Libre Draw and Writer
Kruno wrote: > > 02.07.2016 u 23:17, charles meyer je napisao/la: > > Now, the tricky part. > > > > How do I make that straight line thicker? > > > > In Libre Writer, I’ve opened Insert > Horizontal Line and it inserts a > > line but I don’t see how you can make that line thicker? > > Use styles and there find paragraph style 'Horizontal line'. Right click > it and choose 'Modify'. > I had not noticed that there is a special paragraph style for Horizontal Line. Never too old to learn. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Creating a thick line in Libre Draw and Writer
Kruno wrote: > > 03.07.2016 u 00:36, Piet van Oostrum je napisao/la: > > The line actually is the bottom border of a paragraph. So you can change > > the thickness by positioning the cursor just above the line and then > > Format > Paragraph > Borders > Width. > > Wouldn't that change thickness to just one occurrence of horizontal > line. Modifying it appearance trough styles makes it uniform throughout > a document, if horizontal line inserted more then once. > > Kruno Yes. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Creating a thick line in Libre Draw and Writer
charles meyer wrote: > Piet, > > Thank you so very much. > > That works in Libre Writer. > > Is there a way to create and thicken a line in Libre Draw, too? > > Thank you again for your helpful instructions and explanation. > > Charles. Yes, select the line, and then Format > Line. There is also a Line Width field in the Toolbar on to where you can change the line width. For me it is on the righthand side. If it is not there, you can get it with View > Toolbars > Line and Filling. You can also set the line width there before you draw the line. That is easier if you want to draw several lines with the same thickness. You can find the manuals for LibreOffice here: https://www.libreoffice.org/get-help/documentation/ It is very useful to read through them. It takes some time, but then you get an idea of all the possibilities and you have an handy reference to look things up. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Creating a thick line in Libre Draw and Writer
charles meyer wrote: > Hi Folks, > > I hope I’m describing this correctly. > > I wanted to create a straight line horizontally across the page in > Libre Writer or Draw (that would be preferable). > > I’m using Libre Writer/Draw/Offcice 5.1.1.3 > > It’s my understanding that when I choose the key on my PC keyboard > next to the zero key that I’m choosing an ASCI character? > > Anyway, I use that key (line key) and keep pressing that key until I > reach a line length across the page I desire and it creates a straight > line. > > Now, the tricky part. > > How do I make that straight line thicker? This usually is not a proper way to draw a line in Writer. It actually is not a line, but a sequence of character that happen to look like aline (depending on the font). > > In Libre Writer, I’ve opened Insert > Horizontal Line and it inserts a > line but I don’t see how you can make that line thicker? > The line actually is the bottom border of a paragraph. So you can change the thickness by positioning the cursor just above the line and then Format > Paragraph > Borders > Width. > I’ve highlighted the entire line and hit bold – still no thicker. No, because the line is a border and bold only applies to characters > > I’ve highlighted that entire line and chosen a larger font (as large > as 26) still no thicker. Same here, the line is not characters. > > I’ve chosen Insert > Shape (singular not plural Shapes as in earlier > versions there is the plural Shapes) > Line > then Line again and it > inserts nothing. That is the other way to insert a line, but after that selection you have to draw the line with your mouse: click where you want the line to start and then drag to its endpoint. To keep it precisely horizontal, press SHIFT while dragging. The you can select the line and change the thickness with Format > Text box and Shape > Line Instead of Insert > Shape etc. you can also make the drawing toolbar visible with View > Toolbars > Drawing. There is a line icon (a small diagonal piece of line). Maybe that icon is also visible in the top toolbar. > In Libre Draw, I choose Format > Line where you can adjust width which > appears in the little box to be thicker except when I click OK there > is no line in the Libre Draw document. You first have to draw a line, in the same way as I described above by clicking on the line icon in the drawing toolbar. Then drag a line across the page. > > Thanks so much for your help. > > Charles. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to NOT turn (c) into a symbol
Alexander Thurgood wrote: > Le 28/06/2016 à 20:37, V Stuart Foote a écrit : > > Hi Stuart, > > > tdf#73691 <https://bugs.documentfoundation.org/show_bug.cgi?id=73691>-- > > add unicode conversion shortcut like word (alt+x) has been in the source > > since August 2015, and is included in 5.1 release onward. > > > > Doesn't work on OSX 10.11.5 with LO 5132. > > What many people seem to ignore when making shortcut changes in LO code > is whether or not they will work on OSX...as a result, many don't > (including the example you point to above). Option + command + x -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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 NOT turn (c) into a symbol
Thomas Blasejewicz wrote: > Good evening > I have tried all sorts of settings to prevent LibreOffice from changing > (c) into the copywright symbol. > So far nothing has helped. > Setting it as an exception does not work. > For reasons I do not understand the conversion is NOT made when I type > (C) (=capital C). > > What is the trick required to stop Libreoffice from doing this conversion. > > If possible, I prefer NOT to turn of autocorrect entirely. > > Thank you. > Thomas Well, you have Tools > Autocorrect > Autocorrect options and there you delete that specific replacement. BUT: you have to do it for the language that your text is in. Apparently your text is not English (USA), because that has the (C) [Capital C] replaced by ©, not the lowercase (c). So check the language setting of your document (or that part of the document). -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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 display text using a research function
valcoteau wrote: > Hello, > > I have two columns A and B > > Column A contains emails and column B is empty > > I wish that each time in column A is detected certain words like 'trans', > 'sped' ... can be directly displayed in column B on the same line the word > 'transportation and Logistics'. > > I don't know which function to use > > Thanks in advance for your help > > Regards Something like this (in B1 and copying down): =IF(OR(ISNUMBER(SEARCH("trans";A1));ISNUMBER(SEARCH("sped";A1)));"Transportation and Logistics";"") -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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 - Count a "similar sequence"
cje wrote: > Is there a way to count a sequence of data as long as they are similar? > We have a datasheet were the sales of our sales men are imported. > One of the information we’re using is counting for how long one sales man > has been on top. > > Ex.: > Sales man#1 > Sales man#1 > Sales man#1 > Sales man#2 > Sales man#1 > Sales man#3 > > Is here a way that calc can detect that the data is changing and stop the > counting? > The above sample should return 3 > > Looking forward to any suggestion. You can write a macro for that, e.g. in Basic. Here is one for the above problem: Function CountEquals(r()) ' r must be a one row or one column range If Lbound(r,1) = Ubound(r,1) Then idx = 2 Else idx = 1 End If num = 0 idx1 = Lbound(r,idx) idx2 = Lbound(r,3-idx) first = r(idx1,idx2) While idx1 <= Ubound(r,1) and idx2 <= Ubound(r,2) If r(idx1,idx2) = first Then num = num + 1 End If If idx = 1 Then idx1 = idx1 + 1 Else idx2 = idx2 + 1 End If Wend CountEquals = num End Function ---- Now you can use in a cell, e.g. =CountEquals(A5:A10) -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] undo functionality
Steve Edmonds wrote: > Correct, there are no undo settings in my 5.1.2 from openSUSE, although > it is in the help. > steve > > On 2016-06-02 07:16, B.S. wrote: > > Also there is not actually any such option in the version I use. There is an option under Advanced > Expert Configuration > org.openoffice.Office.Common > Undo The default is 100 steps which should be enough for normal use. But you can increase it if you want. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Sorting in Writer
Piet van Oostrum wrote: > As far as I know, steps 4 and 6 cannot be done with the regular find and > replace as you can't specify a paragraph mark in the replace. At least i > don't know how to. Well, in the meantime I found that \n in the Replace field with the regular Find and Replace represents a paragraph break. In the Search For field $ should be used. The recipe with the regular Find and Replace then becomes: (all Find/replace with "Regular expressions"" ticked): 1. Choose two characters that do not appear in your text. I chose # an §. 2. Mark every song title, except the first one, with # at the beginning of the line. 3. Find & replace: Search For: $ Replace With: § Replace all 4. Find & Replace: Search for: §# Replace With: \n 5. Select all text and then Tools > Sort. 6. Find & Replace: Search for: § Replace with: \n -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Thank goodness for opening legacy formats
V Stuart Foote wrote: > Well sure. But remember, even if some of the "legacy" deprecated document > formats are eventually removed The Document Foundation sponsors an archive > of prior LibreOffice project release builds. > > http://downloadarchive.documentfoundation.org/libreoffice/old/ > > So you are covered either way :-) Until your current O.S. no longer supports these old releases, or your current hardware no longer supports the relevant O.S. releases, or the relevant older hardware is no longer available :) -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Sorting in Writer
Pat Brown wrote: > I received a document which, essentially is a document of song lyrics. > However, they were typed in at random, as they were received. I now want to > sort the songs by song title and can't figure a way to do this. The format > is the following: > The song title, the artist, the lyrics. Each line is essentially a new > paragraph so I cannot sort by paragraph. I need some way of marking the > beginning and the ending of each song, having the contents between these > two marks recognised as a unit, and then sorting these units. Does anyone > have any ideas, without having to select each song, cutting it and then > pasting it in its correct position alphabetically > Here is a recipe that could help you, but it requires the Alternative Searching extension (aka Alternative Find & Replace) 1. Choose two characters that do not appear in your text. I chose # an §. 2. Mark every song title, except the first one, with # at the beginning of the line. 3. With Alt. Find & replace: Search For: \p Replace: § Check "regular expressions" box Replace all 4. With Alt. Find & Replace: Search for: §# Replace \p ("regular expressions" box still checked) 5. Select all text and then Tools > Sort. 6. With Alt. Find & Replace: Search for: § Replace \p ("regular expressions" box still checked) As far as I know, steps 4 and 6 cannot be done with the regular find and replace as you can't specify a paragraph mark in the replace. At least i don't know how to. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] a question about libreoffice writer:
nasrin khaksar wrote: > hello every one. > my sister wrote one document in microsoft word. > i offered her libreoffice and encouraged her to use it. > when she opened the document with libreoffice writer, she told that > before of many words - is added to her document while openning with > libreoffice writer! > she did not add - to her documents and she did not want this unwanted > changes for it. > could you please help her to solve this problem? > thanks for your help and god bless you all. I am afraid that will be difficult without you giving more details. Maybe it has to do with the language and/or script in which the document was written? -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Libre Writer - Windows - Title Case
charles meyer wrote: > Hi Good Folks, > > I Googled this but amongst the posts which included suggestions for > Open Office and Ubuntu Libre Writer I did not see how you can do a > Title Case in Windows Libre Writer > > Title case is this - Refinanced Loans On Three Separate Properties. > > Under Change Case there is Toggle (just capitalizes), All caps. small > case but no Title case listed. > My LibreOffice (5.1.3.2 on Mac OS X) also has a Capitalize Every Word in that submenu. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: Fwd: [libreoffice-users] Re: The Save Tool could not be dimmed
toki wrote: > Regina wrote: > > >Do you have got the most current LibreOffice version? It should have icons > >that indicate saved/unsaved > with a change in the icon. For the icon Galaxy, an unsaved icon will > have a yellow star on the icon, for example. > > That works if, and only if Breezy is set as the default icon theme. > > jonathon Well, I use Galaxy, and the icon is there, only the star is red. And I tried some others, like Tango or Sifr and it still is there. So at least the 'only if' part is not true. I get the impression that the icons in the status bar are theme-independent. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: The Save Tool could not be dimmed
toki wrote: > Anne-ology wrote: > > Curiously wondering why you'd want this to be dimmed; > > When working on two or three documents, this is an easy way to see which > documents have been saved, and which one's still need to be saved. > When a document takes a second or two to save, then the additional time > from saving the "wrong document" is negligible. > But when it takes five to ten minutes to save the document, saving the > "wrong document" can can have a negative impact on productivity. > > > if it were so, then you would be unable to save the document ;-) > > When a change has been made to the document, it automatically becomes > undimmed. When you have the status bar enabled, there is an indicator there whether the document has been modified. It is a small rectangle with a check mark if the document is not modified and a red star if it is modified (this may depend on your theme). You can even save the document by double clicking on that icon, and it won't do that if the document is not modified. Much easier than checking the menu. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Simple sum in column getting zero in libreoffice calc 5.
shirish शिरीष wrote: > Dear Piet, > > Yours and a private mail are bang on target. Libreoffice thinks that > those 'numbers' are text. This I was able to find via View > Value > highlighting . > > Now non-plussed how to tell libreoffice to tell it to treat them as > 'real numbers' ? One way you can get numbers as text is when you import a CSV file, and forget to merk the column as numbers. Or when you paste from plain text and forget the same. One way to get them as numbers is to add a function in another column, containing =NUMBERVALUE(B2) if the first number is in cell B2. Then copy this down for all numbers in the original column. Now you have a copy of your numbers, and they are really formatted as numbers. Now Copy this column with Edit > Copy and do a Edit > Paste Special over the original "text numbers", selecting only "Numbers". -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Simple sum in column getting zero in libreoffice calc 5.
shirish शिरीष wrote: > Hi all, > > I was trying a simple addition in column =SUM(B2:B8) > > but that didn't work . I am getting the output as zero. > > Could somebody look at it and share what is/was wrong ? > > Sharing an example worksheet for the same. > -- The mailing list doesn't accept attachments. You could use Nabble for that (http://www.libreoffice.org/get-help/nabble/) The simplest explanation would be that your "numbers" are entered as text. Check your cell format. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)
Walther Koehler wrote: > I posted the tag, which I think is the relevant, before: > > >>> blabla > I assume "P2" refers to printable, suppressing output on paper. > if you have a simple command line No, "P2" is just a name, it could be anything. You would have to look up the style definition of "P2" and see if it has a text:display="none" in it. And there can be more than one of these styles, depending on the other character attributes, like font, size or color. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)
Robert Funnell wrote: > Felipe - > > The hidden text being discussed here is described at > https://help.libreoffice.org/Writer/Hiding_Text > That doesn't seem to be what you're talking about? > > - Robert > That is missing one important case, that I think we were talking about. It is normal text, that has been formatted with Format > Character > Font Effects > Hidden. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)
Luuk wrote: > > Are you saying that there are still 'hidden formated text' things in the > textfile that is created when one does do 'File/SaveAs/.txt' ?? > Save as .txt des save all text, including hidden text. Just try it out. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: free text editor (was: [libreoffice-users] delete hidden formated text in odt
Walther Koehler wrote: > Am Mittwoch, 4. Mai 2016 schrieb Piet van Oostrum: > > Walther Koehler wrote: > > > Thank you. > > > Your procedure is principally what I need. > > > However, quite complicated for routine work. > > > > > > Walther > > > > The first part (replacing hidden text with colored text) could be done with > > a script. > yes, and the whole procedure could be packed in a basic makro. > The script can be called by a shell command within a makro, the replace > functions realized with dispatcher commands. > > Let us try it. > > Walther Even simpler: Here is a Basic macro that just walks through the document, and deletes all hidden text. No unzipping, editing, etc. It just works inside the ODT document in LO. It only considers normal plain text, i.e. not inside tables, sections, frames, footnotes, etc. If you want that, these have to be specially coded. REM * BASIC * Sub Main Dim oEnum 'com.sun.star.container.XEnumerationAccess Dim oPar Dim oSecEnum'com.sun.star.container.XEnumerationAccess Dim oParSection oEnum = ThisComponent.Text.createEnumeration() Do While oEnum.hasMoreElements() oPar = oEnum.nextElement() If oPar.supportsService("com.sun.star.text.Paragraph") Then oSecEnum = oPar.createEnumeration() Do While oSecEnum.hasMoreElements() oParSection = oSecEnum.nextElement() If oParSection.TextPortionType = "Text" AND oParSection.CharHidden Then oParSection.setString("") End If Loop End If Loop End Sub -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)
Walther Koehler wrote: > Hi Robert > > Am Dienstag, 3. Mai 2016 schrieb Robert Funnell: > > Walther - > > > > Could you open your content.xml with Emacs and record a macro to > > find and remove the hidden text? (I'm not sure that qualifies as > > simple.) > Unfortunately, I am not used to emacs, although I know it is a very powerful > editor. Here is a simple recipe that you can use with any text editor (including sed): Please do this on a copy of your original document, or make a backup copy first. Unzip from your document the file content.xml: > unzip HiddenText.odt content.xml Edit content.xml, replace all occurrences of text:display="none" with fo:color="#800080" This replaces the hidden text with a colored text. I have chosen magenta (#800080) here; you should choose a color that is not used in your document. > sed -e 's/text:display="none"/fo:color="#800080"/' content.xml > content2.xml Rename the new file to content.xml > mv content2.xml content.xml Replace content.xml in the ODT file > zip HiddenText.odt content.xml Now open the file in LibreOffice, and replace the magenta-colored text with empty text. Edit > Find & Replace Other Options > Format > Font Effects > Font color > Magenta I found that Replace All did not work. It said that it replaced the text but it didn't (LO 5.1.2.2 on Mac OS X). The alternative Replace and Find extension, however, did work. There you choose [:::CharColor=8388736::] as search criterium (colors are given in decimal). -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: justification issues
Mike Scott wrote: > On 30/04/16 01:20, Brian Barker wrote: > > > > > Oh, and if you insert a line break (not a paragraph break) after "XXX", > > you will see exactly the improvement he would like to see happen by > > default. > > > Brian, thanks for clarifying my intent, and verifying my observation. > > I'm still wondering if it's worth putting this in formally as an > enhancement request -- or would it be so unlikely to get looked at that > it'd not be worth the effort? > Do you mean the better paragraph breaking algorithm, using the whole paragraph rather than line-by-line? I saw some discussion (or maybe just one message) on the developer's list about implementing the TeX line breaking algorithm, which does that. So it might be useful to check if such a request has already been issued. Another thing that might help, to avoid the letterspacing, is to disable Tools > Options (LibreOffice > Preferences on Mac) > LibreOffice Writer > Compatibility > Expand word space on lines with manual line breaks in justified paragraphs. Then a manual newline at the end of such an ugly line does not justify the line. But the best thing in my opinion (besides the TeX algorithm) would be if you could just switch off letter spacing completely. I hate it and I haven't found an option to disable it. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] very slow loading of a ods file
John R. Sowden wrote: [...] > seconds. After copying to a test file, I deleted the pages other than > page 2 (with the dates), one page at a time, saving the file each time. > I then try to more the cursor after December. No change for each page > deleted. On page 2 I started deleting columns, doing the same test > (save/test). No change all the way to the date column alone-no change. > Could you post a copy of that last file with only the date column somewhere so that others can test it? -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: about libreoffice and tables:
nasrin khaksar wrote: > hi. > i am not shure, because i did not change any format and i dont know > how to do it. > but, only tested docx file and the docx crashed for me in version and > did not crashed in version 5! > without table it was great and opened in all libreoffice versions > which i tested. > Which means you should switch to version 5. LO 5 is much better, especially in the area of compatibility with MS office documents. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Select/copy content of a comment
Eric Beversluis wrote: > How do I select and copy the content of a comment? When I open the > comment and try to select its content, all I get is a hand to move the > content around on the page. > (Eg, I've got a long URL in the comment that I want to copy and past > into the browser.) The page on inserting and editing comments doesn't > seem to address this function. > Cmd-A Cmd-C on a Mac Ctrl-A Ctrl-C on eWindows/Linux -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Math Symbols get corrupted
Roberto Inzerillo wrote: > I have been using Libreoffice 5.1 under Windows and had no problem with > Math symbols before. > > But today, after installing and uninstalling a few programs, Libreoffice > suddenly started displyaing some symbols in a wrong way. > > This is a screenshot of what I'm talking about: > http://www.robertoinzerillo.com/temp/math_01.jpg > The "vector" symbol over the letter "A" is being rendered as a series of > squares :-( > This is not the only symbols which has been corrupted. > > I already followed a few hints found in the internet, such like > downloading and installing opens___.ttf file again; but had no luck :-( > > Any suggestions? This definitely looks like LO doesn't know the OpenSymbol font or forgot how to use it. Can you try the following? In a Writer document, choose OpenSymbol as font, and then Insert > Special Character You will get a table of characters. About halfway the table, just above a sequence of Greek characters (the second set of Greek characters) ΓΔΘΛΞΠΣ, there is a vector symbol. Can you insert that? You can also check in a Formula with Tools > Symbols. (or Catalog, depending on the LO version). Choose symbol set Special, and click Edit. You should get the same table. See if it is there, and then Cancel. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Awkward behaviour of LO Calc
Mike Scott wrote: > > A quick search brings up > https://en.wikipedia.org/wiki/Order_of_operations > > which says > > "There exist differing conventions concerning the unary operator − > (usually read "minus"). In written or printed mathematics, the > expression −3^2 is interpreted to mean 0 − (3^2) = −9 but in > Microsoft Office Excel (and other spreadsheet applications) and the > programming language bc, unary operators have a higher priority than > binary operators" > > Contrary to, eg, perl. > > Ouch! Quite contrary to expectation. Here lie monsters :-) The ODF specification explicitly says that the unary - has higher precedence than ^, which is compatible with Excel. So it is not a bug. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Save/Store files
Heinrich Stoellinger wrote: > Hello, > I am using LO 5.1.1 (latest development version). Since version 5 I notice > that in writer the tab "Speichern" (German for store/save) is not grayed, > even though NOTHING has changed in the file. Is this intentional? > Regards > H. Stoellinger > Salzburg I remember that there had been a discussion in the recent past to always enable File > Save regardless of the document change status. Some people had been complaining about the function being disabled on a non-modified file. I can't find this in the release notes, however. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] anyone knows how to find/replace not-printable glyphs?
Tim---Kracked_P_P---webmaster wrote: > I have a problem with a old book text file. There are 3 or more lines > between paragraphs. I want to reduce them down to only one. > > When I turned the option to view non-printed characters, I get the > "PI-ish" looking symbol - ¶ - that is at the end of every paragraph. > Each extra line has that symbol as its first character. The character > listed in the last line of this text looks like the non-printing > character, but must be different from it, since it gives a "no match > found" error when using it. > > So, is there a way to use that end of paragraph symbol/character to look > for three in a row and replace it with only two? Since some of the > paragraphs have more than 3 extra lines between paragraphs, I could run > that find/replace several times. All I want to show is the symbol at > the end of the paragraph and the one between paragraphs. Since there > are at least 300 pages to the book - in text format - it would not be > practicable to do this manually. > > Actually, I am trying to fix a bad .epub book. I found that if I > convert it to a text file and the convert it back to an e-book format, > most of the formatting issues go away when viewing it with my tablet's > .epub readers [Nook and Pocketbook]. > > So has anyone tried to do something like this, removing blank > paragraphs, i.e. blank lines between paragraphs, as an automatic > find/replace option? As you mention in your last paragraph, it is about blank paragraphs. It is not blank lines between paragraphs. These come from the bad practice to insert so called "blank lines" as paragraph separators, but as you correctly observe, they are additional blank paragraphs. The proper way to get spacing between paragraphs is to set additional space after the paragraph with Format > Paragraph. To get rid of the blank paragraph, use Edit > Find and Replace, Click Other options, and check Regular expressions. In the search field enter ^$ Now you can find/replace the empty paragraphs. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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 application
Tim Lloyd wrote: > Hi, > > Firstly this is the users mailing list. If you want to talk to > developers head in this direction: > > https://lists.freedesktop.org/mailman/listinfo/libreoffice > > or I think you can post without registering here: > > http://www.libreoffice.org/get-help/nabble/ > > However, there may be someone here who can help. Can you provide a > procedure which explains your problem pls? I am afraid the explanation > below does not mean much to me. The developer list is not for communicating user problems. It is only for developers communication about the development. Bugs can be communicated in the bug tracker, see https://wiki.documentfoundation.org/QA/BugReport -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] 'Sheet' menu for DEB version of LO 5.1 Calc
Joe Conner wrote: > Ver Version: 5.1.1.3 installed on Ubuntu 15.10 does have the sheet menu. > > On 03/12/2016 04:55 PM, Bruce Hohl wrote: > > Can someone comment on the status of the [missing] 'Sheet' menu for DEB > > version of LO 5.1 Calc? > > If you have been fiddling with your menus in the past, the Sheet menu may not appear. The solution then is to reset the menus to the default. In a Writer document: Tools > Customize... > Menus > Reset. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] LO 5.1 Presentation can't find system browser on OSX 10.11
Stephan Bergmann wrote: > On 03/10/2016 01:28 AM, Marc Grober wrote: > > Clicking on a live link in a LO 5.1 Presentation results in the > > following error message: > > > > "LibreOffice could not find a web browser on your system. Please check > > your Desktop Preferences or install a web browser (for example, Firefox) > > in the default location requested during the browser installation." > > > > In fact Firefox is set as default and doing a command click on a link > > from Writer works fine. > > From looking at the code (shell/source/unix/exec/shellexec.cxx, > sfx2/source/appl/openuriexternally.cxx) that error message can > misleadingly be presented also when a browser /is/ found, but something > else goes wrong when trying to open the hyperlink with the browser. This happens, for example with a link like "htp://www", i.e. a wrong protocol identifier. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Flat XML ODF Spreadsheet (fods) and human-readable diff of content changes
Karl Voit wrote: > Hi! > > I was hoping that LibreOffice is able to maintain a spreadsheet > document in uncompressed XML which I can check-in to a version > control system. With this, I'd like to get a nice visualization of > *content changes*, e.g., by using the version control system > features. This is what I want to achieve. > > > Storing in uncompressed XML was easy via Flat XML ODF Spreadsheet > (fods). I converted a xlsx file to fods and committed it to a git > repository. > > Then I changed once single cell in the fods and committed the > modified file as well. > > Unfortunately, I got *many* changes: > > 1 file changed, 297 insertions(+), 297 deletions(-) > > «git show» shows typical lines like: > > , > | [...] > | - style:parent-style-name="Default"> > | + style:parent-style-name="Default"> > | [...] > | - table:default-cell-style-name="ce11"/> > | + table:default-cell-style-name="ce18"/> > | [...] > ` > > Therefore, the user-made changes are drowned within an ocean of > style-name changes whose purpose is not obvious to me as someone who > is not an expert in ODF format. > > With ... > > git show HEAD|grep "^[\+-].*office:value="|grep -v "table:style-name=" > > ... I was able to reduce the output lines to the content changes only. > > 1) How stable is this solution? I.e., is it possible that I exclude > content changes with this expression as well? > > 2) This git/grep method is not feasible for normal end-customers. Is > there a way to reduce or omit the style-name changes? > I have done some experimentation with the fods format. Apparently when you load a .fods file, LibreOffice will invent some style names, which might be different from the style names in the file (if any) that was saved from the .xlsx. Here are some suggestions that might help (but no guarantee): (1) Load the .fods and save it again before putting it in the version control system. I.e. start from the .fods file and not from the .xlsx file. (2) Give your columns (and cells) named custom styles. I.e. define your own cell styles and apply them to your spreadsheet. In this way LO may avoid inventing its own style names. Hope this helps a bit. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Programming guide for LibreOffice 4.1
John Meyer wrote: > I'm trying to write a macro for LibreOffice 4.1. Which programming > guide should I use? > OpenOffice.org Macros Explained (OOME) by Andrew Pitonyak. OpenOffice.org is not the same as LibreOffice, but for most uses they are close enough. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] LibreOffice 5.1.1.3 Writer new bug?
Carlo Strata wrote: > Hi Everyone, > > I get a strange behaviour with the new 5.1.1.3 LibreOffice Win_x64 on > Microsoft Windows 10, x64, daily updated build 1511, ita gui. > > I get it with this little sequence: > - copy this raw in a new Writer document: >conoscenza dei processi -> semplificazione -> riduzione dei costi; > - move the cursor in front of the first "->" (like this "->|", if "|" is > the cursor); > - press space key on the keyboard; > - you will get (I get): >conoscenza dei processi -> semplificazione -> semplificazione -> > riduzione dei costi; >with the first two arrows correctly auto-corrected with the right > arrow character (but with a duplicate string: twice " -> semplificazione"); > - if you repeat the behaviour with the third fake arrow ("->") you will get: >conoscenza dei processi -> semplificazione -> semplificazione -> > semplificazione -> riduzione dei costi; >with all four arrows correctly auto-corrected with the right arrow > character (but with a triplicate string: three times " -> semplificazione"). > > Am I the only one? > LO 5.1.1.1 on Mac OS X 10.10.5 the same. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] minimum window size
Paul Morris wrote: > Just updated to LO 5.0.5.2 on the Mac and now I find the minimum > window height for my spreadsheets is almost half my screen height. > I like to be able to make a very thin window so I can enter a row > of numbers while still seeing an underlying web page from a > browser. Is there a way to change the preferences so I can make the > window smaller? It was not a problem with the previous version of > LO. I don't know about 5.0.5.2, but on 5.1 on Mac OS X 10.10.5 I can make it as small as I want (actually up to the title bar+0.3mm). -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: background color in cells invisible
1124mars wrote: > Hi, > In Calc the background color feature of cells is not working. > Who can give me any advice in which LO version the background formating is > working properly. > LO V5.0.4.2 on Win7. > Thanks for any ideas, > mars LO 5.1 on Mac OX S 10.10.5 just works. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Verifying LO 5.1 on Mac OS X takes a long time
I have a strange problem with the new LO 5.1 on Mac OS X Yosemite (10.10.5). I installed it and started it up for the first time. Naturally the first time the app gets verified. However the verification took a long time and my computer got almost completely unresponsive. Activity Monitor indicated that kernel_task had growm to more than 6.3GB (real memory). My machine has 8GM memory. It did not take very much CPU time, but everything came virtually to a halt. Even the clock sometimes lagged minutes behind. The verification process took more than 2 hours and 15 minutes, after which I had to leave. When I returned it had finished, so I know it took less than 5 hours. Ater confirming that I wanted to run the application downloaded from the internet, LO continued, but it took at least 10 minutes before it appeared. In the meantime the kernel_task memory footprint still was high, but later it dropped back to more reasonable values. I did this twice, with a reboot in between. The reboot didn't solve the problem. The problem has also been reported on https://ask.libreoffice.org/en/question/64253/libreoffice-513-stuck-on-verifying-mac-os-x-yosemite-10105/ Maybe it warrants a bug report if more people experience this. I also tried LO 5.0.5, and its verification took about 5 minutes (still quite long I think), with kernel_task going up to about 4GB. But at least the system continued to work normally. So what can be the problem with LO 5.1? -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] UNSUBSCRIBE
Steve Gifford wrote: > PLEASE UNSUBSCRIBE ME > See the bottom of each message: To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Problem with Document- Bad Behavior
rgarcia7 wrote: > Greetings. > > https://cloud.openmailbox.org/index.php/s/4ulZUqq3zP3Ewye > > This document gets a blinking white box on pages 60-63, > but i don't know if this a bug or a error in the file structure. > > Document exported from Google Drive (It was uploaded as PDF) as .docx . > > Tested on: > - LibreOffice 5.0.3.2 (Fresh) on Linux Ubuntu > - LibreOffice 4.4.7.2 (Still) on Windows 7 64-bit > > Thanks for your Help. No problem with LO 5.1.0.3 (RC3) on Mac OS X 10.10.5 -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Uninstalling incompatible extension
jwkokc wrote: > After installation of version 5.03, I found that the 'AltSearch" extension > that I had installed for version 4.x is apparently incompatible with the > newer version, but I have not yet located any instructions for removing such > an extension. Now, each time I save a document while exiting from Writer, I > get an error message that files are damaged and will be reconstructed next > time I open them. > > No damage is evident, and no files are listed in the message. I renamed my > user profile as per the on-line instructions, and the message went away, so > I presume it's connected somehow to the presence of the incompatible > extension. However I have customized my system to such an extent that I need > to return to the original user profile to be able to work comfortably. > > Is there a process for removing such material, or must I bite the bullet, > blow away my entire installation (which is on Xubuntu 14.04.3) and install > version 5 anew from the PPA? Tools > Extension Manager... should give you the option of removing the extension. I also noted that the extension gave problems (Basic runtime errors), but when I don't use it, it doesn't do any harm for me. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] badly formed open document format file
Piet van Oostrum wrote: > My Scrivener (2.7 on Mac OS X) does export the with > s inside it, but it also puts its own bullet before > each paragraph so that they now have 2 bullets each in the ODT > file! It appears that the Scrivener 2.7 situation is different than I thought. I tested it on a Scrivener doc with the test page imported from the .doc file (and also by copy/pasting that text). It appears that Scrivener imports the list in a strange way: it makes a list with no bullets as a list attribute, but with the bullets prepended to each list element. So when exporting it to ODT, the list elements get two bullets: one from being a list element, the other in the text. By correcting the list after importing it will be exported correctly. So the problem is on the import side, not the export side. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] badly formed open document format file
Philip Jackson wrote: > I wonder if anyone on the list can provide any clues as to why a file is > badly formed ? > > The file concerned is an export from another application (Scrivener) > which provides the option to export as an open document odt. The test > file comprises 2 paragraphs of text followed by a third paragraph > incorporating a bullet list and completed by a fourth text paragraph. > > When this file, testexport.odt, is opened in LibreOffice Writer, the > bullets and their associated text items are completely missing. Other > text paragraphs are good. > > Exports in other formats (.doc, .pdf, .rtf) are correct and can be read > by LO or Okular (pdf). > > I am hoping someone more clued up than me can 'analyse' the test files > and provide a clue as to where the odt file is badly made. The bulleted paragraphs are in the file as a , but they are not inside a element as required. My Scrivener (2.7 on Mac OS X) does export the with s inside it, but it also puts its own bullet before each paragraph so that they now have 2 bullets each in the ODT file! -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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 numbering problem
Brian Barker wrote: > You could unzip the .odt file, extract > content.xml, examine this to determine how > Automatic and Character footnote anchors are > differently represented, edit it as necessary, > rezip the .odt file using the edited content.xml > - and hope it works! But I don't recommend this. > I tried this out and it appears to be easy: The text is in the content.xml file in the zip file. The footnotes are of the form 6 followed by a (For some reason all the footnote numbers are equal to the last one:6) In an automatic footnote, the text:label="6" part is missing. So removing this, changes them to automatic. Then, they will be numbered A, B, C, ... If you want to change this to numbers, do it with Tools > Footnotes > Numbering as has been mentioned by Brian in an earlier message. Of course you should do this on a copy of your file, not on the original (or have a copy saved). -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] double brackets
Thomas wrote: > Good evening > I have a 20,000 row file I am supposed to "review" (a translation by > someone else) > > While changing things, I made a mistake and now one particular word > appears as > ((word)) > > Naturally, the double brackets are NOT wanted. > When I try to search and replace them, Calc tell me, there are no such > double brackets. > But they are right in front of me on the screen. > > Is there any particular reason why I cannot search for "((" ? > > The "same" applies to searching for "," and replace that by "." > (of course, none of these searches uses the ") Make sure that "Entire cells" and "Regular expressions" are deselected. With that I have no problem with both searches. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Sorting Calc Sheet in Alphabet orde on names in one Column
ajebay wrote: > I have a calc spreadsheet with many lines of data which include one > column with names for the line. > I want to sort the names from A to Z, top to bottom, and have all the > corresponding data in each line move with the corresponding name. Hope > this is clear. > Is this possible? Yes. Select all the data, i.e. all rows and all columns. Then use Data > Sort, and select the column of the names as the sort column. Now all the SELECTED data will be sorted with the names. If you would exclude certain columns or rows from the selection they would not move with the sorting but stay where they are. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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 change date format in Calc?
Leonardo Steller wrote: > Hi, > > My Calc date format is MM/DD/YY and I need it like this DD/MM/YY. > I have to work with a table with several dates which are in format > DD/MM/YY, for example 02/07/15 that corresponds to 02 July 2015. My > problem is that Calc understands this date as 07 February 2015 > I tried with Right Click -> Format Cells and typing a format code > DD/MM/YY, but it didn’t work because Calc just change my date from > 02/07/15 to 07/02/15, and it stills understand it as 07 February > 2015. > I also went to LibreOffice -> Preferences -> Language Settings -> > Languages, in the option Date acceptance patterns I typed > D/M/Y;D/M. This didn’t work neither. > > I appreciate any help. > > Thanks in advance. > I think this only works if you have chosen a locale that has the dd/mm/yy format as default, e.g. English(UK). I don't know why. I would think that specifying both the Date acceptance pattern and the Format Cells should solve the problem, but apparently the locale setting has preference over the Date acceptance pattern for input. Maybe they could add an option telling which one has preference, or always give the Date acceptance pattern option preference. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Corrupt file restoration
rachuel dick wrote: > Hi, > > My name is Rachuel, and I have been a long time user of your LibreOffice > documents program. But unfortunately, your program may mean that I will fail > one of my University classes for this semester. An essay I had written on > your program became corrupted and deleted itself. Therefore I have no > assignment to submit with no time to re-write it. All accompanying copies of > my file all show no content. Upset is an understatement of how I feel about > this. I need my file restored or I will most certainly fail this class. > Please find attached a copy of the corrupt file. Please help me fix it. This mailing list does not allow attachments. Please put it somewhere on a web site and send a link. -- Piet van Oostrum <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: Save UNO state?
Hi-Angel wrote: Okay, I wrote a python code that explores every property, and doesn't fall into an infinite cycle. It is [...] However it produces too much output, e.g. from a test document it produced 1gb of output. I think the problem is that most elements still appears in output many times — the check that in backtrace wasn't the current element is ensures only that it wouldn't fall in an infinite cycle. You can get an infinite cycle at any level, so only checking at the top level is not good enough. You will have to check at each node. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] LibreOffice 5.0 Review Rating | PCMag.com
zed wrote: James Knott james.kn...@rogers.com wrote: I just came across this article. http://www.pcmag.com/article2/0,2817,2418419,00.asp?mailing_id=1431647mailing=whatsnewnowmailingID=E2768DCC83E0602F9C1DB70A73032992 The review seems to be of LibreOfice v4.0. So, a little out of date :-) When I click on it, it says 5.0. But I don't agree with this: Clunky interface. Confusing menu options. Actually I find the new MS Office interface quite confusing, and the LO menu's much easier to use. Maybe I am just a bit too old-fashioned :) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] WordPad
jerryg...@earthlink.net wrote: Peter, An automatic periodic save without exiting is in LO but you have to set it in the options from the menu. ToolsOptionsLoad/SaveGeneral Under the Save heading you can set the time interval to save the recovery information AND THE DOCUMENT. Set the time interval for whatever you want and check the box to save the document along with the recovery information. LO 5.0, at least on OS X, does not have the option 'Automatically save the document too', although it is described in the help documentation. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Verification problem with OSX and GB language pack
Roger Hayter wrote: If I install Libreoffice 5.0 on a MAC using Mountain Lion, OSX 10.8.5, and then install the English (GB) language pack, the first time I open LO it fails verification and tells me I should delete LO (and presumably re-download the 'damaged' file). However, if I install from the main, US locale, installer and open the program after installation and before adding the language pack, it verifies itself and opens. I can then close it and install the language pack with no further problem. I don't know how specific to my setup this problem is, and whether it is worth reporting as a bug. Has anyone else observed this? This is an artefact of the interaction of the way OS X does the verification, and the way language packas are installed. Installation of the language pack changes the application, thereby making it invalid. After verification, OS X doesn't care anymore whether you change the application (but this may change in future OS versions). The proper way to install is (as you described above in your second attempt): 1. Install the base version of LO. 2. Open LO so that OS X will very it. 3. Close LO 4. Install the language pack. This also applies to other LO versions and later versions of OS X. The proper way for LO to solve this (IMHO) would be to put the language packs outside the application. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: Verification problem with OSX and GB language pack
Larry Gusaas wrote: Are there two separate bug lists? I searched for the LibreOffice bug list with Google and got https://bugs.freedesktop.org/buglist.cgi?list_id=553598order=bug_idproduct=LibreOfficequery_format=specific It did not have the bug listed. That's the old bug tracker. It is no longer used for LibreOffice. I think they should indicate that somehow. The new one is https://bugs.documentfoundation.org/ -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Verification problem with OSX and GB language pack
Larry Gusaas wrote: On 2015-08-16, 7:13 AM Alexander Thurgood wrote: ]...] See bug 93331 in the LibreOffice bugtracker for a report on the problems encountered with 5.x installation sets. Bug #93331 does not exist. It certainly does exist: https://bugs.documentfoundation.org/show_bug.cgi?id=93331 -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Paragraph styles in lists
Steve Edmonds wrote: On 2015-08-13 10:27, Bruce Byfield wrote: Original message From: Steve Edmonds steve.edmo...@ptglobal.com Date:08/12/2015 4:15 PM (GMT-05:00) To: elderdanlewis elderdanle...@gmail.com Subject: Re: [libreoffice-users] Paragraph styles in lists Hi. I am not sure this is what I was after. If I create a list, initially everything is on level one. I would like it so that if I demote an item to level 2 the style is automatically changed to the style defined for level 2. When I tried your suggestion I had to manually apply the List 2 style to the paragraph. Steve I'm coming late into this discussion, but if I understand what you want to do, you need to create a List style with two or more levels. Press F11 to open the Styles and Formatting window in the sidebar, then select the List Styles button and create or modify a list style with several levels using the Options tab. For each level, you will want a different numbering system. When you go to apply the style, press the Tab key to use the level below your present one at the cursor position, or Shift+Tab to use the level above your current one. Hi. Partly correct. I want to create lists with more than one level (2-3 generally) and have the paragraph style of the text change to a predefined style as I demote or promote the level of a paragraph. I.e. a different paragraph style is associated with each level. steve Hi Steve, Did you read my answer to your question? I think that solves it. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Paragraph styles in lists
Steve Edmonds wrote: Hi. I have had a look in the help but can't see if I can achieve my desired effect. Is it possible to assign a paragraph style based on the level in a list. I.e. Level 1 text is regular, level 2 text is italic. Thanks, steve You can do this with a Conditional Paragraph Style. Look up 'single-style outlining' in the LibreOffice Writers Guide. You would then use the paragraph styles List 1, List 2, etc. or Numbering 1, Numbering 2 etc. for numbered lists. You can adapt these or make your own similar paragraph styles. Create a new paragraph style for example Nested List, make it a conditional style, and couple the Numbering levels to Numbering 1, Numbering 2, or List 1, List 2, etc. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] table with offset between rows
Gary Collins wrote: Ah, I think I didn't state my problem clearly, as usual! What I mean is, I want the cells of the bottom row to be offset by half a cell horizontally from those in the top row, so that the vertical borders of the top row come halfway across the cells of the bottom row. [...] I've tried importing a selected row of cells from calc into draw to do this, in theory I think this ought to work well, but the problem I'm experiencing there is that cell size and formatting don't seem to be preserved when pasting the row. I have tried that and it worked. What I did: Select a large numer of columns in Calc, and set the columns to the required width. You can then merge pairs of cells. Actually you don't have to do all of them. If you have 4 or 5 merged cells, just copy these a number of times to the other columns. And then you copy this to another row starting at the second cell, so that it gets indented. Now if you copy/paste these to Writer they seem to keep their widths. But you have to use Edit Paste Special Formatted Text. For me the column widths are preserved. O, yes, if you do something with the column widths in Writer, with Table Properties Columns, select 'Adapt table width'. This causes the table width to follow the sum of the column widths instead of being fixed. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] table with offset between rows
Gary Collins wrote: Hi, I'm needing to create a kind of table, consisting of two rows, where the bottom row is offset by half a cell from the top row. I'm not sure what would be the best way to achieve this - any suggestions would be most welcome! /Gary Make a table with 3 rows. Select the middle row and with Table Properties Borders select only the top and bottom borders. With the same row selected: Format Paragraph Indents Spacing, select Line Spacing Fixed and enter a small size, for example 5pt. With kind regards, -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] [OT] Operating Environment Survey [Kubuntu Linux]
anne-ology wrote: true. I thoroughly enjoyed the way these massive machines were portrayed in the movies - filling an entire room, whirrin' with lights a-flashin' ;-) I worked several years with large computers (CDC Cyber series). One of my old professors used to say, years later: First we had computers filling a whole cabinet, with the documentation on a card. Now we have computers on a card, with the documentation filling a cabinet. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [Calc] Automate creation of series of full date (ie. Day name, Date)?
Andreas Säger wrote: Problem is that too many spreadsheet users do not know what a spreadsheet date/time is and how it differs from a text such as 16/07/2015 which is not a date by any means. Actually it is if you add the pattern to Options Language Settings Languages Date Acceptance Patterns. I had previously added D/M/Y and 16/07/2015 (without the quotes) was perfectly recognized as a date. To keep the formatting you must also adapt the cell formatting. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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 LO files via IE Explorer
Thomas Blasejewicz wrote: I have another question. I noticed, since I am using Windows 8.1 (2-3 months ago), currently LO Version: 4.4.3.2, that attempts at opening files from the IE Explorer (this thing seems to have another name, but can't remember it) file view VERY OFTEN (almost always) fail. With fail I mean: I have for example one Writer and one Calc file open. No errors at all, just ordinary work. Then I click on a WRITER/CALC file somewhere on my disks. - Nothing happens. No matter what I try. - I close the Writer/Calc files one by one. Still nothing happens. - I close LibreOffice - immediately a file recovery screen opens and tells me, it is recovering the files I was working on. - Once that is done, the file I clicked in the Explorer view ALSO opens. This did NOT happen with my old Windows XP machines, not on 3 different Linux machines and as far as I remember not with earlier versions of LibreOffice. Does anybody know anything about this? What I think is happening is this (it happened to me on Mac OS X also): The previous time you had LO open it crashed. Now you double-click a file and LO opens. Because of the crash it opens the recovery dialog, but then it immediately opens the file that you double-clicked, and that window obscures the recovery dialog. However, LO wants you to finish the recovery dialog first, so it refuses to do anything else. So what you can do is switch windows until the recovery dialog gets focus and finish it. Then the opened file can be worked on. I think LO should always give focus to the recovery dialog, even if there is a file opened. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Adding a image to a gridcontrol row using BASIC
Fernand Vanrie wrote: Hello, on a Openoffice wiki page i found some JAVA code to add a image into a GridControl Row what i need is how to make a Object array in BASIC who supports graphics and octher data thanks for any hint Fernand I think new Object[]{xGraphic,1,2,1.3}) translates to Array(xGraphic,1,2,1.3) -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Alignment in heading-styled numbered-paragraphs text
Xiha wrote: Hello, I am trying to make use of heading-like paragraph styles in order to make a document of numbered paragraphs with nested levels. Something like (view this in monospaced font if it does not show like that; however in my document I do not particularly want to use a monosopaced font): 1. Here is some first text and note how the text is aligned vertically in a straight line on the left. 1.1 Here is a subitem of that first item and again the text is aligned in a straight line. 1.1.1 And one more level down. You get the idea. 1.1.2 Et cetera et cetera et cetera. The reason I want to use paragraph styles rather than a numbered list is that I want the structure to show up in the Navigator, which is very handy to get an overview with its collapsible levels, and also for a TOC. You can still use numbered paragraphs, for example the paragraph styles Numbering1, Numbering2, etc or a copy of them. In the paragraph style choose the Outline and Numbering tab. For Outline level, choose Level 1, Level 2, Level 3 etc. This causes the paragraphs to appear like headings in the Navigator. For Numbering style choose Numbering 1 (for all levels), and you will apply the different indents in the Numbering 1 list style. After much wrangling with style definitions (Indents Spacing) and Outline Numbering, I can't quite get it the way shown above. Somehow I'm not getting the straight left alignment emphasized above. Also, ideally, I don't want to use fixed tab positions and the like: I want the first 1 of 1.1 to align (automatically?) with the left border of the text at 1., and so on. You do this by specifying the proper offsets in the Numbering 1 list style. Here is an example: In tab Options you specify the number of sublevels. For Level n, you have Show sublevels = n, so you get the numbering 1, 1.1, 1.1.1, etc. In tab Position: All of them Numbering alignment: Left, Followed by Tab stop Level 1: Aligned at 0cm, Tab stop at 0.5cm, Indent at 0.5cm Level 2: Aligned at 0.5cm, Tab stop at 1.2cm, Indent at 1.2cm Level 3: Aligned at 1.2cm, Tab stop at 2.3cm, Indent at 2.3cm Each level is aligned at the Tab stop of the previous level. Tab stop = Indent, and the difference between 'Tab stop' and 'Aligned at' should be big enough to accomodate the numbering. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Copying text from one document to another with different formatting
H wrote: I am using LibreOffice 4.0.2 and have a need to copy a text selection (recipient address) from one document to another, to a label template for a continuous label printer. The text selection resides in a table and I'd like to /not/ copy any of the formatting to the label template where a different formatting needs to be applied. Currently, I copy the text selection which automatically includes the table cell formatting, paste it into the second document, remove the extra space above and below the table cells, select only the table cells, convert them into text and finally apply the desired formatting style. As i am sure everyone understands, this gets old really fast and surely there must be a faster way? Suggestions appreciated! Have you tried Edit Paste Special Unformatted text? You can bind this to a key. As I use this quite often I have it on Alt-Command-V (on a Mac). -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] cannot select multiple words in impress
Sang-Hyun LEE wrote: I use OSX, Maverick. I'm not sure about that following happen in Windows or Linux, or else. In the Writer, I can select multiple words starting with one word by double click and dragging. but the Impress doesn't allow me to do such job. I only can select one word by double clicking. Dragging doesn't do anything. Just clicking (not double clicking) and dragging works for me. Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] cannot select multiple words in impress
Brian Barker wrote: o Double-clicking and then dragging *without first releasing the mouse button* selects the current word and then expands the selection word by word instead of character by character. The questioner points out that this useful technique works in Writer but not in Impress. I didn't know that. You are never too old to learn. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Find Replace first character broken?
Paul D. Mirowsky wrote: LibreOffice Version: 4.4.2.2 Build ID: c4c7d32d0d49397cad38d62472b0bc8acff48dd6 Locale: en_US Windows 7 Professional SVC Pack 1 on Intel.64 bit. I had recorded some macro's that I use for file cleaning that went nuts. Then I noticed that using Find for the first character ^. was only advancing through each character after finding the the first character. Can some else confirm? Your description is not very clear. Do you happen to have 'regular expressions' selected in the Find and Replace dialog? -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?
Mark LaPierre wrote: Yup, root. I was trying to install it as a system wide extension. That would take root powers. Maybe I need a little hand holding. I RTFM and followed the instructions but no soap. Can any of you who were successful tell me how you got it installed for Libreoffice 4 as a system wide extension? I did it on Mac OS X with sudo /Applications/LibreOffice.app/Contents/MacOS/unopkg On other systems you would have to locate unopkg, but for the rest it should be the same. You can use unopkg add, or (as I did if I remember correctly) unopkg gui. For help give unopkg --help The difference between sudo and running as root is that with sudo you get root privileges, but you are still running in the user's environment. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?
Manfred Bertl wrote: Am 29.04.2015 um 02:38 schrieb Mark LaPierre: On 04/28/15 04:37, Andreas Säger wrote: I followed the link above. It took me to a download page for MRI 1.2.4 which fails to install even though it says right under the download link that it is compatible with LO 4. [...many lines deleted...] compatible with LibreOffice 3.3, 3.4, and 3.5. I have 4.0.4.2. :-( I have MRI Version 1.2.4 successfully installed on LO 4.3.6.2 on CentOS7 64Bit, and it works fine. I installed 1.2.5 from Github (https://raw.githubusercontent.com/hanya/MRI/master/files/MRI-1.2.5.oxt) on LO 4.4.3.1 and on master, on Mac OS X 10.10.3 (Yosemite) for all users with sudo unopkg, without problems. But if I remember correctly, I first did a user install, just with Tools Extension Manager, selecting the downloaded file, also without problems. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: About BASIC or MACRO. How do I get the name, properties and actions of Objects ?
Andreas Säger wrote: Am 28.04.2015 um 10:18 schrieb minhsien0330: Hi~, I am getting start with writing some Macro for Forms in Libreoffice Base, I read some tutorials and guidelines, but I still don't know how do I get the name, properties and actions of Objects ? Would you tell me any information about this? e.g.: I have a table in Form1 (Libreoffice Base). What's the object name of the table? What actions can be done for this table? Thank you! Best Regards, Minhsien0330 Hi, [Tutorial] Introduction into object inspection with MRI https://forum.openoffice.org/en/forum/viewtopic.php?f=74t=49294 And of course you need to understand the architecture of services, interfaces and language independent data types. This is not for people who can not program anything beyond stolen VBA snippets. One advantage is that you are not limited to this awkward Basic lingo of the early 90ies. I can second that about MRI. I think it is invaluable. But if you want to do serious programming you also need the developer's guide (https://wiki.openoffice.org/w/images/d/d9/DevelopersGuide_OOo3.1.0.pdf) It is huge but you can find valuable information there about all the internals. The code examples are in Java, however. The document is a bit old, but I don't think much has changed. It is basically the same as the website (https://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide). Then for Database access you can use Andrew Pitonyak's AndrewBase document that you can download from http://www.pitonyak.org/database/. It has examples of accessing Forms, and it uses Basic. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Libre Calc - moving text in cell + comparison chart
charles meyer wrote: Hi Folks, I’m learning the function keys between MS Excel and Libre Calc work quite differently. In Excel if you wish text in a cell to return to the next line in that cell, you choose Ctrl + Enter. That’s doesn’t seem to work in Libre Calc. Could you please share how that is done in Libre Calc? Has anyone happened upon any comparison chart showing how to accomplish certain functions in Libre Calc compared with how you perform them in MS Excel? MS has shared that with MS Word and WordPerfect so if you’re transitioning into MS Word you can acclimate easier. Thanks so much! Charles. On my Mac it works with Cmd-Enter. Which is kind of strange as Cmd-Enter inserts a page break in Writer, whereas in Writer both Ctrl-Enter and Shift-Enter insert a newline, even in table cells. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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