Re: [libreoffice-users] Email address of the admin/moderator please?
On Friday 17 February 2012, sharon kimble wrote: Does anyone know the email address of the admin or moderator of this mailing list please, as I need to write to them re subscribing from my gmail account? should be users+owner @ global.libreoffice.org (without the blanks) else, try this: quote source=http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ If all your attempts to unsubscribe just don't work, then - as a last resort - please send a message to postmaster @ documentfoundation.org and include the following information: The lists you want to be unsubscribed from, the address you're subscribed with, and detailed information about the problems you encountered. /quote Nino -- For unsubscribe instructions e-mail to: users+h...@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: LO 3.5 - Can't see page margins in Writer
Jean-Francois Nifenecker wrote: The place where to bring questions to the devs has to be a visible and accessible place. [...] I guess there's some work to be done to resolve those two points. Hi Jean-Francois, not necessarily - what would be equally workable is a group of change agents (Regina, Cor, NoOp, you in this case, but also UX people like Christoph), who have their eyes ears here and at the forums and convey to ux-advise or the dev list. Also, what would greatly reduce the cost friction that changes will cause in the future, is early feedback. We invested quite some resources into providing nightly builds here: http://dev-builds.libreoffice.org/daily/ (and my, and other hackers' personal time and money to keep those hosts running), so any suggestion to have people actually download play with those builds greatly appreciated. Cedric blogged his feature here: http://cedric.bosdonnat.free.fr/wordpress/?p=818 (that's also aggregated on planet.documentfoundation.org), but possibly we could do better spreading the word - would someone (you?) be interested in compiling a weekly or monthly newsletter for LibreOffice? BTW, what if many people jump in the ux list and post thousands of messages? ;) Well, ux-advise has a rather narrow topic, that should naturally reduce the breadth of the discussion - otherwise, more participation is a problem I would love to have there. ;) Well, I could do it, yes. In fact, as you might have seen, I did for the first time a few hours ago. I can say that the latest answer my message received is not that encouraging (in short: do it yourself. Doh). Thanks for jumping in indeed - well, you *did* it yourself. Let's see where that (constructive) discussion gets us to. Cheers, -- Thorsten -- For unsubscribe instructions e-mail to: users+h...@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] Gmail
On Fri, 17 Feb 2012 00:22:40 + sharon kimble boudic...@talktalk.net wrote: Hello sharon, that I emailed a subscription request to the server half an hour ago from my gmail account, and I haven't heard back yet, although I've been checking it every ten minutes. Spam folder, perhaps? -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Where will you be when the bodies burn? The Gasman Cometh - Crass -- For unsubscribe instructions e-mail to: users+h...@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] Email address of the admin/moderator please?
Hi :) It occurred to me that Sharon might not be able to receive replies to the list that she can't subscribe to so i thought i would use CC to include her. Also a lot of time the users+ is treated differently from the rest of the address so i thought i would space the answer a little differently so that the entire address appears on it's own line with nothing else on that line except the address. Regards from Tom :) --- On Fri, 17/2/12, Nino Novak nn.l...@kflog.org wrote: From: Nino Novak nn.l...@kflog.org Subject: Re: [libreoffice-users] Email address of the admin/moderator please? To: users@global.libreoffice.org Date: Friday, 17 February, 2012, 9:29 On Friday 17 February 2012, sharon kimble wrote: Does anyone know the email address of the admin or moderator of this mailing list please, as I need to write to them re subscribing from my gmail account? should be users+owner @ global.libreoffice.org (without the blanks). Else, try this: quote source= http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe If all your attempts to unsubscribe just don't work, then - as a last resort - please send a message to postmaster @ documentfoundation.org and include the following information: The lists you want to be unsubscribed from, the address you're subscribed with, and detailed information about the problems you encountered. /quote Nino -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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: LO 3.5 - Can't see page margins in Writer
Hallo Thorsten , A agree, i also looked over the possible problems with no margins for a page, but there was no communication over the column margins. Like i sayed before there are workarounds for the page margins, but working with columns and pictures covering more than 1 column becomes very problematic (imposible) Greetz Fernand Jean-Francois Nifenecker wrote: The place where to bring questions to the devs has to be a visible and accessible place. [...] I guess there's some work to be done to resolve those two points. Hi Jean-Francois, not necessarily - what would be equally workable is a group of change agents (Regina, Cor, NoOp, you in this case, but also UX people like Christoph), who have their eyes ears here and at the forums and convey to ux-advise or the dev list. Also, what would greatly reduce the cost friction that changes will cause in the future, is early feedback. We invested quite some resources into providing nightly builds here: http://dev-builds.libreoffice.org/daily/ (and my, and other hackers' personal time and money to keep those hosts running), so any suggestion to have people actually download play with those builds greatly appreciated. Cedric blogged his feature here: http://cedric.bosdonnat.free.fr/wordpress/?p=818 (that's also aggregated on planet.documentfoundation.org), but possibly we could do better spreading the word - would someone (you?) be interested in compiling a weekly or monthly newsletter for LibreOffice? BTW, what if many people jump in the ux list and post thousands of messages? ;) Well, ux-advise has a rather narrow topic, that should naturally reduce the breadth of the discussion - otherwise, more participation is a problem I would love to have there. ;) Well, I could do it, yes. In fact, as you might have seen, I did for the first time a few hours ago. I can say that the latest answer my message received is not that encouraging (in short: do it yourself. Doh). Thanks for jumping in indeed - well, you *did* it yourself. Let's see where that (constructive) discussion gets us to. Cheers, -- Thorsten -- For unsubscribe instructions e-mail to: users+h...@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 do I change page orientation for only ONE page in Writer?
Thanks everyone. Sorry for my delayed reply. 2012/2/4 Dan Lewis elderdanle...@gmail.com Open the Styles and Formating window. (Use the F11 key to do this.) In the row of tools at the top of this window, click the Page Styles (fourth from the left.) Default should be highlighted. Insert a page break: Insert Manual Break. Page Break will be selected. If it is not, click it. Below this is the Style drop down list. Open this list, and select Landscape from it. Click OK. If the next page already exists and you want it to be portrait, you will have to create another page break at the bottom of the Landscape page to change the page style back to Default. If the next page does not exist yet: Right click the Landscape page style and select Modify from the context menu. Click the Organizer tab. The Next Style box has Landscape as the default next style. Change Landscape to Default. Click OK. When you complete the Landscape page, Writer will automatically make the next page Portrait. Doing this is all about styles. The Writer Guide explains how to do this and has screenshots to help in the explanation. It is a good reference any number of problems that may appear when using Writer. --Dan On Sat, 2012-02-04 at 10:30 +0100, Daniel Wibbing wrote: Hi Konstantinos, you could convert the page of which you want to change the orientation into a Title page: Format/ Tilte Page … / Convert existing pages to title pages / Place title pages at page 3 (e.g.) / Edit Page Properties /Orientation Landscape However when I tried this, the first page of the document would also change its orientation. I don't know how to switch this off. Does that help you in any way? Daniel Am 31.01.2012 um 12:31 schrieb Konstantinos Tzoannopoulos: What the subject says - I need to change the orientation of only ONE page in Writer, but for some reason it only lets me do it for ALL the pages. Anyone know what I'm doing wrong? -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Spell check for 3.4.5 on Win7 not working
Sorry Tom, but I installed the one I always use for initial Java install before I install LO. As I id say, I hope to get access to the laptop soon to connect it to the Net and work on the problem[s]. Then I can get all of the Win7 updates and get the utility software as well. On 02/16/2012 08:15 PM, Tom Davies wrote: Hi :) Hmm, weird. Perhaps it's too high a version of java? Is it using a more recent version than 6u21? Regards from Tom :) --- On Fri, 17/2/12, webmaster for Kracked Press Productionswebmas...@krackedpress.com wrote: From: webmaster for Kracked Press Productionswebmas...@krackedpress.com Subject: Re: [libreoffice-users] Spell check for 3.4.5 on Win7 not working To: users@global.libreoffice.org Date: Friday, 17 February, 2012, 0:20 Her laptop is faster than my quad. It is a desktop replacement. There is hardly any space used on the drive itself. She has not had time to place anything on it. I wish I had a machine as fast as her laptop. I still have to add Virus protection and other utilities as well. LO was the first package to be installed on the thing. I added some video files [less than 3 Gig total] to the laptop so she could watch them later. So I doubt it is an issue with a too full system or one needing to be defragged, etc., etc.. She has had it less than 1 week and I said, I was the first one to place anything on the drive. She does not even have Internet yet. On 02/16/2012 09:30 AM, Tom Davies wrote: Hi :) Sounds like her machine was just being a bit slow. If that is Windows then perhaps defrag, Disk Clean-up, perhaps uninstall the 2nd and 3rd antivirus program. Watch out for auto-scans and defrags. Empty the wastebin and the wastebin of the emailing program she uses. Windows performance seems to suddenly drop off if the 'drive' is over 80% full. If the defragger shows 21% free space then that is about as good as it gets unless you can get it right down to almost nothing on the hard-drive (unlikely) when there seems to be another slight boost in performance. Set the virtual memory to a fixed size about 2xRam or a little less, anything over Ram but below 2xRam is about perfect. The virtual memory is probably heavily fragmented as it's been randomly changing size and throwing bits of itself all over the drive. Setting it to a fixed size stops it getting worse. The standard Windows defragger can't do system-files, such as the virtual memory (pagefile.sys on Xp and earlier), which are usually the ones that make the biggest difference. Hmmm, ideally a reinstall of Windows and then set the virtual memory might be best but it takes a LOT of time to install all the other programs and tweak and update everything. Maybe LO took her just over the 80%? On pretty much any OS check what processes start-up when the machine is booted up and when scheduled tasks are due to run. I tend to switch all that off (or at least the bits i know how to do myself, such as defrags, updates and antivirus-scans) and then try to remember to do maintenance tasks at a time to suit myself. Regards from Tom :) --- On Thu, 16/2/12, webmaster for Kracked Press Productionswebmas...@krackedpress.com wrote: From: webmaster for Kracked Press Productionswebmas...@krackedpress.com Subject: [libreoffice-users] Spell check for 3.4.5 on Win7 not working To: LibreO - Users Globalusers@global.libreoffice.org Date: Thursday, 16 February, 2012, 12:36 I loaded 3.4.5 onto a Win7 [64-bit] laptop yesterday at a meeting for a lady. She wanted to use LO to type up the notes of the meeting right there. But after she saved the document, she clicked on the spell check icon and the windows came up empty with a not responding text in the pop up window name. Anyone have that problem with a newer HP laptop? Any idea how to fix this? I did not have the time to try to work with her to figure out what the issue was, but I hope to get with her soon to fix the problem and add more free software to her brand new laptop. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] LibreO-Base is lying about my age -- The End!
Andreas, Dan, Drew - and others
Thank you very much for your help and giving me your time.
I really admire you for your enthusiasm to helping others.
Even if I did not directly get all the answers, you forced me to
investigate - I have learned a lot!
The situation regarding the function DATEDIFF('year', ...) in
LibreO-Base/HSQLDB seems to be:
1. from SQL's point of view does LO-BHSQLDB calculate the
function quite correctly.
It is not a matter of mathematics - nor are there any int() or
roundings; it is a matter of (not so logical!) definition that you
simply have to be aware of.
DATEDIFF() does not calculate the difference between the given dates:
it calculates the difference between the datepart values that it has
extracted from the given datevalues using the selected datepart type
(year, yy, mm, dd, etc). From two dates 2.11.1939 and 17.2.2012
DIFFDATE('year',..) calculates with the 'year' values 1939 and 2012.
With datepart 'mm' it calculates first from each given datevalue the
total amount of months, extracts them, and then calcs the difference; to
get the result in years the function shall be divided by 12 (as Drew
said). Alternatively do DATEDIFF('dd',...)/365.
2.in most other SQL db-generators '' is a valid abbreviation
for 'year' but obviously not in HSQLDB (v.2.2) and thus not in
LibreO-Base either..
I think that this was not quite clear for all you neither.
I apologize for being a little irritated.
All the best
Pertti Rönnberg
--
For unsubscribe instructions e-mail to: users+h...@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 vertical scroll bar in LibreOffice Writer 3.5 for Mac OS X
Hi :) I think posting a bug-report would be great http://wiki.documentfoundation.org/BugReport I have not heard of other people having the same problem but it is probably happening to others too and they are just being quiet about it. Regards from Tom :) --- On Fri, 17/2/12, Kal Sze (@k_sze) swordan...@gmail.com wrote: From: Kal Sze (@k_sze) swordan...@gmail.com Subject: [libreoffice-users] Problem with vertical scroll bar in LibreOffice Writer 3.5 for Mac OS X To: users@global.libreoffice.org Date: Friday, 17 February, 2012, 6:29 There seems to be a problem with the vertical scroll bar when editing documents in LibreOffice Writer 3.5 for Mac OS X. When the document is long enough and the vertical scroll bar shows up, I have to click the very top of the scroll bar handle in order to drag it; if I click even slightly lower, Writer will directly page-down instead of allowing me to drag the handle. Even worse, if the document is so long that the scroll bar handle becomes about only 0.5 cm long, the clickable zone of the scroll bar handle completely disappears, such that regardless of which part of the scroll bar handle I click, Writer will either directly page-up or page-down. Is every Mac user experiencing the same problem? -- View this message in context: http://nabble.documentfoundation.org/Problem-with-vertical-scroll-bar-in-LibreOffice-Writer-3-5-for-Mac-OS-X-tp3752844p3752844.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Spell check for 3.4.5 on Win7 not working
Hi :) I know LibreOffice 3.5.0 can use java 1.7 but i doubt that has been back-ported to all other releases that people are using out there. Java is going to be a problem until we can get rid of any dependence on it completely. It's not our devs fault that Oracle can't write something that isn't broken and vulnerable before Oracle release it. Regards from Tom :) --- On Fri, 17/2/12, V Stuart Foote vstuart.fo...@utsa.edu wrote: From: V Stuart Foote vstuart.fo...@utsa.edu Subject: RE: [libreoffice-users] Spell check for 3.4.5 on Win7 not working To: users@global.libreoffice.org Date: Friday, 17 February, 2012, 1:47 Tom, It is buried down in the Dev list, but the LibO BASE JDBC performance issues with the Java JRE are fixed by changes to the JDBC driver to reduce JNI Attach/DetachThread cycles, the 35023 bug (https://bugs.freedesktop.org/show_bug.cgi?id=35023 ) is closed. We should no longer be pusing the JRE 1.6u21--current JRE 1.6u31 or 1.7u3 are fully acceptable. Look elseware for the issue with spell check. Stuart -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Thursday, February 16, 2012 7:16 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Spell check for 3.4.5 on Win7 not working Hi :) Hmm, weird. Perhaps it's too high a version of java? Is it using a more recent version than 6u21? Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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-documentation] Re: [libreoffice-users] Word import TOC link style
Hei, Yes, that's fine in theory how to adjust existing TOCs but it doesn't actually tell me how to make these links use index link automagically when I open a word document in writer. I don't also see any way to change the TOC defaults. I can insert a TOC in the template, yes, but that will only achieve having a TOC in all new documents (?). TOC settings do not appear in the style manager or any other place I've found. I can only see them when inserting a new TOC or editing an existing one. WRT template changer, I'm not really sure it's really faster than changing the internet link -style. The keyword here is how to make this happen automagically. I'd love to recommend libreoffice as a handy indexed PDF creator but those amateurish looking garish TOC entries are just not professional looking at all in a document that's supposed to be handed to clients. If you have read a 400-page microcontroller handbook in PDF that isn't indexed you know it'd be pretty easy sell.. Tom wrote Hi :) Thanks Jean :) So, that is Chapter 12 of the Writer Guide in this link http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide or at the official website's documentation (same guide is on both) Regards from Tom :) --- On Wed, 15/2/12, Jean Weber hidden wrote: From: Jean Weber hidden Subject: Re: [libreoffice-documentation] Re: [libreoffice-users] Word import TOC link style To: documentation@.libreoffice Date: Wednesday, 15 February, 2012, 20:20 What template is used for import? If it's the default template for Writer docs, he could set a custom default template. Otherwise, after import he could use Template Changer to apply his custom template; that should be faster than changing the style each time. Aside: instead of changing the Internet link style in order to change the TOC's appearance (which also changes it for actual internet links), I would change the Index Link style and apply that style to the TOC. I think there are instructions about how to change the TOC's link style in the Writer Guide's chapter on TOCs. --Jean So far so good but the default style for TOC items and links in word document is internet link style which is to my mind rather ugly underlined blue. Word uses black font for the TOC-style links normally and blue links only for actual internet links. -- View this message in context: http://nabble.documentfoundation.org/Re-libreoffice-documentation-Re-libreoffice-users-Word-import-TOC-link-style-tp3748246p3753997.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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-documentation] Re: [libreoffice-users] Word import TOC link style
Hi :) I am not sure but when you have a ToC it picks-up new headings that have the appropriate style applied doesn't it? So if you have it so that the ToC picks-up Heading1 and Heading2. Then you 1. write a couple of words 2. apply the style Heading2 to those words 3. right-click in the ToC and tell it to update So set-up a ToC for a short document, delete the contents but leave the ToC (which will look fairly blank) and then save as an OpenDocument Format (a .OTT in this case i think) template? Regards from Tom :) --- On Fri, 17/2/12, Barleyman olli...@gmail.com wrote: From: Barleyman olli...@gmail.com Subject: Re: [libreoffice-documentation] Re: [libreoffice-users] Word import TOC link style To: users@global.libreoffice.org Date: Friday, 17 February, 2012, 15:27 Hei, Yes, that's fine in theory how to adjust existing TOCs but it doesn't actually tell me how to make these links use index link automagically when I open a word document in writer. I don't also see any way to change the TOC defaults. I can insert a TOC in the template, yes, but that will only achieve having a TOC in all new documents (?). TOC settings do not appear in the style manager or any other place I've found. I can only see them when inserting a new TOC or editing an existing one. WRT template changer, I'm not really sure it's really faster than changing the internet link -style. The keyword here is how to make this happen automagically. I'd love to recommend libreoffice as a handy indexed PDF creator but those amateurish looking garish TOC entries are just not professional looking at all in a document that's supposed to be handed to clients. If you have read a 400-page microcontroller handbook in PDF that isn't indexed you know it'd be pretty easy sell.. Tom wrote Hi :) Thanks Jean :) So, that is Chapter 12 of the Writer Guide in this link http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide or at the official website's documentation (same guide is on both) Regards from Tom :) --- On Wed, 15/2/12, Jean Weber hidden wrote: From: Jean Weber hidden Subject: Re: [libreoffice-documentation] Re: [libreoffice-users] Word import TOC link style To: documentation@.libreoffice Date: Wednesday, 15 February, 2012, 20:20 What template is used for import? If it's the default template for Writer docs, he could set a custom default template. Otherwise, after import he could use Template Changer to apply his custom template; that should be faster than changing the style each time. Aside: instead of changing the Internet link style in order to change the TOC's appearance (which also changes it for actual internet links), I would change the Index Link style and apply that style to the TOC. I think there are instructions about how to change the TOC's link style in the Writer Guide's chapter on TOCs. --Jean So far so good but the default style for TOC items and links in word document is internet link style which is to my mind rather ugly underlined blue. Word uses black font for the TOC-style links normally and blue links only for actual internet links. -- View this message in context: http://nabble.documentfoundation.org/Re-libreoffice-documentation-Re-libreoffice-users-Word-import-TOC-link-style-tp3748246p3753997.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 3.5 - Can't see page margins in Writer
What you see is what you get is the rule of thumb. It's an interface for human beings. Anything else is asking for trouble. On 2/14/2012 11:20 AM, noibs wrote: I just upgraded to 3.5 from 3.4.4. There are no page margins visible for my Writer documents last saved in 3.4.4. Am I missing something? I've looked for a preference and can't find one. I'm using Mac OS 10.7.3. Thanks. -- View this message in context: http://nabble.documentfoundation.org/LO-3-5-Can-t-see-page-margins-in-Writer-tp3744148p3744148.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Can't find folder for templates
On Thu, 16 Feb 2012 23:30:40 -0800 (PST) Andreas Säger ville...@t-online.de dijo: FileTemplatesSave... will store the template in the right directory FileTemplatesand register it so it appears in FileNewTemplates and in FileTemplatesOrganize... ToolsOptionsPaths shows all the paths used by the office suite. Thanks. Problem solved. -- For unsubscribe instructions e-mail to: users+h...@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 3.5 - Can't see page margins in Writer
Le 17/02/2012 17:51, Paul D. Mirowsky a écrit : What you see is what you get is the rule of thumb. It's an interface for human beings. Anything else is asking for trouble. Do you mean you never display the unprintable chars? -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@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] LibreO-Base is lying about my age -- The End!
On Fri, 2012-02-17 at 16:49 +0200, Pertti Rönnberg wrote:
Andreas, Dan, Drew - and others
Thank you very much for your help and giving me your time.
I really admire you for your enthusiasm to helping others.
Even if I did not directly get all the answers, you forced me to
investigate - I have learned a lot!
The situation regarding the function DATEDIFF('year', ...) in
LibreO-Base/HSQLDB seems to be:
1. from SQL's point of view does LO-BHSQLDB calculate the
function quite correctly.
It is not a matter of mathematics - nor are there any int() or
roundings; it is a matter of (not so logical!) definition that you
simply have to be aware of.
DATEDIFF() does not calculate the difference between the given dates:
it calculates the difference between the datepart values that it has
extracted from the given datevalues using the selected datepart type
(year, yy, mm, dd, etc). From two dates 2.11.1939 and 17.2.2012
DIFFDATE('year',..) calculates with the 'year' values 1939 and 2012.
With datepart 'mm' it calculates first from each given datevalue the
total amount of months, extracts them, and then calcs the difference; to
get the result in years the function shall be divided by 12 (as Drew
said). Alternatively do DATEDIFF('dd',...)/365.
2.in most other SQL db-generators '' is a valid abbreviation
for 'year' but obviously not in HSQLDB (v.2.2) and thus not in
LibreO-Base either..
OK - just a quick note..
Base DOES NOT use hsql2.2, rather it's using 1.8 (and a patched versio n
of that to boot) .. so watch you don't get caught with inconsistencies
there from the 2.2 docs.
Also - / 12 is fine, but Andreas gave you the complete solution,
accounting for the current date being also your birth anniversary.
Anyway - good luck with your endeavors.
//drew
--
For unsubscribe instructions e-mail to: users+h...@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: LO 3.5 - Can't see page margins in Writer
Hi Thorsten, Le 17/02/2012 10:24, Thorsten Behrens a écrit : Jean-Francois Nifenecker wrote: The place where to bring questions to the devs has to be a visible and accessible place. [...] I guess there's some work to be done to resolve those two points. not necessarily - what would be equally workable is a group of change agents (Regina, Cor, NoOp, you in this case, but also UX people like Christoph), who have their eyes ears here and at the forums and convey to ux-advise or the dev list. Good point and certainly a workable intermediate option. Unfortunately, reading some of the msgs on UX lead me to think the devs aren't ready for that. Also, what would greatly reduce the cost friction that changes will cause in the future, is early feedback. Granted. We invested quite some resources into providing nightly builds here: http://dev-builds.libreoffice.org/daily/ (and my, and other hackers' personal time and money to keep those hosts running), so any suggestion to have people actually download play with those builds greatly appreciated. I, for one, have no time enough to play with all the toys that come up in the Libre software world. I happen to download and test LibO builds, but that's not on a regular basis and much of what I learn is from others' mouths. Cedric blogged his feature here: http://cedric.bosdonnat.free.fr/wordpress/?p=818 (that's also aggregated on planet.documentfoundation.org), Yes, but that blog article (like most of the msgs that were posted on the lists) was aimed at headers and footers, not text boundaries that I feel are considered as some kind of a sub-product from the latter. I did participate on the FR discussion list to the header/footer talks but, at that time, left completely apart the text boundaries. I should have been more vocal about that, certainly, but I stood on topic... :( but possibly we could do better spreading the word - would someone (you?) be interested in compiling a weekly or monthly newsletter for LibreOffice? More simply: give more visibility to the UX list. I share your thoughts that given it's aim, many won't subscribe. But those interested will know of its existence. Thanks for jumping in indeed - well, you *did* it yourself. Let's see where that (constructive) discussion gets us to. sigh Thanks for your time, -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Spell check for 3.4.5 on Win7 not working
Tom, No. You've misunderstood the whole Java JRE and BASE HSQLDB performance issue. Problem is not and never was with the Sun/Oracle Java JRE. The past problem with LibO and OOo HSQLDB performance was with process thread creation in the LibO/OOo JDBC interface. The dev patch (by Stephen Bergmann) for Bug 35023 Base functions extremely slowly with Java 1.6.0_20 and 1.6.0_24 has been applied to the 3.5.0 core, and may make it into 3.4.6; but use of a 1.6u21 JRE was only a work around for LibO's BASE native HSQLDB 1.8 performance issues as that version of the JRE handled needed threads differently. Use of Java JRE 1.7 (with Oracle Corp ownership strings) was back ported to 3.4.5--so no issue there. Look for issues with spell check elsewhere. Stuart -Original Message- From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Friday, February 17, 2012 9:05 AM To: users@global.libreoffice.org Subject: RE: [libreoffice-users] Spell check for 3.4.5 on Win7 not working Hi :) I know LibreOffice 3.5.0 can use java 1.7 but i doubt that has been back-ported to all other releases that people are using out there. Java is going to be a problem until we can get rid of any dependence on it completely. It's not our devs fault that Oracle can't write something that isn't broken and vulnerable before Oracle release it. Regards from Tom :) --- On Fri, 17/2/12, V Stuart Foote vstuart.fo...@utsa.edu wrote: From: V Stuart Foote vstuart.fo...@utsa.edu Subject: RE: [libreoffice-users] Spell check for 3.4.5 on Win7 not working To: users@global.libreoffice.org Date: Friday, 17 February, 2012, 1:47 Tom, It is buried down in the Dev list, but the LibO BASE JDBC performance issues with the Java JRE are fixed by changes to the JDBC driver to reduce JNI Attach/DetachThread cycles, the 35023 bug (https://bugs.freedesktop.org/show_bug.cgi?id=35023 ) is closed. We should no longer be pusing the JRE 1.6u21--current JRE 1.6u31 or 1.7u3 are fully acceptable. Look elseware for the issue with spell check. Stuart -- For unsubscribe instructions e-mail to: users+h...@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 3.5 - Can't see page margins in Writer
Absolutely not. Everything has a time and a place. The time for the entire page including its edge may be preview mode to some, just not me. No doubt, I would never try to make a database form document with out looking very carefully at every unprintable character I could find. On 2/17/2012 12:14 PM, Jean-Francois Nifenecker wrote: Le 17/02/2012 17:51, Paul D. Mirowsky a écrit : What you see is what you get is the rule of thumb. It's an interface for human beings. Anything else is asking for trouble. Do you mean you never display the unprintable chars? -- For unsubscribe instructions e-mail to: users+h...@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] LO 3.5 Impress - No image.
The Mac PPC version of LO 3.5 does not show images in Impress Slide Show. Adding images to a slide produces the error Graphics Filter Not Found. The Mac Intel version does not have this problem, neither does the PPC version if you use LO 3.4.5 Can someone confirm this? Tink. -- View this message in context: http://nabble.documentfoundation.org/LO-3-5-Impress-No-image-tp3754993p3754993.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Problem with vertical scroll bar in LibreOffice Writer 3.5 for Mac OS X
I am using an Intel Mac and LO 3.5 I was not aware of the fault, but I have since tried loading a 12MB document and yes, there is a problem with the vertical scroll bar. I am not sure that this is a LO fault though. Tink. -- View this message in context: http://nabble.documentfoundation.org/Problem-with-vertical-scroll-bar-in-LibreOffice-Writer-3-5-for-Mac-OS-X-tp3752844p3755033.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Web based LibreOffice Q+A site online.
Hi, I would like to introduce you to the newest member of the LibreOffice website family. http://ask.libreoffice.org The AskLibO website provides a space where you can ask (and answer!) questions related to LibreOffice. AskLibo is a modern Q+A site, not a Bulletin Board style web forum. So for those not familiar with such sites, please just dismiss it because it is new, this type of support site if proving quite valuable for many communities. However, as with a BBS forum, or this mail list forum even, it only functions to meet user needs when others volunteer their time to answer questions. I would encourage anyone interested in helping to deliver quality support to the LibreOffie user community to look kindly on helping do so. For those that simply prefer this mailing list - not to worry - it is not going anywhere. One Note: Presently the askLibO website UI is English only, the TDF system administrators are working with the developers of askbot (the tool used at the site) to provide localization of both user interface and questions/answers. Finally - a big thank you to Alexander Werner for all his hard work in getting the site up and running. Best wishes, Drew Jensen -- For unsubscribe instructions e-mail to: users+h...@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] Install LO 3.5 on Kubuntu 10.04.03 LTS - 64 bit
Just installed 3.5. The process did not return any errors, but the menus were not updated to reflect the newly installed programs. When I installed 3.4.5 on a similar machine about a month ago, the menus did get updated. On examination I also noted that the libreoffice3.5 executable was not linked into /usr/bin, as the libreoffice3.4 was. Anyone else had this problem? Aside from adding the entries by hand, and one know of a fix? Thanks for your time. William. -- View this message in context: http://nabble.documentfoundation.org/Install-LO-3-5-on-Kubuntu-10-04-03-LTS-64-bit-tp3755076p3755076.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Web based LibreOffice Q+A site online.
Hi :) Wow! That looks confusing at first glance. It makes a lot more sense after just a couple of clicks and half-hearted poking around. I'm in :) Thanks for all the hard work Drew and all :) Many regards from Tom :) --- On Fri, 17/2/12, drew d...@baseanswers.com wrote: From: drew d...@baseanswers.com Subject: [libreoffice-users] Web based LibreOffice Q+A site online. To: users@global.libreoffice.org Date: Friday, 17 February, 2012, 21:41 Hi, I would like to introduce you to the newest member of the LibreOffice website family. http://ask.libreoffice.org The AskLibO website provides a space where you can ask (and answer!) questions related to LibreOffice. AskLibo is a modern Q+A site, not a Bulletin Board style web forum. So for those not familiar with such sites, please just dismiss it because it is new, this type of support site if proving quite valuable for many communities. However, as with a BBS forum, or this mail list forum even, it only functions to meet user needs when others volunteer their time to answer questions. I would encourage anyone interested in helping to deliver quality support to the LibreOffie user community to look kindly on helping do so. For those that simply prefer this mailing list - not to worry - it is not going anywhere. One Note: Presently the askLibO website UI is English only, the TDF system administrators are working with the developers of askbot (the tool used at the site) to provide localization of both user interface and questions/answers. Finally - a big thank you to Alexander Werner for all his hard work in getting the site up and running. Best wishes, Drew Jensen -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Web based LibreOffice Q+A site online.
On Fri, 2012-02-17 at 22:05 +, Tom Davies wrote: Hi :) Wow! That looks confusing at first glance. It makes a lot more sense after just a couple of clicks and half-hearted poking around. I'm in :) Perhaps - but in reality it is just the next step in forum design, applying lessons learned from the past - it is also a design with a very focused purpose - support. When this type of site was advanced by Alex I was rather skeptical but I put a lot of time into researching how they where working out on other projects - they are not a magic bullet, meaning that they can fail to thrive just as any other site might.. but they also offer a lot of good results when there is an active group of knowledgeable responders to users questions present. So - this is _not_ a discussion board, nor is it a social site. Of those sites I surveyed, which where flourishing, this distinction is actively enforced when necessary. Thanks for all the hard work Drew and all :) well, to be clear - I did nothing on this, it is all Alex's work! Best wishes, //drew snip Hi, I would like to introduce you to the newest member of the LibreOffice website family. http://ask.libreoffice.org The AskLibO website provides a space where you can ask (and answer!) questions related to LibreOffice. snip -- For unsubscribe instructions e-mail to: users+h...@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] Install LO 3.5 on Kubuntu 10.04.03 LTS - 64 bit
Hi William, I've done many installs of LibreOffice on Ubuntu. I always download the proper version from the LibreOffice site directly, and then extract it to the desktop, and then run the following three commands in the terminal: (These are for the 64 bit version only of LibreOffice 3.4.5. You can modify them for LibreOffice 3.5. I most likely will not move to 3.5 until 3.5.2 or 3.5.3.) 1. sudo apt-get remove libreoffice*.* 2. sudo dpkg -i ~/Desktop/LibO_3.4.5rc2_Linux_x86-64_install-deb_en-US/DEBS/*.deb 3. sudo dpkg -i ~/Desktop/LibO_3.4.5rc2_Linux_x86-64_install-deb_en-US/DEBS/desktop-integration/libreoffice3.4-debian-menus_3.4-502_all.deb I've always needed to install the menus (line 3 above) separately from the application itself. Don On 02/17/2012 04:52 PM, William Colls wrote: Just installed 3.5. The process did not return any errors, but the menus were not updated to reflect the newly installed programs. When I installed 3.4.5 on a similar machine about a month ago, the menus did get updated. On examination I also noted that the libreoffice3.5 executable was not linked into /usr/bin, as the libreoffice3.4 was. Anyone else had this problem? Aside from adding the entries by hand, and one know of a fix? Thanks for your time. William. -- View this message in context: http://nabble.documentfoundation.org/Install-LO-3-5-on-Kubuntu-10-04-03-LTS-64-bit-tp3755076p3755076.html Sent from the Users mailing list archive at Nabble.com. -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Office Phone: 814-237-6543 Fax: 814-237-6502 Home Phone: 814-422-8111 Cell Phone: 814-571-9518 Visit the Farm and Rural Property Division Web Site at _www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/ _View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@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] Web based LibreOffice Q+A site online.
Am 17.02.2012 22:41, schrieb drew: Hi, I would like to introduce you to the newest member of the LibreOffice website family. http://ask.libreoffice.org Thanks for sharing this! Never heard of askbot before (me stackexchange fanboy ;-) These kind of Q+A sites can really bring community support to a whole new level as they (IMHO) combine the best features of a forum, a mailing list and a wiki while being accessible through a single site/login and being easy to use. So many thanks to the people who established this site! To all the other supporters and myself: Go create an account and start/continue supporting ;-) Mario -- For unsubscribe instructions e-mail to: users+h...@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: Web based LibreOffice Q+A site online.
drewjensen wrote Finally - a big thank you to Alexander Werner for all his hard work in getting the site up and running. Congratulations to Alexander. I had already tested and collaborated on the trial askbot site. I think this a fantastic tool AND it has OpenID sign in validation. I hope all LibreOffice sites follow this trend (especially bugzilla!) Regards, Pedro -- View this message in context: http://nabble.documentfoundation.org/Web-based-LibreOffice-Q-A-site-online-tp3755042p3755209.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Fw: LibreO-Base is lying about my age!
Hi:
I suggest to do this:
If
A1: 2/11/1939
B1: =Now()
Input in A3:
=ROUNDDOWN ((B1-A1)/365)
outcome: 72
Regards,
Jorge Rodríguez
___
El jue, 16-02-2012 a las 13:40 +0200, p...@elisanet.fi escribió:
--- Alkuperäinen viesti ---
Aihe: LibreO-Base is lying about my age!
Päiväys: 15.2.2012 17:46
Lähettäjä: Pertti Rönnberg [p...@elisanet.fi]
Kopio: Pertti Rönnberg [p...@elisanet.fi]
Dear all of you,
First an opinion - correct me if wrong!
I've got the idea that this is kind of a help-desk where every LibreO
user can both ask for help and give info about problems related to
LibreO's components. Without any bad feelings afterwards!
Referring to the irrelevant debates recently and also my own
experiences some weeks ago I would say that a real expert has the
ability to concentrate on the question as-it-is and give a relevant
answer -- he has knowledge enough to understand that there are no silly
or wrong questions.
Every question has its reason - and every question is valuable because
it indicates that there may be something to repair or do better in LibreO.
There is a truth in quality systems (e.g. ISO 9000): without
identifying the weaknesses there is no development.
_And now to my contribution to make LibreO better:_
I need to calculate in LO-Base the difference between an 'olddate' and
today expressed in whole years (no decimals)
The main procedure seems to be the same in LO-Base and OOo as in MSAccess.
The function I placed in the query field is (ref. also to guides in LO
OOo):
datediff('year',table1.olddate,current_date) or
datediff('year',olddate,current_date)
When I inserted my birthdate (2.11.1939) in 'olddate' my computer states
that I am 73 - I'm NOT, I'm still only 72!
The correct result is 72,225 years; and the desired answer without
decimals 72.
I got the same wrong result (73) both in LO-Base and in OOo-Base
the wrong result is not logical - it can not be a rounding up, nor
is it a result of an 'int()'-function
if I replaced 'year' with 'dd' or 'mm' or 'yy' the function works
-- but
when replaced 'year' with '' the function stopped working (why -
'year' and '' ought to be equal!)
the query field does not accept the expression int(datediff(..etc))
the date-format is equal (finnish - see above) in every relevant field
my OS is Windows7Professional/32Bit
I also tried the formula /year(current_date - olddate)/ but the query
did not accept it as a valid expression - can I put that formula
anywhere else?
Anyone there who can tell me how I shall get the LO-Base to be honest?
Regards
Pertti Rönnberg
--
Atentamente,
Jorge Rodríguez
--
For unsubscribe instructions e-mail to: users+h...@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: Problem with vertical scroll bar in LibreOffice Writer 3.5 for Mac OS X
On 2012-02-17 12:29 AM Kal Sze (@k_sze) wrote: There seems to be a problem with the vertical scroll bar when editing documents in LibreOffice Writer 3.5 for Mac OS X. When the document is long enough and the vertical scroll bar shows up, I have to click the very top of the scroll bar handle in order to drag it; if I click even slightly lower, Writer will directly page-down instead of allowing me to drag the handle. Even worse, if the document is so long that the scroll bar handle becomes about only 0.5 cm long, the clickable zone of the scroll bar handle completely disappears, such that regardless of which part of the scroll bar handle I click, Writer will either directly page-up or page-down. Is every Mac user experiencing the same problem? I have no problem. The scroll bar handle does get smaller with multiple page files but is still quite usable on a 250 page document. The handle is the same size for a specific document when opened in LibreOffice 3.5, OOo 3.3, Pages, Bean, or TextEdit. What version of OS X are you using? (I have version 10.6.8) There is a change in scroll bars in Lion (Version 10.7). -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- For unsubscribe instructions e-mail to: users+h...@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: Problem with vertical scroll bar in LibreOffice Writer 3.5 for Mac OS X
I'm using LibreOffice 3.5 on Mac OS X Lion 10.7.3. Larry Gusaas wrote On 2012-02-17 12:29 AM Kal Sze (@k_sze) wrote: There seems to be a problem with the vertical scroll bar when editing documents in LibreOffice Writer 3.5 for Mac OS X. When the document is long enough and the vertical scroll bar shows up, I have to click the very top of the scroll bar handle in order to drag it; if I click even slightly lower, Writer will directly page-down instead of allowing me to drag the handle. Even worse, if the document is so long that the scroll bar handle becomes about only 0.5 cm long, the clickable zone of the scroll bar handle completely disappears, such that regardless of which part of the scroll bar handle I click, Writer will either directly page-up or page-down. Is every Mac user experiencing the same problem? I have no problem. The scroll bar handle does get smaller with multiple page files but is still quite usable on a 250 page document. The handle is the same size for a specific document when opened in LibreOffice 3.5, OOo 3.3, Pages, Bean, or TextEdit. What version of OS X are you using? (I have version 10.6.8) There is a change in scroll bars in Lion (Version 10.7). -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- For unsubscribe instructions e-mail to: users+help@.libreoffice 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 -- View this message in context: http://nabble.documentfoundation.org/Problem-with-vertical-scroll-bar-in-LibreOffice-Writer-3-5-for-Mac-OS-X-tp3752844p3755569.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Problem with vertical scroll bar in LibreOffice Writer 3.5 for Mac OS X
On 2012-02-17 9:32 PM Kal Sze (@k_sze) wrote: I'm using LibreOffice 3.5 on Mac OS X Lion 10.7.3. Are you scrollbars hidden by default until you need them? If so try enabling the to always show. Go into System Preferences, then General and set Show Scroll Bars to Always. I'm not using Lion so don't know if this will help but it is worth a try. -- _ Larry I. Gusaas Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese -- For unsubscribe instructions e-mail to: users+h...@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
