[libreoffice-users] Re: Export PDF
Cliff Scott-2 wrote > I've run into a strange occurrence in LO 4.1.4. Everytime I export to PDF > I > get a error message that "PDF/A-1a forbids a transparency". Clicking OK > allows the export to continue and I don't see any problems in the > resultant > PDF, but this is something I've only seen on 4.1.4. This happens with > Writer > and Calc. FYI, I'm running OSx Mavericks. Is this a known problem? Yes. It started occurring in the v3.6 series. I reported it here: https://bugs.freedesktop.org/show_bug.cgi?id=65439 It appears to be a default warning for PDF/A-1a that needs to be amended either for improved contextualisation or to make it clearer exactly why the warning is being shown. It is a minor issue and there is no clear indication (yet) on which is the preferred option. Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/Export-PDF-tp4096262p4096291.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc: Searching for values in a certain range string
At 16:57 08/02/2014 +0200, Hylton Conacher wrote: What I seek is to be able to have a sheet of Lottery results downloaded from the Internet and pasted into a Calc sheet. On another Calc sheet I will have a listing of the 6 numbers held for each specific draw date. Each populated cell of my ticket sheet will indicate if the number in that cell is the same as a number in a range of cells from the results sheet, on a particular date. As an example: Assume the draw results below dated drew the following numbers: 04/02/2014 16, 03, 19, 21, 23, 06 11/02/2014 17, 05, 02, 20, 22, 04 18/02/2014 09, 40, 05, 09, 42, 03 Also assume that draw numbers I chose for a draw on a date were: 11/02/2014 02, 05, 18, 20, 22, 04 If any number on my ticket matches a corresponding date value, I want the cell to change background colour. Suppose the results are on a Results sheet in columns A to G, starting in row 1. Suppose also that the draw numbers are on a Tickets sheet in the same columns, again starting in row 1. o Create a cell style with a suitable background colour. o Select cell Tickets.B1. o Go to Format | Conditional Formatting... . o Tick Condition 1. o Select "Formula is". o For Cell Style, select your cell style with the coloured background. o In the formula box, enter NOT(ISNA(MATCH(B1;OFFSET(Results.$B$1:$G$1;MATCH($A1;Results.$A$1:$A$99;0)-1;0);0))) . o With Tickets.B1 still selected, click the Format Paintbrush button in the Standard toolbar. o Drag the paintbrush icon from Tickets.B1 across to G1 and down as many rows as necessary. How does it work? The inner MATCH() function searches the date column of the Results sheet and returns the row number of the matching date. The OFFSET() function then creates a reference to the range of results (Bn:Gn) for that date. The outer MATCH() function then searches that range of results for the individual ticket number, returning a column number (which we don't use) if it is found or the error value #N/A if it is not. The ISNA() function tests for #N/A, so returns TRUE if the ticket number was not found, and the NOT() function inverts this, thus returning TRUE for ticket numbers that are matched. Note that you may need to force recalculation of cells before you see new colouring if you modify the data. I trust this helps. Brian Barker -- 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] Export PDF
On February 8, 2014 6:54:39 PM PST, Cliff Scott wrote: >that someone opening a Tagged Format PDF may have problems if they Originally, only Tagged PDF was fully accessible, but a couple of changes during the finalization of the standard meant that PDF/A-1a is equally accessible. Using "Forms in PDF" can confuse screen readers, and other accessibility tools. >the same fonts installed? I thought that wasn't supposed to be the case. The default was that only "rare" fonts are included, and then only for the glyphs that are used. Now, one has the option of including the entire font, regardless of how rare it is. Including fonts can greatly increase the size of the PDF. jonathon -- Your language. Your documents. Your way. -- 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] Export PDF
Cley Faye wrote: > 2014-02-08 23:40 GMT+01:00 Cliff Scott : > > > I've run into a strange occurrence in LO 4.1.4. Everytime I export to PDF I > > get a error message that "PDF/A-1a forbids a transparency". Clicking OK > > allows the export to continue and I don't see any problems in the resultant > > PDF, but this is something I've only seen on 4.1.4. This happens with > > Writer > > and Calc. FYI, I'm running OSx Mavericks. Is this a known problem? > > > > ?I can tell you that it did happen with previous versions. It's only shown > if you have transparent items in the document, so it might not show up all > the time. > > Now, to know what is transparent is more complicated. It could be an image > with an alpha channel (even if completely opaque). It might also be > anything that LO treat as transparent (maybe borders, some special > characters, etc... I don't really know). The thing is, if your output is > correct, it's probably the kind of transparent item that get converted to > white image over white background... no worries. > > However, a bit of warning from personal experience: a few years ago, some > people (mainly using Acrobat Reader I believe) couldn't open PDF/A-1, while > these same files would open fine on pretty much anything: gnome document > viewer, kde viewer (okular), foxit on windows... Pretty funny if you > consider that PDF/A-1 is supposed to work for long term storage. You should > double-check that your files open with this certain reader, just to be sure > :) Cley, I appreciate your comments. I don't know much about the various PDF formats and don't know how I ended up with that format. For some reason I guess at some time I thought it was the best generally readable format. I notice if I uncheck that format it jumps to "Create PDF Form" with 4 format options. Since I'm not making forms it seems as if that isn't the best option. Tagged PDF seems to be the only option left. Is that the recommended format? The help implies that the fonts are only imbedded in PDF/A-1a so does that mean that someone opening a Tagged Format PDF may have problems if they don't have the same fonts installed? I thought that wasn't supposed to be the case. In testing I have just done, the PDF/A-1a came out as 89k, Tagged - 83k and "Create PDF Form" using the PDF format ended up as 67k. I normally am looking for the smallest size so as not to burden people with slow access speeds. All three are readable in Acrobat as well as Preview on my Mac. There's no way I can know what reader everyone will be using if there are any issues any more. Any further comments are welcome. Cliff -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO Base/MySQL questions
On 02/07/2014 09:07 AM, Ian Whitfield wrote: Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any "proper" work - - interesting!!?? I can confirm that when it crashes it takes everything with it so you have to backup every time you make change. This is what forced me to MySQL. Thanks again I had a lot of trouble a while back, so I stopped using it and started writing my own program in C++. Of course, this is time consuming, but it is something I enjoy doing. That said, I did write some things through MySQL with no problems. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] Scam????
On Sat, 8 Feb 2014 12:26:09 -0600 Earl Beavers wrote: > Have I been scammed? I agreed to a $5 charge but the program would not > download or react in any way. > > I feel like a dunce. Would you please supply the link from which you downloaded? Thanks, Tom - moderator -- Never be ashamed to ask for information. The ignorant man will always be ignorant if he fears that by asking he will display ignorance - Booker T Washington ^^ --... ...-- / -.- --. --... -.-. ..-. -.-. Tom Taylor - retired penguin - KG7CFC AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2 openSUSE 13.1_RC2-x86_64 KDE 4.12.1, FF 25.0, claws-mail 3.9.2 registered linux user 263467 -- 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] Export PDF
2014-02-08 23:40 GMT+01:00 Cliff Scott : > I've run into a strange occurrence in LO 4.1.4. Everytime I export to PDF I > get a error message that "PDF/A-1a forbids a transparency". Clicking OK > allows the export to continue and I don't see any problems in the resultant > PDF, but this is something I've only seen on 4.1.4. This happens with > Writer > and Calc. FYI, I'm running OSx Mavericks. Is this a known problem? > I can tell you that it did happen with previous versions. It's only shown if you have transparent items in the document, so it might not show up all the time. Now, to know what is transparent is more complicated. It could be an image with an alpha channel (even if completely opaque). It might also be anything that LO treat as transparent (mayber borders, some special characters, etc... I don't really know). The thing is, if your output is correct, it's probably the kind of transparent item that get converted to white image over white background... no worries. However, a bit of warning from personal experience: a few years ago, some people (mainly using Acrobat Reader I believe) couldn't open PDF/A-1, while these same files would open fine on pretty much anything: gnome document viewer, kde viewer (okular), foxit on windows... Pretty funny if you consider that PDF/A-1 is supposed to work for long term storage. You should double-check that your files open with this certain reader, just to be sure :) -- Cley Faye http://cleyfaye.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
[libreoffice-users] Keyboard shortcuts
I am using LibreOffice 4.1.3.2, installed from the repos, on Xubuntu 13.10, but on my old computer it was whatever was in the repos for Xubuntu 12.04, and the problem was the same. I just decided that it was time to fix it. The problem is that some keyboard shortcuts are not working, specifically Ctrl-F12 (opens insert table dialog box) and Ctrl-Shift-End / Ctrl-Shift-Home (selects to end / beginning of document). However, Ctrl-Shift-Right / Left Arrow select to the end / beginning of the current word, as they are supposed to, as does Ctrl-a (select all). I have checked in the settings editor for Xubuntu and Ctrl-F12 is set to "Workspace 12", although I have only two workspaces enabled, and I can't tell if "Workspace 12" is just part of a preconfigured list where it is not actually enabled, or whether anything in the list is automatically enabled. I also can't figure out what the keyboard shortcut list in the settings editor actually does - e.g., if a document window is open do the settings editor preferences override the application keyboard shortcuts, or the other way around? As for Ctrl-Shift-End and Ctrl-Shift-Home, neither is listed in the Xubuntu settings editor, so they should be completely free for applications. More importantly, these two shortcuts do not work in Gedit or my mail client's compose window either, although I can't check the Ctrl-F12 in them because these applications have no table function. And all of these shortcuts are enabled in the LO customization dialog box. I'm tired of having to use the mouse/menus to select to the beginning / end of a document or open the insert table dialog window. Does anyone have any suggestions for places to poke around in? Can anyone with LO on a 'buntu duplicate the problem? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Scam????
On 02/08/2014 01:49 PM, James Knott wrote: > Earl Beavers wrote: >> Have I been scammed? I agreed to a $5 charge but the program would not >> download or react in any way. >> >> I feel like a dunce. > I assume you downloaded from somewhere other than www.libreoffice.org. > If so, you may have been scammed, or at least paid when you didn't have > to. While LibreOffice will happily accept donations, they're not required. > > +1 - Earl if you donated through libreoffice.org then you have not been scammed but the donation was 100% voluntary. LibreOffice is free but donations keep us going as the cost of infrastructure and the like are quite high. If you head over to libreoffice.org/download you'll have a whole list of options for download and all of them are free. Hope that helps. All the best, Joel -- 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] Scam????
On 2/8/2014 1:49 PM, James Knott wrote: Earl Beavers wrote: Have I been scammed? I agreed to a $5 charge but the program would not download or react in any way. I feel like a dunce. I assume you downloaded from somewhere other than www.libreoffice.org. If so, you may have been scammed, or at least paid when you didn't have to. While LibreOffice will happily accept donations, they're not required. It could be even worse: If you paid with a debit card, you could be in big trouble, because they might add zeros to the amount and submit multiple charges until they drain your account. If you've done that, I suggest you do whatever it takes to immediately change your password while checking the balance on your account AND report a possible problem to your financial institution (bank or credit union). If you used a credit card, you need to watch the credit card bill and aggressively challenge any questionable charges. US federal law provides reasonable protections for unauthorized credit card charges. If you are not in the US, the rules could be different. Hope this helps. Spencer -- Spencer Graves, PE, PhD President and Chief Technology Officer Structure Inspection and Monitoring, Inc. 751 Emerson Ct. San José, CA 95126 ph: 408-655-4567 web: www.structuremonitoring.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] help pack configuration for other language
Hello, According to an AskLO thread, you cannot use a different language help pack for a LibreOffice installation. It reads in part, "The help pack installed must agree with the language of user interface." There are some workarounds, but none of them seem viable: 1. If you can. use the online help. 2. Install LibreOffice in English with a parallel install (https://wiki.documentfoundation.org/Installing_in_parallel). 3. Save the online help ti your computer with a website copier such as HTTrack (http://www.httrack.com/). There is no direct way to access the help (that I know of) without having to do it from LibreOffice. The workarounds above just don't seem viable, but if you do need the LibreOffice help offline, you can try the workarounds. I hope this helps! Regards, xmlhttprequest.o...@gmail.com On 2/8/2014 4:48 PM, Cristian Baboi wrote: Hi! I've installed LibreOffice with the english help pack because it is not available for my language. Is there a way to activate offline english help without changing the language of the interface? The interface is translated. Thanks. -- 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] Export PDF
On 02/08/2014 05:40 PM, Cliff Scott wrote: I've run into a strange occurrence in LO 4.1.4. Everytime I export to PDF I get a error message that "PDF/A-1a forbids a transparency". Clicking OK allows the export to continue and I don't see any problems in the resultant PDF, but this is something I've only seen on 4.1.4. This happens with Writer and Calc. FYI, I'm running OSx Mavericks. Is this a known problem? Cliff Cliff, I have seen the same with LO 4.1.x on Linux. I am not sure why this is occurring. -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Export PDF
I've run into a strange occurrence in LO 4.1.4. Everytime I export to PDF I get a error message that "PDF/A-1a forbids a transparency". Clicking OK allows the export to continue and I don't see any problems in the resultant PDF, but this is something I've only seen on 4.1.4. This happens with Writer and Calc. FYI, I'm running OSx Mavericks. Is this a known problem? Cliff -- 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] MS Office woes
sounds like an easy work-around; which would also work as a bookmark to show where you left off ;-) From: marianne-x Date: Fri, Feb 7, 2014 at 10:26 PM Subject: Re: [libreoffice-users] MS Office woes To: users@global.libreoffice.org On 2/7/2014 9:10 PM, Carl Paulsen wrote: The biggest problem is that if the formula doesn't meet MSO's standards, > you can't leave it in place to work on later. I've had formulas which took > me days to work out, and if I can't leave them in place even when faulty, > then I have to re-create them each time. When they are so terribly long, > with many layers of nested functions, losing them is a disaster. Yet Excel > prevents you from saving them unless they "work." BAH! > I have no experience with M$O specifically, and have no interest in making excuses for its failings, but with those s.sheets that I do use, "all" you have to do in this situation is put a quote at the start of the formula, thereby making it text. The formula should then be preserved as text, and can be saved as such, until you want to work on it again; removing the quote makes it back into formula. Isn't that a reasonable work-around for their unreasonable default action? -- 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] Review of AndrOpen Office
On February 8, 2014 1:15:08 PM PST, James E Lang wrote: >Regarding the password issue, the default action during a Save As … >operation is to solicit a password and I might have entered a space in >frustration. The default action differs, depending upon which build is used. >Export to PDF exports all the sheets. I want to print the defined print range >from one of five sheets to a PDF file. It should be doable but I That part has not yet been implemented. A couple of months ago I saw a projected roadmap that listed when each feature would probably be implemented. However, I don't know where I saw it, and a Google serch doesn't bring it up. :( >copied from Apache OpenOffice in order to share the print output with an external (not yet available?) app. Defined print range would go through the Android Print API, which relies on Google Print. >works derived from Open Source products had to, themselves, be Open Source >also. How wrong could I get? (Rhetoric question) I'm almost at the point of defining everything that is not licenced under the GNU GPL 2.0, or GNU GPL 3.0 to be closed source, proprietary software. >In any case I do find AnOo (as you called it) to be usable if attention is >paid to its quirks. Unfortunately, those quirks change with each released build. jonathon -- Your language. Your documents. Your way. -- 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] Scam????
Earl Beavers wrote: > Have I been scammed? I agreed to a $5 charge but the program would not > download or react in any way. > > I feel like a dunce. I assume you downloaded from somewhere other than www.libreoffice.org. If so, you may have been scammed, or at least paid when you didn't have to. While LibreOffice will happily accept donations, they're not required. -- 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] help pack configuration for other language
Hi! I've installed LibreOffice with the english help pack because it is not available for my language. Is there a way to activate offline english help without changing the language of the interface? The interface is translated. Thanks. -- 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] All of the messages in Nabble are suddenly going into the "AndrOpen Office" thread!
Well said, Mark. One more comment inserted below. On February 7, 2014 12:09:58 PM PST, Mark Bourne wrote: > >I don't know if it's the case here, but people do sometimes reply to an >existing email to the list and just change the subject line (presumably >to save looking up the address for the list). That isn't enough to make >it a different thread - there are separate headers in the email Specifically References: and In-Reply-To: >which >link messages into threads - so the new message shows up as part of the >original thread. > >Another disadvantage of doing this is that some other people use mail >clients or news readers which they can set to automatically ignore any >further messages in threads they're not interested in or can't help >with. So those people wouldn't see the messages asking about a >different >problem in an existing thread, when they might otherwise have been able >to help with that new problem. > >So it can be in the asker's best interest to create a new thread rather >than replying in an existing one. To do that, they need to create a >completely new email and send it to the list address (users AT >global.libreoffice.org in this case). > >Mark -- Jim -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Scam????
Have I been scammed? I agreed to a $5 charge but the program would not download or react in any way. I feel like a dunce. -- 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] Review of AndrOpen Office
Thank you, Jonathon (or is it Toki?). Regarding the password issue, the default action during a Save As … operation is to solicit a password and I might have entered a space in frustration. When displayed, the navigation panel (which I think I mistakenly called a buttons panel) occupies a lot of screen real estate. Export to PDF exports all the sheets. I want to print the defined print range from one of five sheets to a PDF file. It should be doable but I guess that might require a change to the Android OS and/or to the code copied from Apache OpenOffice in order to share the print output with an external (not yet available?) app. The Open Source and licensing issues are indeed troubling. This kills the cross pollenization (sp?) prospects between projects. I thought works derived from Open Source products had to, themselves, be Open Source also. How wrong could I get? (Rhetoric question) In any case I do find AnOo (as you called it) to be usable if attention is paid to its quirks. -- Jim On February 7, 2014 10:53:35 AM PST, Toki wrote: >On 2/6/2014 4:12 AM, James E Lang wrote: > >>AOO1.x implements all the modules (Text Document, Spreadsheet, >Presentation, Drawing, Data Base, and Formula) > >FWIW, it also has limited support for OOo 1.x file formats. > >> • The UI is hard to use on my smart phone which has a screen 2/3 the >size of a dollar bill. I can't speak regarding tablets with 7" or 10" >screens. > >The navigation panel on the side makes it usable. >Navigator does not work, at least on my tablet. > >> • When saving a file, a password dialog is always offered. I >apparently INADVERTENTLY set a password and since it was not >intentional > >Try: >i) not inputting anything; >ii) inputting a space; > >I don't remember which one is the default. > >My impression is that that is no longer the default configuration. >FWIW, the configuration always reverts to default, when starting. A >horrible feature, IMNSHO. > >> • I have not found how to specify the directory (folder) when >performing a Save As …. It simply has to be possible. > >It can be done. > >Once upon a time, I was going to write documentation for the program, >but decided against doing so, for reasons outlined at the end of this >message, > >> • I have not found a way to Print (even to a PDF file). AOO1.4,1 >complains about there being no default printer. > >"Export to PDF" > >>• There is no Exit on the File menu. > >Close the document, then close the program. >FWIW, the Android software specification does not call for, nor require > >a way to exit the program. Doing so can break something in the OS. > >> I look forward to the day that the LO community gets its entry in >this >environment as good as this. > >So do I. > >My biggest _current_ objection is that it (AnOo) is _not_ distributed >under the Apache Software Licence, but rather a long, rambling licence >designed for a completely different purpose.(I know what the screen >displays, however the developer claims that it is not distributed under >the Apache Licence, In any legal dispute, I'll take the most >restrictive >licence claim, over the least restrictive licence claim.) > >My second biggest objection is that source code is not available, and >will not be publicly released. > >IOW, it is a closed source, non-free non-libre proprietary application. > >jonathon -- 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: LO Base/MySQL questions
Thanks for the information. I'll have a try as soon as I migrate to 4.2. Thanks also to Tom and Jay. It seems that several good solutions are available for the backend db. Paul Lens Eau & Environnement 101, rue Haute 5060 Sambreville BELGIQUE Tel/fax: +32 (0)71/76.14.31 GSM: +32 (0)471/13.16.87 Le 7/02/2014 17:21, Alex Thurgood a écrit : On 07/02/2014 08:38, Ian Whitfield wrote: Hi Ian, For some reason, your question shows up in Thunderbird in the thread about Andropenoffice, hoping that you haven't hijacked it... 1) Where does MySQL store the Database? (I think it's in the root somewhere) It is usually (but not always) stored somewhere in /var on a Linux system. On Ubuntu based systems, it seems to be located in "/var/lib/mysql" 2) Is it easy to move it into the /home directory? If you know how to : - change your my.cnf - change the ownership and privileges of the new directory to correspond to those of the user mysql process (i.e. the user that runs the mysqld daemon) 3) Where do I find the LO front-end form? In your ODB file. Unzip it and have a look, it'll be in there in a subdirectory. 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? No, mysql doesn't work as a single file that you just copy from one place to another. It takes more work than that. Use a dump (sql file), or setup the new mysql server on the second machine to be a replicant of the first - this presupposes that the two machines can be connected together over the internet or a local LAN, but if you have two machines on the same subnet, better to just allow the second machine to access your first machine's mysql server. Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Only possible with a macro that takes the location and name of the image file stored in the database as a string, and then convert that to a link for you on your form and provide some way of displaying it (e.g. shell function to an outside viewer or loading the file into an image control). Provided that you don't go and change the name of the file or its location, the image will always be up to date even if you modify the image itself. 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
[libreoffice-users] Re: Connect Base to External HSQLDB
Le 08/02/14 15:07, Jean-Francois Nifenecker a écrit : Hi Jean-François, all : Having just re-tested with Mac OSX Mavericks, LO 4.2.0.3 and hsqldb 2.2.8, I was able to get this to work :-) 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
Re: [libreoffice-users] Calc: Searching for values in a certain range string
At 16:57 08/02/2014 +0200, Hylton Conacher wrote: What I seek is to be able to have a sheet of Lottery results downloaded from the Internet and pasted into a Calc sheet. On another Calc sheet I will have a listing of the 6 numbers held for each specific draw date. Each populated cell of my ticket sheet will indicate if the number in that cell is the same as a number in a range of cells from the results sheet, on a particular date. I'm guessing (since you don't say) that the ticket sheet is not the results sheet? As an example: Assume the draw results below dated drew the following numbers: 04/02/2014 16, 03, 19, 21, 23, 06 11/02/2014 17, 05, 02, 20, 22, 04 18/02/2014 09, 40, 05, 09, 42, 03 Also assume that draw numbers I chose for a draw on a date were: 11/02/2014 02, 05, 18, 20, 22, 04 If any number on my ticket matches a corresponding date value, I want the cell to change background colour. After looking into the usage of vlookup and given I want the background colour to change if the conditions are met, I selected the cell containing the first number on my ticket (02) and then selected 'Format', Conditional Formatting'. I selected that the cell value is equal to and entered vlookup($LottoResults.$B$39,$LottoResults.$C$39:$D$39,1,0) into the field, chose the new background style and said OK. I think you are getting confused here: are you trying to search two things with one test? You presumably need to search the various date rows for the appropriate date, and for this VLOOKUP() might be appropriate. But you haven't attempted that here: you have mentioned only cells in row 39. Yes, you may then also need to search the row for a matching draw result, but that is along a row, not down a column, so HLOOKUP() might be more appropriate for that. Don't you need both? You have also said that the ticket numbers are on a separate sheet from the draw numbers, but your search is confined to the results sheet. You appear to be searching to see if a draw result happens to be equal to the date on which it was drawn! That would happen on 11 February 2014 only if a number drawn were 41681! Now I can't speak for South African lotteries, but ... Using the other option on Conditional Formatting I selected 'Formula is' and entered the same vlookup formula with the same disastrous results, ... That tests the formula for zero result. How could your retrieved draw result be zero? Now if you subtracted your ticket number from the draw result ... So close yet so far, what am I missing? The need to apply two searches or tests. Oh, and the need to specify correct arguments. pointers? See above. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc: Searching for values in a certain range string
Hi, I am looking for a pointer or two to enable me to accomplish what I seek. What I seek is to be able to have a sheet of Lottery results downloaded from the Internet and pasted into a Calc sheet. On another Calc sheet I will have a listing of the 6 numbers held for each specific draw date. Each populated cell of my ticket sheet will indicate if the number in that cell is the same as a number in a range of cells from the results sheet, on a particular date. As an example: Assume the draw results below dated drew the following numbers: 04/02/2014 16, 03, 19, 21, 23, 06 11/02/2014 17, 05, 02, 20, 22, 04 18/02/2014 09, 40, 05, 09, 42, 03 Also assume that draw numbers I chose for a draw on a date were: 11/02/2014 02, 05, 18, 20, 22, 04 In theory looking at the data, if I submitted my ticket for prize redemption, I might score very well considering my ticket matches 5 out of 6 of the numbers from the draw. If any number on my ticket matches a corresponding date value, I want the cell to change background colour. Now the trick is to put this in practice. :) After looking into the usage of vlookup and given I want the background colour to change if the conditions are met, I selected the cell containing the first number on my ticket (02) and then selected 'Format', Conditional Formatting'. I selected that the cell value is equal to and entered vlookup($LottoResults.$B$39,$LottoResults.$C$39:$D$39,1,0) into the field, chose the new background style and said OK. I checked the first number of my ticket on the specified date and noticed that the background had not changed as instructed to by the conditional formatting. :( Using the other option on Conditional Formatting I selected 'Formula is' and entered the same vlookup formula wit the same disastrous results, i.e. no colour change on the first cell of my ticket number :( Doing a second trial I said cell value must equal and entered $LottoResults.$C$39. The cell on my ticket came out the requested colour however the formula did not allow me to check if on the ticket date and corresponding ticket draw were identical. :( The purchased ticket has 6 numbers on it, with the first 5 being in numerical order and the 6th being a bonus random ball( 01-49). The draw results are not in numerical order. So close yet so far, what am I missing? pointers? Regards Hylton -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Connect Base to External HSQLDB
Hello Alex, Le 06/02/2014 07:16, Alex Thurgood a écrit : > > Note that this part didn't work for me on Mac, it provokes an error in > LO's component loader or service manager (don't remember which now), or > at least, that was the case for 4.0 and 4.1. well... this *did* work fo me under WinXP and I never had a Mac to test :( Any Apple-maniac suggestion would be fine :) -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Writer printing problem
Joe Alders hetnet.nl> writes: > There was one recently response. > You wrote that your O.S. is XP/SP3 and that brought me to the idea > that I can install LO on my old XP/SP3 machine and see if the problem > is also there. > Keep you informed. > Joe. > > Hello rost52, Just installed and tested the latest LO 4.1.4.2 on my old XP SP3 computer: The printing behaves exactly as on my Win 7 one. Joe. -- 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: L.O. 4.0.5 pb enregistrement fichier
Hi :) I think that for a lot of us, well certainly for me, your kudos rocketed up a few notches. 1. you appear to be a native-English speaker but seem fluent in another language too 2. you help on more than 1 forum but are quite prolific even on 'just' this list 3. you deal with at least 2 of the highest traffic mailing lists "without breaking a sweat" The other people in the thread were pretty impressive too, of course. Also it's nice to occasionally be reminded that LO is NOT only English. While MSO is available in many other languages it's awkward and cumbersome and becomes extremely expensive if you need more than 1 language Regards form Tom :) On 7 February 2014 17:00, Cley Faye wrote: > 2014-02-07 Tom Davies : > >> Hi :) >> I also often find that LibreOffice doesn't let me save over the top of >> files stored on our network file-shares. It only does seem to work if >> using the same computer. When i go to a different machine i use that >> as an opportunity to add/upodate a version number to the end of the >> document name and move the old version into a back-ups folder. >> >> It seems to work quite well but maybe because we only have a small >> number of files active at any particular time. >> >> >> It is probably something to do with a "~lockfile" in the network >> folder or in the "backups" folder inside the "User Profile" of LO on >> whichever machine you happen to be trying to save from. >> >> Sorry i can't write that in French! My translation tool is stuck in >> English! :( >> Regards from >> Tom :) >> > > > Damn, didn't even see that this was not the french list! > For reference, the french lists are here: http://fr.libreoffice.org/forums/ > > Pour info, les listes françaises sont ici: http://fr.libreoffice.org/forums/ > > -- > 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] MS Office woes
Hi :) Look i'm sure we are all quite sophisticated MS Office users, as Carl probably is too. I, for one, have often taught people how to use MSO and marked exams for ECDL and other training courses. I know for certain at least 1 other here has too and i'm reasonably certain that almost everyone else either already had a high level of skill with MSO or has learned shed-loads since using OOo, LO,or AOO (or both). So i'm sure we can all find work-arounds for the frustrations he shared with the rest of us. I thought Marianne-x's was the best for item 1 but Anne-ology's a close 2nd. Mine would have been painful = to cut&paste the formula into a text file. I think it is good for us to know more than the average MSO user and to stay ahead by sharing some of these ideas but often we learn just because we have experienced radically different approaches to things whereas MSO users have stayed blinkered. What we normally hear on this mailing-list is noobs frustrations with LO. It's kinda what we are here for. It's our job (most of us volunteers but unpaid work is still work) to point them towards decent document and even directly help them both with their specific problem and maybe help them realign their thinking so that they can "go with the flow" more easily rather than fighting against the tide by trying to apply bad-habits picked up through years of MS (ab)use and then grumbling that they can't do idiotic things. So, it makes a nice change to hear some of the grumbles about MSO, especially because they were different from the usual grumbles (as neatly stated by null). I agree with Carl that it's probably not a good idea to have another rant-fest this week but they can be fun. The thing is that we have to work alongside MSO users especially those of us at some stage of a migration and we don't want to make the list appear too hateful and unwelcoming. So, if anyone feels the need to rant please can they make it humorous? Regards from Tom :) On 8 February 2014 04:56, Carl Paulsen wrote: > I suppose you're right. With some work I could have found a workaround, and > I appreciate your idea. My issue is much more about the way MSO is set up > by default, and changes to that are not especially apparent. > > But your point is well taken. > Carl > > > > On 2/7/14 11:26 PM, marianne-x wrote: >> >> On 2/7/2014 9:10 PM, Carl Paulsen wrote: >>> >>> The biggest problem is that if the formula doesn't meet MSO's standards, >>> you can't leave it in place to work on later. I've had formulas which took >>> me days to work out, and if I can't leave them in place even when faulty, >>> then I have to re-create them each time. When they are so terribly long, >>> with many layers of nested functions, losing them is a disaster. Yet Excel >>> prevents you from saving them unless they "work." BAH! >> >> I have no experience with M$O specifically, and have no interest in making >> excuses for its failings, but with those s.sheets that I do use, "all" you >> have to do in this situation is put a quote at the start of the formula, >> thereby making it text. The formula should then be preserved as text, and >> can be saved as such, until you want to work on it again; removing the quote >> makes it back into formula. Isn't that a reasonable work-around for their >> unreasonable default action? >> > > -- > > Carl Paulsen > > Dover, NH 03820 > > > -- > 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