Re: [libreoffice-users] Paragraph styles for list styles
Hi :) I have cc'd your question to the documentation team for them to consider for the next set of guides. Which documentation? Is it in the Guides that appear on these 2 pages? http://www.libreoffice.org/get-help/documentation/ http://wiki.documentfoundation.org/Documentation/Publications (all the guides that appear in the first link are also in the 2nd but the 2nd has a lot more and includes 3rd party documentation too) If you mean the help files that you get when you click on Help inside the program then you might find the guides tend to be a lot more up-to-date and helpful. Thanks and regards from Tom :) --- On Thu, 10/5/12, Carlos Pita carlosjosep...@gmail.com wrote: From: Carlos Pita carlosjosep...@gmail.com Subject: [libreoffice-users] Paragraph styles for list styles To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 3:45 Hi all, I find this description in the documentation very misleading: Each of the list styles predefined in Writer has four associated paragraph styles. For example, the Numbering 1 list style is associated with four paragraph styles: Numbering 1 Numbering 1 Cont. Numbering 1 End Numbering 1 Start In what sense list style Numbering 1 is related to paragraph styles Numbering 1 *? What one can see is that the N in paragraph styles Numbering N * is related to indentation level and not intended for working in tandem with the list style Numbering N. One can use paragraph style Numbering 1 with any of the list styles, because concerns seem to be completely orthogonal. Can you clarify the relationship between paragraph styles Numbering N * and list style Numbering N? What scenarios are paragraph styles Numbering N * and List N * intended for? Thank you a lot -- Carlos -- 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] Templates Disappeared
Hi :) Try Tools - Options - Paths to see where LibreOffice is looking for your templates. Hopefully you can edit that to look in the right place. It is better to have your templates inside your /home along with all the rest of your users data and settings. The full address for the 3.5.x branch is something like /home/username/.config/libreoffice/3/user/template Note that inside /home/username/.config you will see a lot of folders. Each program has a folder in there for it's own settings and configurations. Some are still in /home/username but are moving to the newer place to reduce congestion and confusion. Note that username should be replaced by your own user-name, the one you login with. Don't change the 3/user part tho! Regards from Tom :) --- On Thu, 10/5/12, Keith Bates ke...@new-life.org.au wrote: snip / On 03/05/12 05:12, Dan Lewis wrote: snip / The problem arises from a change in where the templates are located: LO 3.5 stores them in a different location (.config/libreoffice/3/user/template) than 3.4 (.libreoffice/3/user/template). Suggestion: use the organise templates feature again. If you use My Templates as the folders for your templates, highlight it. The click the Command button and select Update. Perhaps this will cause your templates to appear. If this does not work, copy your templates contained in .libreoffice/3/user/template to .config/libreoffice/3/user/template. Then organise your templates, highlight the My Template folder, click the Command button, and select Update from the drop down menu. The templates should appear. I used this process to add multiple templates to My Templates, and it saves time compared to importing one template at a time. --Dan I tried what Dan suggested but it doesn't work :( I don't even have a My Templates folder in the template organiser wizard thing. I know it was there in 3.4 but it's no longer there. I copied the template files to .config/libreoffice/3/user/template then clicked the Commands button and Update but then got several templates already exists messages and one Update could not be completed error. I've removed all folders from the templates path except the default (/usr/lib/ something) and then added.config/libreoffice/3/user/template and set it as the default for adding new templates. I'm wondering if there is a glitch in the Ubuntu update. -- God bless you Keith Bates -- 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: Cal default print settings (and general default settings)
Am 10.05.2012 02:51, The Wolfkin wrote: another quick one. by default Calc doesn't print the grid or column/row headers. For everyone for whom I suggest LibreOffice this is a huge problem. Is there a way to change settings by default? Speaking of default settings.. on a slightly more off topic. Is there a way, for instance write a small script, to save a series of settings? When I install LibreOffice on someone's computer I got thru a the same series of steps to ensure the smoothest transition. This includes things like changing the default file saving format. Perhaps turning the autocorrect off (oddly most of the people I know would be grateful to remove the squiggle they've just never known it was an option before), and stuff like that. Install http://gnumeric.org and forget about all office software based on templates and styles. -- 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] My story
I have been testing LibreOffice Base 3.5 and MySQL on a Windows 7 64bit computer. I have found that the OpenOffice connector does work for me with LibreOffice but the discussion that it does not work for everyone and is likely to fail at some time in the future encouraged me to have another look at using the ODBC connector. I also found that I received a 'can't find driver' error but this is caused by 64bit/32bit issues. As I understand it, LibreOffice requires a 32bit ODBC driver and needs to be configured with the 32bit ODBC administrator. The default ODBC administrator on my computer is the 64bit. Anyway all these issues and the solutions are described in http://ltlbgr.files.wordpress.com/2012/05/mysql_odbc.odt at my blog site. cheers Mike On Wed, May 9, 2012 at 6:09 PM, Tony Sumner t...@whittycat.me.uk wrote: A while back Tom asked people to tell their stories so this is mine. I started with a project to create an application using a DBMS to manage our local currency. This would be used by relatively basic users who would almost certainly want to use Windows. I already had a working knowledge of MySQL and I knew how to use that to do all the admin tasks but I needed a GUI to do data entry and report writing. So I started by trying to connect LO to MySQL with the ODBC connector. After a lot of reading I installed the MyODBC connector, created a driver and a DSN amd LO said Can't find driver or something like that. I thought I'd try it in Linux to get the hang of it before settling down to work in Windows and this gave me Can't find library or something like that. Then I found that LO will connect to MySQL directly without the need for a connector so I tried that and it worked. But this facility is not available in Windows. OOo does have the facility to connect directly to MySQL in Windows so at last I can get on with the project. OOo does what I want and OOo Base is pretty much like LO Base so I'm afraid it is goodbye LO. Been good to know you Tony -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-documentation] Re: [libreoffice-users] Paragraph styles for list styles
--- On Thu, 10/5/12, Gary Schnabl gschn...@swdetroit.com wrote: From: Gary Schnabl gschn...@swdetroit.com Subject: Re: [libreoffice-documentation] Re: [libreoffice-users] Paragraph styles for list styles To: documentat...@global.libreoffice.org Date: Thursday, 10 May, 2012, 9:28 These styles make up the set of paragraph styles for ordered and unordered lists that date way back to version 1.x, but which never were really explained much outside of the OOo/LO user guides. Also, the factory-default formatting for these styles is not in general agreement throughout the Ns (worse in OOo than in LO). They appear to be much unlike the human appendix--somewhat useless in its original form but which can be made useful. I assume that the N was originally meant to refer to the level of nesting of lists, which itself would almost always use indentation. Because their factory-default formatting is somewhat inconsistent, their parameters should be reformatted by the users (or template designers) in order to be made to work better . Gary On 5/10/2012 4:01 AM, Tom Davies wrote: Hi :) I have cc'd your question to the documentation team for them to consider for the next set of guides. Which documentation? Is it in the Guides that appear on these 2 pages? http://www.libreoffice.org/get-help/documentation/ http://wiki.documentfoundation.org/Documentation/Publications (all the guides that appear in the first link are also in the 2nd but the 2nd has a lot more and includes 3rd party documentation too) If you mean the help files that you get when you click on Help inside the program then you might find the guides tend to be a lot more up-to-date and helpful. Thanks and regards from Tom :) --- On Thu, 10/5/12, Carlos Pitacarlosjosep...@gmail.com wrote: From: Carlos Pitacarlosjosep...@gmail.com Subject: [libreoffice-users] Paragraph styles for list styles To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 3:45 Hi all, I find this description in the documentation very misleading: Each of the list styles predefined in Writer has four associated paragraph styles. For example, the Numbering 1 list style is associated with four paragraph styles: Numbering 1 Numbering 1 Cont. Numbering 1 End Numbering 1 Start In what sense list style Numbering 1 is related to paragraph styles Numbering 1 *? What one can see is that the N in paragraph styles Numbering N * is related to indentation level and not intended for working in tandem with the list style Numbering N. One can use paragraph style Numbering 1 with any of the list styles, because concerns seem to be completely orthogonal. Can you clarify the relationship between paragraph styles Numbering N * and list style Numbering N? What scenarios are paragraph styles Numbering N * and List N * intended for? Thank you a lot -- Carlos -- Unsubscribe instructions: E-mail to documentation+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/documentation/ 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] Bad printing quality if printer language ir PDF
Hi, I had a hard time, tracking down the reasons for bad printing quality when using LibeOffice. * When the printer language is set to PDF (either in File- Print - Properties - Device or via printer-properties) - grafics (logos) have pixeled edges - fonts are pixeled and of very poor quality * When setting the printer language to Postscript, the quality is good. * When exporting the document to PDF and printing this directly (using lp), quality is good. I inspected the print-job attributes and did not find any relevant difference. How can I enhance the printing quality with printing language PDF? Details: LibreOffice 3.4.4.2 Printer supports 600x600 dpi and 600x1200 dpi Used Fonts: LiberationsSans (TrueType=) Linux, CUPS -- Schönen Gruß - Regards Hartmut Goebel Dipl.-Informatiker (univ.), CISSP, CSSLP Goebel Consult Spezialist für IT-Sicherheit in komplexen Umgebungen http://www.goebel-consult.de Monatliche Kolumne: http://www.cissp-gefluester.de/ Goebel Consult ist Mitglied bei http://www.7-it.de -- 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] Templates Disappeared
On 10/05/12 18:18, Tom Davies wrote: Hi :) Try Tools - Options - Paths to see where LibreOffice is looking for your templates. Hopefully you can edit that to look in the right place. It is better to have your templates inside your /home along with all the rest of your users data and settings. The full address for the 3.5.x branch is something like /home/username/.config/libreoffice/3/user/template Note that inside /home/username/.config you will see a lot of folders. Each program has a folder in there for it's own settings and configurations. Some are still in /home/username but are moving to the newer place to reduce congestion and confusion. Note that username should be replaced by your own user-name, the one you login with. Don't change the 3/user part tho! Regards from Tom :) --- On Thu, 10/5/12, Keith Bateske...@new-life.org.au wrote: snip / I get all that. It's not helping. I've edited the paths. I've even deleted them and re-added them. The templates are in the correct folder but LO isn't finding them. There isn't even a folder in the organiser for any templates-- My Templates isn't there. Keith On 03/05/12 05:12, Dan Lewis wrote: snip / The problem arises from a change in where the templates are located: LO 3.5 stores them in a different location (.config/libreoffice/3/user/template) than 3.4 (.libreoffice/3/user/template). Suggestion: use the organise templates feature again. If you use My Templates as the folders for your templates, highlight it. The click the Command button and select Update. Perhaps this will cause your templates to appear. If this does not work, copy your templates contained in .libreoffice/3/user/template to .config/libreoffice/3/user/template. Then organise your templates, highlight the My Template folder, click the Command button, and select Update from the drop down menu. The templates should appear. I used this process to add multiple templates to My Templates, and it saves time compared to importing one template at a time. --Dan I tried what Dan suggested but it doesn't work :( I don't even have a My Templates folder in the template organiser wizard thing. I know it was there in 3.4 but it's no longer there. I copied the template files to .config/libreoffice/3/user/template then clicked the Commands button and Update but then got several templates already exists messages and one Update could not be completed error. I've removed all folders from the templates path except the default (/usr/lib/ something) and then added.config/libreoffice/3/user/template and set it as the default for adding new templates. I'm wondering if there is a glitch in the Ubuntu update. -- God bless you Keith Bates -- God bless you Keith Bates Narrabri NSW Jesus is the Way the Truth and the Life -- 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: Templates Disappeared
Am 10.05.2012 11:37, Keith Bates wrote: I get all that. It's not helping. I've edited the paths. I've even deleted them and re-added them. The templates are in the correct folder but LO isn't finding them. There isn't even a folder in the organiser for any templates-- My Templates isn't there. Keith OK, try this: Open the new office version. FileOpen... Get the old templates folder .libreoffice/3/user/template/ select all the templates you are interested in and load them. Now for each file: FileTemplatesSave... and enter the template name. FileNewTemplate [Ctrl+Shift+N] should list the imported templates now. -- 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: Cal default print settings (and general default settings)
Hi :) You can just copypaste the UserProfile to different machines to set things up the same without going through each individual setting. It's probably better to copy the UserProfile into the right place before install LibreOffice just in case there are new settings that need to over-write 'old' ones. http://wiki.documentfoundation.org/Documentation/UserProfile If you hunt around the print settings there is a tick-box to make row and column headings print. I think try Format - Page - Sheet - Print - Column and row headers I've never known anyone want that sort of thing except a few techie types working in finances on working papers but then they have to switch it off to make presentable documents for clients. Also people get used to red wriggles and bad spellings in MS Office because it randomly switches styles back to ones set to use American English. So people have learned they can't rely on spell-checkers. LibreOffice doesn't misbehave like that. LO usually stays in the language you tell it you want and defaults to whatever you set for the Operating System (eg WinXp, Ubuntu, whatever) Gnumeric is a very light-weight spreadsheet program which is difficult to set to default to using MS formats. I would stick with LibreOffice on machines that can handle it. Regards from Tom :) --- On Thu, 10/5/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Cal default print settings (and general default settings) To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 9:18 Am 10.05.2012 02:51, The Wolfkin wrote: another quick one. by default Calc doesn't print the grid or column/row headers. For everyone for whom I suggest LibreOffice this is a huge problem. Is there a way to change settings by default? Speaking of default settings.. on a slightly more off topic. Is there a way, for instance write a small script, to save a series of settings? When I install LibreOffice on someone's computer I got thru a the same series of steps to ensure the smoothest transition. This includes things like changing the default file saving format. Perhaps turning the autocorrect off (oddly most of the people I know would be grateful to remove the squiggle they've just never known it was an option before), and stuff like that. Install http://gnumeric.org and forget about all office software based on templates and styles. -- 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] Bad printing quality if printer language ir PDF
Hi :) Have you tried exporting to Pdf first? There is a ton of settings in the dialogue-box so that you can set the compression type and amount, the dpi of images and soem tick-boxes that might be worth playing with. Regards from Tom :) --- On Thu, 10/5/12, Hartmut Goebel h.goe...@goebel-consult.de wrote: From: Hartmut Goebel h.goe...@goebel-consult.de Subject: [libreoffice-users] Bad printing quality if printer language ir PDF To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 10:28 Hi, I had a hard time, tracking down the reasons for bad printing quality when using LibeOffice. * When the printer language is set to PDF (either in File- Print - Properties - Device or via printer-properties) - grafics (logos) have pixeled edges - fonts are pixeled and of very poor quality * When setting the printer language to Postscript, the quality is good. * When exporting the document to PDF and printing this directly (using lp), quality is good. I inspected the print-job attributes and did not find any relevant difference. How can I enhance the printing quality with printing language PDF? Details: LibreOffice 3.4.4.2 Printer supports 600x600 dpi and 600x1200 dpi Used Fonts: LiberationsSans (TrueType=) Linux, CUPS -- Schönen Gruß - Regards Hartmut Goebel Dipl.-Informatiker (univ.), CISSP, CSSLP Goebel Consult Spezialist für IT-Sicherheit in komplexen Umgebungen http://www.goebel-consult.de Monatliche Kolumne: http://www.cissp-gefluester.de/ Goebel Consult ist Mitglied bei http://www.7-it.de -- 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] Freezing a cell in Calc permanently
Hi :) Move the cursor down to the 2nd row and then try Window - Freeze If it's not the right cell then you can undo it by selecting Window - Freeze again. I usually select cell B2 or thereabouts so that when i scroll horizontally i can still see the headings in Column A as well as Row 1. Regards from Tom :) --- On Thu, 10/5/12, The Wolfkin wolf...@gmail.com wrote: From: The Wolfkin wolf...@gmail.com Subject: Re: [libreoffice-users] Freezing a cell in Calc permanently To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 3:16 Well my mom just sent me a spreadsheet she's doing. Created on her MacBook 10.5 i think. Should be the latest version of LO. I was working on my Win7 64bit Dell computer here. Ver 3.4.4. These were .ods files. Simple simple stuff here.. Only using one (of three default) sheet. Less than 100 rows, trying to freeze the top row. -- Wolfkin http://about.me/wolfkin On Wed, May 9, 2012 at 9:25 PM, Dan Lewis elderdanle...@gmail.com wrote: Then we need more information about your set up: operating system? version of LO? 32 bit or 64 bit? Is the spreadsheet an Excel workbook? How many sheets do you have in the file? How many of these sheets have the rows or columns frozen? Something is different about your setup that is causing this because you are not getting the standard results. For the last 8 years or perhaps more, a Calc (originally .sxc; now .ods) spreadsheet would preserve the Window Freeze when the file was saved. --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 -- 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: Templates Disappeared
On 10/05/12 19:57, Andreas Säger wrote: Am 10.05.2012 11:37, Keith Bates wrote: I get all that. It's not helping. I've edited the paths. I've even deleted them and re-added them. The templates are in the correct folder but LO isn't finding them. There isn't even a folder in the organiser for any templates-- My Templates isn't there. Keith OK, try this: Open the new office version. FileOpen... Get the old templates folder .libreoffice/3/user/template/ select all the templates you are interested in and load them. Now for each file: FileTemplatesSave... and enter the template name. FileNewTemplate [Ctrl+Shift+N] should list the imported templates now. I deleted all the existing templates in .config/.libreoffice/3/user/template. Then I opened a template and tried to save as a template and got this error: Error writing document Untitled2 as template: templates already exists Click OK and it opens the box to enter a name and save the template.I enter a name and click save and it comes back with the same message. I click OK and then get this message: Error writing document Untitled2 as template: General error General input/output error -- God bless you Keith Bates Narrabri NSW Jesus is the Way the Truth and the Life -- 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: IPad?
Hi :) Push for Doc rather than DocX. Most people have no idea how to do something as complicated as File - Save As .. or Golden Globe - Save As ... Regards from Tom :) --- On Thu, 10/5/12, The Wolfkin wolf...@gmail.com wrote: From: The Wolfkin wolf...@gmail.com Subject: Re: [libreoffice-users] Re: IPad? To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 1:45 .docx is rapidly becoming my new most annoying default. Though it will likely never trump hide file extensions by default or even Hide My Computer/My Documents from desktop by default -- Wolfkin http://about.me/wolfkin On Sun, May 6, 2012 at 1:47 PM, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: I also tend to tell them to send out .doc instead of .docx files, since there are still a large percentage of people/agencies that never bought any newer version of MSO than 2003. Also I tell them that MSO 2010 .docx files can have issues if you open them in MSO 2007. So they should stick with .doc files instead. MSO just keep on messing with their file formats and those new version are not completely compatible with their older MSO versions that could read those formats [by mime name]. -- 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: IPad?
Hi again :) You are a geek. A lot of people are a connoisseur of something. When it's to do with computers it's considered weird and geeky. Take pride in it and take pity on those less capable than you. If you were a wine connoisseur then you would probably hate cheap wines but in the computer world you just have to deal with it as it dominates. Regards from Tom :) --- On Thu, 10/5/12, The Wolfkin wolf...@gmail.com wrote: From: The Wolfkin wolf...@gmail.com Subject: Re: [libreoffice-users] Re: IPad? To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 1:45 .docx is rapidly becoming my new most annoying default. Though it will likely never trump hide file extensions by default or even Hide My Computer/My Documents from desktop by default -- Wolfkin http://about.me/wolfkin On Sun, May 6, 2012 at 1:47 PM, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: I also tend to tell them to send out .doc instead of .docx files, since there are still a large percentage of people/agencies that never bought any newer version of MSO than 2003. Also I tell them that MSO 2010 .docx files can have issues if you open them in MSO 2007. So they should stick with .doc files instead. MSO just keep on messing with their file formats and those new version are not completely compatible with their older MSO versions that could read those formats [by mime name]. -- 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] Bad printing quality if printer language ir PDF
Hi Have you tried exporting to Pdf first? There is a ton of settings in the dialogue-box so that you can set the compression type and amount, the dpi of images and soem tick-boxes that might be worth playing with. As I wrote: the exported PDF prints in good quality. My aim is *not* generate a PDF, but to use PDF as printer language, as this is the default for CUPS now. I do not see how the export-settings should interfere here- -- Schönen Gruß - Regards Hartmut Goebel Dipl.-Informatiker (univ.), CISSP, CSSLP Goebel Consult Spezialist für IT-Sicherheit in komplexen Umgebungen http://www.goebel-consult.de Monatliche Kolumne: http://www.cissp-gefluester.de/ Goebel Consult ist Mitglied bei http://www.7-it.de -- 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] Hyperlink Toolbar
Hi all, This is the first post of a normal user of LO from the beginning and without specials skills. I know hyperlink toolbar was considered a bug, but it is useful. I'm working with LO 3.3.4, no upgrade, to no lost this tool. I don't find any extension making the same function. Usually I read documents in Writer with much references and I must search on internet. May be there is another easy way. There is some project to get back this useful tool, via core or extension? I don't found any Spanish list. Best regards -- 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: Cal default print settings (and general default settings)
Sorry I can't possibly switch anyone to a program that requires this much work to save in an excel format http://www.vladd44.com/ubuntu-linux/gnumeric_save_excel.php Our usage scenarios are relatively simple. Gnumeric's accuracy advantages will likely never come into consideration. Thanks for the information though it might be useful for myself. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 4:18 AM, Andreas Säger ville...@t-online.de wrote: Install http://gnumeric.org and forget about all office software based on templates and styles. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/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: Cal default print settings (and general default settings)
Hi :) +1 Stick with LibreOffice, it's usually better. Gnumeric is excellent on very low-spec or old machines. Regards from Tom :) --- On Thu, 10/5/12, The Wolfkin wolf...@gmail.com wrote: From: The Wolfkin wolf...@gmail.com Subject: Re: [libreoffice-users] Re: Cal default print settings (and general default settings) To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 13:15 Sorry I can't possibly switch anyone to a program that requires this much work to save in an excel format http://www.vladd44.com/ubuntu-linux/gnumeric_save_excel.php Our usage scenarios are relatively simple. Gnumeric's accuracy advantages will likely never come into consideration. Thanks for the information though it might be useful for myself. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 4:18 AM, Andreas Säger ville...@t-online.de wrote: Install http://gnumeric.org and forget about all office software based on templates and styles. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/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] Re: Cal default print settings (and general default settings)
thanks. I did find the settings to print the grid. it's just a bit odd imo that it by default was off. I've never known anyone who was using a spreadsheet and DIDN'T want the grid printed out. That's pretty much WHY they use spreadsheets FOR the grid. and thanks for the userprofile information. that will be helpful once I experiment with it a bit. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 6:02 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) You can just copypaste the UserProfile to different machines to set things up the same without going through each individual setting. It's probably better to copy the UserProfile into the right place before install LibreOffice just in case there are new settings that need to over-write 'old' ones. http://wiki.documentfoundation.org/Documentation/UserProfile If you hunt around the print settings there is a tick-box to make row and column headings print. I think try Format - Page - Sheet - Print - Column and row headers I've never known anyone want that sort of thing except a few techie types working in finances on working papers but then they have to switch it off to make presentable documents for clients. Also people get used to red wriggles and bad spellings in MS Office because it randomly switches styles back to ones set to use American English. So people have learned they can't rely on spell-checkers. LibreOffice doesn't misbehave like that. LO usually stays in the language you tell it you want and defaults to whatever you set for the Operating System (eg WinXp, Ubuntu, whatever) Gnumeric is a very light-weight spreadsheet program which is difficult to set to default to using MS formats. I would stick with LibreOffice on machines that can handle it. Regards from Tom :) --- On Thu, 10/5/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Cal default print settings (and general default settings) To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 9:18 Am 10.05.2012 02:51, The Wolfkin wrote: another quick one. by default Calc doesn't print the grid or column/row headers. For everyone for whom I suggest LibreOffice this is a huge problem. Is there a way to change settings by default? Speaking of default settings.. on a slightly more off topic. Is there a way, for instance write a small script, to save a series of settings? When I install LibreOffice on someone's computer I got thru a the same series of steps to ensure the smoothest transition. This includes things like changing the default file saving format. Perhaps turning the autocorrect off (oddly most of the people I know would be grateful to remove the squiggle they've just never known it was an option before), and stuff like that. Install http://gnumeric.org and forget about all office software based on templates and styles. -- 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] Freezing a cell in Calc permanently
Thanks Tom I did actually figure that part out. It was just when i saved and closed the file. I tried to open it again and the row wasn't frozen. I assumed that was intentionally and didn't know how to change it. Now i see that it was a bug and i need to reassess my results. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 6:13 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) Move the cursor down to the 2nd row and then try Window - Freeze If it's not the right cell then you can undo it by selecting Window - Freeze again. I usually select cell B2 or thereabouts so that when i scroll horizontally i can still see the headings in Column A as well as Row 1. Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: IPad?
i think i wasn't quite clear on this.. but my annoyance wasn't with people using Word. I get that. Believe me I fully understand how complicated it is for people to change the file format. My annoyance was with MS for making .docx the default because it means anytime someone sends me something for help it's going to be .docx and that's frustrating for me to work with. Nothing to do about it. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 6:29 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi again :) You are a geek. A lot of people are a connoisseur of something. When it's to do with computers it's considered weird and geeky. Take pride in it and take pity on those less capable than you. If you were a wine connoisseur then you would probably hate cheap wines but in the computer world you just have to deal with it as it dominates. Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Hyperlink Toolbar
On Thu, 2012-05-10 at 14:11 +0200, gualter wrote: Hi all, This is the first post of a normal user of LO from the beginning and without specials skills. I know hyperlink toolbar was considered a bug, but it is useful. I'm working with LO 3.3.4, no upgrade, to no lost this tool. I don't find any extension making the same function. Usually I read documents in Writer with much references and I must search on internet. May be there is another easy way. There is some project to get back this useful tool, via core or extension? I don't found any Spanish list. Best regards This is a list of International Sites by language: http://www.libreoffice.org/international-sites/. Spanish is in this list. From there you should look for mailing lists in Spanish if that is what you want. Could you be more specific about what you want to do with hyperlinks in Writer. If I have a document containing hyperlinks open if Writer, I can open them. I hold the Control key (Ctrl) down while clicking the link. My browser opens the link's web page. Is this what you want to do? --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: IPad?
On Thu, May 10, 2012 at 8:33 AM, The Wolfkin wolf...@gmail.com wrote: i think i wasn't quite clear on this.. but my annoyance wasn't with people using Word. I get that. Believe me I fully understand how complicated it is for people to change the file format. My annoyance was with MS for making .docx the default because it means anytime someone sends me something for help it's going to be .docx and that's frustrating for me to work with. Nothing to do about it. I just open the .docx in LibO, manipulate it in LibO, save it as .odt and send it back to them as .doc. They never notice, and then it's a .doc forever. -- 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] Paragraph styles for list styles
On Wed, 2012-05-09 at 23:45 -0300, Carlos Pita wrote: Hi all, I find this description in the documentation very misleading: Each of the list styles predefined in Writer has four associated paragraph styles. For example, the Numbering 1 list style is associated with four paragraph styles: Numbering 1 Numbering 1 Cont. Numbering 1 End Numbering 1 Start In what sense list style Numbering 1 is related to paragraph styles Numbering 1 *? What one can see is that the N in paragraph styles Numbering N * is related to indentation level and not intended for working in tandem with the list style Numbering N. One can use paragraph style Numbering 1 with any of the list styles, because concerns seem to be completely orthogonal. Can you clarify the relationship between paragraph styles Numbering N * and list style Numbering N? What scenarios are paragraph styles Numbering N * and List N * intended for? Thank you a lot -- Carlos Was this documentation in a Styles chapter of the Writer Guide perhaps? If so, where in this guide was it located? If not, what documentation did you mean? I think the answer you are seeking is found in the Styles and Formating window. Use the F11 key to open it. There are several icons at the top; the one of the left (Paragraph styles) is the one you want. At the bottom of the window is a drop down list with Automatic selected by Default (unless you have changed it). Select All Styles. In that list you will find the Numbering N * paragraph styles. Right click anyone of them and select Modify from the context menu (it is a pop up window.) Click the Outline Numbering tab. When you want to add a numbering or bullet style to your paragraph style, you select it here. The paragraph style dictates the properties of the paragraph. The numbering (or list [bullet]) style dictates the numbering that appears at the beginning of each paragraph. --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] Re: Templates Disappeared
Am 10.05.2012 12:19, Keith Bates wrote: I deleted all the existing templates in .config/.libreoffice/3/user/template. Then I opened a template and tried to save as a template and got this error: Error writing document Untitled2 as template: templates already exists Click OK and it opens the box to enter a name and save the template.I enter a name and click save and it comes back with the same message. I click OK and then get this message: Error writing document Untitled2 as template: General error General input/output error Reset your entire user profile and try again. Close the office, delete the .config/libreoffice folder and let it build a new one. Do not copy any files into the profile. Templates need to be registered for whatever reason. There is also an import command in the templates organizer (FileTemplatesOrganize... button [Commands]) -- 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] Customize keyboard shortcut
I like openoffice very much! But can we set a shortcut to Customize keyboard shortcut? just like MS word's Alt+Ctrl+num+ can Customize keyboard shortcut.I thind it's coll thanks. -- 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] Anchoring the images to page inside section.
On 05/10/2012 01:18 AM, Vit wrote: I'm very sorry for the images. Here are the examples. 1. Fix position relative to the text, moving with the text. Text should be on the right or on the left of the picture. I can't achieve this using anchoring now. Example: http://dug.im/d7682 2. I want two different pictures positioned after the text in parallel at right and at left and moving with it. Example: http://dug.im/87bb8 3. I want the image on the separate page and moving with the text before it, which is before the image. Example: http://dug.im/6c379 I don't know an easy way to realise any of this situations. The most complicated and topmost wanted by me is positioning the image on the top-right (bottom-right, bottom-left) corner of the page and moving with the text it is anchored to (but no overlapping with other images positioned to that corner, which are anchored to another text and accidentally are located at the same page). This will look like 1, but the images should be always in the corner regadrless of exact position the text they are anchored to, and if there are images on the same position on the page they mustn't overlap. With best regards, Vit Anchor your images to paragraph. Your pictures will move along with your paragraph. -- 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: IPad?
Hi :) Smart move! :) I like it :) Regards from Tom :) --- On Thu, 10/5/12, jomali jomali3...@gmail.com wrote: From: jomali jomali3...@gmail.com Subject: Re: [libreoffice-users] Re: IPad? To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 13:50 On Thu, May 10, 2012 at 8:33 AM, The Wolfkin wolf...@gmail.com wrote: i think i wasn't quite clear on this.. but my annoyance wasn't with people using Word. I get that. Believe me I fully understand how complicated it is for people to change the file format. My annoyance was with MS for making .docx the default because it means anytime someone sends me something for help it's going to be .docx and that's frustrating for me to work with. Nothing to do about it. I just open the .docx in LibO, manipulate it in LibO, save it as .odt and send it back to them as .doc. They never notice, and then it's a .doc forever. -- 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] DocX
Hi :) +1 I find it a total pita too. Do you get blank looks from people when you ask them to send in a different format? Do you find people treat you with suspicion or treat you as being deliberately difficult? Do you get blamed when their formats turn out to appear broken when viewed on any machine other than their own? When i installed MSO 2010 on the machines here i deliberately set it to default to Doc instead of DocX but then felt guilty and worried i would get the blame if anything happened so i set it back :( Regards from Tom :) --- On Thu, 10/5/12, The Wolfkin wolf...@gmail.com wrote: From: The Wolfkin wolf...@gmail.com Subject: Re: [libreoffice-users] Re: IPad? To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 13:33 i think i wasn't quite clear on this.. but my annoyance wasn't with people using Word. I get that. Believe me I fully understand how complicated it is for people to change the file format. My annoyance was with MS for making .docx the default because it means anytime someone sends me something for help it's going to be .docx and that's frustrating for me to work with. Nothing to do about it. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 6:29 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi again :) You are a geek. A lot of people are a connoisseur of something. When it's to do with computers it's considered weird and geeky. Take pride in it and take pity on those less capable than you. If you were a wine connoisseur then you would probably hate cheap wines but in the computer world you just have to deal with it as it dominates. Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Cal default print settings (and general default settings)
Hi :) Here and in the accountancy practices i have worked in people definitely don't want the grid but then put some effort into getting different types of borders printed around specific cells or get rulers out to make sure they read the right figures. In one place my boss hated computer number-pad's because it's upside-down and proper calculators are the other way around (ie with 123 at the top not the bottom) so i bought a printing calculator that was the same way as the number-pad because that's what i trained on (thanks Meavis!). When he nicked it to do a quick sum he was furious at me. He was extremely fast on calculators that are the right way up but most of us could get the answer in a spreadsheet before he could find a decent calculator. Predictably i got fired for being obtuse. People are often adamant that their way is the only way and indeed often it's easy to see their point of view but the thing i most like about OpenSource is that we can each have it our way, the right way, however many different and completely opposite ways that includes, and still help each other get the right answers. Btw sorry about the other thread where i didn't realise that documents were losing their freeze points. I realised just after sending my answer but thought the best policy would be to let other people deal with it as i couldn't add anything useful. Regards from Tom :) --- On Thu, 10/5/12, The Wolfkin wolf...@gmail.com wrote: From: The Wolfkin wolf...@gmail.com Subject: Re: [libreoffice-users] Re: Cal default print settings (and general default settings) To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 13:19 thanks. I did find the settings to print the grid. it's just a bit odd imo that it by default was off. I've never known anyone who was using a spreadsheet and DIDN'T want the grid printed out. That's pretty much WHY they use spreadsheets FOR the grid. and thanks for the userprofile information. that will be helpful once I experiment with it a bit. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 6:02 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) You can just copypaste the UserProfile to different machines to set things up the same without going through each individual setting. It's probably better to copy the UserProfile into the right place before install LibreOffice just in case there are new settings that need to over-write 'old' ones. http://wiki.documentfoundation.org/Documentation/UserProfile If you hunt around the print settings there is a tick-box to make row and column headings print. I think try Format - Page - Sheet - Print - Column and row headers I've never known anyone want that sort of thing except a few techie types working in finances on working papers but then they have to switch it off to make presentable documents for clients. Also people get used to red wriggles and bad spellings in MS Office because it randomly switches styles back to ones set to use American English. So people have learned they can't rely on spell-checkers. LibreOffice doesn't misbehave like that. LO usually stays in the language you tell it you want and defaults to whatever you set for the Operating System (eg WinXp, Ubuntu, whatever) Gnumeric is a very light-weight spreadsheet program which is difficult to set to default to using MS formats. I would stick with LibreOffice on machines that can handle it. Regards from Tom :) --- On Thu, 10/5/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Cal default print settings (and general default settings) To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 9:18 Am 10.05.2012 02:51, The Wolfkin wrote: another quick one. by default Calc doesn't print the grid or column/row headers. For everyone for whom I suggest LibreOffice this is a huge problem. Is there a way to change settings by default? Speaking of default settings.. on a slightly more off topic. Is there a way, for instance write a small script, to save a series of settings? When I install LibreOffice on someone's computer I got thru a the same series of steps to ensure the smoothest transition. This includes things like changing the default file saving format. Perhaps turning the autocorrect off (oddly most of the people I know would be grateful to remove the squiggle they've just never known it was an option before), and stuff like that. Install http://gnumeric.org and forget about all office software based on templates and styles. -- 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
Re: [libreoffice-users] Bad printing quality if printer language ir PDF
Hi :) I was hoping that changing those settings might nudge something into behaving properly. If it's a Cups problem then the Cups forums might be more helpful http://www.cups.org/newsgroups.php but there are often a couple of people on this list that help people with this sort of problem too so hopefully better answer will appear later. Regards from Tom :) --- On Thu, 10/5/12, Hartmut Goebel h.goe...@goebel-consult.de wrote: From: Hartmut Goebel h.goe...@goebel-consult.de Subject: Re: [libreoffice-users] Bad printing quality if printer language ir PDF To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 11:42 Hi Have you tried exporting to Pdf first? There is a ton of settings in the dialogue-box so that you can set the compression type and amount, the dpi of images and soem tick-boxes that might be worth playing with. As I wrote: the exported PDF prints in good quality. My aim is *not* generate a PDF, but to use PDF as printer language, as this is the default for CUPS now. I do not see how the export-settings should interfere here- -- Schönen Gruß - Regards Hartmut Goebel Dipl.-Informatiker (univ.), CISSP, CSSLP Goebel Consult Spezialist für IT-Sicherheit in komplexen Umgebungen http://www.goebel-consult.de Monatliche Kolumne: http://www.cissp-gefluester.de/ Goebel Consult ist Mitglied bei http://www.7-it.de -- 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] Customize keyboard shortcut
On 10/05/2012 at 15:09, 李小生 jxlixiaosh...@163.com wrote: I like openoffice very much! Actually it's LibreOffice mailing list. LibreOffice is direct descendant of OpenOffice.org, as well as Apache OpenOffice is. From user perspective, they are very similar office suites, but in fact they are different programs. I don't want to go much into details right now. But can we set a shortcut to Customize keyboard shortcut? You are free to do it yourself: 1. Open Tools → Customize 2. Keyboard tab 3. Find keyboard shortcut you like (unfortunately, there is no Ctrl+Alt+(numeric +)) 4. In Functions select Category Options and in Functions - Customize 5. Click Modify button near top right corner I doubt there is need for default keyboard shortcut for opening keyboard shortcuts dialog window. -- Best regards Mirosław Zalewski -- 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] Customize keyboard shortcut
Hi :) Yes, they are separate programs but there is an overlap in the communities so it's almost 1 big community producing 2 products aimed at slightly different niches and co-operatively competing with each other. I think it's still true that most of the people that only work on LibreOffice (not OOo too) used to work on OpenOffice (or worked on Go-oo which used to call itself OpenOffice quite a lot of the time). OpenOffice.org is now often called Apache OpenOffice or AOO or AOOo for short. In a way LibreOffice is just an advanced version of OpenOffice So, when someone compliments OpenOffice you might as well just accept the compliment. :) Good work all :) Regards from Tom :) --- On Thu, 10/5/12, Mirosław Zalewski mini...@poczta.onet.pl wrote: From: Mirosław Zalewski mini...@poczta.onet.pl Subject: Re: [libreoffice-users] Customize keyboard shortcut To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 16:41 On 10/05/2012 at 15:09, 李小生 jxlixiaosh...@163.com wrote: I like openoffice very much! Actually it's LibreOffice mailing list. LibreOffice is direct descendant of OpenOffice.org, as well as Apache OpenOffice is. From user perspective, they are very similar office suites, but in fact they are different programs. I don't want to go much into details right now. But can we set a shortcut to Customize keyboard shortcut? You are free to do it yourself: 1. Open Tools → Customize 2. Keyboard tab 3. Find keyboard shortcut you like (unfortunately, there is no Ctrl+Alt+(numeric +)) 4. In Functions select Category Options and in Functions - Customize 5. Click Modify button near top right corner I doubt there is need for default keyboard shortcut for opening keyboard shortcuts dialog window. -- Best regards Mirosław Zalewski -- 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] Cal default print settings (and general default settings)
Le 10/05/2012 02:51, The Wolfkin a écrit : another quick one. by default Calc doesn't print the grid or column/row headers. For everyone for whom I suggest LibreOffice this is a huge problem. Is there a way to change settings by default? Speaking of default settings.. on a slightly more off topic. Is there a way, for instance write a small script, to save a series of settings? When I install LibreOffice on someone's computer I got thru a the same series of steps to ensure the smoothest transition. This includes things like changing the default file saving format. Perhaps turning the autocorrect off (oddly most of the people I know would be grateful to remove the squiggle they've just never known it was an option before), and stuff like that. The current user settings are stored in the /home/(username)/.libreoffice/3/user directory (under linux) /Document settings/(username)/libreoffice/3/user (under Windows XP). If you save the /user subdirectory then copy it over to any other users' account, you'll certainly achieve what you're looking for: a uniform setting for all users. I do this everyday and it has always been working ok for me. BTW, this answers both of your questions. HTH, -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Read error on .ods file
Just in case others might have the same problem: I used OO to save my file in .xls. LO would then open it successfully, and I could save it back to .ods [which both OO and LO could open]. HTH somebody. Paul From: Tom Davies tomdavie...@yahoo.co.uk To: users@global.libreoffice.org Sent: Tuesday, May 8, 2012 11:57 AM Subject: Re: [libreoffice-users] Read error on .ods file Hi :) That is where i get completely stuck, especially if i can see the xml. Luckily my text editor can be switched from reading Plain text to html/css which just about covers xml too so at least i can roughly work out which bits are the texts. With no xml at all or very little then i would be very stuck. Is everything in Csv format with commas between columns and a new-line for a new row? If so then copypaste sounds like one possible but messy route! Tbh if OpenOffice can deal with this file and LO can't then i would recommend either having both installed or just going back to OpenOffice for a while. They are so similar in code-base and ideals that it's not worth struggling. Of course LO is better but you can always try it again at some point in the future to see if it is better for you, your machine and your files Aaargh, i have just upgraded this machine and can't get back into Seamonkey and all my lovely links! I tried hunting for the page on installing multiple instances of LibreOffice but couldn't find it :( Regards from Tom :) --- On Tue, 8/5/12, Paul Schwartz pmjs1...@yahoo.com wrote: From: Paul Schwartz pmjs1...@yahoo.com Subject: Re: [libreoffice-users] Read error on .ods file To: users@global.libreoffice.org users@global.libreoffice.org Date: Tuesday, 8 May, 2012, 16:43 OK. The file is not compressed, but how do I find the xml stuff. There is a fair amount of plain text separated by many \00 and other things in red. Tutorial anyone? Paul From: Paul Schwartz pmjs1...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Tuesday, May 8, 2012 9:30 AM Subject: Re: [libreoffice-users] Read error on .ods file Thanks for the hints, but I have already done all those things. The default Archive Manager in Ubuntu 12.04 is fileroller, and from the error messages generated, it seems to use gzip for the compress/uncompress. I'm beginning to think that the file may not be compressed. Next is to try gedit directly. Thanks again, but if I don't make some progress LO will get replaced with OO. Paul From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Tuesday, May 8, 2012 5:01 AM Subject: Re: [libreoffice-users] Read error on .ods file On Mon, 2012-05-07 at 19:23 -0700, Paul Schwartz wrote: From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Monday, May 7, 2012 8:02 PM Subject: Re: [libreoffice-users] Read error on .ods file On Mon, 2012-05-07 at 21:20 -0400, Jay Lozier wrote: Paul, On 05/07/2012 07:11 PM, Paul Schwartz wrote: I recently installed Libre Office [default on a new Ubuntu 12.04 install]. I have a file that opens fine with Open Office but generates a Read error with Libre Office. Any clues on how to solve this problem? TIA Paul Schwartz What is the error message? Also, can you post the file on Nabble so someone can try to find the problem. A possible work around is to unzip the ods file to recover the xml data file and then open that in LO. I forget what the default Ubuntu archive utility is. Neither gunzip nor fileroller/Archive Manager work. gunzip says gunzip STOCKS.ods gzip: STOCKS.ods: unknown suffix -- ignored Archive Manger says Could not open STOCKS.ods Archive type not supported. I tried changing the name to temp.zip; same thing. Paul -- Jay Lozier jsloz...@gmail.com The name is Archive Manager, and the file name is fileroller. --Dan To change the name of the file, right click STOCKS.ods. Click Rename from the popup menu. Use the End key to move the cursor to the end of STOCKS.ods. Use the back arrow to remove ods. Enter zip in its place. You should not see STOCKS.zip. If you do, type Enter. Now apply gzip to it. --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 -- 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:
[libreoffice-users] Re: Cal default print settings (and general default settings)
Am 10.05.2012 14:15, The Wolfkin wrote: Sorry I can't possibly switch anyone to a program that requires this much work to save in an excel format http://www.vladd44.com/ubuntu-linux/gnumeric_save_excel.php Our usage scenarios are relatively simple. Gnumeric's accuracy advantages will likely never come into consideration. Thanks for the information though it might be useful for myself. You will be surprised that no software is able to work with xls properly other than Microsoft Excel. If you really need to work with xls files then you've got to install Excel and nothing else. If you can not edit and distribute a simple configuration file you are the born Excel user anyway. -- 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: Freezing a cell in Calc permanently
Am 10.05.2012 14:29, The Wolfkin wrote: Thanks Tom I did actually figure that part out. It was just when i saved and closed the file. I tried to open it again and the row wasn't frozen. I assumed that was intentionally and didn't know how to change it. Now i see that it was a bug and i need to reassess my results. You forgot to mention that you save in some foreign format. -- 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: Cal default print settings (and general default settings)
Hi :) Lol. Easy, tiger!! Regards from Tom :) --- On Thu, 10/5/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Cal default print settings (and general default settings) To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 20:30 Am 10.05.2012 14:15, The Wolfkin wrote: Sorry I can't possibly switch anyone to a program that requires this much work to save in an excel format http://www.vladd44.com/ubuntu-linux/gnumeric_save_excel.php Our usage scenarios are relatively simple. Gnumeric's accuracy advantages will likely never come into consideration. Thanks for the information though it might be useful for myself. You will be surprised that no software is able to work with xls properly other than Microsoft Excel. If you really need to work with xls files then you've got to install Excel and nothing else. If you can not edit and distribute a simple configuration file you are the born Excel user anyway. -- 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] Read error on .ods file
Hi :) Nicely done :) Regard from Tom :) --- On Thu, 10/5/12, Paul Schwartz pmjs1...@yahoo.com wrote: From: Paul Schwartz pmjs1...@yahoo.com Subject: Re: [libreoffice-users] Read error on .ods file To: users@global.libreoffice.org users@global.libreoffice.org Date: Thursday, 10 May, 2012, 20:24 Just in case others might have the same problem: I used OO to save my file in .xls. LO would then open it successfully, and I could save it back to .ods [which both OO and LO could open]. HTH somebody. Paul From: Tom Davies tomdavie...@yahoo.co.uk To: users@global.libreoffice.org Sent: Tuesday, May 8, 2012 11:57 AM Subject: Re: [libreoffice-users] Read error on .ods file Hi :) That is where i get completely stuck, especially if i can see the xml. Luckily my text editor can be switched from reading Plain text to html/css which just about covers xml too so at least i can roughly work out which bits are the texts. With no xml at all or very little then i would be very stuck. Is everything in Csv format with commas between columns and a new-line for a new row? If so then copypaste sounds like one possible but messy route! Tbh if OpenOffice can deal with this file and LO can't then i would recommend either having both installed or just going back to OpenOffice for a while. They are so similar in code-base and ideals that it's not worth struggling. Of course LO is better but you can always try it again at some point in the future to see if it is better for you, your machine and your files Aaargh, i have just upgraded this machine and can't get back into Seamonkey and all my lovely links! I tried hunting for the page on installing multiple instances of LibreOffice but couldn't find it :( Regards from Tom :) --- On Tue, 8/5/12, Paul Schwartz pmjs1...@yahoo.com wrote: From: Paul Schwartz pmjs1...@yahoo.com Subject: Re: [libreoffice-users] Read error on .ods file To: users@global.libreoffice.org users@global.libreoffice.org Date: Tuesday, 8 May, 2012, 16:43 OK. The file is not compressed, but how do I find the xml stuff. There is a fair amount of plain text separated by many \00 and other things in red. Tutorial anyone? Paul From: Paul Schwartz pmjs1...@yahoo.com To: users@global.libreoffice.org users@global.libreoffice.org Sent: Tuesday, May 8, 2012 9:30 AM Subject: Re: [libreoffice-users] Read error on .ods file Thanks for the hints, but I have already done all those things. The default Archive Manager in Ubuntu 12.04 is fileroller, and from the error messages generated, it seems to use gzip for the compress/uncompress. I'm beginning to think that the file may not be compressed. Next is to try gedit directly. Thanks again, but if I don't make some progress LO will get replaced with OO. Paul From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Tuesday, May 8, 2012 5:01 AM Subject: Re: [libreoffice-users] Read error on .ods file On Mon, 2012-05-07 at 19:23 -0700, Paul Schwartz wrote: From: Dan Lewis elderdanle...@gmail.com To: users@global.libreoffice.org Sent: Monday, May 7, 2012 8:02 PM Subject: Re: [libreoffice-users] Read error on .ods file On Mon, 2012-05-07 at 21:20 -0400, Jay Lozier wrote: Paul, On 05/07/2012 07:11 PM, Paul Schwartz wrote: I recently installed Libre Office [default on a new Ubuntu 12.04 install]. I have a file that opens fine with Open Office but generates a Read error with Libre Office. Any clues on how to solve this problem? TIA Paul Schwartz What is the error message? Also, can you post the file on Nabble so someone can try to find the problem. A possible work around is to unzip the ods file to recover the xml data file and then open that in LO. I forget what the default Ubuntu archive utility is. Neither gunzip nor fileroller/Archive Manager work. gunzip says gunzip STOCKS.ods gzip: STOCKS.ods: unknown suffix -- ignored Archive Manger says Could not open STOCKS.ods Archive type not supported. I tried changing the name to temp.zip; same thing. Paul -- Jay Lozier jsloz...@gmail.com The name is Archive Manager, and the file name is fileroller. --Dan To change the name of the file, right click STOCKS.ods. Click Rename from the popup menu. Use the End key to move the cursor to the end of STOCKS.ods. Use the back arrow to remove ods. Enter zip in its place. You should not see STOCKS.zip. If you do, type Enter. Now apply gzip to it. --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
[libreoffice-users] Re: Freezing a cell in Calc permanently
Am 10.05.2012 21:33, Andreas Säger wrote: You forgot to mention that you save in some foreign format. Obviously you do even save in xlsx which is the worst choice. -- 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] Paragraph styles for list styles
On Thu, 2012-05-10 at 15:34 -0300, Carlos Pita wrote: Hi all, Was this documentation in a Styles chapter of the Writer Guide perhaps? If so, where in this guide was it located? If not, what It's quoted verbatim from LibreOffice Writer Guide 3.4.x, chapter 6 or 7 (sorry, I'm not able to access the file just right now). Dan, I understand how styles work, my problem is more about how provided styles are intended to be used. What is confusing to me is that the Numbering N or List N paragraph styles come with increasing indentation levels, suggesting that they're intended to somehow nest lists up to the 5th level instead of being used in a close 1-1 relationship with corresponding list styles, as can be inferred from the guide. Gary has clarified the issue. Perhaps the styles should all be indented the same by default and just control the interline spacing and things like that. Another related issue is the purpose of the List N vs List N Cont paragraph styles. From the indentation in the styles one can infer what follows: | aditional space here First item --- Start style Internal item --- base style Continuation of internal item--- Cont style Last item--- End style | aditional space here That cont seems to be intended to follow the base style is suggested by the default indentation of the manually formatted lists. For example: 2. Iternal item More text Continuation of item 2 The indentation provided by the Cont style is exactly the indentation needed by Continuation of item 2 in a manually formatted list in order to be left aligned with the item text. But this seems misleading again, because the guide explains that Start will be usually linked to Cont which will be linked to End, for lists where a single style (the base style) isn't enough. Briefly, the alternative interpretations are: Start-base(-Cont)-End vs Start-Cont-End or base (for simple formatting requirements) I'll copy the relevant passages of the documentation for this last issue asap, but you can see that the problem is essentially the same: default style indentation that seems to be at odds with the usage described by the guide, maybe because of historical reasons. Thanks a lot -- Carlos Yes, I see what you mean. Personally, I think this is unnecessarily complex and difficult to understand. It is not the Writer Guide. It is these styles: Numbering 1, Numbering 1 Cont. Numbering 1 End, and Numbering 1 Start. What seems strange is that the Indent Spacing for Numbering 1 and Numbering 1 Cont. are identical. What was the reason for this? I also not that Numbering 1 Start has a 2 line spacing (0.42cm) above it, and Numbering 1 End has 2 line spacing (0.42) below it. That also seems to be more than needed. If your Writer Guide used ODT format instead of PDF, you would see that we use three styles instead of four: OOoNum 123 Cont., OOoNum 123 Start, and OOoNum 123 End. It has its strange point too: OOoNum 123 Start and OOoNum 123 Cont. have identical Indent Spacing entries. Perhaps I need to read what the Writer Guide mentions about this. Chapters 6 and 7 are the Style chapters of WG. --Dan On Thu, May 10, 2012 at 10:05 AM, Dan Lewis elderdanle...@gmail.com wrote: On Wed, 2012-05-09 at 23:45 -0300, Carlos Pita wrote: Hi all, I find this description in the documentation very misleading: Each of the list styles predefined in Writer has four associated paragraph styles. For example, the Numbering 1 list style is associated with four paragraph styles: Numbering 1 Numbering 1 Cont. Numbering 1 End Numbering 1 Start In what sense list style Numbering 1 is related to paragraph styles Numbering 1 *? What one can see is that the N in paragraph styles Numbering N * is related to indentation level and not intended for working in tandem with the list style Numbering N. One can use paragraph style Numbering 1 with any of the list styles, because concerns seem to be completely orthogonal. Can you clarify the relationship between paragraph styles Numbering N * and list style Numbering N? What scenarios are paragraph styles Numbering N * and List N * intended for? Thank you a lot -- Carlos documentation did you mean? I think the answer you are seeking is found in the Styles and Formating window. Use the F11 key to open it. There are several icons at the top; the one of the left (Paragraph styles) is the one you want. At the bottom of the window is a drop down list with Automatic selected by Default (unless you have changed it). Select All Styles. In that list you will find the Numbering N * paragraph styles. Right click anyone of them and select Modify from the context menu (it is a pop up window.) Click the Outline Numbering tab. When you want to add a numbering
Re: [libreoffice-users] Re: Freezing a cell in Calc permanently
normally I do .. but in this case it was in .ods format.. I'm positive I mentioned that earlier. I just checked. it was my second message. These were .ods files to repeat myself. In the other thread on defaults I did mention that I prefer to default to Office formats but that happened to not be the case here. I spend a lot of time dealing with people who are not .. quite adept with technology. I would never have left out such a major detail. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 3:33 PM, Andreas Säger ville...@t-online.de wrote: Am 10.05.2012 14:29, The Wolfkin wrote: Thanks Tom I did actually figure that part out. It was just when i saved and closed the file. I tried to open it again and the row wasn't frozen. I assumed that was intentionally and didn't know how to change it. Now i see that it was a bug and i need to reassess my results. You forgot to mention that you save in some foreign format. -- 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: Freezing a cell in Calc permanently
I'm confused because as far as I can tell in this thread you're the first person to even mention xlsx or xls. I don't think I mentioned that file format in the other thread. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 3:51 PM, Andreas Säger ville...@t-online.de wrote: Am 10.05.2012 21:33, Andreas Säger wrote: You forgot to mention that you save in some foreign format. Obviously you do even save in xlsx which is the worst choice. -- 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] Paragraph styles for list styles
Yes, I see what you mean. Personally, I think this is unnecessarily complex and difficult to understand. It is not the Writer Guide. It is these styles: That's my very impression too. The guide is clear in what it states, but the styles obfuscate the message. What seems strange is that the Indent Spacing for Numbering 1 and Numbering 1 Cont. are identical. What was the reason for this? I also Not exactly, they differ in the first line indent setting. Numbering 1 looks like (except for the numbering itself): 1. blah blah blah --- first line blah blah blah --- following lines Instead Numbering 1 Cont looks like: blah blah blah --- first line blah blah blah --- following lines So, regarding the indentation, the implication seems to be: Numbering 1 Start (Numbering 1 Numbering 1 Cont * ) * . . . Numbering 1 End Regards -- Carlos On Thu, May 10, 2012 at 10:05 AM, Dan Lewis elderdanle...@gmail.com wrote: On Wed, 2012-05-09 at 23:45 -0300, Carlos Pita wrote: Hi all, I find this description in the documentation very misleading: Each of the list styles predefined in Writer has four associated paragraph styles. For example, the Numbering 1 list style is associated with four paragraph styles: Numbering 1 Numbering 1 Cont. Numbering 1 End Numbering 1 Start In what sense list style Numbering 1 is related to paragraph styles Numbering 1 *? What one can see is that the N in paragraph styles Numbering N * is related to indentation level and not intended for working in tandem with the list style Numbering N. One can use paragraph style Numbering 1 with any of the list styles, because concerns seem to be completely orthogonal. Can you clarify the relationship between paragraph styles Numbering N * and list style Numbering N? What scenarios are paragraph styles Numbering N * and List N * intended for? Thank you a lot -- Carlos documentation did you mean? I think the answer you are seeking is found in the Styles and Formating window. Use the F11 key to open it. There are several icons at the top; the one of the left (Paragraph styles) is the one you want. At the bottom of the window is a drop down list with Automatic selected by Default (unless you have changed it). Select All Styles. In that list you will find the Numbering N * paragraph styles. Right click anyone of them and select Modify from the context menu (it is a pop up window.) Click the Outline Numbering tab. When you want to add a numbering or bullet style to your paragraph style, you select it here. The paragraph style dictates the properties of the paragraph. The numbering (or list [bullet]) style dictates the numbering that appears at the beginning of each paragraph. --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 -- 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] DocX
I'm pretty good at people and I know full and well that they don't have the skill to change it to .doc or the patience for me to explain why. I'm like an inverse human. Rather than adapting my environment to suit myself. I expend most of my energy to adapt my practices to suit my environment. If I get .docx files I generally either open it as it and roll the dice or find a computer with a version of Office compatible. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 10:15 AM, Tom Davies tomdavie...@yahoo.co.ukwrote: Hi :) +1 I find it a total pita too. Do you get blank looks from people when you ask them to send in a different format? Do you find people treat you with suspicion or treat you as being deliberately difficult? Do you get blamed when their formats turn out to appear broken when viewed on any machine other than their own? When i installed MSO 2010 on the machines here i deliberately set it to default to Doc instead of DocX but then felt guilty and worried i would get the blame if anything happened so i set it back :( Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Freezing a cell in Calc permanently
Hi :) Don't worry about Andreas' strangeness. There are a few people on this list that like to bully new people and create a bad atmosphere presumably to drive people away from LibreOffice. Regards from Tom :) --- On Thu, 10/5/12, The Wolfkin wolf...@gmail.com wrote: From: The Wolfkin wolf...@gmail.com Subject: Re: [libreoffice-users] Re: Freezing a cell in Calc permanently To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 22:36 normally I do .. but in this case it was in .ods format.. I'm positive I mentioned that earlier. I just checked. it was my second message. These were .ods files to repeat myself. In the other thread on defaults I did mention that I prefer to default to Office formats but that happened to not be the case here. I spend a lot of time dealing with people who are not .. quite adept with technology. I would never have left out such a major detail. -- Wolfkin http://about.me/wolfkin On Thu, May 10, 2012 at 3:33 PM, Andreas Säger ville...@t-online.de wrote: Am 10.05.2012 14:29, The Wolfkin wrote: Thanks Tom I did actually figure that part out. It was just when i saved and closed the file. I tried to open it again and the row wasn't frozen. I assumed that was intentionally and didn't know how to change it. Now i see that it was a bug and i need to reassess my results. You forgot to mention that you save in some foreign format. -- 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: Templates Disappeared
Thank you Andreas. That fixed the problem. Keith On 10/05/12 23:22, Andreas Säger wrote: Am 10.05.2012 12:19, Keith Bates wrote: I deleted all the existing templates in .config/.libreoffice/3/user/template. Then I opened a template and tried to save as a template and got this error: Error writing document Untitled2 as template: templates already exists Click OK and it opens the box to enter a name and save the template.I enter a name and click save and it comes back with the same message. I click OK and then get this message: Error writing document Untitled2 as template: General error General input/output error Reset your entire user profile and try again. Close the office, delete the .config/libreoffice folder and let it build a new one. Do not copy any files into the profile. Templates need to be registered for whatever reason. There is also an import command in the templates organizer (FileTemplatesOrganize... button [Commands]) -- God bless you Keith Bates Narrabri NSW Jesus is the Way the Truth and the Life -- 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] AutoText for a document
Hi all, is it possible to store an autotext entry within a document (as it is possible for a macro) instead of storing it in the local filesystem? Maybe by means of associating it to a macro? Seems like a useful feature for autotext snippets closely related to specific documents. Thanks a lot -- Carlos -- 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] DocX
The Wolfkin wrote: I'm pretty good at people and I know full and well that they don't have the skill to change it to .doc or the patience for me to explain why. I'm like an inverse human. Rather than adapting my environment to suit myself. I expend most of my energy to adapt my practices to suit my environment. If I get .docx files I generally either open it as it and roll the dice or find a computer with a version of Office compatible. Something that may come in handy are the free Word, Excel and PowerPoint viewers from Microsoft. These will allow you to view MS Office documents, though not edit them. -- 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] HOWTO change all-user default file formats (Windows), for LOo3.5?
Hi All, I've searched this topic and found [libreoffice-users] Re: Default file save format to MSOffice (doc, xls, ppt) etc.. http://listarchives.libreoffice.org/global/users/msg12888.html from last November, however in 3.5 the referenced .xcd files (writer.xcd, etc.,) have multiple strings that match the text to replace. I'd rather not find out the hard way that replacing them all breaks something, though if someone can tell me that replacing them all works properly (based on experience) that's altogether different. i.e. for the current LOo version, how does one change the default file save format for all users, e.g. during OS deployment. Is there any documentation (other than the source) on how these files/that xml works? TIA. ultra -- 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] Anchoring the images to page inside section.
I like openoffice very much! But can we set a shortcut to Customize keyboard shortcut? just like MS word's Alt+Ctrl+num+ can Customize keyboard shortcut.I thind it's coll thanks. At 2012-05-10 21:10:15,Calvin Kim rea...@calvinkim.org wrote: On 05/10/2012 01:18 AM, Vit wrote: I'm very sorry for the images. Here are the examples. 1. Fix position relative to the text, moving with the text. Text should be on the right or on the left of the picture. I can't achieve this using anchoring now. Example: http://dug.im/d7682 2. I want two different pictures positioned after the text in parallel at right and at left and moving with it. Example: http://dug.im/87bb8 3. I want the image on the separate page and moving with the text before it, which is before the image. Example: http://dug.im/6c379 I don't know an easy way to realise any of this situations. The most complicated and topmost wanted by me is positioning the image on the top-right (bottom-right, bottom-left) corner of the page and moving with the text it is anchored to (but no overlapping with other images positioned to that corner, which are anchored to another text and accidentally are located at the same page). This will look like 1, but the images should be always in the corner regadrless of exact position the text they are anchored to, and if there are images on the same position on the page they mustn't overlap. With best regards, Vit Anchor your images to paragraph. Your pictures will move along with your paragraph. -- 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