Re: [libreoffice-users] Label creation Q
At 11:35 17/12/2013 -0800, John R. Sowden wrote: With the recent messages re: the label function, I created a shipping label. Worked very nicely. Is there a feature to populate the rest of the labels on a sheet (on the screen), from the top left one, so they are all the same? That depends rather on how you have created your label - which you have kept a secret! Have you used a table? o Put the cursor in the cell containing the text. o Press Ctrl+A to select all the text in that cell. o Press Ctrl+C to copy that text. o Press Ctrl+A again to select the entire table. o Press Ctrl+V to paste copies of the text into all the cells at once. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Additions
2013/12/18 Richard Vickery richard.vicker...@gmail.com Dear Sirs/Madame: I wonder if I could make a suggestion for improvement to the program. Somehow, early on, Microsoft built into Word an ability of the program to suggest various ways to correct grammar. I wonder if the same could be done for Writer? I switched to Linux after getting frustrated with Microsoft's crashing in 1998 and have not gone back since, neither have I the energy to put up with their crap: do you think that you can help me out? It is possible to install an extension that work reasonnably well. It support a large range of languages, some better than other. http://www.languagetool.org/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Label creation Q
Yes, if you are using the table style templates. Don On 12/17/2013 08:33 PM, Tom Davies wrote: Hi :) Errr, Copypaste? Regards from Tom :) On 17 December 2013 19:35, John R. Sowden jsow...@americansentry.net wrote: With the recent messages re: the label function, I created a shipping label. Worked very nicely. Is there a feature to populate the rest of the labels on a sheet (on the screen), from the top left one, so they are all the same? John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- ** -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail Merge and Labels
** Reply to message from Don C. Myers donmy...@myersfarm.com on Tue, 17 Dec 2013 10:53:17 -0500 Don, Initially I just want a sheet with all the labels the same. Being able to fill a sheet with addresses from a database or even directly print envelopes may be in the future. For now I can obviously copy/paste to each label, but the wizard's way of entering data for one then propagating it to all is handy for like a set of return address labels. Cliff Hi Cliff, Are you using fields from a data base, or do you simply want something like return labels where every label is the same? Don On 12/17/2013 10:06 AM, Cliff Scott wrote: ** Reply to message from Don C. Myers donmy...@myersfarm.com on Mon, 16 Dec 2013 20:48:12 -0500 Don, Thanks for the link to the templates, but, pardon my ignorance, what is the proper way to setup a table based template? The wizard is useful, but, as already discussed, the built-in templates often don't work well. If the built in ones could be replaced with these table based ones and still have the wizard work it would be the best of both worlds. Cliff Hi Virgil, They have really worked well for me. With the frame based templates, I always had trouble with the spacing on the labels changing as you would get into the bottom third of the label sheet. The frame based templates print out perfectly from top to bottom, and they are so easy to adjust. I've left similar posts when people have had issues before, but it seems very few are willing to try the table based formats. Maybe they try to use the wizard, which is not the way to set up a table based template. Don On 12/16/2013 08:11 PM, Virgil Arrington wrote: Don, Thank you for this. I knew I had seen something like that before. LO uses a frame based label template. I agree that a table based template makes far more sense. Virgil -Original Message- From: Don C. Myers Sent: Monday, December 16, 2013 7:34 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels About 5 or 6 years ago when using OpenOffice to print Christmas labels, I ran across an article about using table style labels in OpenOffice instead of the type which come with Word, OpenOffice, and LibreOffice. It is far easier to adjust the table style labels. To adjust the top spacing, simply adjust the top margin for the page. To adjust the column width, simply drag the column borders and the entire column is adjusted. At one time OpenOffice had these label templates available as an extension. I don't know if they still do or not. But they are available from World Label here: http://www.worldlabel.com/Pages/openoffice-template.htm They can be downloaded individually, or all together as a pdf. I've found them much easier to use and adjust, and have never used any other label templates since then. Also, when you enter the text or fields in them, the text is starts with being paced in the center of the label between the top and the bottom, and then as additional lines are added, the text of fields are automatically centered within the label itself, top to bottom. I've never used the standard templates with OpenOffice or LibreOffice since finding these. Nor have I wasted any sheets of labels because they didn't print properly. Don ---Extra trimmed--- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] State of password support.
On 12/17/2013 10:12 AM, Massimo Del Zotto wrote: However, I recently had a problem with OOo password protection. Somehow it disabled password protection for a file I was working on and it took me a while to restore it. Asking for help on OOo forum, I have been informed password protection is somehow considered unnecessary by... I don't know who to be honest. You mean recently?As in the latest version of LO has a problem with passwords? The forum administrator strongly suggested me to not use it, and even pointed out a few previous cases in which password protection caused data loss (!!!). Which forum, do you have a link to the post? I think *this is unacceptable *so I started looking more seriously at LO. Digging the mailing list archives, I noticed there are quite a few messages regarding password protection. It seems most problem were between keyboard and chair, the only exception being perhaps an inter-operability problem after switching to AES-256. In your experience, how is LO with password protection? Massimo, you seem to be more informed of this than I, but, I am only aware of one (what I consider) real bug that existed with LO and passwords. At one point, I was no longer able to open a password protected file. Specifically, one version of LO was not able to open a password protected file. I am pretty sure it was LO and not AOO anyway. I believe that I have seen things such as: 1. I forgot my password, how I open my document 2. I am not able to open a password protected document created by MS Office 3. Problems signing a document I don't ever remember anyone saying that password protection should be dropped. Does not mean that it has not been said. I have seen people pushing to drop the ability to write non-ODF format, but I don't remember anyone advocating no support for passwords. I have also seen reports of another bug that sometimes causes total data loss of a file, but, since it is not reproducible in any sort of meaningful way, the bug has not been researched. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] State of password support.
I don't know if this is relevant to Massimo's case but it might be: I had a problem a while back with Fedora 15 (and I don't remember which version of OO or LO): I would discover that I could open a password-protected spreadsheet without being prompted for the password. It turned out that it had something to do with Fed 15 shutting down w/o prompting to save an open and changed spreadsheet. When restarted, the spreadsheet would open without password protection. The workaround seemed to be to do a 'save as' at that point and check 'save with password'. More recently this hasn't seemed to be a problem, but I think it has happened once or twice, though I didn't bother to try to figure out why. On Wed, 2013-12-18 at 09:24 -0500, Andrew Douglas Pitonyak wrote: On 12/17/2013 10:12 AM, Massimo Del Zotto wrote: However, I recently had a problem with OOo password protection. Somehow it disabled password protection for a file I was working on and it took me a while to restore it. Asking for help on OOo forum, I have been informed password protection is somehow considered unnecessary by... I don't know who to be honest. You mean recently?As in the latest version of LO has a problem with passwords? The forum administrator strongly suggested me to not use it, and even pointed out a few previous cases in which password protection caused data loss (!!!). Which forum, do you have a link to the post? I think *this is unacceptable *so I started looking more seriously at LO. Digging the mailing list archives, I noticed there are quite a few messages regarding password protection. It seems most problem were between keyboard and chair, the only exception being perhaps an inter-operability problem after switching to AES-256. In your experience, how is LO with password protection? Massimo, you seem to be more informed of this than I, but, I am only aware of one (what I consider) real bug that existed with LO and passwords. At one point, I was no longer able to open a password protected file. Specifically, one version of LO was not able to open a password protected file. I am pretty sure it was LO and not AOO anyway. I believe that I have seen things such as: 1. I forgot my password, how I open my document 2. I am not able to open a password protected document created by MS Office 3. Problems signing a document I don't ever remember anyone saying that password protection should be dropped. Does not mean that it has not been said. I have seen people pushing to drop the ability to write non-ODF format, but I don't remember anyone advocating no support for passwords. I have also seen reports of another bug that sometimes causes total data loss of a file, but, since it is not reproducible in any sort of meaningful way, the bug has not been researched. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Issues downloading LibreOffice Portable
Hi :) This link might help https://www.libreoffice.org/download/portable/ There is another portable apps type of place that has every version of LibreOffice but i'm not sure of the address. The marketing team were going to put their link on the same page as the link i just gave but i didn't read the page to see if it's there. Regards from Tom :) On 18 December 2013 01:40, Name Hidden for Security Reasons xmlhttprequest.o...@gmail.com wrote: Hello, Sorry for replying so late. I was just searching my disposable inbox for portable, not expecting to find anything, and found your e-mail. I found that LibreOffice Portable is available on CNet's Download.com service (http://download.cnet.com/LibreOffice-Portable/3000-18483_4-75449672.html?tag=mncol;1). However, the version is shown as 4.1, and last updated July 29, 2013. The LibreOffice Portable site on PortableApps.com lets me download version 4.1.3, but the same problems persist. I've cleared the browser cache, tried different browsers (IE, Firefox, and Chrome), and even tried different computers and wireless networks. I get the same result, in which the browser gets the impression that the download is complete, and upon opening the .paf.exe file, I get Installer integrity check failed. error. I'm using Windows Vista 64-bit. Version 4.1 (downloadable from Download.com) downloaded successfully, and I installed it on my flash drive successfully. Did The Document Foundation quit mirroring their downloads off of Download.com? Thank you. On 12/3/2013 7:55 AM, Tom Davies wrote: Hi :) Did you manage to solve this in the end? I think the Portable Aps version is only for Windows. On Linux it's much easier to install LibreOffice through any of your package managers although you might not get the most up-to-date one. However it is odd that you were having trouble downloading with Firefox. Any nonIE web-browser tend to be able to cope better with intermittent connections. The only way you could usually improve on that is by using the torrent. You probably have a reasonably good torrenting client built-in to your system so just download the tiny torrent and then allow your client to use it or else double-click on it when it's downloaded. Either way the full download should start shortly after. It might be even better to try a different mirror but i've not figured out how to do anything like that. Most people know but it eludes me Regards from Tom :) On 28 November 2013 18:53, Name Hidden for Security Reasons xmlhttprequest.o...@gmail.com wrote: Hello, I was trying to download the LibreOffice 4.1.3 Portable edition from LibreOffice.org, and then tried the download from PortableApps.com. I've tried to download the package using different methods and browsers, and the download (which is supposed to be around 113 MB, according to HTTP headers) stops (at anywhere from 7.9 MB downloaded to 40.2 MB downloaded, in the multiple attempts to download LibreOffice Portable). The browser gets the impression that the download is completed. However, I get an error message when opening the LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe file, saying that the installer integrity check failed. I know that: * I am using a direct connection to the internet router. * I got the same, repeating issue every time I tried to re-download the file. * It appeared as if I were being redirected to a mirror. * Nothing is wrong with my hosts file (%systemroot%\system32\drivers\etc\hosts). * I didn't lose my internet connection. I've come to the conclusion that something might be wrong with the servers of The Document Foundation, LibreOffice, or the mirror mirror.nexcess.net. Is there anything I can do to download LibreOffice Portable without these issues, or is something going on on your servers or the mirror? I also noticed unusual behavior of the LibreOffice website when attempting to download LibreOffice Portable, as described below in the HTTP headers: Data I found questionable is marked red, while data that is unusual is marked yellow, followed by a note. When I clicked the download button for LibreOffice, I noticed that it goes to the url http://download.documentfoundation.org/libreoffice/portable/4.1.3/LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe. However, I get redirected to a mirror url (http://mirror.nexcess.net/tdf/libreoffice/portable/4.1.3/LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe). When reviewing the headers of the requests, I found some information in the headers that is questionable, as seen below. Request URL: http://download.documentfoundation.org/libreoffice/portable/4.1.3/LibreOfficePortable_4.1.3_MultilingualNormal.paf.exe Request Method: GET Status Code: HTTP/1.1 302 Found - For some reason, I get redirected. Request Headers18:57:51.000 User-Agent: Mozilla/5.0 (Windows NT 6.0; WOW64; rv:25.0) Gecko/20100101
[libreoffice-users] using database
Is there any written document that I could get for creating/using the database feature? Or...a phone number I could use to BRIEFLY contact and speak to someone there about the same issue? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] video in impress presentation mode
Hi Tom, Thanks for your reply. I tried memory. It's set to several times the size of the video and matches the desktop settings. I tried changing it with no improvement in the result. I'd love to hear any other ideas you or others might have. I will also try the whole user profile later. Jay On 12/18/2013 05:56 AM, Tom Davies wrote: Hi :) Perhaps copy your old User Profile from your old machine to your new one? I'm specifically think about the memory settings Tools - Options - Memory and just bump them right up, not by a small fraction but by setting things to 100MB or however large the video-file is (well a little bit more than however large it is). Copying the entire User Profile will bring in more of your old settings too and galleries, templates, blah, blah. Regards from Tom :) On 18 December 2013 04:53, Jay Tasson jtas...@carleton.edu wrote: I have been running libreoffice impress 3.7.2 on my desktop computer in Ubuntu 12.04 for some time without difficulty. I recently purchased a laptop with Ubuntu 13.10. Everything about libreoffice impress works well on the laptop also except that inserted movies cause problems in the default presentation mode. The movies play in a slow, jerky way, or crash impress. It seems that it is not a hardware issue as the specs on the laptop are much better than my rather old desktop where things work fine. The problem occurs in impress 4.1 as well as 3.7.2 on the laptop, but the same impress files work fine on my desktop. The relevant video files (avi) also play fine on the laptop in any other mode: in video player, outside of presentation mode in impress, and when window is selected as the presentation mode. This is a fairly serious problem for me as this was my primary intended use for the laptop. Help would be greatly appreciated. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] video in impress presentation mode
Hi :) Perhaps copy your old User Profile from your old machine to your new one? I'm specifically think about the memory settings Tools - Options - Memory and just bump them right up, not by a small fraction but by setting things to 100MB or however large the video-file is (well a little bit more than however large it is). Copying the entire User Profile will bring in more of your old settings too and galleries, templates, blah, blah. Regards from Tom :) On 18 December 2013 04:53, Jay Tasson jtas...@carleton.edu wrote: I have been running libreoffice impress 3.7.2 on my desktop computer in Ubuntu 12.04 for some time without difficulty. I recently purchased a laptop with Ubuntu 13.10. Everything about libreoffice impress works well on the laptop also except that inserted movies cause problems in the default presentation mode. The movies play in a slow, jerky way, or crash impress. It seems that it is not a hardware issue as the specs on the laptop are much better than my rather old desktop where things work fine. The problem occurs in impress 4.1 as well as 3.7.2 on the laptop, but the same impress files work fine on my desktop. The relevant video files (avi) also play fine on the laptop in any other mode: in video player, outside of presentation mode in impress, and when window is selected as the presentation mode. This is a fairly serious problem for me as this was my primary intended use for the laptop. Help would be greatly appreciated. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail Merge and Labels
At 07:46 18/12/2013 -0600, Cliff Scott wrote: Initially I just want a sheet with all the labels the same. [...] For now I can obviously copy/paste to each label, but the wizard's way of entering data for one then propagating it to all is handy for like a set of return address labels. If you are using a table, have you tried my suggestion in a related thread? o Put the cursor in the cell containing the text. o Press Ctrl+A to select all the text in that cell. o Press Ctrl+C to copy that text. o Press Ctrl+A again to select the entire table. o Press Ctrl+V to paste copies of the text into all the cells at once. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: Formats failed marketing, was: Fwd: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office
James E Lang wrote: I really wish there were a LO Calc implementation for Android to use in place of Kingsoft Office. I don't feel secure using a proprietary office product; especially one from China. There is AndroidOpenOffice. Whilst closed source, it is based upon Apache Open Office, to the point of including most of the obvious, and all of the non-obvious AOo tells. (I'm not sure, but I think it is simply a recompiled version of AOO, with things that throw errors simpoly commented out. Then latter rewritten to comppile correctly.) jonathon -- Sent from the eating establishment at the Far side of the Universe, at the begining of Time, and at the end of Space. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: Formats failed marketing, was: Fwd: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office
tk wrote: There is AndroidOpenOffice. I tried that a while ago, on my Nexus 7, and it didn't work very well. I uninstalled it. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] with styles, is not master document functionality unnecessary+
Readers, Suppose a collection of documents each about 100kb size. What is the benefit of using master document function (presumably a gratuitous copy of m$), when styles function is available in LO? Surely it would be more stable and easier to manage if these files were imported into one new document? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] multiple file import
Readers, Is there a way to import multiple files into a new document? The existing function only allows multiples files to be imported successively, which is inefficient. If a directory contains file1 file2 file3 it would be beneficial to be able to select all files in the import dialogue window for automatic successive import into the new document. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] with styles, is not master document functionality unnecessary+
2013/12/18 e-letter inp...@gmail.com Readers, Suppose a collection of documents each about 100kb size. What is the benefit of using master document function (presumably a gratuitous copy of m$), when styles function is available in LO? Surely it would be more stable and easier to manage if these files were imported into one new document? Master document are not only about sharing styles (in fact, I never saw them in this light), it's about splitting your work in easily manageable smaller files. I don't even know why having styles would concern having the possibility to create a master document. When you're working on a reasonnably large project, it's simply easier to split it. For example, having each chapter in it's own file, instead of loading one huge file. It's more stable and easier to navigate. Ahem, still don't get why you're mixing the presence of styles and master document. The only link I can think of is that a master document's style override the sub-documents, but even then... maybe you can clarify what you meant? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] with styles, is not master document functionality unnecessary+
Another benefit of master documents is that it forces all styles of the same name to appear the same. For example, suppose I have written five documents, all having a style called BodySingle. But, in one document, my BodySingle style uses a Consolas font (good for on screen editing). In another, I have set the BodySingle font to Iowan Old Style, a personal favorite of mine. Now, let's say I combine these documents into a master document for final output. The styles of the master document will control over the styles of the individual files. So, in my master document, I set my BodySingle font to Linux Libertine G with a host of expert effects (old style numbers, historic or discretionary ligatures, etc.) This is great for printing a final document (to either a printer or PDF file), but not so effective for onscreen editing. So, I can change the final output by editing only the styles of the master document without having to edit the styles in each individual document. Virgil -Original Message- From: Gabriel Risterucci Sent: Wednesday, December 18, 2013 2:19 PM Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] with styles, is not master document functionality unnecessary+ 2013/12/18 e-letter inp...@gmail.com Readers, Suppose a collection of documents each about 100kb size. What is the benefit of using master document function (presumably a gratuitous copy of m$), when styles function is available in LO? Surely it would be more stable and easier to manage if these files were imported into one new document? Master document are not only about sharing styles (in fact, I never saw them in this light), it's about splitting your work in easily manageable smaller files. I don't even know why having styles would concern having the possibility to create a master document. When you're working on a reasonnably large project, it's simply easier to split it. For example, having each chapter in it's own file, instead of loading one huge file. It's more stable and easier to navigate. Ahem, still don't get why you're mixing the presence of styles and master document. The only link I can think of is that a master document's style override the sub-documents, but even then... maybe you can clarify what you meant? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Bonus calculator in Calc
A while back I posted up about calculating bonuses based upon a lookup. now, I need to add an additional step. Every once in a while, agents get additional bonuses for sales outside of the normal commission ladder. Here's the layout of the main sheet A B CD E Date1 Date2 Date3 . agent ID Agent Name$### $### $### What I wanted to do was add an Additional Bonus sheet With a layout like this A B C agentID DateBonus Then have a final bonus screen with this layout and formula similar to the main sheet A B CDE Date1 Date2 Date3 agentIDAgent Name$(sales + add bonus total) ... Note: the agent can have multiple bonuses for the same date on the additional bonus sheet. Where would i start doing something like that? I might figure that out while I'm typing that out (which is probably one of the most useful functions of this list), but right now I'm spinning. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] multiple file import
At 19:13 18/12/2013 +, Nobody Noname wrote: Is there a way to import multiple files into a new document? The existing function only allows multiples files to be imported successively, which is inefficient. If a directory contains file1 file2 file3 it would be beneficial to be able to select all files in the import dialogue window for automatic successive import into the new document. One obvious problem would be the necessity to indicate the order in which multiple files should be incorporated. It would be easy if you had files with carefully organised names, but in general you wouldn't have that. In any case, would file10 become positioned after file9 or between file1 and file2? Would that apply in all operating systems? If you needed either to list the files in the order in which you wanted them incorporated, or else to readjust everything after assembly, you would be better off (and achieve a more reliable result) by simply importing one at a time. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: Formats failed marketing, was: Fwd: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office
James Knott wrote: There is AndroidOpenOffice. I tried that a while ago, on my Nexus 7, and it didn't work very well. It is very inconsistent in how well it works. The updates, bug-fixes, etc. can either be much better, or much worse than the previous version. For the most part, releases within the last month are much more stable, and offer more features that work as expected, than releases from even four months ago. All that said, I don't think it quite yet suitable for mission critical work. jonathon -- Sent from the eating establishment at the Far side of the Universe, at the begining of Time, and at the end of Space. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] using database
Hi :) There is a handbook https://wiki.documentfoundation.org/Documentation/Publications and the 1st 3 chapters of the full guide. Also the Faq wiki has a section about Base https://wiki.documentfoundation.org/Faq Regards from Tom :) On 18 December 2013 12:42, Keith Armbruster keith...@bex.net wrote: Is there any written document that I could get for creating/using the database feature? Or...a phone number I could use to BRIEFLY contact and speak to someone there about the same issue? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail Merge and Labels
Hi Cliff, When you use the table style templates, the wizard does not work. It is designed for the frame style. What I do is fill in one label. Then if you have a 30 label sheet with 3 columns and 10 rows, I copy and paste it to the nest two labels to the right. Then I copy all three of those labels on row 1, and paste into the complete second row. Then I copy rows 1 and two and paste into rows 3 4, 5 6, 7 8, and 9 10. It really goes pretty fast that way. Don On 12/18/2013 08:46 AM, Cliff Scott wrote: ** Reply to message from Don C. Myers donmy...@myersfarm.com on Tue, 17 Dec 2013 10:53:17 -0500 Don, Initially I just want a sheet with all the labels the same. Being able to fill a sheet with addresses from a database or even directly print envelopes may be in the future. For now I can obviously copy/paste to each label, but the wizard's way of entering data for one then propagating it to all is handy for like a set of return address labels. Cliff Hi Cliff, Are you using fields from a data base, or do you simply want something like return labels where every label is the same? Don On 12/17/2013 10:06 AM, Cliff Scott wrote: ** Reply to message from Don C. Myers donmy...@myersfarm.com on Mon, 16 Dec 2013 20:48:12 -0500 Don, Thanks for the link to the templates, but, pardon my ignorance, what is the proper way to setup a table based template? The wizard is useful, but, as already discussed, the built-in templates often don't work well. If the built in ones could be replaced with these table based ones and still have the wizard work it would be the best of both worlds. Cliff Hi Virgil, They have really worked well for me. With the frame based templates, I always had trouble with the spacing on the labels changing as you would get into the bottom third of the label sheet. The frame based templates print out perfectly from top to bottom, and they are so easy to adjust. I've left similar posts when people have had issues before, but it seems very few are willing to try the table based formats. Maybe they try to use the wizard, which is not the way to set up a table based template. Don On 12/16/2013 08:11 PM, Virgil Arrington wrote: Don, Thank you for this. I knew I had seen something like that before. LO uses a frame based label template. I agree that a table based template makes far more sense. Virgil -Original Message- From: Don C. Myers Sent: Monday, December 16, 2013 7:34 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Mail Merge and Labels About 5 or 6 years ago when using OpenOffice to print Christmas labels, I ran across an article about using table style labels in OpenOffice instead of the type which come with Word, OpenOffice, and LibreOffice. It is far easier to adjust the table style labels. To adjust the top spacing, simply adjust the top margin for the page. To adjust the column width, simply drag the column borders and the entire column is adjusted. At one time OpenOffice had these label templates available as an extension. I don't know if they still do or not. But they are available from World Label here: http://www.worldlabel.com/Pages/openoffice-template.htm They can be downloaded individually, or all together as a pdf. I've found them much easier to use and adjust, and have never used any other label templates since then. Also, when you enter the text or fields in them, the text is starts with being paced in the center of the label between the top and the bottom, and then as additional lines are added, the text of fields are automatically centered within the label itself, top to bottom. I've never used the standard templates with OpenOffice or LibreOffice since finding these. Nor have I wasted any sheets of labels because they didn't print properly. Don ---Extra trimmed--- -- ** -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Label creation Q
Good morning: (Nice Farm Site Don) I do not know what ya'all mean by 'table' unless you are saying that I might get the name address data from a database. I am not. I am creating a shipping label to put on large (9 x 12) envelopes for my security system proposals. I am using equivalent to Avery 5164 labels (6 on a page). I fill them out manually on a typewriter. My question related to the concept of obvious and efficiency, meaning most label creation would be: 1. Design label (lines, test colors, etc.) 2. Copy to other label locations on the sheet 3. Print Labels So having a command that would take the label that you just created and populate the other label locations on the sheet seemed to be the next step, and I could not find the option. Problem: In label design, the text and the drawing are separate objects, so selecting the top left label buy highlighting the upper left to lower right the, rt cl copy, put cursor in upper right box, upper right corner, put the lower half of my original label (drawing only, no text) below the original and nothing in the upper right box. It just seems that a populate other empty labels on this sheet with original would make sense. John On 12/17/2013 02:32 PM, Don C. Myers wrote: Hi John, If you are using the table based templates, simply copy and paste. Don On 12/17/2013 02:35 PM, John R. Sowden wrote: With the recent messages re: the label function, I created a shipping label. Worked very nicely. Is there a feature to populate the rest of the labels on a sheet (on the screen), from the top left one, so they are all the same? John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] with styles, is not master document functionality unnecessary+
e-letter wrote: What is the benefit of using master document function (presumably a gratuitous copy of m$), when styles function is available in LO? For all practical purposes, the advantages and virtues of using Master Document functionality is completely irrelevant to the advantages and virtues of using Styles. be more stable and easier to manage if these files were imported into one new document? Whether it is more appropriate for the content to maintained as One Single File, One Master Document file, or 100 individual files, depends upon a dozen different factors, starting with the type of content, and ending up with the size of the components of that content. Regardless of which approach is used (single document, master document, individual files), what is crucial, is that a named template be used, which is where all style changes are made. jonathon -- Sent from the eating establishment at the Far side of the Universe, at the begining of Time, and at the end of Space. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Bonus calculator in Calc
I know it's a relational database. ;-) Is there any way to design this to work on a spreadsheet? On 12/18/2013 4:40 PM, Tom Davies wrote: Hi :) That is very much like a relational database. The 1st sheet is the main table. The 2nd sheet would be a separate table but would be linked by a relationship between both column As. The 3rd sheet would actually not be a table as such, it would be a Query that takes data from the 2 tables and performs calculations on them. Hmm, it could be a Form or Report but if i was doing it (and note that i'm not) then i tend to prefer using a Query for as much of this sort of thing as possible because it makes it easier to adjust the formulae in the future Regards from Tom :) On 18 December 2013 20:22, John Meyer johnme...@pueblocomputing.com wrote: A while back I posted up about calculating bonuses based upon a lookup. now, I need to add an additional step. Every once in a while, agents get additional bonuses for sales outside of the normal commission ladder. Here's the layout of the main sheet A B CD E Date1 Date2 Date3 . agent ID Agent Name$### $### $### What I wanted to do was add an Additional Bonus sheet With a layout like this A B C agentID DateBonus Then have a final bonus screen with this layout and formula similar to the main sheet A B CDE Date1 Date2 Date3 agentIDAgent Name$(sales + add bonus total) ... Note: the agent can have multiple bonuses for the same date on the additional bonus sheet. Where would i start doing something like that? I might figure that out while I'm typing that out (which is probably one of the most useful functions of this list), but right now I'm spinning. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Bonus calculator in Calc
Let's assume I can't get IT to install the JRE for database access. On 12/18/2013 4:48 PM, Tom Davies wrote: Hi :) Why not use Base to read the 2 existing sheets? Then let it do the bit it does best? Regards from Tom :) On 18 December 2013 23:46, John Meyer johnme...@pueblocomputing.com wrote: I know it's a relational database. ;-) Is there any way to design this to work on a spreadsheet? On 12/18/2013 4:40 PM, Tom Davies wrote: Hi :) That is very much like a relational database. The 1st sheet is the main table. The 2nd sheet would be a separate table but would be linked by a relationship between both column As. The 3rd sheet would actually not be a table as such, it would be a Query that takes data from the 2 tables and performs calculations on them. Hmm, it could be a Form or Report but if i was doing it (and note that i'm not) then i tend to prefer using a Query for as much of this sort of thing as possible because it makes it easier to adjust the formulae in the future Regards from Tom :) On 18 December 2013 20:22, John Meyer johnme...@pueblocomputing.com wrote: A while back I posted up about calculating bonuses based upon a lookup. now, I need to add an additional step. Every once in a while, agents get additional bonuses for sales outside of the normal commission ladder. Here's the layout of the main sheet A B CD E Date1 Date2 Date3 . agent ID Agent Name$### $### $### What I wanted to do was add an Additional Bonus sheet With a layout like this A B C agentID DateBonus Then have a final bonus screen with this layout and formula similar to the main sheet A B CDE Date1 Date2 Date3 agentIDAgent Name$(sales + add bonus total) ... Note: the agent can have multiple bonuses for the same date on the additional bonus sheet. Where would i start doing something like that? I might figure that out while I'm typing that out (which is probably one of the most useful functions of this list), but right now I'm spinning. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail Merge and Labels
At 18:09 18/12/2013 -0500, Don C. Myers wrote: When you use the table style templates, the wizard does not work. It is designed for the frame style. What I do is fill in one label. Then if you have a 30 label sheet with 3 columns and 10 rows, I copy and paste it to the nest two labels to the right. Then I copy all three of those labels on row 1, and paste into the complete second row. Then I copy rows 1 and two and paste into rows 3 4, 5 6, 7 8, and 9 10. It really goes pretty fast that way. Copy one cell. Select all cells. Paste once into all. (That's Ctrl+A, Ctrl+C, Ctrl+A, Ctrl+V.) Isn't that even faster than pretty fast - and equally fast no matter how many labels you have? Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail Merge and Labels
Hi Brian, That is a much better solution. Thanks for suggesting it. Don On 12/18/2013 10:00 PM, Brian Barker wrote: At 18:09 18/12/2013 -0500, Don C. Myers wrote: When you use the table style templates, the wizard does not work. It is designed for the frame style. What I do is fill in one label. Then if you have a 30 label sheet with 3 columns and 10 rows, I copy and paste it to the nest two labels to the right. Then I copy all three of those labels on row 1, and paste into the complete second row. Then I copy rows 1 and two and paste into rows 3 4, 5 6, 7 8, and 9 10. It really goes pretty fast that way. Copy one cell. Select all cells. Paste once into all. (That's Ctrl+A, Ctrl+C, Ctrl+A, Ctrl+V.) Isn't that even faster than pretty fast - and equally fast no matter how many labels you have? Brian Barker -- ** -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Label creation Q
Too cranky, Brian. Mr Sowden thought table referred to a database table. Peter West For my yoke is easy, and my burden is light. On 19 Dec 2013, at 1:00 pm, Brian Barker b.m.bar...@btinternet.com wrote: At 15:10 18/12/2013 -0800, John R. Sowden wrote: I do not know what ya'all mean by 'table' ... Have you looked at the help text? Do you see that menu labelled Table? That's all about tables. Table | Insert | Table... inserts a table. Try it and see how it works. So having a command that would take the label that you just created and populate the other label locations on the sheet seemed to be the next step, and I could not find the option. If you are using a table, see previous advice. If not, I don't imagine anyone can help you whilst you keep secret exactly what you are doing. Problem: In label design, the text and the drawing are separate objects, ... The *drawing*?! Why did no-one mention drawings in their answers? Oh, perhaps because you kept them a secret too? ... so selecting the top left label by highlighting the upper left to lower right the, rt cl copy, put cursor in upper right box, upper right corner, put the lower half of my original label (drawing only, no text) below the original and nothing in the upper right box. This behaviour appears to depend on how your graphic is anchored. Try anchoring As Character to achieve what you need easily. It just seems that a populate other empty labels on this sheet with original would make sense. With tables, it's probably too simple for there to be a special command. See previous advice. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Bonus calculator in Calc
Hi :) Why not use Base to read the 2 existing sheets? Then let it do the bit it does best? Regards from Tom :) On 18 December 2013 23:46, John Meyer johnme...@pueblocomputing.com wrote: I know it's a relational database. ;-) Is there any way to design this to work on a spreadsheet? On 12/18/2013 4:40 PM, Tom Davies wrote: Hi :) That is very much like a relational database. The 1st sheet is the main table. The 2nd sheet would be a separate table but would be linked by a relationship between both column As. The 3rd sheet would actually not be a table as such, it would be a Query that takes data from the 2 tables and performs calculations on them. Hmm, it could be a Form or Report but if i was doing it (and note that i'm not) then i tend to prefer using a Query for as much of this sort of thing as possible because it makes it easier to adjust the formulae in the future Regards from Tom :) On 18 December 2013 20:22, John Meyer johnme...@pueblocomputing.com wrote: A while back I posted up about calculating bonuses based upon a lookup. now, I need to add an additional step. Every once in a while, agents get additional bonuses for sales outside of the normal commission ladder. Here's the layout of the main sheet A B CD E Date1 Date2 Date3 . agent ID Agent Name$### $### $### What I wanted to do was add an Additional Bonus sheet With a layout like this A B C agentID DateBonus Then have a final bonus screen with this layout and formula similar to the main sheet A B CDE Date1 Date2 Date3 agentIDAgent Name$(sales + add bonus total) ... Note: the agent can have multiple bonuses for the same date on the additional bonus sheet. Where would i start doing something like that? I might figure that out while I'm typing that out (which is probably one of the most useful functions of this list), but right now I'm spinning. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Bonus calculator in Calc
Hi :) That is very much like a relational database. The 1st sheet is the main table. The 2nd sheet would be a separate table but would be linked by a relationship between both column As. The 3rd sheet would actually not be a table as such, it would be a Query that takes data from the 2 tables and performs calculations on them. Hmm, it could be a Form or Report but if i was doing it (and note that i'm not) then i tend to prefer using a Query for as much of this sort of thing as possible because it makes it easier to adjust the formulae in the future Regards from Tom :) On 18 December 2013 20:22, John Meyer johnme...@pueblocomputing.com wrote: A while back I posted up about calculating bonuses based upon a lookup. now, I need to add an additional step. Every once in a while, agents get additional bonuses for sales outside of the normal commission ladder. Here's the layout of the main sheet A B CD E Date1 Date2 Date3 . agent ID Agent Name$### $### $### What I wanted to do was add an Additional Bonus sheet With a layout like this A B C agentID DateBonus Then have a final bonus screen with this layout and formula similar to the main sheet A B CDE Date1 Date2 Date3 agentIDAgent Name$(sales + add bonus total) ... Note: the agent can have multiple bonuses for the same date on the additional bonus sheet. Where would i start doing something like that? I might figure that out while I'm typing that out (which is probably one of the most useful functions of this list), but right now I'm spinning. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] multiple file import
Hi :) I've not tried this either but in a similar case i often find it's more efficient to drag the last one in first and then it's easier to drag in earlier and earlier ones into the same place each time without having to scroll through Regards from Tom :) On 18 December 2013 20:32, Brian Barker b.m.bar...@btinternet.com wrote: At 19:13 18/12/2013 +, Nobody Noname wrote: Is there a way to import multiple files into a new document? The existing function only allows multiples files to be imported successively, which is inefficient. If a directory contains file1 file2 file3 it would be beneficial to be able to select all files in the import dialogue window for automatic successive import into the new document. One obvious problem would be the necessity to indicate the order in which multiple files should be incorporated. It would be easy if you had files with carefully organised names, but in general you wouldn't have that. In any case, would file10 become positioned after file9 or between file1 and file2? Would that apply in all operating systems? If you needed either to list the files in the order in which you wanted them incorporated, or else to readjust everything after assembly, you would be better off (and achieve a more reliable result) by simply importing one at a time. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Label creation Q
At 13:12 19/12/2013 +1000, Peter West wrote: Too cranky, Brian. Not cranky at all. Mr Sowden thought table referred to a database table. And hopefully he now knows what people have been talking about. I'm happy to have been the one to help him. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] State of password support.
2013/12/18 Andrew Douglas Pitonyak and...@pitonyak.org You mean recently?As in the latest version of LO has a problem with passwords? No, I am referring to OOo. I am considering to switch to LO because of this problem and I'm trying to figure out if this problem is considered more important by LO developers. 2013/12/18 Andrew Douglas Pitonyak and...@pitonyak.org Which forum, do you have a link to the post? This was in the OOo forum, https://forum.openoffice.org/en/forum/viewtopic.php?f=9t=65690. I'm not well aware how the forum admins interact with the OOo developer base, it looks to me they don't. I'd say this is another problem in itself but luckly, I'm not really interested in that one. Massimo, you seem to be more informed of this than I, but, I am only aware of one (what I consider) real bug that existed with LO and passwords. At one point, I was no longer able to open a password protected file. Specifically, one version of LO was not able to open a password protected file. I am pretty sure it was LO and not AOO anyway. [...omissis...] Thank you very much Andrew, this is very informative. I'm currently inclined to switch to LO. Massimo -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] State of password support.
Yes Eric, those problems are surely related as crashes are involved in my case as well (and I fixed it in the same way). The implication is that temporary saves are not encrypted. Given the modest size of **usual** files this could probably be done with little performance loss but after all, this behavior is acceptable in my opinion. Should a user need more protection, (s)he should likely consider full file-system crypto. Massimo 2013/12/18 Eric Beversluis ebe...@researchintegration.org I don't know if this is relevant to Massimo's case but it might be: I had a problem a while back with Fedora 15 (and I don't remember which version of OO or LO): I would discover that I could open a password-protected spreadsheet without being prompted for the password. It turned out that it had something to do with Fed 15 shutting down w/o prompting to save an open and changed spreadsheet. When restarted, the spreadsheet would open without password protection. The workaround seemed to be to do a 'save as' at that point and check 'save with password'. More recently this hasn't seemed to be a problem, but I think it has happened once or twice, though I didn't bother to try to figure out why. On Wed, 2013-12-18 at 09:24 -0500, Andrew Douglas Pitonyak wrote: On 12/17/2013 10:12 AM, Massimo Del Zotto wrote: However, I recently had a problem with OOo password protection. Somehow it disabled password protection for a file I was working on and it took me a while to restore it. Asking for help on OOo forum, I have been informed password protection is somehow considered unnecessary by... I don't know who to be honest. You mean recently?As in the latest version of LO has a problem with passwords? The forum administrator strongly suggested me to not use it, and even pointed out a few previous cases in which password protection caused data loss (!!!). Which forum, do you have a link to the post? I think *this is unacceptable *so I started looking more seriously at LO. Digging the mailing list archives, I noticed there are quite a few messages regarding password protection. It seems most problem were between keyboard and chair, the only exception being perhaps an inter-operability problem after switching to AES-256. In your experience, how is LO with password protection? Massimo, you seem to be more informed of this than I, but, I am only aware of one (what I consider) real bug that existed with LO and passwords. At one point, I was no longer able to open a password protected file. Specifically, one version of LO was not able to open a password protected file. I am pretty sure it was LO and not AOO anyway. I believe that I have seen things such as: 1. I forgot my password, how I open my document 2. I am not able to open a password protected document created by MS Office 3. Problems signing a document I don't ever remember anyone saying that password protection should be dropped. Does not mean that it has not been said. I have seen people pushing to drop the ability to write non-ODF format, but I don't remember anyone advocating no support for passwords. I have also seen reports of another bug that sometimes causes total data loss of a file, but, since it is not reproducible in any sort of meaningful way, the bug has not been researched. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
