[libreoffice-users] Re: Too many sheets?
Anybody have any ideas? -- View this message in context: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3773708.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] OT- too many emails- how do I stop them?
On 24/02/2012, . pe...@aleksandrsolzhenitsyn.net wrote: Is there a way to modify some sort of mail settings so that I only get replies to my queries? There does not look to be this function. Perhaps you can try digest mode. A single message is received via e-mail, containing a number of messages posted to the mailing list. You can reply to individual messages by replying to the single digest message with the syntax: users+get-1atglobal..., where '1' is the message number in the digest. An example digest message shown below: On 25/02/2012, users+h...@global.libreoffice.org users+h...@global.libreoffice.org wrote: Topics (messages 17443 through 17472): [libreoffice-users] bug in creating forms 17443 - Stefano Fraccaro druid...@libero.it [libreoffice-users] Top posting 17444 - Marc Grober m...@interak.com [libreoffice-users] Top posting 17445 - Marc Grober m...@interak.com Note the appearance of message quote angle bracket () marks. If your mail client/web mail interface cannot produce this type of reply format, it is poor quality and not suitable for mailing lists. -- 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] Too many sheets?
On 23/02/2012, . pe...@aleksandrsolzhenitsyn.net wrote: There are 35 sheets within the file The file is becoming rather slow when saving and loading it (probably because my computer is 10 years old, etc) No, the drive isn't full- only 2% used so far. What can I do to speed up the manipulation of the Calc file? Some of the sheets could be just put into another Calc file and referenced to the main fileI have no idea how to do that but it sounds good. Search the mailing list archive for posts 'database vs spreadsheet' and consider whether you are organising your data in an efficient design. -- 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: Too many sheets?
Are all the spreadsheets needed? Do you have formulas that connect all 35 sheets? Or are many of them complete and not updated? If you need all 35 tables, then you are using a spreadsheet as a database :) -- View this message in context: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3774661.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Top posting
On Fri, 24 Feb 2012 21:24:58 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote Re Re: [libreoffice-users] Re: Top posting: On 02/23/2012 04:18 AM, Caesar wrote: On Wed, 22 Feb 2012 23:38:59 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote Re Re: [libreoffice-users] Re: Top posting: On 02/22/2012 03:10 PM, T. R. Valentine wrote: On 22 February 2012 13:56, Larry Gusaaslarry.gus...@gmail.com wrote: I avoid the aggravation by having posts from Tom Davies automatically deleted. Now that is cold... Cold but effective. Perhaps you misunderstood what I meant. What I meant was it feels mean to say that someone values a person's contributions so little that they have an automatic deletion filter on all of their contributions. Especially when it is someone that produces so much good for the LO community (say in the area of free documentation). If a poster insists that he be able to post in a manner that I find confusing and offensive, then I'm not interested in reading anything he is writting. I find it very effective in making this mailing list readable. -- 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: Editing Auto-completion List in Calc
Am 24.02.2012 18:18, Rich Shepard wrote: In LO-3.5.0 Calc I am offered a completed word or phrase as I start typing in a cell. The list of potential completions varies with the column. However, there are some mis-spelled words in that list and I would like to edit them out. How do I access these lists? I find nothing in the Tools-Options menus. And Tools-Cell Contents only lets me turn on or off this completion feature. TIA, Rich This has nothing to do with the ToolsAutoCorrect options. Since 95% of today's spreadsheet users try to misuse spreadsheets as a database for text data, all constant text values within the same column are offered as a category list analogue to a combo box in a database form. This can be turned off for the entire Calc component in ToolsCellContentsAutoInput List validation provides a more controllable feature where you define a list of values which is supposed to be valid for a defined range of cells. DataValidity... Type: List or Cell Range. -- 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: Top posting
Hi, Am 25.02.2012 12:30, schrieb Caesar: On Fri, 24 Feb 2012 21:24:58 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote What I meant was it feels mean to say that someone values a person's contributions so little that they have an automatic deletion filter on all of their contributions. If a poster insists that he be able to post in a manner that I find confusing and offensive, then I'm not interested in reading anything he is writting. I find it very effective in making this mailing list readable. True. However it´s not a solution for the main problem. The main problem is, that people who do not follow the suggested posting rules, destroy the value of the archive of this mailing list, which is intended to be a growing knowlegde base. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: Question re: Calc default font
Am 23.02.2012 18:28, Willy Williams wrote: That was just the trick, Regina. Thanks for the wisdom. Now, if that capability could be made part of the Options, much as it's part of the Options in Writer, it would be even better. Pardon? Which options in Writer? I only know the same methods in Writer, Calc, Draw and Impress. Simply define your own templates and styles. What's wrong with it? Where is the link to your issue? -- 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: Top posting
Hi :) I think that is fair enough. The 2 worst case scenarios i can see as a result are 1. A questionner gets 2 almost identical answer or the same advice given in 2 different ways. 2. A questionner gets 2 completely different answers going in different directions Both are actually quite positive. In 2 the questionner gets to pick and choose which answer they like or they get to try both ways. In 1 the questionner is given greater confidence in the answer and maybe has a greater understanding of how to deal with side-issues. Both cases occur anyway and that is part of the advantage of having a public list. No-one can get along well with everyone all the time. If we all did then there would be substantial less great and inspiring art, literature, innovations and all the rest. So, i think it is all good. Regards from Tom :) --- On Sat, 25/2/12, Caesar cae...@hiwaay.net wrote: From: Caesar cae...@hiwaay.net Subject: Re: [libreoffice-users] Re: Top posting To: users@global.libreoffice.org Date: Saturday, 25 February, 2012, 11:30 On Fri, 24 Feb 2012 21:24:58 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote Re Re: [libreoffice-users] Re: Top posting: On 02/23/2012 04:18 AM, Caesar wrote: On Wed, 22 Feb 2012 23:38:59 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote Re Re: [libreoffice-users] Re: Top posting: On 02/22/2012 03:10 PM, T. R. Valentine wrote: On 22 February 2012 13:56, Larry Gusaaslarry.gus...@gmail.com wrote: I avoid the aggravation by having posts from Tom Davies automatically deleted. Now that is cold... Cold but effective. Perhaps you misunderstood what I meant. What I meant was it feels mean to say that someone values a person's contributions so little that they have an automatic deletion filter on all of their contributions. Especially when it is someone that produces so much good for the LO community (say in the area of free documentation). If a poster insists that he be able to post in a manner that I find confusing and offensive, then I'm not interested in reading anything he is writting. I find it very effective in making this mailing list readable. -- 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: Top posting
Hi :) Official documentation, 3rd party documentation, official wiki-guides, 3rd party wiki-pages and blogs, distro-specific documentation (and wiki-guides and blogs) are all better and easier to search through than old archives of mailing lists for a product that develops so fast that answers get outdated so quickly. It would be really fantastic if people could take valuable advice given in the lists and update the wiki-guides. It would be even better if the person that took the advice and found it worked did the update as they probably noticed details that old-timers may not have considered significant. Regards from Tom :) --- On Sat, 25/2/12, Stefan Weigel stefan.wei...@bildungskreis.org wrote: From: Stefan Weigel stefan.wei...@bildungskreis.org Subject: Re: [libreoffice-users] Re: Top posting To: users@global.libreoffice.org Date: Saturday, 25 February, 2012, 12:04 Hi, Am 25.02.2012 12:30, schrieb Caesar: On Fri, 24 Feb 2012 21:24:58 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote What I meant was it feels mean to say that someone values a person's contributions so little that they have an automatic deletion filter on all of their contributions. If a poster insists that he be able to post in a manner that I find confusing and offensive, then I'm not interested in reading anything he is writting. I find it very effective in making this mailing list readable. True. However it´s not a solution for the main problem. The main problem is, that people who do not follow the suggested posting rules, destroy the value of the archive of this mailing list, which is intended to be a growing knowlegde base. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: Top posting
On Sat, 25 Feb 2012 13:04:40 +0100, Stefan Weigel stefan.wei...@bildungskreis.org wrote Re Re: [libreoffice-users] Re: Top posting: Hi, Am 25.02.2012 12:30, schrieb Caesar: On Fri, 24 Feb 2012 21:24:58 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote What I meant was it feels mean to say that someone values a person's contributions so little that they have an automatic deletion filter on all of their contributions. If a poster insists that he be able to post in a manner that I find confusing and offensive, then I'm not interested in reading anything he is writting. I find it very effective in making this mailing list readable. True. However it´s not a solution for the main problem. The main problem is, that people who do not follow the suggested posting rules, destroy the value of the archive of this mailing list, which is intended to be a growing knowlegde base. Stefan That is very true Stefan. The question then becomes: how do we handle people who do not follow the suggested posting rules, and thus destroy the value of the archive of this mailing list. There are only two options available: 1) individuals can kill-file offenders, thus leaving them to correspond only with fellow top posters; or 2) expel them from this list. I prefer option (1). -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Too many sheets?
Yes, all of the spreadsheets are needed. I have a main sheet named START wherein all of the data is entered, such as names and birth dates. Then on each of the 35 sheets an array has been created which shows all of the data that was entered in the sheet named START. Butas each sheet is specific to a certain person (and not all people) only that persons data will appear on a given sheet in the cells that I want them to. Does that make any sense? -- View this message in context: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3774884.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Too many sheets?
Yes, all of the spreadsheets are needed. I have a main sheet named START wherein all of the data is entered, such as names and birth dates. Then on each of the 35 sheets an array has been created which shows all of the data that was entered in the sheet named START. Butas each sheet is specific to a certain person (and not all people) only that persons data will appear on a given sheet in the cells that I want them to. Here's how it appears- Spreadsheet at the top (starting at A1) (let's call the sheet CARLTON) wherein all of the information from the sheet START appears. Below that spreadsheet CARLTON with all of the data is an array that shows ALL of the data from the sheet START. CARLTON has cells with formulas that get the necessary information/data from the array below it. Does that make any sense? -- View this message in context: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3774891.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Too many sheets?
Hi :) Wow! That really does sound like something that would be better handled by a database. Plus it sounds as though you have already made the most difficult step that most people have with databases which is the conceptualisation in your brain. Most people never get that far. Please forgive me my excitement but i just thought this was a heavy and intractable spreadsheet issue which i tend to find very, very dull. The Start sheet would be the table of data. All the other sheets would be Forms/Reports built up from Queries. Initially people would probably feel more comfortable using the Queries directly as they look like a spreadsheet. FormsReports display the same info in a prettier gui so they might get built-up later. Queries are probably easier to work with and are clearer about exactly how they choose which data to show from the table. It's probably easier to modify or tweak Queries if things change in the future. I take it the information in Start is confidential? Is it possible for you to let us see the formulas of 1 or 2 of the other sheets? or even just a couple of the formulae from 1 of the sheets that reads the data? This list doesn't handle attachments so either copy and paste a couple directly into email/message or use Nabble? Regards from Tom :) --- On Sat, 25/2/12, PDA1 pe...@aleksandrsolzhenitsyn.net wrote: From: PDA1 pe...@aleksandrsolzhenitsyn.net Subject: [libreoffice-users] Re: Too many sheets? To: users@global.libreoffice.org Date: Saturday, 25 February, 2012, 12:49 Yes, all of the spreadsheets are needed. I have a main sheet named START wherein all of the data is entered, such as names and birth dates. Then on each of the 35 sheets an array has been created which shows all of the data that was entered in the sheet named START. Butas each sheet is specific to a certain person (and not all people) only that persons data will appear on a given sheet in the cells that I want them to. Here's how it appears- Spreadsheet at the top (starting at A1) (let's call the sheet CARLTON) wherein all of the information from the sheet START appears. Below that spreadsheet CARLTON with all of the data is an array that shows ALL of the data from the sheet START. CARLTON has cells with formulas that get the necessary information/data from the array below it. Does that make any sense? -- View this message in context: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3774891.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] L.O. 3.5
Hi :) In Ubuntu the PPA version of 3.4.5 isn't rc. Maybe the team that makes it distro-specific changed the name slightly? I thought most popular distros have LibreOffice in their repos? I think a lot of people prefer to download from the official site rather than their repos even if they aren't using the ultra-latest version. I think don't care is the wrong way around. I think they expect GnuLinux users to be more like themselves and more familiar with the types of details that devs know well and pointclick users such as us (well, me anyway) probably don't. Regards from Tom :) --- On Sat, 25/2/12, man_without_clue flychopp...@livedoor.com wrote: From: man_without_clue flychopp...@livedoor.com Subject: Re: [libreoffice-users] L.O. 3.5 To: users@global.libreoffice.org Date: Saturday, 25 February, 2012, 7:38 On 02/25/2012 01:09 PM, Dan Lewis wrote: On Sat, 2012-02-25 at 13:03 +0900, man_without_clue wrote: Is LibreOffice 3.5.0rc3 same as final official release? I just downloaded and installed on my Debian but the version says rc3. This has been confusing to me in the past as well, but the answer is yes. Three release candidates were created. The third one (RC3) was then released as 3.5.0. I have hear talk of making changes in the numbering system to make all of this clearer. --Dan Ok, thanks Dan. Yeah, it is confusing. I thought they just didn't care about Linux. m.w.c. -- 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: Embedded OLE Objects in Writer
Hi :) There have been problems with pictures embedded into documents so you might be being affected by one of those problems. If it's possible to pin-down exactly what is happening then it might help for posting a bug-report http://wiki.documentfoundation.org/BugReport The problem with the pictures issue is 1. It almost never happens 2. that there seem to be a number of very specific factors that have to be combined for it to happen. So, it's a nightmare trying to disentangle a specific, reproducible case. Regards from Tom :) --- On Sat, 25/2/12, DavidC telem...@yahoo.com.au wrote: From: DavidC telem...@yahoo.com.au Subject: Re: [libreoffice-users] Re: Embedded OLE Objects in Write To: users@global.libreoffice.org users@global.libreoffice.org Date: Saturday, 25 February, 2012, 2:53 ... Thanks, but the box is checked and graphics and objects are set to be displayed. Other graphics appear just fine. I've cut out everything except a couple of pages and made it available for download here: http://dl.dropbox.com/u/17999770/LOProbs1.odt. If anyone can think of a solution I'd appreciate it as That document contains no object folders. Meaning that if an object were embeded in the document, the document when extracted should have folders/directories for each embedded object. Example: LOProbs1.odt_FILES LOProbs1.odt_FILES/Object 1 LOProbs1.odt_FILES/Object 2 LOProbs1.odt_FILES/Object 3 etc. Further, the LOProbs1.odt_FILES/ObjectReplacements shows two files at zero bytes (Object 1 and 31) and only one with any data in the xml file: Object 9. --- Ok, I'm obviously doing something incredibly stupid. I'll go away and work it out based on what you've said here. Thanks NoOp. I appreciate your help. Regards David -- 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] L.O. 3.5
On 02/25/2012 02:38 AM, man_without_clue wrote: On 02/25/2012 01:09 PM, Dan Lewis wrote: On Sat, 2012-02-25 at 13:03 +0900, man_without_clue wrote: Is LibreOffice 3.5.0rc3 same as final official release? I just downloaded and installed on my Debian but the version says rc3. This has been confusing to me in the past as well, but the answer is yes. Three release candidates were created. The third one (RC3) was then released as 3.5.0. I have hear talk of making changes in the numbering system to make all of this clearer. --Dan Ok, thanks Dan. Yeah, it is confusing. I thought they just didn't care about Linux. m.w.c. To be honest, I once heard the figure of 87% of Linux users use LibreOffice as their office package. So yes we care about Linux users. I am a Linux users, for the most part, and the people here do their best to make use Linux users happy. The big push is to get more Windows users. We want them to feel LO is better for them that paying for MSO. I really wonder how many of our developers are actually Linux users first [their default system] and Windows users second, like myself. I think the issue of the final release having the RC label sometimes is due to the timing. We have a strict release schedule and there are a lot of different install files from the package itself to the help and language packs. That is a lot of files to change their names in one batch. Yes it would be better if the RC2 or RC3 was removed from the internal file names of each part of the Linux install. Does it affect the way the package works? No. Actually sometimes Linux is more confusing that Windows in the ways its packages are installed, over the way Windows does it. We pay the price of having a safer, less crashing, and free OS. But it is worth it most days. -- 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: Too many sheets?
Hi :) Is the 20 short for 1920? Here is an advert starring the incredible William Shatner just to show off how far in the future the product is, errr was. http://www.youtube.com/watch?v=PUEI7mm8M7Q There is documentation here http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide which can help you fill in the gaps even tho you already have most of the plan already drawn-up. Queries don't tend to have nice layouts and fonts so they look like raw spreadsheets but that is where FormsReports come in. It's best (imo) to have the Queries do the calculations and filtering and then have the FormsReports read the data from them rather than directly from the Table. Some people have the FormsReports do all the calculations and filtering themselves but i find that has a tendency to be less flexible and less easy to fix or modify. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3775158.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Too many sheets?
Hi :) One advantage of using a database should be greater stability partly due to less ram getting used up. There might be other things like greater control, multi-user (maybe, but i'm not certain), maybe smaller file-size. Vic20 had 16kb of memory. I had a ZX81 and eventually got a 16Kb extension pack that plugged into the back of it. It kept making the machine crash. Accepted wisdom at the time was roughly the same as the cure for a wobbly table. We put a book under the computer and let the expansion pack hang loosely off the back. Magically no more crashes. Well, not so many. http://oldcomputers.net/zx81.html Yes, have a good weekend and don't worry about not replying until Monday or whenever. The thread stays here. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3775578.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Unable to install LibreOffice 3.5.0 viaGPO
--- On Fri, 2/24/2012, Tom Davies tomdavie...@yahoo.co.uk wrote: From: Tom Davies [mailto:tomdavie...@yahoo.co.uk] Sent: Fri 2/24/2012 12:22 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Unable to install LibreOffice 3.5.0 viaGPO Hi :) Has anyone been able to help with this yet? Does anyone know good answers? This is about corporate deployment right? There is an excellent wiki in the OpenOffice wiki and presumably it's still good for LibreOffice? Sorry i have lost track of it again Apols and regards from Tom :) The Bugzilla report https://bugs.freedesktop.org/show_bug.cgi?id=45750 fully addresses issue, have a read. Andreas was referred there for a work around with the 3.5.0 Windows installer which has issues dealing with language codes for not present languages. He's not posted back so assume he's resolved things. Also, per the Bug report, the DEV maintainer will be patching Windows builds for issues caused by packaging changes with the Windows installer. At 3.5.0 deployment now use a single Microsoft Installer packaging (.MSI) rather than a two stage executable (.EXE). I'd expect the patch should address needs of volume deployments from administrative installs using GPO from SCCM or similar management environments. Stuart -- 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] OT- too many emails- how do I stop them?
Try adding a tag to your subject line and then use your mail client filters to put from the list in the trash save for those with your tag in the subject line. -- 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: Top posting
Frankly listservs make very poor knowledge bases for the obvious reasons, hence the efforts by some in other communities to distill the problem/resolution couplet into dynamic online docs where a user will find current comprehensive succinct and useful information. On Feb 25, 2012, at 3:29 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) I think that is fair enough. The 2 worst case scenarios i can see as a result are 1. A questionner gets 2 almost identical answer or the same advice given in 2 different ways. 2. A questionner gets 2 completely different answers going in different directions Both are actually quite positive. In 2 the questionner gets to pick and choose which answer they like or they get to try both ways. In 1 the questionner is given greater confidence in the answer and maybe has a greater understanding of how to deal with side-issues. Both cases occur anyway and that is part of the advantage of having a public list. No-one can get along well with everyone all the time. If we all did then there would be substantial less great and inspiring art, literature, innovations and all the rest. So, i think it is all good. Regards from Tom :) --- On Sat, 25/2/12, Caesar cae...@hiwaay.net wrote: From: Caesar cae...@hiwaay.net Subject: Re: [libreoffice-users] Re: Top posting To: users@global.libreoffice.org Date: Saturday, 25 February, 2012, 11:30 On Fri, 24 Feb 2012 21:24:58 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote Re Re: [libreoffice-users] Re: Top posting: On 02/23/2012 04:18 AM, Caesar wrote: On Wed, 22 Feb 2012 23:38:59 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote Re Re: [libreoffice-users] Re: Top posting: On 02/22/2012 03:10 PM, T. R. Valentine wrote: On 22 February 2012 13:56, Larry Gusaaslarry.gus...@gmail.com wrote: I avoid the aggravation by having posts from Tom Davies automatically deleted. Now that is cold... Cold but effective. Perhaps you misunderstood what I meant. What I meant was it feels mean to say that someone values a person's contributions so little that they have an automatic deletion filter on all of their contributions. Especially when it is someone that produces so much good for the LO community (say in the area of free documentation). If a poster insists that he be able to post in a manner that I find confusing and offensive, then I'm not interested in reading anything he is writting. I find it very effective in making this mailing list readable. -- 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] Too many sheets?
On 02/23/2012 08:47 AM, . wrote: What can I do to speed up the manipulation of the Calc file? Some of the sheets could be just put into another Calc file and referenced to the main fileI have no idea how to do that but it sounds good. Have you tried following link? http://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document Maybe each sheet(person) can be separate calc files with reference to main(start sheet) file. cK -- 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: Too many sheets?
Tom, Oh man oh mansign me up for one!nbsp; My very first computer was the Timex/Sinclair TS-1000.nbsp; Thank you for the information about LO Base.nbsp; I'll look it over in a bit. 'Have a nice weekend. Alek On 02/25/2012 10:47 AM, Tom [via Document Foundation Mail Archive] wrote: Hi :) Is the 20 short for 1920? nbsp;Here is an advert starring the incredible William Shatner just to show off how far in the future the product is, errr was. nbsp; http://www.youtube.com/watch?v=PUEI7mm8M7Q There is documentation here http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide which can help you fill in the gaps even tho you already have most of the plan already drawn-up. nbsp; Queries don't tend to have nice layouts and fonts so they look like raw spreadsheets but that is where Formsamp;Reports come in. nbsp;It's best (imo) to have the Queries do the calculations and filtering and then have the Formsamp;Reports read the data from them rather than directly from the Table. nbsp;Some people have the Formsamp;Reports do all the calculations and filtering themselves but i find that has a tendency to be less flexible and less easy to fix or modify. nbsp; Regards from Tom :) If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3775158.html To unsubscribe from Too many sheets?, click here . NAML -- View this message in context: http://nabble.documentfoundation.org/Too-many-sheets-tp3769750p3775359.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Too many sheets?
Hi :) I think this is the best, fastest option for the short-term. Copypaste might help to adjust the formulas quickly of course. Regards from Tom :) --- On Sat, 25/2/12, Calvin Kim em...@calvinkim.org wrote: From: Calvin Kim em...@calvinkim.org Subject: Re: [libreoffice-users] Too many sheets? To: users@global.libreoffice.org Date: Saturday, 25 February, 2012, 18:09 On 02/23/2012 08:47 AM, . wrote: What can I do to speed up the manipulation of the Calc file? Some of the sheets could be just put into another Calc file and referenced to the main fileI have no idea how to do that but it sounds good. Have you tried following link? http://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document Maybe each sheet(person) can be separate calc files with reference to main(start sheet) file. cK -- 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: Too many sheets?
On 2/25/2012 06:37 AM, PDA1 wrote: snip Another handicap to what I'm doing is largely determined by the speed of the ancient computers I use. Most 'em are trash picked wreckshere...let me take a look at the label on this one...hold on a minuteit says something like, Vic 20. Maybe that's someone's name? (well, I thought it was funny) My son called it the Victim 20 -- 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: Top posting
Marc Grober m...@interak.com writes: Frankly listservs make very poor knowledge bases for the obvious reasons, hence the efforts by some in other communities to distill the problem/resolution couplet into dynamic online docs where a user will find current comprehensive succinct and useful information. Such distilled couplets are a great resource provided they're kept up to date--which in my experience they often aren't. Or even, somebody sees such a couplet, but dated several years ago, and then posts to a mailing list to make sure it's still correct: you get the worst of both worlds. So yes, mailing lists do make poor knowledge bases--but then, they're not meant to be knowledge bases (or, for that matter, a substitute from reading actual documentation). Knowledge bases make poor mailing lists, too. -- 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: Top posting
On 02/25/2012 06:30 AM, Caesar wrote: If a poster insists that he be able to post in a manner that I find confusing and offensive, I can't even type it -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted