Re: [libreoffice-users] Re: Date manipulation
On 30-10-2014 21:04, Andreas Säger wrote:
For an embedded HSQL database the query goes like this:
SELECT * FROM Your Table WHERE DATEDIFF('day', CURRENT_DATE, Date Field)
BETWEEN -10 AND 10
Replace the double quoted names with the actual names of your table and
field.
Quicker should be (if an index exists on Date Field:
select *
from Your Table
WHERE Date Field BETWEEN
DATEADD('day', -10, CURRENT_DATE and DATEADD('day', +10, CURRENT_DATE)
Because with this query an index will be used, and with the
datadiff-query, no index will be used.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Base Relationships: Update cascade not working
Hi Andreas, Thanks for your detailed reply. After I had sent my message, I realised that I had neglected to mention that I am using the H2 database. I went back into Tools | Relationships and decided to remove the the relationship lines so that I could manually make the changes I wanted. I discovered that for two of the relationships it took three attempts to delete the lines. That made me wonder if I had somehow managed to link my tables three times! So I reinstated the relationships using the New Relation button rather than dragging the lines. Then, to my surprise, I discovered that Update cascade worked!! If there were three lines joining the tables, I've no idea how I managed to do that. Otherwise, I'm at a loss to know what I was doing wrong yesterday. Perhaps the overnight reboot of my PC fixed it! Anyway, thanks again. Noel -- Marion Noel Lodge lodg...@gmail.com On 1 November 2014 02:53, Andreas Säger ville...@t-online.de wrote: Am 31.10.2014 um 14:11 schrieb Marion Noel Lodge: Hi, I am trying to change some Primary Keys in my main table, and get the changes to be reflected in several Foreign Keys. I have gone into Tools | Relationships, have set up the 1 to n connections between the tables and chosen Update cascade. However when I open the main table and attempt to change a Primary Key, I get the message Referential integrity constrain violation. I thought that Update cascade would override this. Have I missed something, or is it a possible bug? Thanks, Noel -- Noel Lodge lodg...@gmail.com Hi, If it were a bug, then it would be a bug in the underlying database program which is HSQL and not Base. Base is not a database at all. Referencial integrity never lets you enter any foreign key value on the n-side if there is no corresponding value in the other table's primary key (the 1-side). Update cascade allows you to update a primary key value on the 1-side. This update will automatically change all the values in related foreign keys. Normally you don't want cascading updates, particularly when using auto-IDs which may be inserted and deleted but never updated. If you want to enter arbitrary values into some field then you must not make it a foreign key of some other table's primary key. You can make it optional (nullable) but an orphaned foreign key value is not possible. If you happen to work with an embedded HSQLDB (this is indicated in the status bar), http://www.hsqldb.org/doc/1.8/guide/ch09.html is the complete official documentation for the database program you are working with. Hope this helps, A.S. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Invoking a dialog from a macro to insert text into a Writer document
Hi guys: I work on a call center and everyday I aswer about 20 call with the exact requirements, so I thought about making a macro to speed things up. The procedure is this, normally I copy some text from a web page and paste it on a text document, I read the text to the client and write down the answer (I.E: Phone line active?, yes). I was reading Andrew Pitonyak’s OpenOffice.org Macros Explained (OOME) and on page 606 he explains how to invoke a dialog from a macro. I don't know what I'm doing wrong but everytime I try to run the macro to invoke the dialog I got BASIC runtime error.An exception occurredType: com.sun.star.container.NoSuchElementExceptionMessage: . pointing to line 15 DialogLibraries.loadLibrary(Template) What I'm trying to do is this, a macro to invoke a dialog with 3 buttons (Enable Services, Disable Services, Call Retrieval). When I push a button I call another dialog with buttons that represent all the questions a ask the clients (I.E, when I push Enable Services I invoke a dialog with all the questions related to the process to enable aditional services Phone line is active?, What is your OS?, Do you have an AV installed?). The use case is this, a call is answered, I take the personal data and then I execute the macro, the macro call the dialog, in the dialog I click button Enable Services and it bring the second dialog, when I click the buttons Phone line is active?, What is your OS?, Do you have an AV installed? the macro should end and I should have writed down on the document the questions Phone line is active?, What is your OS?, Do you have an AV installed? I already design the dialogs, but I can't invoke the first dialog from the macro, or the following dialogs after clicking the buttons, and I don't have any text written down on my document... Any help on this is highly appreciated. -- 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] LO Calc question...
Thanks for that - I'll just move the chart! On 31 October 2014 21:16, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: I think freeze and split windows are intended for scrolling around large table of data, for example to keep heading and total rows and columns in view. So they keep the rows in the views next to each lined up so the headings match the data. But as I understand it, you want to break that coupling, so you can scroll the left side up and down without the right side moving. I don't think that's possible, although it may be an interesting feature request. As it happens, I have a similar sheet where I'm continually adding new data to the bottom of the table and have a chart to the right of it, but I just move the chart down the sheet as more data is added. Another possibility is use Window New Window to open a second window of the same document, then arrange the two windows on screen as you want. Changes in one window are reflected in the other (it's the same document, not a copy). But I don't think that arrangement is saved so you'd have to set the windows up each time you open the file, which may or may not work for you. It may be possible to use a macro to automate opening a second window and positioning it, but I'm not sure of the details for that and may not work too well if someone with a different size screen opens it. A couple of things which I don't think are quite what you want, but mention in case they do the trick or inspire other ideas... Place the cursor in F1 before selecting Window Split or Window Freeze. But the two halves would scroll together vertically; you'll only be able to scroll them separately horizontally. You can also split both horizontally and vertically at the same time by first positioning the cursor somewhere in the middle of the sheet (e.g. F20) then Window Split. But again the two parts next to each other horizontally would be kept in sync when scrolling vertically, and the two parts stacked vertically would be kept in sync when scrolling horizontally. So you'd end up with only the lower left part available for scrolling around your data. If you scrolled the top left part vertically, or the lower right part horizontally, it would also scroll your chart in the top right out of view. (Hope that all makes sense... if not just try it and see what happens!) Mark. Andrew Sullivan wrote: Is it possible to freeze the left and right parts of a spreadsheet (as opposed to the upper and lower parts, which I know you can do)? Thanks Andrew On 26 October 2014 20:06, Andrew Sullivan andrew.t.sulli...@gmail.com wrote: That doesn't do exactly what I want... The data starts at A1; the chart occupies the space G3/M19. What I'd ideally like to do is split the sheet vertically between say columns E and F and be able to scroll the data columns. Can this be done? Thanks again. Andrew On 26 October 2014 19:21, Joe Conner joeconner2...@gmail.com wrote: You are able. Select a cell below your chart, then select WINDOW - FREEZE. That should do it. Blessings, Joe Conner, Poulsbo, WA USA On 10/26/2014 11:48 AM, Andrew Sullivan wrote: Hello First post here, hope it's in the right place... I have a simple spreadsheet in Calc - just a few columns fo data and a chart at the top of the page. The data columns are quite long (hundreds of lines eventually) and I would like to fix the position of the chart at the top of the page and scroll down the data columns. Assuming this makes sense, is it possible??? TIA Andrew -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Recommended version of Java?
Hi :) Back in 2011, the first several versions of Java 1.7 had compatibility issues with lots of software including LibreOffice. So that was around LO 3.4.3 and earlier. Java 1.7.0_0, Java 1.7.0_1, Java 1.7.0_2, Java 1.7.0_3 and i think Java 1.7.0_4 (maybe even 5 too) were all compromised before release date which was particularly bad because 1.6.xx created serious problems on some platforms. Through intense testing and discussions on this list we found that around 1.6.xx24 and onwards there were hefty slow-downs whereas 1.6xx21 let LO run quite quickly. I can't remember exactly which version was found to be optimal. While we were waiting for 1.7.xx to become safe enough to use one in their earlier branch, a 1.6xx29(?) was suddenly fast again on Windows (and i think Linux too) but had horrendous malware issues on Macs. Macs were vulnerable to only 2 malware threats that entire year and at least 1 of those was due to Java 1.6xx. It was serious enough that press articles reported that many people were starting to have to run 'anti-virus' on Macs and many articles promised it was the end of Macs security (purportedly 'security through obscurity') and suggested that Macs would henceforth have the same problem Windows has. It was then at least 1-2 years before Macs had any other malware issues despite continuing rapid growth of market-share. It doesn't seem to have been such a serious issue since then but most times when people have had problems with Java, or problems with LO crashing, it has been solved by people on this mailing list suggesting to switch off Java and consider removing it. We don't seem to need to track specific versions of Java quite as closely as we once did. When we did track it the information outside of this mailing list was abysmal. Regards from Tom :) On 1 November 2014 09:07, Alex Thurgood alex.thurg...@gmail.com wrote: Le 31/10/2014 21:12, Andreas Säger a écrit : Huh? Really? Which issue number was that? I can't believe that any LO version had been released with such a show stopper issue. Well, please reconsider your statement in light of the requirement for LibreOffice 4.3.3 on OSX Yosemite and current master 440 alpha to use an end of life Apple Java 6, in addition to Java 1.8, to remain even remotely stable with the default bundled extensions that require Java. The Java 1.8 invocation problem is Oracle's bug (known, slated for fix in Java 9), and the fact that on OSX LibreOffice bundles extensions requiring Java is the LibreOffice projects responsibility. FWIW : https://bugs.freedesktop.org/show_bug.cgi?id=74877 Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications
I agree with your method ... congratulate you on obviously being a bright teacher. Now ... I'm curiously wondering how using 'styles' differs from the 'select all' then changing the font, or whatever; that method takes me mere seconds as well ;-) Also, I'm curiously wondering what method(s) your students would be using which would take them so long ??? From: Virgil Arrington arringto...@gmail.com Date: Fri, Oct 31, 2014 at 9:36 AM Subject: Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications To: users@global.libreoffice.org Tim, I'm way too late in this thread to be helpful as I have been absent for several months (for some reason the list stopped recognizing my email address, so I recently resubscribed with a different address). That said, I can relate to what I perceive to be your issues. I do a lot of Bible study work with LO and eSword and Bibletime as well as Bible.org. I always run into problems when I copy and paste quotes from one of these sources to LO. As I look at your document (an interesting study indeed, btw -- love the reference to Origen), I see a lot of formatting inconsistency going on. Font changes, smartquotes here, dumbquotes there, etc. This is the result of pasting formatted text from one source into LO. Now you may not care about this as I'm sure these are probably private notes, not necessarily for dissemination, but... In my experience with extra-LO sources such as eSword, etc., I've come to always paste using Paste-Special/Unformatted text. That way, I can then quickly apply an appropriate paragraph style to the text and all is well. Virgil btw., Ironically, as I'm typing this, I'm sitting in my Law Office Technology class while my students are taking a test on the use of paragraph styles. After teaching this class for five semesters, I've finally found an approach that works. I think Tom suggested it. I give them an unformatted document and ask them to format it using any method they understand. They usually take 30 to 45 minutes and end up with a mess. I then demonstrate reformatting the document with styles and I'm done in about 3 minutes and the document formatting is consistent and useful. I then ask, If your client was paying $200 an hour to have a legal document prepared and formatted, who would they rather pay, me or you? On 10/31/2014 9:57 AM, Tim Deaton wrote: Sorry for the delay in responding. Too many other things going on. -- Tim === On 10/26/2014 4:56 PM, Brian Barker wrote: At 16:25 26/10/2014 -0400, Dan Lewis wrote: On 10/26/2014 02:13 PM, Brian Barker wrote: At 13:51 26/10/2014 -0400, Tim Deaton wrote: I'm currently running LO v4.2.6.3 on Windows 7, 64-bit, SP1. I use Writer primarily to create notes for Bible study lessons. In that process, I often copy text into Writer from other programs (most likely e-Sword and TheWord (two free Bible software programs which, I think, both use the SQLite open-source database program). The template I use for this has the default tab-stop setting (Tools|Options|LO Writer|General) set to 0.25 inch. My problem is that when copying text passages from those (and perhaps other) programs into LO, that default tab-stop gets reset to 0.5 inch, so that I have to go into the Options to change it back after each copy/paste. I don't know when exactly this behavior started, but I do know this resetting did not happen when I was using OOo and then LO 3.x. It either started with LO 4.0 or 4.1. I'm not sure why you would want to use default tab stops at all. They are so close that you often need to add multiple consecutive tab characters, and this is surely a recipe for your documents being fragile and not robust to changes of font, paper size, printer, platform, and so on? Tab stops are a property of paragraph styles. Why not set up a paragraph style with just the tab stops you actually need and then apply this style to the text (very easily done) immediately after pasting What about using paste special the Unformatted text option after creating the paragraph style you want? I'm not sure how that helps. In any case, the questioner originally said he wanted to retain elements of formatting in the copied text. Brian Barker Thanks for your comments, and your patience. The reason for the .25 tab stops (about 6mm) is that in these documents I do a lot of outline-type indenting, but without the outline numbering. Also, the pasted-in scripture sections use .25 hanging indents in one of the source programs, and I like to keep that. It's NOT for tabbed spaces in the middle of a line. When I started using OOo for this, I set up a template just for these documents, and brought that over to LO when I switched. The .25 default tab stops are part of that template. Given its age, I doubt I used styles then, but I really don't remember. I just know that
[libreoffice-users] Videos of the Bern conference
Hi all, If you missed it on our social networks, all the videos of the Bern Conference are now on our YouTube channel here: https://www.youtube.com/channel/UCQAClQkZEm2rkWvU5bvCAXQ/playlists Kind regards Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org Tel:+33683901545 Co-founder - Release coordinator The Document Foundation -- 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: Recommended version of Java?
Am 01.11.2014 um 10:07 schrieb Alex Thurgood: Le 31/10/2014 21:12, Andreas Säger a écrit : Huh? Really? Which issue number was that? I can't believe that any LO version had been released with such a show stopper issue. Well, please reconsider your statement in light of the requirement for LibreOffice 4.3.3 on OSX Yosemite and current master 440 alpha to use an end of life Apple Java 6, in addition to Java 1.8, to remain even remotely stable with the default bundled extensions that require Java. The Java 1.8 invocation problem is Oracle's bug (known, slated for fix in Java 9), and the fact that on OSX LibreOffice bundles extensions requiring Java is the LibreOffice projects responsibility. FWIW : https://bugs.freedesktop.org/show_bug.cgi?id=74877 Alex Thank you. Just like Florian Reisinger I was unaware of this issue with OSX. Let me rewrite the 3 answers since I still don't know Tanstaafl's operating system. 1. Always use a 32 bit JRE with LO on Windows. It may be your second or third JRE which is perfectly OK. Nothing wrong with many JREs for different purposes. 2. Mac users need an outdated Java 6 in addition to their default JRE until Oracle fixed a bug. 3. Use whatever JRE comes from the distributor of your Linux platform. -- 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: Base Relationships: Update cascade not working
Am 01.11.2014 um 12:19 schrieb Marion Noel Lodge: Hi Andreas, Thanks for your detailed reply. After I had sent my message, I realised that I had neglected to mention that I am using the H2 database. I went back into Tools | Relationships and decided to remove the the relationship lines so that I could manually make the changes I wanted. I discovered that for two of the relationships it took three attempts to delete the lines. That made me wonder if I had somehow managed to link my tables three times! So I reinstated the relationships using the New Relation button rather than dragging the lines. Then, to my surprise, I discovered that Update cascade worked!! Learning a little bit of SQL you can save a lot of time and effort. The things you need to know learn about creation and modification of tables, fields and indexes are very simple. There are text editors which help you to compose statements from prepared snippets. Well, even a Writer template can be spiced up with some auto-text in SQL language. Even the most simple plain text editor lets me define a table with primary key, default values and foreign key faster than the Base GUI. Back to Base, you have to call menu:ViewRefresh Tables. And yes, sometimes it is a good idea to restart the office suite. Using an external database such as H2 keeps your data safe and warm. -- 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] Videos of the Bern conference
Hi Sophie: Thank you very much for the information, Regards, Jorge Rodríguez - Mensaje original - De: Sophie gautier.sop...@gmail.com Para: proje...@global.libreoffice.org, users@global.libreoffice.org Enviados: Sábado, 1 de Noviembre 2014 8:14:44 Asunto: [libreoffice-users] Videos of the Bern conference Hi all, If you missed it on our social networks, all the videos of the Bern Conference are now on our YouTube channel here: https://www.youtube.com/channel/UCQAClQkZEm2rkWvU5bvCAXQ/playlists Kind regards Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org Tel:+33683901545 Co-founder - Release coordinator The Document Foundation -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Recommended version of Java?
On 10/31/2014 8:35 PM, jonathon toki.kant...@gmail.com wrote: On 31/10/14 20:12, Andreas Säger wrote: The fact is, Libreoffice, for a long time, simply did not work at al with Java7. Huh? Really? Which issue number was that? I can't believe that any LO version had been released with such a show stopper issue. The problem is/was much more subtle than the OP implied. Java functioned correctly for some things, but not others. Nope. There was a considerable time period when the current version of Libreoffice didn't even *see* a Java7 installation. -- 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: Recommended version of Java?
On 10/31/2014 4:30 PM, Andreas Säger ville...@t-online.de wrote: Am 31.10.2014 um 20:50 schrieb Sophie Gautier: So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... Sheesh... No, that was: THAT IS WHAT I ASKED FOR. SHEESH. See the difference? Nope.. no clue what your point was, since you snipped necessary context. -- 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: Recommended version of Java?
On 10/31/2014 4:12 PM, Andreas Säger ville...@t-online.de wrote: Am 31.10.2014 um 20:32 schrieb Tanstaafl: If Libreoffice requires Java to do certain things (yes, I understand that iits reliance on Java is less and less as time goes on, but it still requires it for some things), then it is on LIBREOFFICE to provide information what version(s) of Java it supports, and for what platforms. And you got valid answers from me and from Florian for all operating systems (since you don't tell us yours). The first (and only) valid answer I got was from V Stuart Foote... And thanks Stuart - you totally answered my question, but I neglected to thank you. The reply from Florian was not unhelpful, but certainly didn't fully answer my question. I never got a valid answer from you, Andreas, just a snarky reply. -- 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] Tab defaults change when pasting into Writer from some other applications
Hi :) Select All and just changing the font only does the 1 thing and it does it to everything. My guess is that the students go through the document applying different bits of formatting as they go along. Then they have trouble being consistent. Bullets and numbering is probably a bit more sophisticated in legal documents so if they are re-doing those or shudders / typing them in directly each time it could be troublesome. Inconsistent indents and messing with the ruler at the top can quickly make a right mess of things too. It might be fun to hear about specific cases and/or things that almost all of them do. Regards from Tom :) On 1 November 2014 13:33, anne-ology lagin...@gmail.com wrote: I agree with your method ... congratulate you on obviously being a bright teacher. Now ... I'm curiously wondering how using 'styles' differs from the 'select all' then changing the font, or whatever; that method takes me mere seconds as well ;-) Also, I'm curiously wondering what method(s) your students would be using which would take them so long ??? From: Virgil Arrington arringto...@gmail.com Date: Fri, Oct 31, 2014 at 9:36 AM Subject: Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications To: users@global.libreoffice.org Tim, I'm way too late in this thread to be helpful as I have been absent for several months (for some reason the list stopped recognizing my email address, so I recently resubscribed with a different address). That said, I can relate to what I perceive to be your issues. I do a lot of Bible study work with LO and eSword and Bibletime as well as Bible.org. I always run into problems when I copy and paste quotes from one of these sources to LO. As I look at your document (an interesting study indeed, btw -- love the reference to Origen), I see a lot of formatting inconsistency going on. Font changes, smartquotes here, dumbquotes there, etc. This is the result of pasting formatted text from one source into LO. Now you may not care about this as I'm sure these are probably private notes, not necessarily for dissemination, but... In my experience with extra-LO sources such as eSword, etc., I've come to always paste using Paste-Special/Unformatted text. That way, I can then quickly apply an appropriate paragraph style to the text and all is well. Virgil btw., Ironically, as I'm typing this, I'm sitting in my Law Office Technology class while my students are taking a test on the use of paragraph styles. After teaching this class for five semesters, I've finally found an approach that works. I think Tom suggested it. I give them an unformatted document and ask them to format it using any method they understand. They usually take 30 to 45 minutes and end up with a mess. I then demonstrate reformatting the document with styles and I'm done in about 3 minutes and the document formatting is consistent and useful. I then ask, If your client was paying $200 an hour to have a legal document prepared and formatted, who would they rather pay, me or you? On 10/31/2014 9:57 AM, Tim Deaton wrote: Sorry for the delay in responding. Too many other things going on. -- Tim === On 10/26/2014 4:56 PM, Brian Barker wrote: At 16:25 26/10/2014 -0400, Dan Lewis wrote: On 10/26/2014 02:13 PM, Brian Barker wrote: At 13:51 26/10/2014 -0400, Tim Deaton wrote: I'm currently running LO v4.2.6.3 on Windows 7, 64-bit, SP1. I use Writer primarily to create notes for Bible study lessons. In that process, I often copy text into Writer from other programs (most likely e-Sword and TheWord (two free Bible software programs which, I think, both use the SQLite open-source database program). The template I use for this has the default tab-stop setting (Tools|Options|LO Writer|General) set to 0.25 inch. My problem is that when copying text passages from those (and perhaps other) programs into LO, that default tab-stop gets reset to 0.5 inch, so that I have to go into the Options to change it back after each copy/paste. I don't know when exactly this behavior started, but I do know this resetting did not happen when I was using OOo and then LO 3.x. It either started with LO 4.0 or 4.1. I'm not sure why you would want to use default tab stops at all. They are so close that you often need to add multiple consecutive tab characters, and this is surely a recipe for your documents being fragile and not robust to changes of font, paper size, printer, platform, and so on? Tab stops are a property of paragraph styles. Why not set up a paragraph style with just the tab stops you actually need and then apply this style to the text (very easily done) immediately after pasting What about using paste special the Unformatted text option after creating the paragraph style you want?
Re: [libreoffice-users] Invoking a dialog from a macro to insert text into a Writer document
Hi Angel, Am 01.11.2014 um 12:28 schrieb Angel Pérez: Hi guys: I work on a call center and everyday I aswer about 20 call with the exact requirements, so I thought about making a macro to speed things up. The procedure is this, normally I copy some text from a web page and paste it on a text document, I read the text to the client and write down the answer (I.E: Phone line active?, yes). I was reading Andrew Pitonyak’s OpenOffice.org Macros Explained (OOME) and on page 606 he explains how to invoke a dialog from a macro. I don't know what I'm doing wrong but everytime I try to run the macro to invoke the dialog I got BASIC runtime error.An exception occurredType: com.sun.star.container.NoSuchElementExceptionMessage: . pointing to line 15 DialogLibraries.loadLibrary(Template) There simply is no library Template in the library container where the macro resides. Either the macro is called from the MyMacro global container or the macro is called from a document's container. Did you see Andrew's remark on GlobalScope.DialogLibraries? Did you take care of correct upper or lower case? What I'm trying to do is this, a macro to invoke a dialog with 3 buttons (Enable Services, Disable Services, Call Retrieval). When I push a button I call another dialog with buttons that represent all the questions a ask the clients (I.E, when I push Enable Services I invoke a dialog with all the questions related to the process to enable aditional services Phone line is active?, What is your OS?, Do you have an AV installed?). The use case is this, a call is answered, I take the personal data and then I execute the macro, the macro call the dialog, in the dialog I click button Enable Services and it bring the second dialog, when I click the buttons Phone line is active?, What is your OS?, Do you have an AV installed? the macro should end and I should have writed down on the document the questions Phone line is active?, What is your OS?, Do you have an AV installed? I already design the dialogs, but I can't invoke the first dialog from the macro, or the following dialogs after clicking the buttons, and I don't have any text written down on my document... Any help on this is highly appreciated. I'm sorry, but I can't see the benefit of a macro, where a set of template documents would do better and faster. Volker -- 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: date acceptance patterns not sticking
Am 14.10.2014 um 22:20 schrieb bunk3m: Libreoffice is driving me nuts. I am in Canada. UI is set to English US; Locale settings to English Canada and Default Currency is CAD. I have my Mac set dates to dd.mm.. (OSX 10.9.x) For some reason Libreoffice (4.3.1.2) will only accept dates in the -MM-DD format. I'm happy that I can format the date to look DD.MM. but entering in the -MM-DD is totally unnatural for me. Modify your default template for spreadsheets if you have any. Add a German cell style for the dates. Apply number format code TT.MM. which means 2-digit Tag(day), 2-digit month and 4_digit Jahr (year) Use that style for all cells where you want to use this input method: 25. = 25.11.2014 (this month's 25th day) 25.12 = 25.12.2014 (this year's 25th of December). This can not work with any English locale because the point conflicts with the decimal point. Save this as your default template for your new spreadsheets: FileTemplatesSave... [some name] FIleTemplatesOrganize... pick your new spreadheet and choose Set Default from the command button on the right. Additionally you may define a custom shortcut to apply this style (ToolsCustomizeKeyboard, category Styles. -- 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] Tab defaults change when pasting into Writer from some other applications
On 11/1/2014 9:33 AM, anne-ology wrote: I agree with your method ... congratulate you on obviously being a bright teacher. Now ... I'm curiously wondering how using 'styles' differs from the 'select all' then changing the font, or whatever; that method takes me mere seconds as well ;-) Also, I'm curiously wondering what method(s) your students would be using which would take them so long ??? If the *only* thing you want to change is the font document-wide, then your select all method will work. But formatting goes far beyond changing a font. The documents I typically create (as simple as they are) have many different types of paragraphs including the following: - A Title, set in 20 point, bold, Linux Biolinum G, centered, with 12 points of white space below the paragraph. - A Subtitle, the same as the Title, except with 16 point, bold type. - Several Section Heading paragraphs, each with Linux Biolinum G in ever reducing sizes, flush left, with 12 points of white space above the paragraph, and with automatic numbering through the Outline Numbering. Also, I have them set to keep with the next paragraph, which is important when creating heading styles to ensure that you don't have a random heading by itself at the bottom of the page with the following paragraph on the next page. If I need a Chapter Title paragraph, I can create it to always begin on a new page. - A main Body paragraph, with 12 point Linux Libertine G, set flush left, single spaced, with 12 points of white space above it. - A main Body paragraph, the same as the above, but with an indented first line (2 picas) and no white space above the paragraph. - Main Body paragraphs set double-spaced for legal briefs and scholarly paragraphs. - A Blockquote paragraph, which is single spaced and indented 2 picas on the left margin with additional white space above and below the paragraphs. To generate all of this formatting without styles requires the user to format each paragraph or set of paragraphs directly, selecting each formatting characteristic separately, including font, size, line spacing, paragraph indents, and on and on. Doing it directly takes a lot of time, and then you have to be careful to make sure all your section headings are formatted consistently (was that 16 points or 18 points?). But, to do it with styles is super quick. And the consistency throughout the document almost brings tears of joy to my eyes. Virgil -- 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] Tab defaults change when pasting into Writer from some other applications
Oh, and I forgot to mention that, if you want LO (or in the case of my class, MS-Word) to automatically generate a table of contents you *must* use styles as the program searches for specific styles (typically Heading 1, 2, 3, etc.) to put into the contents. Virgil On 11/1/2014 9:33 AM, anne-ology wrote: I agree with your method ... congratulate you on obviously being a bright teacher. Now ... I'm curiously wondering how using 'styles' differs from the 'select all' then changing the font, or whatever; that method takes me mere seconds as well ;-) Also, I'm curiously wondering what method(s) your students would be using which would take them so long ??? From: *Virgil Arrington* arringto...@gmail.com mailto:arringto...@gmail.com Date: Fri, Oct 31, 2014 at 9:36 AM Subject: Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications To: users@global.libreoffice.org mailto:users@global.libreoffice.org Tim, I'm way too late in this thread to be helpful as I have been absent for several months (for some reason the list stopped recognizing my email address, so I recently resubscribed with a different address). That said, I can relate to what I perceive to be your issues. I do a lot of Bible study work with LO and eSword and Bibletime as well as Bible.org. I always run into problems when I copy and paste quotes from one of these sources to LO. As I look at your document (an interesting study indeed, btw -- love the reference to Origen), I see a lot of formatting inconsistency going on. Font changes, smartquotes here, dumbquotes there, etc. This is the result of pasting formatted text from one source into LO. Now you may not care about this as I'm sure these are probably private notes, not necessarily for dissemination, but... In my experience with extra-LO sources such as eSword, etc., I've come to always paste using Paste-Special/Unformatted text. That way, I can then quickly apply an appropriate paragraph style to the text and all is well. Virgil btw., Ironically, as I'm typing this, I'm sitting in my Law Office Technology class while my students are taking a test on the use of paragraph styles. After teaching this class for five semesters, I've finally found an approach that works. I think Tom suggested it. I give them an unformatted document and ask them to format it using any method they understand. They usually take 30 to 45 minutes and end up with a mess. I then demonstrate reformatting the document with styles and I'm done in about 3 minutes and the document formatting is consistent and useful. I then ask, If your client was paying $200 an hour to have a legal document prepared and formatted, who would they rather pay, me or you? On 10/31/2014 9:57 AM, Tim Deaton wrote: Sorry for the delay in responding. Too many other things going on. -- Tim === On 10/26/2014 4:56 PM, Brian Barker wrote: At 16:25 26/10/2014 -0400, Dan Lewis wrote: On 10/26/2014 02:13 PM, Brian Barker wrote: At 13:51 26/10/2014 -0400, Tim Deaton wrote: I'm currently running LO v4.2.6.3 on Windows 7, 64-bit, SP1. I use Writer primarily to create notes for Bible study lessons. In that process, I often copy text into Writer from other programs (most likely e-Sword and TheWord (two free Bible software programs which, I think, both use the SQLite open-source database program). The template I use for this has the default tab-stop setting (Tools|Options|LO Writer|General) set to 0.25 inch. My problem is that when copying text passages from those (and perhaps other) programs into LO, that default tab-stop gets reset to 0.5 inch, so that I have to go into the Options to change it back after each copy/paste. I don't know when exactly this behavior started, but I do know this resetting did not happen when I was using OOo and then LO 3.x. It either started with LO 4.0 or 4.1. I'm not sure why you would want to use default tab stops at all. They are so close that you often need to add multiple consecutive tab characters, and this is surely a recipe for your documents being fragile and not robust to changes of font, paper size, printer, platform, and so on? Tab stops are a property of paragraph styles. Why not set up a paragraph style with just the tab stops you actually need and then apply this style to the text (very easily
Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications
Yes, Tom, you hit nearly all of the problems. Some typical mistakes. - using the Tab key to indent the first line of a paragraph... or worse yet, hitting the Spacebar five times. Often, the typist will forget to indent a paragraph that should be indented. - creating white space between paragraphs by hitting the Enter key (a la typewriter). This messes up the keep with next paragraph setting on heading paragraphs. - yes, typing numbers and letters for outlined paragraphs or numbered headings. - manually typing a table of contents. - centering a Title or Heading by hitting the Tab key several times until it looks centered. Virgil On 11/1/2014 12:26 PM, Tom Davies wrote: Hi :) Select All and just changing the font only does the 1 thing and it does it to everything. My guess is that the students go through the document applying different bits of formatting as they go along. Then they have trouble being consistent. Bullets and numbering is probably a bit more sophisticated in legal documents so if they are re-doing those or shudders / typing them in directly each time it could be troublesome. Inconsistent indents and messing with the ruler at the top can quickly make a right mess of things too. It might be fun to hear about specific cases and/or things that almost all of them do. Regards from Tom :) On 1 November 2014 13:33, anne-ology lagin...@gmail.com mailto:lagin...@gmail.com wrote: I agree with your method ... congratulate you on obviously being a bright teacher. Now ... I'm curiously wondering how using 'styles' differs from the 'select all' then changing the font, or whatever; that method takes me mere seconds as well ;-) Also, I'm curiously wondering what method(s) your students would be using which would take them so long ??? From: Virgil Arrington arringto...@gmail.com mailto:arringto...@gmail.com Date: Fri, Oct 31, 2014 at 9:36 AM Subject: Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications To: users@global.libreoffice.org mailto:users@global.libreoffice.org Tim, I'm way too late in this thread to be helpful as I have been absent for several months (for some reason the list stopped recognizing my email address, so I recently resubscribed with a different address). That said, I can relate to what I perceive to be your issues. I do a lot of Bible study work with LO and eSword and Bibletime as well as Bible.org. I always run into problems when I copy and paste quotes from one of these sources to LO. As I look at your document (an interesting study indeed, btw -- love the reference to Origen), I see a lot of formatting inconsistency going on. Font changes, smartquotes here, dumbquotes there, etc. This is the result of pasting formatted text from one source into LO. Now you may not care about this as I'm sure these are probably private notes, not necessarily for dissemination, but... In my experience with extra-LO sources such as eSword, etc., I've come to always paste using Paste-Special/Unformatted text. That way, I can then quickly apply an appropriate paragraph style to the text and all is well. Virgil btw., Ironically, as I'm typing this, I'm sitting in my Law Office Technology class while my students are taking a test on the use of paragraph styles. After teaching this class for five semesters, I've finally found an approach that works. I think Tom suggested it. I give them an unformatted document and ask them to format it using any method they understand. They usually take 30 to 45 minutes and end up with a mess. I then demonstrate reformatting the document with styles and I'm done in about 3 minutes and the document formatting is consistent and useful. I then ask, If your client was paying $200 an hour to have a legal document prepared and formatted, who would they rather pay, me or you? On 10/31/2014 9:57 AM, Tim Deaton wrote: Sorry for the delay in responding. Too many other things going on. -- Tim === On 10/26/2014 4:56 PM, Brian Barker wrote: At 16:25 26/10/2014 -0400, Dan Lewis wrote: On 10/26/2014 02:13 PM, Brian Barker wrote: At 13:51 26/10/2014 -0400, Tim Deaton wrote: I'm currently running LO v4.2.6.3 on Windows 7, 64-bit, SP1. I use Writer primarily to create notes for Bible study lessons. In that process, I often copy text into Writer from other programs (most likely e-Sword and TheWord (two free Bible software programs which, I think, both use the SQLite open-source database program). The template I use for this has the default tab-stop setting
Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications
Wow, you're really bringing your students up to date; congratulations! Maybe I should start using 'styles' ;-) From: Virgil Arrington arringto...@gmail.com Date: Sat, Nov 1, 2014 at 2:41 PM Subject: Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications To: anne-ology lagin...@gmail.com Cc: users@global.libreoffice.org On 11/1/2014 9:33 AM, anne-ology wrote: I agree with your method ... congratulate you on obviously being a bright teacher. Now ... I'm curiously wondering how using 'styles' differs from the 'select all' then changing the font, or whatever; that method takes me mere seconds as well ;-) Also, I'm curiously wondering what method(s) your students would be using which would take them so long ??? If the *only* thing you want to change is the font document-wide, then your select all method will work. But formatting goes far beyond changing a font. The documents I typically create (as simple as they are) have many different types of paragraphs including the following: - A Title, set in 20 point, bold, Linux Biolinum G, centered, with 12 points of white space below the paragraph. - A Subtitle, the same as the Title, except with 16 point, bold type. - Several Section Heading paragraphs, each with Linux Biolinum G in ever reducing sizes, flush left, with 12 points of white space above the paragraph, and with automatic numbering through the Outline Numbering. Also, I have them set to keep with the next paragraph, which is important when creating heading styles to ensure that you don't have a random heading by itself at the bottom of the page with the following paragraph on the next page. If I need a Chapter Title paragraph, I can create it to always begin on a new page. - A main Body paragraph, with 12 point Linux Libertine G, set flush left, single spaced, with 12 points of white space above it. - A main Body paragraph, the same as the above, but with an indented first line (2 picas) and no white space above the paragraph. - Main Body paragraphs set double-spaced for legal briefs and scholarly paragraphs. - A Blockquote paragraph, which is single spaced and indented 2 picas on the left margin with additional white space above and below the paragraphs. To generate all of this formatting without styles requires the user to format each paragraph or set of paragraphs directly, selecting each formatting characteristic separately, including font, size, line spacing, paragraph indents, and on and on. Doing it directly takes a lot of time, and then you have to be careful to make sure all your section headings are formatted consistently (was that 16 points or 18 points?). But, to do it with styles is super quick. And the consistency throughout the document almost brings tears of joy to my eyes. Virgil -- 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] How to add/delete a column without changing the size of the other columns
Hi, Our wiki TDF has an article «How to add/delete a column without changing the size of the other columns» [1]. I can not achieve the expected result when I follow this instruction. Perhaps, something is missing there or there is another way to do it. Thanks for any ideas. Lera. [1] https://wiki.documentfoundation.org/Faq/Writer/161 -- 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] Invoking a dialog from a macro to insert text into a Writer document
Hi Volker: Thank you for answering. I solve the problem after reading and re reading your answer at least a hundred times. My bad was assuming that OOME_30 was actually the name of the file containing the library instead of assuming that was the name of the library, using Standard instead of Template fix the problem. Surely a couple of templates are the best option, but the use of such templates are forbidden :( El Sábado, 1 de noviembre, 2014 13:08:04, Volker Lenhardt volker.lenha...@uni-due.de escribió: Hi Angel, Am 01.11.2014 um 12:28 schrieb Angel Pérez: Hi guys: I work on a call center and everyday I aswer about 20 call with the exact requirements, so I thought about making a macro to speed things up. The procedure is this, normally I copy some text from a web page and paste it on a text document, I read the text to the client and write down the answer (I.E: Phone line active?, yes). I was reading Andrew Pitonyak’s OpenOffice.org Macros Explained (OOME) and on page 606 he explains how to invoke a dialog from a macro. I don't know what I'm doing wrong but everytime I try to run the macro to invoke the dialog I got BASIC runtime error.An exception occurredType: com.sun.star.container.NoSuchElementExceptionMessage: . pointing to line 15 DialogLibraries.loadLibrary(Template) There simply is no library Template in the library container where the macro resides. Either the macro is called from the MyMacro global container or the macro is called from a document's container. Did you see Andrew's remark on GlobalScope.DialogLibraries? Did you take care of correct upper or lower case? What I'm trying to do is this, a macro to invoke a dialog with 3 buttons (Enable Services, Disable Services, Call Retrieval). When I push a button I call another dialog with buttons that represent all the questions a ask the clients (I.E, when I push Enable Services I invoke a dialog with all the questions related to the process to enable aditional services Phone line is active?, What is your OS?, Do you have an AV installed?). The use case is this, a call is answered, I take the personal data and then I execute the macro, the macro call the dialog, in the dialog I click button Enable Services and it bring the second dialog, when I click the buttons Phone line is active?, What is your OS?, Do you have an AV installed? the macro should end and I should have writed down on the document the questions Phone line is active?, What is your OS?, Do you have an AV installed? I already design the dialogs, but I can't invoke the first dialog from the macro, or the following dialogs after clicking the buttons, and I don't have any text written down on my document... Any help on this is highly appreciated. I'm sorry, but I can't see the benefit of a macro, where a set of template documents would do better and faster. Volker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[Solved] Re: Fwd: [libreoffice-users] LO Calc question...
Hi :) Good plan! :) I was wondering if another way might be to use the freeze window to keep the left side steady and then do the split on the right. I tend to find the split thing gets VERY confusing because people seem to be able to scroll all different ways inside all 4 quadrants. Better to just open the same file 2-4 time imo. The freeze option keeps it's 4 quadrants lined-up with each other other and looks very tidy and professional. Errr, i just tried it and you can't use split and freeze at the same time. Split looked a LOT less confusing than when i last used it (in the previous millenium (so i guess some things have moved on since then!)). So my next thought was whether the spreadsheet could be viewed in html, maybe with frames (yuk!) or something? Also wondering if Gnumeric could view the spreadsheet in such a way? It might be an interesting feature request. I can't imagine many people needing it but it might still be interesting. I wonder if it could be added as an Extension. That made me wonder if someone already has created an Extension to do this. There are a few Extensions that greatly add to Calc's functionality so i wonder if any of them do this already. Personally i would rather see Calc gain the ability to have a chart be an entire sheet rather than having to try to put a chart on top of a sheet (and maybe some weeu scrolling too far and 'lose' the chart). On the other hand Andrew seems happy to do what most of us do and just move the chart so this thread is really closed now isn't it? ;) Regards from Tom :) On 1 November 2014 12:04, Andrew Sullivan andrew.t.sulli...@gmail.com wrote: Thanks for that - I'll just move the chart! On 31 October 2014 21:16, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: I think freeze and split windows are intended for scrolling around large table of data, for example to keep heading and total rows and columns in view. So they keep the rows in the views next to each lined up so the headings match the data. But as I understand it, you want to break that coupling, so you can scroll the left side up and down without the right side moving. I don't think that's possible, although it may be an interesting feature request. As it happens, I have a similar sheet where I'm continually adding new data to the bottom of the table and have a chart to the right of it, but I just move the chart down the sheet as more data is added. Another possibility is use Window New Window to open a second window of the same document, then arrange the two windows on screen as you want. Changes in one window are reflected in the other (it's the same document, not a copy). But I don't think that arrangement is saved so you'd have to set the windows up each time you open the file, which may or may not work for you. It may be possible to use a macro to automate opening a second window and positioning it, but I'm not sure of the details for that and may not work too well if someone with a different size screen opens it. A couple of things which I don't think are quite what you want, but mention in case they do the trick or inspire other ideas... Place the cursor in F1 before selecting Window Split or Window Freeze. But the two halves would scroll together vertically; you'll only be able to scroll them separately horizontally. You can also split both horizontally and vertically at the same time by first positioning the cursor somewhere in the middle of the sheet (e.g. F20) then Window Split. But again the two parts next to each other horizontally would be kept in sync when scrolling vertically, and the two parts stacked vertically would be kept in sync when scrolling horizontally. So you'd end up with only the lower left part available for scrolling around your data. If you scrolled the top left part vertically, or the lower right part horizontally, it would also scroll your chart in the top right out of view. (Hope that all makes sense... if not just try it and see what happens!) Mark. Andrew Sullivan wrote: Is it possible to freeze the left and right parts of a spreadsheet (as opposed to the upper and lower parts, which I know you can do)? Thanks Andrew On 26 October 2014 20:06, Andrew Sullivan andrew.t.sulli...@gmail.com wrote: That doesn't do exactly what I want... The data starts at A1; the chart occupies the space G3/M19. What I'd ideally like to do is split the sheet vertically between say columns E and F and be able to scroll the data columns. Can this be done? Thanks again. Andrew On 26 October 2014 19:21, Joe Conner joeconner2...@gmail.com wrote: You are able. Select a cell below your chart, then select WINDOW - FREEZE. That should do it. Blessings, Joe Conner, Poulsbo, WA USA On 10/26/2014 11:48 AM, Andrew Sullivan wrote: Hello First post here, hope it's in the right
Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications
Styles work best if you are creating the same types of documents over and over again. But, if each document is unique and relatively short, you'll spend more time setting up your styles than just getting your work done. Indeed, one of the drawbacks of using styles is that they take considerable investment of time and effort to create and/or maintain. To me, the investment has been worth it, and I would consider it essential to really good output, but I fully understand when other people say they just want to get their work done without fiddling with the program itself. Virgil On 11/01/2014 04:19 PM, anne-ology wrote: Wow, you're really bringing your students up to date; congratulations! Maybe I should start using 'styles' ;-) From: Virgil Arrington arringto...@gmail.com Date: Sat, Nov 1, 2014 at 2:41 PM Subject: Re: [libreoffice-users] Tab defaults change when pasting into Writer from some other applications To: anne-ology lagin...@gmail.com Cc: users@global.libreoffice.org On 11/1/2014 9:33 AM, anne-ology wrote: I agree with your method ... congratulate you on obviously being a bright teacher. Now ... I'm curiously wondering how using 'styles' differs from the 'select all' then changing the font, or whatever; that method takes me mere seconds as well ;-) Also, I'm curiously wondering what method(s) your students would be using which would take them so long ??? If the *only* thing you want to change is the font document-wide, then your select all method will work. But formatting goes far beyond changing a font. The documents I typically create (as simple as they are) have many different types of paragraphs including the following: - A Title, set in 20 point, bold, Linux Biolinum G, centered, with 12 points of white space below the paragraph. - A Subtitle, the same as the Title, except with 16 point, bold type. - Several Section Heading paragraphs, each with Linux Biolinum G in ever reducing sizes, flush left, with 12 points of white space above the paragraph, and with automatic numbering through the Outline Numbering. Also, I have them set to keep with the next paragraph, which is important when creating heading styles to ensure that you don't have a random heading by itself at the bottom of the page with the following paragraph on the next page. If I need a Chapter Title paragraph, I can create it to always begin on a new page. - A main Body paragraph, with 12 point Linux Libertine G, set flush left, single spaced, with 12 points of white space above it. - A main Body paragraph, the same as the above, but with an indented first line (2 picas) and no white space above the paragraph. - Main Body paragraphs set double-spaced for legal briefs and scholarly paragraphs. - A Blockquote paragraph, which is single spaced and indented 2 picas on the left margin with additional white space above and below the paragraphs. To generate all of this formatting without styles requires the user to format each paragraph or set of paragraphs directly, selecting each formatting characteristic separately, including font, size, line spacing, paragraph indents, and on and on. Doing it directly takes a lot of time, and then you have to be careful to make sure all your section headings are formatted consistently (was that 16 points or 18 points?). But, to do it with styles is super quick. And the consistency throughout the document almost brings tears of joy to my eyes. Virgil -- 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] Gliffy- and Tango-inspired palette - https://github.com/sentientmeatnet/glyphic-tang
Hi, I spent a couple days obsessing and built an alternative palette to the default color palette in LibreOffice Writer and Draw. I uploaded the single file you need -- standard.soc -- to GitHub: https://github.com/sentientmeatnet/glyphic-tang The color choices are inspired by colors in Gliffy (web-based drawing and diagram software) and Linux Tango Desktop Project. I spent some time… choosing all the names tweaking all the color value choices and filling in a few of the hue gaps between Gliffy's hues in their uneditable palette. After all that work, I do understand why Gliffy left those gaps. The new hue lines are not as pretty. But I wanted SOME representatives in those hues without the kitchen sink approach many palettes have, with seemingly automated color interpolation. I wanted a more tweaked, esthetic collection that harmonizes well across hues. Give it a try if you like. It's useful to me anyway and I thought I'd share. -- Dean http://sentientmeat.net -- 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
