[libreoffice-users] problem downloading LibreOffice 3.4.4
I am located in Tokyo with a Japanese laptop. The installer recognized my system (Windows) and the language as Japanese, but when the dialogue boxes openned up to install, the instructions in the dialogue boxes were written in gibberish with random symbols, and they were therefore unreadable. I simply clicked on the button where cancel would be and cancelled out. Can you let me know what I did wrong and how to download LibreOffice with the English and Japanese language packs. (I would like to have all drop down menus and help menus in English with the ability to use it both in English and Japanese). Thank you, Brian -- 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] Base/SQL help
On 01/02/2012 05:05 PM, Jeff Sadowski wrote: I can't figure out the best place to get help with SQL to use to get the information I want. Situation: I have a script gathering information about printers daily. It puts the information directly to the database. The fields in the database are date,ip,serial,counter date is a timestamp ip and serial are character arrays and counter is a big int I would like to get the last 2 entries in sql but I can't figure out how to do it in 1 sql statement. I created a script that gets the distinct ip's using one sql statement and sorts them so that all offices entries are together and can be separated by office. then runs a sql statement for each ip to get the last two entries. final output looks like so IP, Serial, Couter Diff ,, between and ... Subtotal IP, Serial, Couter Diff ,, between and ... Subtotal ... I'd like to be able to do this in a report in LibreOffice under Base but can't figure out how to use base to do what my script does. I never had anything like this situation in any of my classes on databases so I am lost on how to begin. All I remember reports on where things that could be gotten with a single sql statement. What is the database backend? You can use Base as a front end to many database engines. -- Jay Lozier jsloz...@gmail.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: Calc Question Regarding Sheets and Formulas
El 02/01/12 22:23, Mark Phillips escribió: My apologies, gmail decided to send the message before I was finished..I will try it again. A row has "Jan 3", "Jan 8", "Jan 12", in each of three columns. These string are really formatted dates. I have three sheets with names Jan 3, Jan 8, Jan 12. I want to write a formula (vlookup) that has a reference 'Jan 3'.a1:g14, but I want the "Jan 3" sheet name to be taken from the cell that has Jan 3 in it. I can then copy the formula across the spreadsheet in the row under the dates and refer to each succeeding sheet. I hope this makes sense! Thanks, Mark On Mon, Jan 2, 2012 at 2:18 PM, Mark Phillipswrote: Is there a way to have a text string in a cell and use that text string in a formula for the sheet name?e For example, I have this row 1: row 2 One method is use INDIRECT(TEXT(ceelwithdate;"MMM D")&".A1:g14") to compose the address. Miguel Ángel. -- 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] Base/SQL help
I can't figure out the best place to get help with SQL to use to get the information I want. Situation: I have a script gathering information about printers daily. It puts the information directly to the database. The fields in the database are date,ip,serial,counter date is a timestamp ip and serial are character arrays and counter is a big int I would like to get the last 2 entries in sql but I can't figure out how to do it in 1 sql statement. I created a script that gets the distinct ip's using one sql statement and sorts them so that all offices entries are together and can be separated by office. then runs a sql statement for each ip to get the last two entries. final output looks like so IP, Serial, Couter Diff ,, between and ... Subtotal IP, Serial, Couter Diff ,, between and ... Subtotal ... I'd like to be able to do this in a report in LibreOffice under Base but can't figure out how to use base to do what my script does. I never had anything like this situation in any of my classes on databases so I am lost on how to begin. All I remember reports on where things that could be gotten with a single sql statement. -- 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: Calc Question Regarding Sheets and Formulas
My apologies, gmail decided to send the message before I was finished..I will try it again. A row has "Jan 3", "Jan 8", "Jan 12", in each of three columns. These string are really formatted dates. I have three sheets with names Jan 3, Jan 8, Jan 12. I want to write a formula (vlookup) that has a reference 'Jan 3'.a1:g14, but I want the "Jan 3" sheet name to be taken from the cell that has Jan 3 in it. I can then copy the formula across the spreadsheet in the row under the dates and refer to each succeeding sheet. I hope this makes sense! Thanks, Mark On Mon, Jan 2, 2012 at 2:18 PM, Mark Phillips wrote: > Is there a way to have a text string in a cell and use that text string in > a formula for the sheet name? > > For example, I have this > > row 1: > row 2 > > > -- 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] Calc Question Regarding Sheets and Formulas
Is there a way to have a text string in a cell and use that text string in a formula for the sheet name? For example, I have this row 1: row 2 -- 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] LibreOffice 3.4.4 bug report - tools/customise/keyboard
Hi Neil, Neil wrote (02-01-12 21:47) I need to delete all keyboard shortcuts involving control + alt + character combinations in order to remove conflicts with my customised keyboard but version 3.4.4 does not save my changes when I press OK, it just reverts to the default assignments. Never had problems with that. Did you choose the button Modify before hitting OK Cheers, -- - Cor - http://nl.libreoffice.org -- 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] LibreOffice 3.4.4 bug report - tools/customise/keyboard
Hi there, I need to delete all keyboard shortcuts involving control + alt + character combinations in order to remove conflicts with my customised keyboard but version 3.4.4 does not save my changes when I press OK, it just reverts to the default assignments. I've tried repairing my installation but it makes no difference. Did version 3.3 have the same bug? If not, I'll install this earlier version. Kind Regards, Neil -- 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] can't print to pages on a single side of paper
Hi Cor Am 02.01.2012 um 19:55 schrieb Cor Nouws: > Hi Thomas, > > Thomas Knierim wrote (31-12-11 17:14) > >> I've waited for some updates but it's still not ok! Opensuse 12.1 >> doesn't has the problem, but I don't know why my favorite >> distribution (Archlinux) still isn't able to print to side-by-side. > > I never had a problem with this on Ubuntu. Yes, you are right. Ubuntu doesn't has this problem > So indeed, has to be a problem related to ArchLinux. No, it's not a problem related to ArchLinux. OpenSuse RC had the same Problem. Maybe there are more distris. I haven't checked them all ;) > >> Does anybody know how to set up a printer using spadim. I always get >> the message, the filesystem is read only > > Sorry, Linux/printer admin is not something for which I can be of any help. > I would expect that lists/fora related to ArchLinux are more logic places to > ask. You are right if it is a Arch-specific problem. But the write-permission is a problem of every distri I tried in the last month (as far as I remember)... > > Regards, > > -- > - Cor > - http://nl.libreoffice.org > > > -- > 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] can't print to pages on a single side of paper
Hi Thomas, Thomas Knierim wrote (31-12-11 17:14) I've waited for some updates but it's still not ok! Opensuse 12.1 doesn't has the problem, but I don't know why my favorite distribution (Archlinux) still isn't able to print to side-by-side. I never had a problem with this on Ubuntu. So indeed, has to be a problem related to ArchLinux. Does anybody know how to set up a printer using spadim. I always get the message, the filesystem is read only Sorry, Linux/printer admin is not something for which I can be of any help. I would expect that lists/fora related to ArchLinux are more logic places to ask. Regards, -- - Cor - http://nl.libreoffice.org -- 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] can't print to pages on a single side of paper
As a workaround I could set up a second printer with the setting 2 pages per sheet. But this doesn't answers why LibreOffice can't do it by itself - or even why LibreOffice sends a PDF-File to cups - or how to setup up LibreOffice to send a PS-File to cups as default. Mysterious... ;) Regards ToK Am 31.12.2011 um 17:14 schrieb Thomas Knierim: > Hi again, > > I've waited for some updates but it's still not ok! > Opensuse 12.1 doesn't has the problem, but I don't know why my favorite > distribution (Archlinux) still isn't able to print to side-by-side. > > Does anybody know how to set up a printer using spadim. I always get the > message, the filesystem is read only > > PLEASE > does anybody know how to solve ONE of the problems? > > > ToK > > > Am 08.11.2011 um 19:32 schrieb Thomas Knierim: > >> Hi, >> >> I mean to print two pages side by side. The problem is if I print two pages >> side by side the printer hangs - with libreoffice only. Not with evince >> (gnome pdf viewer) for example. If I switch the "printer language" from pdf >> to ps everything works fine... But I don't want to do it for every job - and >> by the way: can ps send fonts to the printer? Does libreoffice send fonts to >> the printer if the "printer language" is set to pdf? >> >> regards >> >> Thomas >> >> >> Am 29.10.2011 um 17:05 schrieb webmaster for Kracked Press Productions: >> >>> >>> The two pages per sheet issue. You want to have them printed side by side? >>> Or one page on one side and the second page on the other side of the sheet? >>> Side by side printed out on a landscape orientation works well, but it is >>> a printer option. Having the pages printed one on each side of the sheet >>> is a duplexing issue. I have been having the same problem with duplexing >>> as well as others. >>> >>> side by side printing >>> Print > Page Layout > Pages per sheet. >>> 2 will print two page side by side. >>> IT works fine for me. I prefer to have the option of bordering the pages, >>> since it looks better to me. >>> >>> For duplex printing, I have to print it out as a PDF document and print it >>> with the document viewer with the duplex option, instead of printing it >>> directly through LO. LO just does not "see" or adjust the duplex option on >>> my Epson Artisan printer properly. >>> >>> >>> On 10/29/2011 10:47 AM, Tom Davies wrote: Hi :) In your existing Arch could you just install a virtual machine and try out a few things in there? Alternatively create a new partition on a hard-drive and use that for experimentation. You surely don't need to trash what you do have that is almost perfect in order to just try something a little different! Regards from Tom :) --- On Sat, 29/10/11, Thomas Knierim wrote: > From: Thomas Knierim > Subject: Re: [libreoffice-users] can't print to pages on a single side of > paper > To: users@global.libreoffice.org > Date: Saturday, 29 October, 2011, 15:24 > OK, that's some kind of confusing: > Using Ubuntu everything works out of the box! Where is the > difference to other distributions? > > The Versions are nearly the same: > > Cups: > - OpenSuse: 1.5 > - Archlinux: 1.5 > - ubuntu: 1.5 > Ghostscript > - Opensuse: 9.00 > - Archlinux: 9.04 > - ubuntu: 9.04 > hplip > - Opensuse: 3.11.10 > - Archlinux: 3.11.10 > - ubuntu: 3.11.7 > libreoffice: > - Opensuse: 3.4.2 OOO340m1 (Build: 1206) > - Archlinux: 3.4.3 (build unknown since Archlinux is not > installed this moment) > - ubuntu: 3.4.3 OOO340m1 (build 302) > > So I go back and install archlinux again to see what > happens if I install hplip 3.11.7. > > > Am 29.10.2011 um 01:59 schrieb webmaster for Kracked Press > Productions: > >> Sorry, I just say the Device option tap showing PDF as > the default. I do not know what "PDF" means in this > context, since my printers may have that as a printer > language type, as far as I remember. My HP Inkjet is > not a postscript printer, but my Color Laser might be able > to deal with that. I did not see Postscript as an > option for the Epson inkjet. I sure did not read it > having a PDF language option. So something is not > right. Could PDF here mean "Printer Defined Format" > for the language used? >> Can the Postscript type "level from driver" be kept as > the "default" option somehow? Maybe the "Printer > Administration" shown was a module of LO 3.4 [at least with > Ubuntu]? I believe that module of LO was designed to > set up the printers to run properly with LO. >> -- >> >> CUPS-PDF - no package for OpenSUSE? I > wondered what OpenSUSE uses as a replacement package, so I > looked it up on the site. >> On the opensuse.org site,
Re: [libreoffice-users] need help on my dictionaries for LibreOffice/OOo
On 01/01/2012 08:09 PM, Dan Lewis wrote: Something to remember: the main dictionary for the language used by LO is a binary file kept in the Installation folder. If a language pack is added, this language is also binary and kept in the same place. These are large files. User created dictionary files (.dic) are kept in the personal settings folder. These are text files. Some time ago, someone asked about dictionary file sizes referring to the user created .dic files. The reply was 22K or less per file seemed like a good number. It was mentioned that OOo would not use a dictionary file if it was too large. The dictionary files .dic) are text documents with the first four lines very important as far as content is concerned. Below is the first four lines for an English user created .dic file followed by a German user created .dic file. OOoUserDict1 OOoUserDict1 lang: en-US ORlang: de-DE type: positive type: positive --- --- It appears like the second line is the one that has to be changed from language to language. the letters before the hyphen are the language (en,English; de, Deutch) and the letters afterward are the country (US, USA; GB, Great Britain; etc.) But with the number of entries you have, you need to find some way to make a binary file that LO can read as a .dic file. From what I remember about the creation of the Austrialian dictionary, it is very time consuming to create the binary files. --Dan Dan Every dictionary .dic file that I looked at English/German/French/etc. for LibreOffice, and from OOo's own site, is shown as the following: line 1: the number of words in the list line 2 through the end: the list of words and any control codes All of the dictionaries are in .oxt files and they are a type of archives. The largest dictionary I have is Irish/Gaeilge, which is about 7 meg in size for the .oxt file, but the .dic file inside it is about 2 meg. The Thesaurus and hyphenation files are most of the rest of the file size. I do not know about any .oxt files that are in a "binary" format. Maybe the .dic files are converted to a binary somewhere, but not in dictionary creator's end. When using my dictionaries, I do not notice any slowing down of the loading process. Even with all of my American English .oxt file enabled, plus the largest British English and Canadian English enabled. I do not know what "binary conversion" takes a long time, but I do not see it. I have the the Australian .oxt file with the .dic file from 2008-12-15, also the Australian Medical dictionary with its .dic file from 2008-07-01. Neither .dic files are in a binary format. When opened they are just an ASCII text file in an archived file. There are control codes after some of the words in that .dic file, so maybe that was what too time to create - words and their control codes. Here is a link to the English dictionary section and Australian is the first ones listed. http://libreoffice-na.us/English-3.4-installs/dictionary.html#english Now, I have large word lists in my .dic files. 6.4 meg for the 638K word size. But there is no control codes in my .dic files except the top line stating the number of words in the list. Now, I offer several word list sizes for my dictionaries; 98K, 217K, 390K, and 638K words, with no 98K for Canada since I did not have a word list [yet] that size to use for one. So if the user wants to use the 98K word list for their spelling words, they can do it. There is the 638K word list dictionary since someone on this list asked me for a dictionary with the largest word list that I had. I asked before I made them. As for seeing these in the .dic files I got from the OOo dictionary list, sorry I did not see them. OOoUserDict1 OOoUserDict1 lang: en-US ORlang: de-DE type: positive type: positive Maybe they are are created in the folder that they reside in after LO/OOo loads them up through the Extension Manager. I know that I used some of these dictionaries when I used OOo 3.x.x and they were still 500K or more for the .dic files then. There is a 8074 word list with a .dic file of 87.9KB. How many words would be in a 22K .dic file? Where did you get that 22K size info? I went to the .libreoffice hidden folder [Ubuntu 10.04] and not one of the .dic files listed there are anyway near that 22K size. Most are in the 1 to 3 MB range. I did a lot of looking into what documentation I could find for creating a language dictionary, and nowhere did I find any info about file sizes and converting the .dic files to a binary format. I know binary as something other than a file that shows the actual "text" of the file in a text editor. I have seen "true binary" files when I had to program in Assembly and C. The resulting files ended up
[libreoffice-users] Regards
Good Morning, Happy New Year for all ! >From Costa Rica ... Central America. -- 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
Re: [libreoffice-users] Re: can't print to pages on a single side of paper
No, this problem isn't solved. The first mail is from october, 28th. This E-Mail should be replies of the original mail. So I think I shoudn't start a new subject-line. But anyway - here is the message of the first E-Mail I have a strange problem - and I have to admint: I don't know if it belongs to llibreoffice only. So here is the Problem: I'm using a HP Officjet Pro k8600dn and I can't print to pages on a sheet of paper. If I start a print job the paper gets loaded and the printer hangs. I could only bring it back to live if I switch it off and on again. The problem does only appear if the printer language is set to PDF (the default) in LibreOffice. If I set it to PostScript (level of the driver) the printer works as expected. On the other hand: I have an old HP Laserjet 5L. With it the two-pages-on-a-sheet-printing works (but the orientation is wrong - but that's another problem). Here is my software: OperationSystem: Linux (Archlinux - both the same error) LibreOffice: 3.4.2 CUPS: 1.5.0 hplip: 3.11.10 The Software has changed - in the first message I used OpenSuse RC1, too - which had the same Problem. The final release doesn't have the problem. Regards ToK Am 01.01.2012 um 23:51 schrieb Tom: > Hi :) > So is that one of the problems solved? Please could you post the other > q1uestions as new mails to the ilst so that you can make the subject-lines > relevant to the questions? > Regards from > Tom :) > > -- > View this message in context: > http://nabble.documentfoundation.org/can-t-print-to-pages-on-a-single-side-of-paper-tp3460824p3625500.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
