Re: [libreoffice-users] Macro to Convert Date in Text Format to Date in Date Format (Spreadsheet)
At 20:08 31/01/2013 -0800, Joel Madero wrote: I have a macro that converts QIF files to a spreadsheet. I have a few things left to do and one of these is that the column for dates are currently in text format: "dd.mm.". I want to convert this to a date format through a macro. Note that you may not need a macro at all: you could create an additional column with a formula to evaluate a genuine date value from the data in your text column. You could even hide the column of original text values if you preferred. One formula that might work is =DATEVALUE(Xn) but whether this will handle your DD.MM. may depend on your locale setting. Otherwise, something such as =DATE(RIGHT(Xn;4);MID(Xn;4;2);LEFT(Xn;2)) ought to work. Alternatively, does this point you in the right direction to create a macro? I trust this helps. Brian Barker -- 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] Macro to Convert Date in Text Format to Date in Date Format (Spreadsheet)
On 01/31/2013 09:46 PM, Andrew Douglas Pitonyak wrote: On 01/31/2013 11:08 PM, Joel Madero wrote: Hi All, I have a macro that converts QIF files to a spreadsheet. I have a few things left to do and one of these is that the column for dates are currently in text format: "dd.mm." I want to convert this to a date format through a macro. Note that selecting these cells and just doing format - Cell and setting to Date does NOT change the formatting to a date. Thanks in advance. Joel Are you asking how to convert text in the form dd.mm. to a date, or are you asking how to format a cell to format the date as dd.mm.? Just thought that I would mention it. Convert text in the form of dd.mm. to a date Trying the first post, thanks to that reply as well Best, Joel -- 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] Macro to Convert Date in Text Format to Date in Date Format (Spreadsheet)
On 01/31/2013 11:08 PM, Joel Madero wrote: Hi All, I have a macro that converts QIF files to a spreadsheet. I have a few things left to do and one of these is that the column for dates are currently in text format: "dd.mm." I want to convert this to a date format through a macro. Note that selecting these cells and just doing format - Cell and setting to Date does NOT change the formatting to a date. Thanks in advance. Joel Are you asking how to convert text in the form dd.mm. to a date, or are you asking how to format a cell to format the date as dd.mm.? Just thought that I would mention it. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] Macro to Convert Date in Text Format to Date in Date Format (Spreadsheet)
Hi All, I have a macro that converts QIF files to a spreadsheet. I have a few things left to do and one of these is that the column for dates are currently in text format: "dd.mm." I want to convert this to a date format through a macro. Note that selecting these cells and just doing format - Cell and setting to Date does NOT change the formatting to a date. Thanks in advance. Joel -- 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] Saving to an ascii file
On 01/31/2013 07:49 PM, John R. Sowden wrote: How do I 'save as' or export selected text in LO calc to an ascii file where i can exit it. I seem only to have the options for special file formats, PDF, XML, etc. Thanks, John Save the Calc file as CSV. This is a text file with its data separated by commas. It can be opened with any text editor. --Dan -- 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] Saving to an ascii file
How do I 'save as' or export selected text in LO calc to an ascii file where i can exit it. I seem only to have the options for special file formats, PDF, XML, etc. Thanks, John -- 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: setting paper size
Thanks, Heinrich it helps to know the same problem exists on different OSs. Here's what I've found on Vista: If I export to PDF and then reset the printer settings from my PDF reader (Foxit), I can print at any desired page size. It's a work-around, and doesn't solve the problem of printing directly from the ODF file. I find the same behavior in selecting text color (see the thread "changing text color." Do these behaviors represent an underlying bug? Would it be worth my reporting it? Heinrich Stoellinger wrote > Hi again, > I use LO under Linux (Debian-Wheezy as well as Mint-Nadia). There you can > specify > PDF/Postscript and other printing destinations under "Device" in the > printing > dialog. PDF is the default. Unfortunately things like landscape printing > don't > work properly then. Setting it to Postscript Level 2 works fine, however. > In older > versions I knew how to change that default in some config-file, but don't > know how > to do so under LO 4.0-rc2 in Linux. > Regards > H.S. > > > On Thu, 31 Jan 2013 10:19:13 +0100, edo1 < > edagro12@ > > wrote: > >> I'll be damned - I don't know where to set "Device" in vista, but taking >> your >> hint, instead of "Export as PDF" I chose "Export." With that I saw that >> the >> file format was defaulted to .xml. I changed this to pdf, and lo! Though >> the >> chosen foreground color doesn't show in the odt. file, it does show in >> the >> pdf. The color toolbar is indeed buggy, no? >> >> >> Heinrich Stoellinger wrote >>> Hi, >>> Did you set the "Device" to PostScript? PDF printing is "buggy" in my >>> opinion. >>> Regards >>> H.S. >>> >>> On Thu, 31 Jan 2013 09:20:37 +0100, edo1 < >> >>> edagro12@ >> >>> > wrote: >>> I'm using LO on Vistax64, printing on a Canon IP2600. I can't change the paper size successfully when printing from LO. When trying to print on half-sheets (5.5x8.5 stock), I can set the printer settings OK, but when I click on Print the LO shows the requested text printed at the top left of a full 8.6x11 sheet; and the printer's pre-print display follows that instead of the settings it had accepted from me.. (By exporting the LO file to the PDF file I finally was able to print to the half size sheets, but it require my setting the printer to "fit to page printing," which I didn't have to bother with in the last Oracle version. OOo 3.2.0.) The LO user guide was no help. Any advice would be appreciated. -- View this message in context: http://nabble.documentfoundation.org/setting-paper-size-tp4033383.html Sent from the Users mailing list archive at Nabble.com. >>> >>> >>> -- >>> Erstellt mit Operas revolutionärem E-Mail-Modul: >>> http://www.opera.com/mail/ >>> >>> -- >>> 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/setting-paper-size-tp4033383p4033395.html >> Sent from the Users mailing list archive at Nabble.com. >> > > > -- > Erstellt mit Operas revolutionärem E-Mail-Modul: > http://www.opera.com/mail/ > > -- > 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/setting-paper-size-tp4033383p4033576.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: [libreoffice-l10n] LO 4.0 Reference Cards
Hi :) I thought people here might be interested in Ron Faile's latest creation https://wiki.documentfoundation.org/Documentation/Publications#Desktop_Reference_Cards Regards from Tom :) > > From: Ron Faile >To: l...@global.libreoffice.org >Sent: Thursday, 31 January 2013, 20:57 >Subject: [libreoffice-l10n] LO 4.0 Reference Cards > >All, > >I wanted to let you know about some reference cards for keyboard >shortcuts that have been added to the Documentation page [1]. They are >reference cards for new users showing some basic keyboard shoutcuts that >are designed to be printed and folded into a triangular tube and >displayed next to the keyboard. They have been recently updated for LO >4.0 and are currently available only in English. For anyone would like >to translate these, here are the details: > >There are three separate tables in each of the LO4.0 reference cards. >All text is editable. To save time, if the Letter and A4 versions of >Writer, Calc, Impress and Draw, Base, Math are translated first, the >tables from those files can be copied and pasted into the other cards. > >Font: Liberation Sans (this font is included in a default installation >of LibreOffice) > >Paragraph styles used: > >1. LOLogo >2. LOTableText >3. LOTableTextBold >4. LOTableTextItalic >5. LOTableTitle >6. LOTextBegin >7. LOTextBody >8. LOTextEnd >9. LOTitle > >Logo: >https://wiki.documentfoundation.org/File:LibreOffice_Initial-Artwork-Logo_ColorLogoBasic_500px.png > >If there are any questions I will be happy to answer. > >Thanks, >Ron > >[1] >https://wiki.documentfoundation.org/Documentation/Publications#Desktop_Reference_Cards > >-- >Unsubscribe instructions: E-mail to l10n+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/l10n/ >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] Re: changing text color
Thanks for the reminder. The alternative method Format > Character, select color, etc. gives the same result as my usual method: Click on the underscored "A" at the right of the format toolbar, choose color, etc.: The chosen color does not show up in the .odt file; but the colors are rendered properly in an exported .pdf. Dan Lewis wrote > On 01/31/2013 04:01 AM, edo1 wrote: >> I cannot change the foreground color (i.e., the color of selected text) - >> pressing on the text-color icon in the toolbar has no effect. Setting >> background color works, sort of - I get a color, but not the one I've >> chosen. >> >> I've tried changing the color setting in Options > LibreOffice > >> Appearance >> between Font: automatic (shows black in box)) and Font: Black. Neither of >> these make a difference; color selection from the toolbar still doesn't >> work. As usual, any advice would be appreciated. - edo1 >> >> -- >> View this message in >> context:http://nabble.documentfoundation.org/changing-text-color-tp4033394.html >> Sent from the Users mailing list archive at Nabble.com. > You have not described what you did when you tried to change the > color of the selected text. We need your specific steps. > The font color can also be changed using Character styles (Format > -> Character): > 1. Highlight some text. > 2. Format -> Character > 3. Select the color you want to use. > 4. Click OK. > > --Dan > > -- > 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/changing-text-color-tp4033394p4033571.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: Numbering Questions: (2) or (1)?
On Thu, Jan 31, 2013 at 7:41 AM, Tom Davies wrote: > Hi :) > The Maths Guide is getting a major re-vamp fairly soon. The Docs Team > suddenly found the German translation had added tons of extra stuff and > even has enough to break it out into separate chapters. If you can read > German look for their version. > > My guess is that your case worked out all right and in the guide they > might have had a previous example at some point in the last 10 years or so > that maybe didn't make it into the version of the guide you are reading. > Also when creating the guides sometimes weird things do happen and there > are never enough people in the team to get everything perfect. > > MS Guides only need to be produced to cover 1 release every 3 or 4 years > and they employ tons of people to work on those guides. Their guides cost > quite a lot too so that they can pay people and make a hefty profit. > LibreOffice has a major new branch twice per year and relies on people > volunteering and in the few places where they sell it the prices are > extremely low. Even so most people just download the free versions from > the official website or the wiki. So, "it's a completely different bottle > of crisps". > > The Draw and Impress Guides recently got taken on by someone that really > cares about them so quality has jumped up in the last couple of releases > but Math is still a bit iffy, at least until the translations from German > get done. Personally i am hoping the Docs Team are focusing on the Base > Guide this time and maybe worry about Math afterwards but people join the > team to work on issues that concern them and so that's what gets the most > attention. It works well because it means the people working on any > particular guide have a vested interested and are keen to get good quality > results. > > Regards from > Tom :) > > > > -- > *From:* Taang Zomi > *To:* users@global.libreoffice.org > *Cc:* Taang Zomi ; putaangz...@gmail.com > *Sent:* Thursday, 31 January 2013, 10:06 > *Subject:* [libreoffice-users] Numbering Questions: (2) or (1)? > > On page 23 of LibreOffice 3.5.5 Math Guide, it is written: > > *Numbering equations* > > > Equation numbering is one of Writer’s best hidden features. The steps are > simple, but obscure: > > 1. > > Start a new line. > 2. > > Type *fn* and then press *F3*. > > The *fn* is replaced by a numbered formula: > > > E= mc2(2) > > == > > > But I got: > > E = mc2 (1) > > == > > Should I have got (2), as in the Math Guide? Is it all right for me to get > (1)? Is the Math Guide a little wrong here? > > Sincerely, > > Taang Zomi > > > == > > Dear Tom, Yes, my case worked out all right, and thank you all for your help. Thank you for the information on how LibreOffice Guides were produced. Sincerely, Taang Zomi -- 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 good is Impress compared to PowerPoint?
Hi :) There was something about being able to use Android phones as a remote control device for running Impress slideshows. Regards from Tom :) > > From: anne-ology >To: Tom >Cc: users@global.libreoffice.org >Sent: Thursday, 31 January 2013, 17:41 >Subject: Re: [libreoffice-users] How good is Impress compared to PowerPoint? > > > Huh ??? > > I've been impressed with IMPRESS over MsFt's since I found it has more >options, including the ability to save to whatever; > although saving to MsFt's loses some of those options - as audio >additions, and many of IMPRESS' transitional effects are also not recognized >by MsFt ... > > I don't understand the comment re. Android - I've heard the name, along >with these fruit-names, yet have not acquired any of these yet ;-) > > > > >On Wed, Jan 30, 2013 at 6:24 PM, Tom Davies wrote: > > >Hi :) >>Have you checked your glasses for roses? That is about the first time i have >>heard anyone saying they thought Impress is actually better in terms of >>functionality. Especially going back a few years. >> >>I thought a lot of progress had been made over the last year and this new >>remote-control feature if it's on Gnu&Linux and you are using an Android all >>sounds intriguing. >>Regards from >>Tom :) >> >> >> >> >> >> >> >> >>> >>> From: anne-ology >>> >>>To: Gilles >>>Cc: users@global.libreoffice.org >>>Sent: Wednesday, 30 January 2013, 23:48 >>>Subject: Re: [libreoffice-users] How good is Impress compared to PowerPoint? >>> >>> >>> IMPRESS does more, has more options; and has been my favorite for >>>years; >>> it also allows for saving to PP, etc. - for those who refuse to >>>leave MSFT ;-) >>> >>> >>> >>>On Wed, Jan 30, 2013 at 4:32 PM, Gilles wrote: >>> >>>Hello Before possibly recommending LibreOffice to a friend who needs an office suite for her personal use, I need to know how good its Impress component is compared to PowerPoint. She won't need to create very sophisticated slides, and won't need to import PowerPoint files. It's just to create some presentations for her class. She has regular office skills, she's not a geek. If you have extensive experience with both PowerPoint and Impress, would you say Impress is good enough or still lacking? Here's a review: "Admittedly, PowerPoint still outperforms Impress, yet not by such an extent that the difference couldn't be overcome in a release or two. In fact, the lack of improvements in Impress over the last few years -- particularly in its audio capabilities -- suggests that for most users the deficiencies are unimportant." www.datamation.com/open-source/libreoffice-vs.-ms-office-spreadsheets-and-slide-shows-1.html Thank you. >>> > > -- 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] table on notes
Hi Il 31/01/2013 18:58, Brian Barker ha scritto:> At 18:19 31/01/2013 +0100, you wrote: >> I need (for a customer) to put a table in footnote. I can't from menu >> ... > > I think the software is telling you loudly and clearly that you > shouldn't be trying to do this. Footnotes are not the right place for > something as extensive as a table. > >> There's a workaround for this? > > Yes. You could recommend your customer to put the information as a > sidebar or in an appendix, but why not just include it within the main > text of the document? I suppose it would be possible to reformat the > information so that it could be displayed in a footnote (tabs can be > used there), but that might not be the best advice. > > I trust this helps. > Thanks but this don't help 'cause my customer is converting many book in digital so they must be like the original. I found (thanks to italian ML) a workaround If you create the table on calc and then paste it in the note it works. Thanks to all -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Ami i PELUCHE? Acquistali online su MisterCupido.com! Tante offerte su: Disney, Simpson, Spongebob, Puffi, Sette Nani, Super Mario, Barbapapà, Teletubbies, Angry Birds, ecc Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=12384&d=31-1 -- 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 good is Impress compared to PowerPoint?
Huh ??? I've been impressed with IMPRESS over MsFt's since I found it has more options, including the ability to save to whatever; although saving to MsFt's loses some of those options - as audio additions, and many of IMPRESS' transitional effects are also not recognized by MsFt ... I don't understand the comment re. Android - I've heard the name, along with these fruit-names, yet have not acquired any of these yet ;-) On Wed, Jan 30, 2013 at 6:24 PM, Tom Davies wrote: Hi :) > Have you checked your glasses for roses? That is about the first time i > have heard anyone saying they thought Impress is actually better in terms > of functionality. Especially going back a few years. > > I thought a lot of progress had been made over the last year and this new > remote-control feature if it's on Gnu&Linux and you are using an Android > all sounds intriguing. > Regards from > Tom :) > > > > > -- > *From:* anne-ology > > *To:* Gilles > *Cc:* users@global.libreoffice.org > *Sent:* Wednesday, 30 January 2013, 23:48 > *Subject:* Re: [libreoffice-users] How good is Impress compared to > PowerPoint? > > IMPRESS does more, has more options; and has been my favorite for > years; > it also allows for saving to PP, etc. - for those who refuse to > leave MSFT ;-) > > > > On Wed, Jan 30, 2013 at 4:32 PM, Gilles wrote: > > Hello > > > > Before possibly recommending LibreOffice to a friend who needs an office > > suite for her personal use, I need to know how good its Impress > component > > is compared to PowerPoint. > > > > She won't need to create very sophisticated slides, and won't need to > > import > > PowerPoint files. It's just to create some presentations for her class. > She > > has regular office skills, she's not a geek. > > > > If you have extensive experience with both PowerPoint and Impress, would > > you > > say Impress is good enough or still lacking? > > > > Here's a review: > > "Admittedly, PowerPoint still outperforms Impress, yet not by such an > > extent > > that the difference couldn't be overcome in a release or two. In fact, > the > > lack of improvements in Impress over the last few years -- particularly > in > > its audio capabilities -- suggests that for most users the deficiencies > are > > unimportant." > > > > > > > www.datamation.com/open-source/libreoffice-vs.-ms-office-spreadsheets-and-slide-shows-1.html > > > > Thank you. > > > > -- 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] table on notes
Hi I need (for a customer) to put a table in footnote I can't from menu and if I try by copy and paste libreoffice hang off There's a workaround for this? I'm on libreoffice 3.6.2.2 italian version. Thanks -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Vuoi fare un regalo davvero originale? Su MisterCupido.com troverai centinaia di IDEE REGALO per tutte le tasche! Consegne in tutta Italia in soli 2-3 giorni Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=12387&d=31-1 -- 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: Base Report Builder
Hi :) Lol! I liked that post. Very funny. I thought PostgreSQL was for large databases? Also i thought Firebird was supposed to be quite good? I think that really is a large one though so possibly not what i am looking for. I'm hoping it is because i think one of my bosses is buying a front-end that uses it and i was hoping to use the same back-end for other databases. Regards from Tom :) > > From: Wolfgang Keller >To: users@global.libreoffice.org >Sent: Wednesday, 30 January 2013, 17:31 >Subject: Re: [libreoffice-users] Re: Base Report Builder > >> I have heard that corporates love to have their valuable data in java >> based backends > >That's because corporations are intrinsically dysfunctional organisations >that promote opportunist egomaniacs who have no competence in any other >field than careerism into those positions where they can cause the >maximum damage to the entity. > >FOSS projects shouldn't try to mimic corporate pathologies. > >> but is there something safer that is still good for smaller amounts >> of data? > >There's no (FOSS) RDBMS that beats PostgreSQL. And LO has a native >driver for it. > >Sincerely, > >Wolfgang > >-- >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] Embedded video in Impress
Hi :) Yes :( Sorry about that! At least it was good to hear someone found the work-around got fixed! Regards from Tom :) > > From: Malcolm Moore >To: users@global.libreoffice.org >Sent: Thursday, 31 January 2013, 11:47 >Subject: Re: [libreoffice-users] Embedded video in Impress > >Ah, yes, it has been reported. It has been outstanding for about a year now :-( > > >Mal > _ > >From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] >To: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info], >users@global.libreoffice.org [mailto:users@global.libreoffice.org] >Sent: Thu, 31 Jan 2013 00:09:59 + >Subject: Re: [libreoffice-users] Embedded video in Impress > > >Hi :) >I think this is a bug that has already been reported. If you find the >bug-report than please add a helpful comment. I think people have suggested >using a link from the slide to a video that is not embedded in the document. >https://wiki.documentfoundation.org/BugReport >Apols and regards from >Tom :) > > > > > > > > _ > > From: Malcolm Moore >To: users@global.libreoffice.org >Sent: Wednesday, 30 January 2013, 20:45 >Subject: [libreoffice-users] Embedded video in Impress > >This has got to be really easy but I can't figure it out :-( >How do I embed a video on a slide and then have it only play >when you click on it. At the moment it starts playing as soon >as I show the slide. > >Ta > >Mal > >-- >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] Need comfirmation about no function of Modeless Dialogs in 4.0
...and for me as well
(produces empty window ~ 55mm x 55mm
with title reading "LibreOffice 3.6").
jdh
On 01/29/2013 03:33 PM, Leif Lodahl wrote:
It works for me (I see an emty grey window but not with a title).
Running LibreOffice 4.0.0.2 on 32bit deb_Linux.
Hopes this can help ;-)
Chhers,
Leif Lodahl
2013/1/29 Fernand Vanrie
We uses the Basic codelines below to make Modeless Dialogs, sinds 4.0 we
end up with a non-visible window
is this a Windows only problem or a more general regression due to changes
in the API ?,
it was working until 3.6.4 Windows
Greetz
Fernand
Sub Main
oDoc = ThisComponent
oParentFrame = oDoc.CurrentController.Frame
oPeer = oParentFrame.ContainerWindow
oToolkit = oPeer.Toolkit
oWindow = CreateNewWindow(oToolkit,**oPeer,150,150,200,200)
oFrame = CreateUnoService("com.sun.**star.frame.Frame")
oFrame.initialize(oWindow)
oFrame.setCreator(**oParentFrame)
oFrame.setName("NewFrame")
oFrame.Title = "New Frame"
oParentFrame.getFrames().**append(oFrame)
oWindow.setVisible(True)
End Sub
Function CreateNewWindow( _
oToolkit,oParent,nX,nY,nWidth,**nHeight) As Object
aRect = CreateUnoStruct("com.sun.star.**awt.Rectangle")
With aRect
.X = nX
.Y = nY
.Width = nWidth
.Height = nHeight
End With
aWinDesc = CreateUnoStruct("com.sun.star.**awt.WindowDescriptor")
With aWinDesc
.Type = com.sun.star.awt.WindowClass.**TOP
.WindowServiceName = "dialog"
.ParentIndex = -1
.Bounds = aRect
.Parent = oParent
.WindowAttributes = _
com.sun.star.awt.**WindowAttribute.MOVEABLE + _
com.sun.star.awt.**WindowAttribute.CLOSEABLE
End With
CreateNewWindow = oToolkit.createWindow(**aWinDesc)
End Function
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
org
Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
unsubscribe/
List archive:
http://listarchives.**libreoffice.org/global/users/
[libreoffice-users] MariaDB 5.5.29, 5.3.12, 5.2.14, 5.1.67 now available
Hi :) I thought a few people in here might be interested in this announcement from MariaDb, which is a drop-in replacement for MySql. So it's for people here who; * are using Base as a front-end and MariaDb as a back-end already, * are interested in other OpenSource projects that have broken free from Oracle in much the same way as LibreOffice did and at around the same time for roughly the same reasons, * are currently unhappy with MySql and looking for a drop-in replacement * are looking for a robust alternative back-end for a database that contains (or will/might contain) a lot of data Regards from Tom :) > > From: MariaDB Announce List >To: annou...@mariadb.org >Sent: Thursday, 31 January 2013, 14:00 >Subject: [MariaDB Announce] MariaDB 5.5.29, 5.3.12, 5.2.14, 5.1.67 now >available > >The MariaDB project is pleased to announce the immediate availability >of the following new MariaDB versions: 5.5.29, 5.3.12, 5.2.14, & 5.1.67 > >Appologies in advance for the length of this email but we'd rather send >out just one combined announce email instead of an email for each of >these releases. > >- - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > >MariaDB 5.5.29 Stable (GA) >- Release Notes: https://kb.askmonty.org/en/mariadb-5529-release-notes >- Changelog: https://kb.askmonty.org/en/mariadb-5529-changelog >- Downloads: https://downloads.mariadb.org/mariadb/5.5.29 > >MariaDB 5.3.12 Stable (GA) >- Release Notes: https://kb.askmonty.org/en/mariadb-5312-release-notes >- Changelog: https://kb.askmonty.org/en/mariadb-5312-changelog >- Downloads: https://downloads.mariadb.org/mariadb/5.3.12 > >MariaDB 5.2.14 Stable (GA) >- Release Notes: https://kb.askmonty.org/en/mariadb-5214-release-notes >- Changelog: https://kb.askmonty.org/en/mariadb-5214-changelog >- Downloads: https://downloads.mariadb.org/mariadb/5.2.14 > >MariaDB 5.1.67 Stable (GA) >- Release Notes: https://kb.askmonty.org/en/mariadb-5167-release-notes >- Changelog: https://kb.askmonty.org/en/mariadb-5167-changelog >- Downloads: https://downloads.mariadb.org/mariadb/5.1.67 > > >- - Other Links - - - - - - - - - - - - - - - - - - - - - - - - - - - > > APT and YUM Repository Configuration Generator: > https://downloads.mariadb.org/mariadb/repositories/ > > Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 > Overview of MariaDB 5.3: https://kb.askmonty.org/en/what-is-mariadb-53 > Overview of MariaDB 5.2: https://kb.askmonty.org/en/what-is-mariadb-52 > Overview of MariaDB 5.1: https://kb.askmonty.org/en/what-is-mariadb-51 > > >- - Security Updates - - - - - - - - - - - - - - - - - - - - - - - - - > >These releases are "bug fix" releases and they include, among other >things, fixes for the following security vulnerabilities: > >- A buffer overflow that can cause a server crash or arbitrary code > execution (a variant of CVE-2012-5611) > http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5611 > >- CVE-2012-5627/MDEV-3915 fast password brute-forcing using the > "change user" command > http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5627 > https://mariadb.atlassian.net/browse/MDEV-3915 > >- CVE-2012-5615/MDEV-3909 information leakage about existing user > accounts via the protocol handshake > http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5615 > https://mariadb.atlassian.net/browse/MDEV-3909 > >- fixes for DoS attacks - crashes and server lockups > https://mariadb.atlassian.net/browse/MDEV-4029 > https://mariadb.atlassian.net/browse/MDEV-729 > >These releases of MariaDB also include all applicable upstream security >fixes from MySQL, such as fix for a CVE-2012-5612/MDEV-3908 and other >crashes. >http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-5612 >https://mariadb.atlassian.net/browse/MDEV-3908 > > >- - New Packages - - - - - - - - - - - - - - - - - - - - - - - - - - - > >MariaDB 5.5.29 includes packages for Fedora 18 "Spherical Cow" and >Ubuntu 12.10 "Quantal Quetzal". Visit the Repository Configurator to >generate the necessary commands to easily install MariaDB on these and >many other distributions. > >We've also extended the repository configuration tool to provide >instructions for distributions which include MariaDB. We've started with >Mageia and will be adding others soon. > >https://downloads.mariadb.org/mariadb/repositories/ > > >- - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - > >Along with the news of new package builds is the news that some old >distributions will be deprecated. The MariaDB project tries to support >as many different operating systems and Linux distributions as >possible. However, when a distribution or OS stops receiving upstream >security and other updates it becomes difficult to provide packages for >that platform. In such cases, our policy is to deprecate that platform >and stop building binary packages for it in our build system. > >As of 1 Feb 201
[libreoffice-users] The best cordless presenter for Impress? Logitech R-RB5 or..?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, A few years ago I went out to LinuxExpo (2008) and we needed a cordless presenter. After testing about a dozen (I kid you not!) I found this gem: Logitech R-RB5 2.4 GHz Cordless Presenter http://www.logitech.com/en-us/support/175?crid=402 The range is crazy (I tested >100 m in open areas) and despite heavy wifi interference it's always done very well in crowded conferences. It also works out of the box in GNU/LInux (I primarily use Trisquel now, a Debian derivative, but tested in many others). It was expensive at the time (U$100) and it's been discontinued now in favor of other models: http://www.logitech.com/en-us/support/presenter It can still be found on eBay and classified ads sites, though. I was wondering if anyone here is using the other presenters Logitech offers, specially in GNU/Linux. What has been your experience? Anyways, if you look for a fantastic range and easy to use cordless presenter, the above is my personal favorite. Cheers, F. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: PGP/Mime available upon request Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iEUEARECAAYFAlEKeU0ACgkQfUcTXFrypNX2MACg/YCaI6/C2eQdzziC3MXpWtrI 3pMAlAmFDbBWU0BdTZfSCywOZ99f3hU= =dkp6 -END PGP SIGNATURE- -- 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] Copy Paste Calc Writer
On 01/31/2013 03:26 AM, Ad Kurvink wrote: Dear All, Since quite some time I cannot complete copy paste anymore the way I used to. I did as follows : I made a contract in Calc Made a selection and clicked copy Than opened a writer sheet what I have already, that is where I have my adress on top and some genereal conditions. I normally used to paste the selection from Calc with Copy Special and than choose Bitmap. Used to work fine. Now there is only a window appearing showing "Image" How can I get it back the way it used to be ? Thanks in advance for your help +++ Ad Kurvink What version of LibreOffice are you using? When I use 2.5.7 or 4.0.0.2, I can paste special (Edit -> Paste Special) a graphic into a Writer document that I copied from a spreadsheet. Bitmap was one of the choices available when I used paste special. --Dan -- 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: Numbering Equations (Thanks)
Hi :) You are welcome. I think it was Brian that did most of the heavy lifting there. For a while i thought it was going to be an intractable problem so i was really glad to see it solved. Thanks for pushing through with it rather than just giving up, as many would have done. Good work and congrats! Oh, and to all the people that helped with this thread too Regards from Tom :) > > From: Taang Zomi >To: users@global.libreoffice.org >Cc: Taang Zomi ; putaangz...@gmail.com >Sent: Thursday, 31 January 2013, 9:44 >Subject: [libreoffice-users] Re: Numbering Equations (Thanks) > >Dear Robert Funnell, Brian Barker, Dries Feys, Dan Lewis, Tom Davies, and >Tom Webb, > >Thank you all for discussing and solving one of my problems. > >Sincerely, > >Taang Zomi > >On Sun, Jan 27, 2013 at 6:04 PM, Taang Zomi wrote: > >> >> >> In LibreOffiice 3.3 Math Guide (0700MG33-MathGuide3.3.odt), on p. 14, the >> following is written: >> >> *Numbering equations* >> >> Equation numbering is one of LibreOffice Math’s best hidden features. The >> steps are simple, but obscure: >> >> 1. >> >> Start a new line. >> 2. >> >> Type *fn* and then press *F3*. >> >> The *fn* is replaced by a numbered formula: >> >> [[equation: E = mc2] (2) >> >> () >> >> Now you can double-click on the formula to edit it. For example, here is >> the Riemann Zeta function: >> [equation: [Rieman Zeta Function] (3) >> >> You can reference an equation (“as shown in Equation (2)”) with these >> steps: >> >> 1. >> >> Choose *Insert > Cross-reference* from the menu bar. >> 2. >> >> On the *Cross-references* tab (Figure 17), under *Type*, select *Text*. >> 3. >> >> Under *Selection*, select the equation number. >> 4. >> >> Under *Format*, select *Reference*. >> >> >> >> == >> >> When I typed fn and pressed F3, nothing happened. In the document the fn I >> typed appeared, not the desired result. >> >> >> I do not know whether my F3 key did not work. >> >> Can somebody kindly explain in step-by-step detail how to number >> equations. >> >> >> == >> > >-- >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] libreOfficeImpress hangs after inserting 2minute video
On 2013-01-28 6:05 PM, anne-ology wrote: IMPRESS doesn't accept videos; ??? Sure it does... -- 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] Numbering Questions: (2) or (1)?
Hi :) The Maths Guide is getting a major re-vamp fairly soon. The Docs Team suddenly found the German translation had added tons of extra stuff and even has enough to break it out into separate chapters. If you can read German look for their version. My guess is that your case worked out all right and in the guide they might have had a previous example at some point in the last 10 years or so that maybe didn't make it into the version of the guide you are reading. Also when creating the guides sometimes weird things do happen and there are never enough people in the team to get everything perfect. MS Guides only need to be produced to cover 1 release every 3 or 4 years and they employ tons of people to work on those guides. Their guides cost quite a lot too so that they can pay people and make a hefty profit. LibreOffice has a major new branch twice per year and relies on people volunteering and in the few places where they sell it the prices are extremely low. Even so most people just download the free versions from the official website or the wiki. So, "it's a completely different bottle of crisps". The Draw and Impress Guides recently got taken on by someone that really cares about them so quality has jumped up in the last couple of releases but Math is still a bit iffy, at least until the translations from German get done. Personally i am hoping the Docs Team are focusing on the Base Guide this time and maybe worry about Math afterwards but people join the team to work on issues that concern them and so that's what gets the most attention. It works well because it means the people working on any particular guide have a vested interested and are keen to get good quality results. Regards from Tom :) > > From: Taang Zomi >To: users@global.libreoffice.org >Cc: Taang Zomi ; putaangz...@gmail.com >Sent: Thursday, 31 January 2013, 10:06 >Subject: [libreoffice-users] Numbering Questions: (2) or (1)? > >On page 23 of LibreOffice 3.5.5 Math Guide, it is written: > >*Numbering equations* > >Equation numbering is one of Writer’s best hidden features. The steps are >simple, but obscure: > > 1. > > Start a new line. > 2. > > Type *fn* and then press *F3*. > >The *fn* is replaced by a numbered formula: > >E= mc2 (2) > >== > > >But I got: > >E = mc2 (1) > >== > >Should I have got (2), as in the Math Guide? Is it all right for me to get >(1)? Is the Math Guide a little wrong here? > >Sincerely, > >Taang Zomi > > >== > >-- >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] changing text color
On 01/31/2013 04:01 AM, edo1 wrote: Sorry to continue asking elementary questions, I'm having a devil of a time getting LO 3.6.4.3 to behave. I cannot change the foreground color (i.e., the color of selected text) - pressing on the text-color icon in the toolbar has no effect. Setting background color works, sort of - I get a color, but not the one I've chosen. I've tried changing the color setting in Options > LibreOffice > Appearance between Font: automatic (shows black in box)) and Font: Black. Neither of these make a difference; color selection from the toolbar still doesn't work. As usual, any advice would be appreciated. - edo1 -- View this message in context:http://nabble.documentfoundation.org/changing-text-color-tp4033394.html Sent from the Users mailing list archive at Nabble.com. You have not described what you did when you tried to change the color of the selected text. We need your specific steps. The font color can also be changed using Character styles (Format -> Character): 1. Highlight some text. 2. Format -> Character 3. Select the color you want to use. 4. Click OK. --Dan -- 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] Embedded video in Impress
Ah, yes, it has been reported. It has been outstanding for about a year now :-( Mal _ From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] To: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info], users@global.libreoffice.org [mailto:users@global.libreoffice.org] Sent: Thu, 31 Jan 2013 00:09:59 + Subject: Re: [libreoffice-users] Embedded video in Impress Hi :) I think this is a bug that has already been reported. If you find the bug-report than please add a helpful comment. I think people have suggested using a link from the slide to a video that is not embedded in the document. https://wiki.documentfoundation.org/BugReport Apols and regards from Tom :) _ From: Malcolm Moore To: users@global.libreoffice.org Sent: Wednesday, 30 January 2013, 20:45 Subject: [libreoffice-users] Embedded video in Impress This has got to be really easy but I can't figure it out :-( How do I embed a video on a slide and then have it only play when you click on it. At the moment it starts playing as soon as I show the slide. Ta Mal -- 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: setting paper size
Hi again, I use LO under Linux (Debian-Wheezy as well as Mint-Nadia). There you can specify PDF/Postscript and other printing destinations under "Device" in the printing dialog. PDF is the default. Unfortunately things like landscape printing don't work properly then. Setting it to Postscript Level 2 works fine, however. In older versions I knew how to change that default in some config-file, but don't know how to do so under LO 4.0-rc2 in Linux. Regards H.S. On Thu, 31 Jan 2013 10:19:13 +0100, edo1 wrote: I'll be damned - I don't know where to set "Device" in vista, but taking your hint, instead of "Export as PDF" I chose "Export." With that I saw that the file format was defaulted to .xml. I changed this to pdf, and lo! Though the chosen foreground color doesn't show in the odt. file, it does show in the pdf. The color toolbar is indeed buggy, no? Heinrich Stoellinger wrote Hi, Did you set the "Device" to PostScript? PDF printing is "buggy" in my opinion. Regards H.S. On Thu, 31 Jan 2013 09:20:37 +0100, edo1 < edagro12@ > wrote: I'm using LO on Vistax64, printing on a Canon IP2600. I can't change the paper size successfully when printing from LO. When trying to print on half-sheets (5.5x8.5 stock), I can set the printer settings OK, but when I click on Print the LO shows the requested text printed at the top left of a full 8.6x11 sheet; and the printer's pre-print display follows that instead of the settings it had accepted from me.. (By exporting the LO file to the PDF file I finally was able to print to the half size sheets, but it require my setting the printer to "fit to page printing," which I didn't have to bother with in the last Oracle version. OOo 3.2.0.) The LO user guide was no help. Any advice would be appreciated. -- View this message in context: http://nabble.documentfoundation.org/setting-paper-size-tp4033383.html Sent from the Users mailing list archive at Nabble.com. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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/setting-paper-size-tp4033383p4033395.html Sent from the Users mailing list archive at Nabble.com. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] Copy Paste Calc Writer
Thanks Sigrid, that solved it. thanks again. On 31-01-13 11:02, Sigrid Carrera wrote: Hi Ad, On 31 January 2013 10:55, Tom Davies wrote: Hi :) First thing to try (if/when things suddenly go weird or stop working) is to rename the User Profile https://wiki.documentfoundation.org/Documentation/UserProfile That should not be necessary. Please check the following: Tools > Options > LibreOffice Writer > View Is there a checkmark under the heading "Display" in front of "Graphics and Objects"? If not, please set it. I believe, that this is the "cause" of your problem. Sigrid -- 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] Numbering Questions: (2) or (1)?
At 05:06 31/01/2013 -0500, Taang Zomi wrote: On page 23 of LibreOffice 3.5.5 Math Guide, it is written: *Numbering equations* [...] The *fn* is replaced by a numbered formula: E= mc2 (2) But I got: E = mc2 (1) Should I have got (2), as in the Math Guide? That depends on what is currently in your document. If this is your first equation, you will see "(1)"; if it is your second (as apparently in the guide's example), you will see "(2)" and so on. That is the nature of numbering! Because the number is a field, it will change if you subsequently insert other equations before it in your document. So any references to it should be cross-references, not hard text. Is it all right for me to get (1)? Yes. Is the Math Guide a little wrong here? Not necessarily. I trust this helps. Brian Barker -- 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] Numbering Questions: (2) or (1)?
On page 23 of LibreOffice 3.5.5 Math Guide, it is written: *Numbering equations* Equation numbering is one of Writer’s best hidden features. The steps are simple, but obscure: 1. Start a new line. 2. Type *fn* and then press *F3*. The *fn* is replaced by a numbered formula: E= mc2 (2) == But I got: E = mc2 (1) == Should I have got (2), as in the Math Guide? Is it all right for me to get (1)? Is the Math Guide a little wrong here? Sincerely, Taang Zomi == -- 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] Copy Paste Calc Writer
Hi :) First thing to try (if/when things suddenly go weird or stop working) is to rename the User Profile https://wiki.documentfoundation.org/Documentation/UserProfile It might be that you can simply paste now and don't need to use the Paste Special - Bitmap Just paste. Regards from Tom :) > > From: Ad Kurvink >To: users@global.libreoffice.org >Sent: Thursday, 31 January 2013, 8:26 >Subject: [libreoffice-users] Copy Paste Calc Writer > >Dear All, > >Since quite some time I cannot complete copy paste anymore the way I used to. > >I did as follows : > >I made a contract in Calc >Made a selection and clicked copy >Than opened a writer sheet what I have already, that is where I have my >address on top and some general conditions. > >I normally used to paste the selection from Calc with Copy Special and than >choose Bitmap. Used to work fine. > >Now there is only a window appearing showing "Image" > >How can I get it back the way it used to be ? > >Thanks in advance for your help > >+++ >Ad Kurvink > >-- 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] Re: Numbering Equations (Thanks)
Dear Robert Funnell, Brian Barker, Dries Feys, Dan Lewis, Tom Davies, and Tom Webb, Thank you all for discussing and solving one of my problems. Sincerely, Taang Zomi On Sun, Jan 27, 2013 at 6:04 PM, Taang Zomi wrote: > > > In LibreOffiice 3.3 Math Guide (0700MG33-MathGuide3.3.odt), on p. 14, the > following is written: > > *Numbering equations* > > Equation numbering is one of LibreOffice Math’s best hidden features. The > steps are simple, but obscure: > >1. > >Start a new line. >2. > >Type *fn* and then press *F3*. > > The *fn* is replaced by a numbered formula: > > [[equation: E = mc2] (2) > > () > > Now you can double-click on the formula to edit it. For example, here is > the Riemann Zeta function: > [equation: [Rieman Zeta Function] (3) > > You can reference an equation (“as shown in Equation (2)”) with these > steps: > >1. > >Choose *Insert > Cross-reference* from the menu bar. >2. > >On the *Cross-references* tab (Figure 17), under *Type*, select *Text*. >3. > >Under *Selection*, select the equation number. >4. > >Under *Format*, select *Reference*. > > > > == > > When I typed fn and pressed F3, nothing happened. In the document the fn I > typed appeared, not the desired result. > > > I do not know whether my F3 key did not work. > > Can somebody kindly explain in step-by-step detail how to number > equations. > > > == > -- 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: setting paper size
I'll be damned - I don't know where to set "Device" in vista, but taking your hint, instead of "Export as PDF" I chose "Export." With that I saw that the file format was defaulted to .xml. I changed this to pdf, and lo! Though the chosen foreground color doesn't show in the odt. file, it does show in the pdf. The color toolbar is indeed buggy, no? Heinrich Stoellinger wrote > Hi, > Did you set the "Device" to PostScript? PDF printing is "buggy" in my > opinion. > Regards > H.S. > > On Thu, 31 Jan 2013 09:20:37 +0100, edo1 < > edagro12@ > > wrote: > >> I'm using LO on Vistax64, printing on a Canon IP2600. >> >> I can't change the paper size successfully when printing from LO. When >> trying to print on half-sheets (5.5x8.5 stock), I can set the printer >> settings OK, but when I click on Print the LO shows the requested text >> printed at the top left of a full 8.6x11 sheet; and >> the printer's pre-print display follows that instead of the settings it >> had >> accepted from me.. >> >> (By exporting the LO file to the PDF file I finally was able to print to >> the half size sheets, but it require my setting the printer to "fit to >> page >> printing," which I didn't have to bother with in the last Oracle version. >> OOo 3.2.0.) >> >> The LO user guide was no help. Any advice would be appreciated. >> >> >> >> >> -- >> View this message in context: >> http://nabble.documentfoundation.org/setting-paper-size-tp4033383.html >> Sent from the Users mailing list archive at Nabble.com. >> > > > -- > Erstellt mit Operas revolutionärem E-Mail-Modul: > http://www.opera.com/mail/ > > -- > 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/setting-paper-size-tp4033383p4033395.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] changing text color
Sorry to continue asking elementary questions, I'm having a devil of a time getting LO 3.6.4.3 to behave. I cannot change the foreground color (i.e., the color of selected text) - pressing on the text-color icon in the toolbar has no effect. Setting background color works, sort of - I get a color, but not the one I've chosen. I've tried changing the color setting in Options > LibreOffice > Appearance between Font: automatic (shows black in box)) and Font: Black. Neither of these make a difference; color selection from the toolbar still doesn't work. As usual, any advice would be appreciated. - edo1 -- View this message in context: http://nabble.documentfoundation.org/changing-text-color-tp4033394.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] Embedded video in Impress
Hai Malcolm, > >This has got to be really easy but I can't figure it out :-( > >How do I embed a video on a slide and then have it only play > >when you click on it. At the moment it starts playing as soon > >as I show the slide. Until this bug or missing feature (depends on how you look at it) is fixed you might do what I do: - Capture a picture of the movie in question and put that on a slide. - Through the use of an interaction link to the video and make it start playing when you click on the image. There's one catch though: only the most recent versions allow the use of relative links for embedding external content, making this method not really portable for versions at least up to 3.5. If it doesn't need to be portable, or if you have the same location for your presentation on the machines you use, or if you use 3.6, then this shouldn't be a problem. Grx HdV -- 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] setting paper size
Hi, Did you set the "Device" to PostScript? PDF printing is "buggy" in my opinion. Regards H.S. On Thu, 31 Jan 2013 09:20:37 +0100, edo1 wrote: I'm using LO on Vistax64, printing on a Canon IP2600. I can't change the paper size successfully when printing from LO. When trying to print on half-sheets (5.5x8.5 stock), I can set the printer settings OK, but when I click on Print the LO shows the requested text printed at the top left of a full 8.6x11 sheet; and the printer's pre-print display follows that instead of the settings it had accepted from me.. (By exporting the LO file to the PDF file I finally was able to print to the half size sheets, but it require my setting the printer to "fit to page printing," which I didn't have to bother with in the last Oracle version. OOo 3.2.0.) The LO user guide was no help. Any advice would be appreciated. -- View this message in context: http://nabble.documentfoundation.org/setting-paper-size-tp4033383.html Sent from the Users mailing list archive at Nabble.com. -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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] Copy Paste Calc Writer
Dear All, Since quite some time I cannot complete copy paste anymore the way I used to. I did as follows : I made a contract in Calc Made a selection and clicked copy Than opened a writer sheet what I have already, that is where I have my adress on top and some genereal conditions. I normally used to paste the selection from Calc with Copy Special and than choose Bitmap. Used to work fine. Now there is only a window appearing showing "Image" How can I get it back the way it used to be ? Thanks in advance for your help +++ Ad Kurvink -- 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] setting paper size
I'm using LO on Vistax64, printing on a Canon IP2600. I can't change the paper size successfully when printing from LO. When trying to print on half-sheets (5.5x8.5 stock), I can set the printer settings OK, but when I click on Print the LO shows the requested text printed at the top left of a full 8.6x11 sheet; and the printer's pre-print display follows that instead of the settings it had accepted from me.. (By exporting the LO file to the PDF file I finally was able to print to the half size sheets, but it require my setting the printer to "fit to page printing," which I didn't have to bother with in the last Oracle version. OOo 3.2.0.) The LO user guide was no help. Any advice would be appreciated. -- View this message in context: http://nabble.documentfoundation.org/setting-paper-size-tp4033383.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
