[libreoffice-users] Re: Calc: suppress header/footer from page 15 onwards
Brian and all, I expect that the technique of creating a Style for each sheet will work. As it was this afternoon I didn't have the moxo to work through the Edit Styles dialogs. You asked what my clumsy workaround was: OK, with some shyness... but it got the job done by 3 pm! Select Sheet1 with an already defined Print Area. Check or make the Format Page | Footer specify . Print! In my case I printed to PDF. PDF looks good; save it as Sheet1.PDF Now, the dufus: Return to the ODS; select Sheet2. Go to Format Page | Footer and change the text to . Now again print to PDF. This will create Sheet2.PDF. Looks good. Now, paying the monthly Adobe "Cloud" subscription I have available the "Combine Pages" functionality. Specify "Combine"; navigate and select the 2 PDF from above. Combine and it creates a "Binder1.PDF". Examine, close, rename as desired. Next month I will be asked to again update and publish this contact list. I will work with page styles first. David - -- David S. Crampton -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: Calc: suppress header/footer from page 15 onwards
Here it is 9 years later. I just encountered a need to have Sheet1 use Footer1 (Sheet1 prints in 3 pages). Then Sheet2 use Footer2 (another 3 pages). With focus on either Sheet1 or Sheet2 to set 'Format | Page | Footer ... ' changes the Footer to be the same in both Sheets. I worked around it but clumsy and error prone. Using v 6.2.8.2 - -- David S. Crampton -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: Update SQL does nothing using Run SQL directly button
Jay Noel, One other effect of the SQL button in Query Design appears to be that it disables the GUI style design view. If one wants to use both the GUI table (to get started with the basics) and then fine tune with written SQL, you have to sacrifice the formatting of the SQL phrases. If you return to the GUI table, and then to the SQL, the SQL phrases will be unformatted: just a long line. - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902p4011942.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: Update SQL does nothing using Run SQL directly button
John and the others who responded, It took me a while to realize that the useful SQL menu is available only on the main / opening window of the db. The SQL button in the Query Design view still appears to do nothing. I'm finally getting some traction. I acknowledge and appreciate the stylistic suggestions. This year and month data is very unlikely to change once the transaction record is accurately entered. Thank you, all, David - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902p4011374.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] Update SQL does nothing using Run SQL directly button
Register1a is a table with field Trans-Date of type TIMESTAMP. Field Trans-Date-Year is either TIMESTAMP or INTERGER. I have tried with both. Update Register1a Set Register1a.Trans-Date-Year = YEAR(Register1a.Trans-Date); Looks like is should be a very simple SQL statement. It does absolutely nothing. The statement won't run with the F5 key (the run button). It gives The given command is not a SELECT statement. I'm trying to apply SQL learned elsewhere, mostly in MicroBloat Access, and I'm getting nowhere. Help will be appreciated. David - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902.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: No Java could be found: LO 3.6.1.2: Win7 pro sp1; java 1.7.0_07
Pedro, Thank you. Your instructions are very clear. I did this. Same result. I read the content of javasettings_Windows_x86.xml It contains a line: java xmlns=http://openoffice.org/2004/java/framework/1.0; xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; I tried to go to http://openoffice.org/2004/java/framework/1.0; in my (Opera) browser. Got a redirection to http://www.openoffice.org/2004/java/framework/1.0; which displayed a customized Error 404. Looks like Oracle/Openoffice has diddled the works. Is there a more recent page for whatever is meant by xmlns? David - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/No-Java-could-be-found-LO-3-6-1-2-Win7-pro-sp1-java-1-7-0-07-tp4010076p4010109.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: No Java could be found: LO 3.6.1.2: Win7 pro sp1; java 1.7.0_07
Geez, I'm feeling a right dunce on this. You were correct in that my architecture is 64-bit. I uninstalled Java and then installed from jre-7u7-windows-i586.exe as downloaded from filehippo. Restarted machine. Still same behavior in Base. Yes in Tools | Options | LibreOffice | Java there is only the one registered Java. In Windows Control Panel | Programs is listed only 1 entry: Java 7 update 7 Should I revert to the java 6? Thanks for your patience, - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/No-Java-could-be-found-LO-3-6-1-2-Win7-pro-sp1-java-1-7-0-07-tp4010076p4010157.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: No Java could be found: LO 3.6.1.2: Win7 pro sp1; java 1.7.0_07
Base is now working with jre 1.6.0_30. Left unsolved is why Java 7 update 7 doesn't work. Having 6 work is good enough for me at this time. Thanks to all, - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/No-Java-could-be-found-LO-3-6-1-2-Win7-pro-sp1-java-1-7-0-07-tp4010076p4010184.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: some text not printing
An idea based on my experience with this type of long-lived document. Look for a corruption in the file format. Look for an older version of it (from your archive / backup systems) that might print correctly. True, this idea comes from experience with M$ products. But the formats are not so much different. A long document that receives hundreds of small changes over a period of 1 or 2 years is likely to acquire a format corruption. One such sign is a difference between the file size as reported by LibreOffice and the file size as reported by disk file manager in OS. -- David S. Crampton On Mon, 23 Jan 2012 11:40:41 -0800, George E Noon ge.n...@verizon.net wrote: Spencer, The document in question is a set of the By-Laws of an Odd Fellow Lodge that I happen to have been Secretary of for 19 years, now. I've had it since January, 2002, when as Lodge Secretary, I was named Clerk of the Committee tasked with 'revising updating the Lodge's By-Laws. I originally had it as a WordPerfect document ( I had a Star Office document version when I came upon and tried that for a while) - I changed over to Ubuntu Linux (Breezy) in 2006 proceeded to migrate all my document folder contents to it they've been in Ubuntu program files ever since. Odd, but i was not that fond of Star Office - but when i got to using Ubuntu, i took right to OOo, which came out of Star Office, as I understand it. Switched to Libre Office a bout a year ago 7 this is really the first problem I've had with it. The parts that don't print are all full paragraphs --- but I can not find any reason for their not printing in either printer settings nor in any LO settings that I have been able to find. No, i haven't rebooted -- if I were still running MS Windows, that would have been my first choice - but so far that has never been a necessity with Linux, thankfully. I will give it a try - though, if only to eliminate it as something needed. I have most of my documents in standard open document format [whatever LO defaults to, at the time] - I do make MS Word compatible ' .doc' copies, though - so if I need to e-mail to others i don't get a whiney reply back that your document was unreadable. I guess it would also be a good idea to convert to PDF, as well -- that might be a solution, or, at least a problem revealer. Thank you for your suggestions I'll be trying them out perhaps I'll be inspired to search further to see if I've 'gained' some strange setting somewhere or other... George On 01/23/2012 01:48 PM, Spencer Graves wrote: What part doesn't print? If it's always at the end, check the print setting to make sure it's set to print all pages. If that does not seem to be the problem, have you rebooted? I would not expect this to change much, but it might. Did you try exporting it in various formats, then reimporting it? If you've had it for several years, it's probably more likely in *.doc than any other format. Have you tried exporting it as RTF and OpenOffice format plus text? Do you still get the problem exporting it as text, reimporting then printing it? If you still get the problem, you must have some funny control characters that get exported with the text. There are tools to scan for characters that are NOT vanilla ascii, but I'm not familiar with them. Once you can get the text to print as you want, you need to restore formatting and anything else in the original file. I'd delete all the text that does not print plus a bit more, verify that everything retained prints, then add back the text deleted from the *.txt version. If that does not work, then I'd work from the *.txt version and add all the formatting, etc., a part at a time, saving intermediate files until you get what you want. Binary search techniques could speed this work, potentially: If you have one version that has the problem and another version that doesn't, then identify the differences and systematically try a version roughly half way between one that works and one that doesn't until you fix the problem. Hope this helps. Spencer On 1/23/2012 10:25 AM, George E Noon wrote: Harold, Thanks for your reply. When I copied pasted the page in question, the result was unchanged; all was visible on-screen, but the 2 last paragraphs did not print. In those 2 paragraphs, I am unable to find any setting which would account for their 'going invisible'... As to the Help changesreview function -- that does not seem to have any join to what my problem is, in fact it only refers to spreadsheets. I see that you are in London -- not that that, or where my dad's family comes from has a thing to do with anything, but I'll toss it in anyway; my dad's father was from the village of Arnold in Nottinghamshire UK came to the USA on the Lucitania
Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?
I will speak up a little for the positive case for cloud-based computing and apps. In the IT Manager position I recently left the motivator for looking at web apps was PEOPLE; specifically problems with our in-house people. Making a long story short, I had built an entirely in-house M$ shop supported by people I hired plus occasional consulting especially for network / Cisco support. We had about 12 servers, 160 desktops, a very elaborate WAN, M$ Suite plus an in-house M$ WSUS for their flood of updates. The team was 3 people: myself, a sys admin and a desktop tech. The workload was heavy and I relied on the motivation of the two hired staff to be learning M$ stuff toward becoming full M$ experts. The overall economics of in-house machines and fully burdened in-house staff made sense for a while. The people problems started as competition between my two staff people. Productivity and teamwork began to stink; deadlines were flaunted; Helpdesk calls took longer. For a million different reasons (excuses) neither I nor the organization found a way to deal with the people problems. We had built in an addiction to in-house expertise and when our own people went sour nobody, myself included, had the cojones to correct it. So we started to look at web apps. The economics were looking good. Buy more bandwidth, pay the monthly costs and get rid of at least 1 bad actor, maybe both! I left their employment mostly for personal reasons, a death in the family. But even so, mostly is the key word. Six months later the organization has increased the bandwidth and (temporarily?) solved lots of WAN performance issues. The people problems and how to support the burden of M$ apps and their security issues remains unsolved. Status quo. In summary, I agree with all the technical reasons and security concerns expressed about web / cloud apps. It was people-problems that blew down the house. Upon reflection, this calls for LO to build a community of support people that can support small to medium sized businesses and avoid the siren call of M$ style big money and big ego. Good luck! No, seriously, good luck to us all. -- David S. Crampton On Wed, 14 Dec 2011 07:35:51 -0800, webmaster for Kracked Press Productions webmas...@krackedpress.com wrote: On 12/14/2011 10:18 AM, Caesar wrote: On Wed, 14 Dec 2011 10:07:38 -0500, webmaster for Kracked Press Productionswebmas...@krackedpress.com wrote Re Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?: Personally, I do not like the idea of cloud based computing, for security reasons and ownership of files. If the connection to the Internet is down on your end or theirs, you do not have access to your data. Excellent points. The whole 1980s migration from central computers w/dumb terminals to PCs was motivated in large part by the desire to spread the computing load and sever the umbilical cord/chain that central mainframe computers required. In most rural areas of the U.S. today, dial-up modem is as good as it gets, and that won't facilitate the cloud. I was part of the movement. I even saw PCs used as dumb terminals for a time with software like Kermit being used since it had the ability to upload/download the files to the central systems like we do with FTP clients and the web. Yes, I know a lot of people who either can only get dial-up in their areas, or cannot afford the price for broadband. I am currently lucky to have broadband, but with a fixed income, and the fees going up for everything, I may not have it in the future. Or, I may keep it and drop my current digital phone system for some cheaper and less reliable one that is based off my PC or my purchased network device that does Internet phone calls. So, if you want to use cloud computing and file storage, you better remain in the cities. In the more rural areas where people like to live to get away from the crowd, you are out of luck. -- 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: LibreOffice Portable
Try to turn off your realtime antivirus scanner. Unload it or stop the process. On Wed, 14 Dec 2011 13:33:40 -0800, Pedro pedl...@gmail.com wrote: M Robinson wrote What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version 10. It doesn't matter which site a attempt to download from I end up with an incomplete file of 19.9 MB, the downloads start with a file side of 121 MB. That seems to be a problem with the PortableApps mirrors or your download manager. Try to get LibreOffice separately from http://portableapps.com/apps/office/libreoffice_portable In any case you should ask at the PortableApps forum since LibreOffice or TDF can't help you on this problem ;) -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-Portable-tp3586506p3586838.html Sent from the Users mailing list archive at Nabble.com. -- David S. Crampton -- 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: LibreOffice Portable
I don't know why. Sorry experience suggested it. I have seen this behavior on 3 different antivirus scanners over the years. All in Windows OS. No useful user feedback. Not even an event registered to event logs. If you download a lot you might see it in other downloads. I answered a similar question in this forum about a month ago. Same thing. I can see it in theory. The scanner is looking for tokens or sequences of binary code that are associated with virus / worm executables. It's not improbable that a huge download, using compression, would generate enough of similar looking binary string to trigger a false positive. Why the antivirus scanner doesn't tell you what's happened? Mystery. I'm glad you got it, David On Wed, 14 Dec 2011 15:30:52 -0800, M Robinson mr.m.robin...@gmail.com wrote: That worked. Why does that work? I'm using Avast 6.0.1367, and it hasn't thrown any flags while silently killing ONLY LibreOffice Portable downloads. On 12/14/2011 6:14 PM, David S. Crampton wrote: Try to turn off your realtime antivirus scanner. Unload it or stop the process. On Wed, 14 Dec 2011 13:33:40 -0800, Pedro pedl...@gmail.com wrote: M Robinson wrote What's the story with LibreOffice Portable, I've been trying to download the file since PortableApps released version 10. It doesn't matter which site a attempt to download from I end up with an incomplete file of 19.9 MB, the downloads start with a file side of 121 MB. That seems to be a problem with the PortableApps mirrors or your download manager. Try to get LibreOffice separately from http://portableapps.com/apps/office/libreoffice_portable In any case you should ask at the PortableApps forum since LibreOffice or TDF can't help you on this problem ;) -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-Portable-tp3586506p3586838.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] import from HTML
Jef, Take a look at the raw HTML. The formatting might be using style sheets (.css) files. It is pretty easy for the linkages between the body of html and the external style sheets to be broken. Just a suggestion, -- David S. Crampton On Mon, 12 Dec 2011 00:34:55 -0800, jef peeraer jef.peer...@telenet.be wrote: On 12/12/2011 01:29 AM, e-letter wrote: On 11/12/2011, jef peeraerjef.peer...@telenet.be wrote: On 12/10/2011 05:54 PM, e-letter wrote: On 10/12/2011, jef peeraerjef.peer...@telenet.be wrote: i have a website that generates reports in HTML. it contains nice Not able to generate a csv report? Assuming you are importing into a spreadsheet to perform data manipulation, why is pretty formatting necessary? well, this is not an issue for me, but for other users i now, and they are always referring to the other spreadsheet program. My task is of course to counteract and to show them that it works even better in LO. This was one question popping up by a user, and i agree, why do pretty formatting in excel, but i just want to have an answer ready tables, with headers andso. in another spreadsheet program, i can just ctrl-a, ctrl-c and then ctrl-v, all tables are nicely imported, even the markup is converted to the spreadsheet. Can i do this with LO ? What is stopping you to continue using the other spreadsheet? trying to convert some people, is a goof thing, no ? Have you tried yet??? Then tell us the results! well, i can't use Insert Link to External Data, because i don't hace an URL of that generated report. What is wrong with the function 'paste special' and the option 'as html' in the dialogue window? jef -- 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] Calc: Identifying duplicate cell values with conditional formatting?
Hylton, I can offer a few general considerations and thoughts. Your problem statement appears to contain two objectives: a) to make consistent the case of all the elements; all Upper Case; all Lower Case; whatever. It seems the case makes no difference to the meaning of the record. The case is just an artifact of the typing style of the data input person(s). In this situation, a mass application of =UPPER or =LOWER and placing the result in a new sheet would suffice. I think no amount of special formatting will reliably catch your eye to eliminate manually all the instances of differing case. b) the deduplication. Once the case issue is resolved you will have rows with all elements exactly equal. This deduplication should be done by exporting the 68000 x 10 sheet to a database and running a deduplication query. Again any of the visual tricks to identify duplicate rows will be unreliable and you will be guaranteed to miss at least a few. At this point my advise bogs down. I have past experience with the M$ Access product; recent versions of Access have a pre-written deduplication query. It is not available to me right now because I have left my workplace and don't have an installation of that recent version of M$ Suite. Use caution in the deduplication process; make lots of backups. It is a delete-type query and data will be lost! Hopefully only the duplicates but you never know. I hope this vague hand waving is of some help to you, -- David S. Crampton On Mon, 12 Dec 2011 06:39:31 -0800, Hylton Conacher (ZR1HPC) hyl...@conacher.co.za wrote: Hi, Using LibreOffice 3.3.1 and am in the process of editing a 68000 row, 10 column file. There are two main columns that contain the data to be cleaned up with multiple instances of duplication i.e. the same text but only the text case differs between two rows or the text is totally different in column A row 1 and row 2 but the text in column B rows 1 and 2 is identical i.e. Col A Col B OR Col A Col B a hx a hx A hx a hx OR a hx a hx a hy A hy etc for the other combinations I am doing the alphabetical sort via Col A. I can use find to search for the duplicate record row once I know what I am looking for however determining what test is different when the values in the Col A are the same and vice versa/ On 136000 cells this is a FAIR mission! I would like to know if there is a conditional formula I could use that could highlight the differences in one column when cells in the other column are the same. I am thinking of a formula that says if the cell contents are the same as any other cell in a range, apply the conditional format. Of course this conditional would need to be added onto all 136000 cells. :( That way I can highlight the 'error' cells and find them easily and correct them or add a new row of data. Any pointers would be appreciated for doing this in Calc as an external database is not available. What elements of the formula can I investigate? Many thanks Hylton -- 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] Identifying the correct row in Spreadsheet formulas
Ian, The If 'Month'=Jan then Row=1 relationship can be a VLOOKUP, MATCH and INDEX family of spreadsheet functions. I have sometimes used the INDIRECT functions but these get very cumbersome and fragile. This looks like it would be better done as a query in Base. I used combinations of spreadsheets, for the raw data, and databases for the monthly reporting in my budget/expense tracking work. -- David S. Crampton On Fri, 09 Dec 2011 04:12:23 -0800, Ian Whitfield whitfi...@telkomsa.net wrote: Hi All I have a spread sheet in LO 3.4.3 where I record and analyse monthly numbers and amounts for a electricity bill. The figures for each month are all in one Row. Below this I have Allocation Blocks that allocate the top figures to different sub-users. Like this... A BC D 1 Jan 00 00 00 etc 2 Fed 00 00 00 etc 3 Mar 00 00 00 etc 4 Apr 00 00 00 .etc _ANALYSIS FOR (Month)_ Name - Cell n + Cell n (where the 'n' has to be the correct Month Row) Name - Cell n + Cell n (ie it increments by one for each month) etc I have simplified the above but this is the basic concept. How can I modify the formula to pick-up the correct Row for the month I wish to do the analysis - and printout the report for? Is there a way to pick-up the 'Month' in the Analysis Block and use this to select the correct row? (In Basic this would have been If 'Month'=Jan then Row=1 etc etc Hope you follow me. Thanks for any help. Ian Whitfield. -- 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] Calc: How to refresh advanced filter automatically
Oleg, It might help us to know more about your application. There are functions within Calc to do this under the menu item: Data. Using these database-like operations in Calc (or any other spreadsheet) requires a reasonably experienced level of user. The user must place the 15 in exactly the correct cell and then navigate to the portion of the spreadsheet which will display the result. This type of operation, IMHO, is better done in a database, ie. LO Base. The user input can be gathered through a Form. The results of the query are quick and interactive. If you are just beginning to design this application for users please make a good decision about spreadsheet versus database for the engine. I just finished 10 years of IT Management which included troubleshooting massive and tangled spreadsheet apps that should have been databases from the beginning. -- David S. Crampton On Mon, 05 Dec 2011 06:08:46 -0800, relgames relga...@gmail.com wrote: Hi, I have Calc file with a long list of rows, what I need is to filter those rows by some criteria entered by user. So, if user enters 15 into some cell, list should immediately update itself and show only rows containing 15 Any suggestions? Regards, Oleg. -- View this message in context: http://nabble.documentfoundation.org/Calc-How-to-refresh-advanced-filter-automatically-tp3561522p3561522.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] open .odt without updating fields
Insert the Field for Modified Date: Insert | Fields | Other | tab:DocInformation in the Type list: Modified in the Select list: Date in the Format list: your heart's desire checkbox Fixed Content: experiment. Probably for this purpose Unchecked. In my experience this issue arises in collaborative projects where people are supposed to update their own portions and meet a schedule (but often do not). -- David S. Crampton On Sat, 03 Dec 2011 00:11:41 -0800, bjloc...@lockie.ca wrote: I have a Writer file that has a date field. Is it possible to open the file with the date field displaying the date it was last saved? -- 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: Stuck with 3.3 forever?
I agree with Pedro. A null text is not to be treated as a numeric zero. An empty cell may be calculated as a zero but a null text is not an empty cell. If have found the #VALUE result of mixing null text within a calculation to be a good debugging and alert technique that the values elsewhere in my spreadsheet have become messed up. - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557547.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: Stuck with 3.3 forever?
Expanding a bit on Jonny's concatenation: A1: (null string) A2: 1 (numeric) A3: =A1+A2 displays #VALUE A4: =A1 A2 displays left-aligned 1. It is a text result. A5: =A2 + A4 displays a right-aligned 2. It is a numeric result. Ergo, the + operator gave #VALUE result when combining a null string and a numeric but gives a numeric when combining a text string which can be interpreted as a numeric with a numeric. Per my mini-sermon (earlier today) on debugging and preferring strict type-based behavior, I would prefer A5 to also display #VALUE. -- David S. Crampton On Sat, 03 Dec 2011 12:08:20 -0800, Jay Lozier jsloz...@gmail.com wrote: On 12/03/2011 12:50 PM, Johnny Rosenberg wrote: 2011/12/3 Pedropedl...@gmail.com: Johnny Rosenberg wrote Depending on the value in other cells, the result can be a time or an empty string (). In this case, E9 is an empty string, so E10 becomes ”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because of this. Can you provide an example file? This used to be a problem but it is fixed in 3.4.4 (at least under Windows) I could, but it's not needed, I think. I just did this simple test in 3.3.4 and 3.4.4: Open LibreOffice Calc from scratch. A1: = A2: =A1+1 In LibreOffice 3.3.4 (Ubuntu 10.10), A2 displays: 1 In 3.4.4 (Ubuntu 11.10), OOO340m1 (Build:402), A2 displays: #VALUE! Try in A1 no data/empty cell and in A2 =A1+1, you will get 1 in A2. You are adding a text and number and the + operator is not used for concatenation. This has to do with operator overloading, are other, similar, operations allowed when using '+'. Some may allow it and others may not, restricting its use to mathematical operations only. LO uses the '' operator for concatenation. If you use A1 = and A2 = A1 1 you get 1. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- View this message in context: http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557454.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] The tone of thiese Lists (from a newbie)
Bob, I made the same mistake when I first signed up. I was sending questions to users+help. The syntax makes that sound reasonable. After the 3rd try of getting the same boilerplate help message back I found the correct: users@global.libreoffice.org. That's what puts you in business! Good luck, David S. Crampton On Sat, 26 Nov 2011 09:11:52 -0800, Bob Houston bob_hous...@hotmail.com wrote: Tom, Thanks for the quick response. My question was sent directly to (user+help) but right after signing up. Maybe I should have waited for the dust to settle before launching the question. I'll resend the email.Thanks again.And I truly am enjoying the boat load of emails. |:) Bob Bob Houston eBook Formattinghttp://about.me/BobHouston http://facebook.com/eBookFormatting Date: Sat, 26 Nov 2011 16:59:12 + From: tomdavie...@yahoo.co.uk Subject: RE: [libreoffice-users] The tone of thiese Lists (from a newbie) To: users@global.libreoffice.org Hi :) Weird. I couldn't find your question. I had a look through Nabble http://www.libreoffice.org/get-help/nabble-mailing-list-interface/ and also checked all through my in-box for the last few days. (That's usually a good way to find a post that accidentally (or deliberately) hijacked a thread). The best way to ask a question is to write a new email rather than just using Reply to. Or in Nabble click New Topic somewhere top(ish) left. GMane will have something similar no doubt. Please could you ask again but make it a new question? Regards from Tom :) --- On Sat, 26/11/11, Bob Houston bob_hous...@hotmail.com wrote: From: Bob Houston bob_hous...@hotmail.com Subject: RE: [libreoffice-users] The tone of thiese Lists (from a newbie) To: users@global.libreoffice.org Date: Saturday, 26 November, 2011, 16:45 Hi,I hope it's OK to jump in with a question, because I'm one of the newbies that you may be talking about. I sent an email off to (user+help) on 11/23 about a problem with the display of hidden characters (The Pilcrow) that I am having on two systems. Since sending the email I have been receiving a boat load of libreoffice-users emails that I am finding very informative but nothing about my Pilcrow. Questions: Did I send it to the right place?Do I even know if it was received?Is there an input queue that it goes into and I'll see something when it's looked at?And lastly, does anyone on this list know how to get my Pilcrows back. Sorry for jumping in but thanks in advance. Bob Bob Houston eBook Formattinghttp://about.me/BobHouston http://facebook.com/eBookFormatting Date: Sat, 26 Nov 2011 16:20:50 + From: tomdavie...@yahoo.co.uk Subject: Re: [libreoffice-users] The tone of thiese Lists To: users@global.libreoffice.org Hi :) We have phases. This is a fairly bad phase but we have had worse and got through. Typically we arrive the other side of these bad times better friends than we were previously and with more understanding of how other people think. It's all part of being in a community. Someone has an excellent signature saying something like Friends argue. Non-friends just don't care enough. Regards from Tom :) --- On Sat, 26/11/11, David dgbo...@gmail.com wrote: From: David dgbo...@gmail.com Subject: [libreoffice-users] The tone of thiese Lists To: users@global.libreoffice.org Date: Saturday, 26 November, 2011, 16:08 Is it just me or is the tone of the messages on these lists turned extremely hostile as of late? -- 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 -- 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
Re: [libreoffice-users] Installer stalls after C++ process
Mike, What antivirus environment? If your realtime antivirus detects a false positive in the unpacking / running of the installation, this is the behavior I have seen. Disable the antivirus / unload the realtime scanner. And a million other impediments built in by M$ into Windows7. -- David S. Crampton On Fri, 25 Nov 2011 10:33:48 -0800, Michael Bauer f...@akerbeltz.org wrote: Hi ppl, My motherboard died on me this morning so I was forced to move on to Win 7 (shudders). Anyway, when I re-downloaded LO (x86), my install process got as far as unpacking, then moved onto the C++ process and then stopped. The window disappeared and nothing happened. Running the .exe or .msi got me an error message saying the setup process was running. After shutting that down in Task Manager, didn't get any further than before. Tried a reboot, no change either. Tried 3.4.3 - same problem. I'm flummoxed - any ideas? Cheers Mike (the gd localization team) http://www.foramnagaidhlig.net/stuth/geamannan/tetris/ -- 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] How do I enter a numeric into a Calc cell from LO Basic macro?
I wish to perform some complex arithmetic operations on several variables. One such variable is Firsta as in the attachment below. I wish to enter the values of Firsta (and others) into cells in Calc. The only method I have found for entering data into cells is the dispatcher statement using uno:EnterString. This I am using from the Macro recorder script. The issue appears to be that uno:EnterString requires a string as its parameter. If the parameter is a numeric (an integer in my case), the cell is left empty. How to enter an integer value from LO Basic into a cell without having to klutzy-convert it to a string? Is there an equivalent to Calc's Text(ref, format) function that will execute in Basic? I've searched Andrew's book (very good book) and other web resources about uno (very bad resources mostly). Andrew's book, however, doesn't include the EnterString method in its uno chapter. LO v3.4.4 on Windows XP Pro ~~~begin code fragment~ ~~~this code works OK only because of the number-to-string conversion~ Things = 9 Do ' WriteTriplet0 dim args5(1) as new com.sun.star.beans.PropertyValue args5(0).Name = By args5(0).Value = 1 args5(1).Name = Sel args5(1).Value = false dispatcher.executeDispatch(document, .uno:GoDown, , 0, args5()) Select Case Firsta Case 1 args1(0).Value = 1 Case 2 args1(0).Value = 2 Case 3 args1(0).Value = 3 Case 4 args1(0).Value = 4 End Select dispatcher.executeDispatch(document, .uno:EnterString, , 0, args1()) Firsta = Firsta + 1 Loop While Firsta = Things ~~~end code fragment~ -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How do I enter a numeric into a Calc cell from LO Basic macro?
Johnny, You asked: Is there a reason why you want to use that UNO dispatcher thing...? Yes. That's what I got from the macro recorder. I'm low on the learning curve. I would love to learn about your ThisComponent.getSheets().getByIndex(0).getCellByPosition(0,0).setValue(x). Especially the .setValue! That type of syntax I have not found anywhere in the LO Basic documentation. Can you point me to the source for this? Thank you, David On Mon, 21 Nov 2011 09:08:41 -0800, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/11/21 David S. Crampton david_cramp...@ie2b.com: I wish to perform some complex arithmetic operations on several variables. One such variable is Firsta as in the attachment below. I wish to enter the values of Firsta (and others) into cells in Calc. The only method I have found for entering data into cells is the dispatcher statement using uno:EnterString. This I am using from the Macro recorder script. The issue appears to be that uno:EnterString requires a string as its parameter. If the parameter is a numeric (an integer in my case), the cell is left empty. How to enter an integer value from LO Basic into a cell without having to klutzy-convert it to a string? Is there an equivalent to Calc's Text(ref, format) function that will execute in Basic? I've searched Andrew's book (very good book) and other web resources about uno (very bad resources mostly). Andrew's book, however, doesn't include the EnterString method in its uno chapter. LO v3.4.4 on Windows XP Pro ~~~begin code fragment~ ~~~this code works OK only because of the number-to-string conversion~ Things = 9 Do ' WriteTriplet0 dim args5(1) as new com.sun.star.beans.PropertyValue args5(0).Name = By args5(0).Value = 1 args5(1).Name = Sel args5(1).Value = false dispatcher.executeDispatch(document, .uno:GoDown, , 0, args5()) Select Case Firsta Case 1 args1(0).Value = 1 Case 2 args1(0).Value = 2 Case 3 args1(0).Value = 3 Case 4 args1(0).Value = 4 End Select dispatcher.executeDispatch(document, .uno:EnterString, , 0, args1()) Firsta = Firsta + 1 Loop While Firsta = Things ~~~end code fragment~ -- David S. Crampton Is there a reason why you want to use that UNO dispatcher thing or whatever it is called. Why not just doing something like the following? Dim x As Integer x=3 ThisComponent.getSheets().getByIndex(0).getCellByPosition(0,0).setValue(x) Well, something like that, I didn't test it. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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] Mail merge doesn't send e-mails
This sounds to me like an e-mail processing issue; not an LO problem. What exactly is the evidence that some of the e-mails are not sent? How large is the document that you are trying to send? What is your e-mail environment? Your client? Your messaging server? What is your antivirus environment? Are you in control of it? In my humble experience, mass mailings (5 might be interpreted as mass depending on the antivirus / antispam enviroment) are very fragile. Attachments (your document) can be unexpectedly bulky and trigger ISP traffic limits. The slightest syntax error in the list(s) of recipients can make it appear that the entire mailing went wrong. I don't propose to troubleshoot an e-mail / server problem in this forum. I'm trying to see on which side of the fence your issue may be hiding. Good luck, David On Sun, 20 Nov 2011 02:52:40 -0800, annedonnelly a...@annedonnelly.co.uk wrote: Using LibreOffice 3.4.4 OOO340m1 (Build:402) on Windows 7 Home Premium SP1 I use Writer to mail merge from a .CSV file and send the results via e-mail (I have been doing this successfully using OO Writer on Windows XP for a number of years). The input file has only 5 records. The records are merged successfully but not all e-mails are sent. The e-mail status dialog will say 2 of 5 e-mails sent. 0 e-mails not sent. No errors are reported. If I edit the input file to remove the two records which were successful and merge again I may be able to send another message successfully. Eventually after repeated tries I can send all the messages. I have a number of input files (all with 5 records) and the problem happens with each. Sometimes 1 message is sent, sometimes 4. I've never been able to send all 5 at the first attempt. Any ideas what is happening? Is there a log file generated anywhere? It is taking so long to mail merge these e-mails that it would be quicker to send them manually! Thanks Anne -- 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] Backspace key in IDE behaves as Delete Key instead.
Backspace key behaves correctly in Calc and in Writer. In the Basic IDE, however, it eats the character to the right of the cursor. Should eat the character to the left of the cursor. Toggling Insert and Overlay work as expected. Delete key as expected. Delete eats the character to the right of the cursor. Quick search through Bugzilla returned way too many results on Backspace. LO 3.4.4 (also observed in 3.4.3) on Windows XP, US English, Microsoft Natural Keyboard. -- David S. Crampton -- 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] How do I enable Create new Python macros?
How do I enable Create new Python macros? In the Python Macros dialog the buttons for Create, Edit, Rename, Delete are greyed out. The Run button behaves correctly: it is greyed out until one of the sample Python macros is selected from the tree in the left hand pane. LO v3.4.4 on Windows XP Pro. -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How do I enable Create new Python macros?
Tom Drew, Path to experimental features is Tools | Options | LibreOffice | General. Been there, done that. Drew's info about the editor leads to next question: Where is the Python interpreter? Still in LO? How to address it / launch it? Or should I install Python as a self-standing language? The fact that the sample Python scripts execute properly implies that a Pyton environment is already within LO. I would regale the forum with the story of the optimist's birthday present but ... I digress. I fully agree with ditching not great editors. -- David S. Crampton On Wed, 16 Nov 2011 09:35:04 -0800, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) You need to enable Experimental features. I'm not sure exactly sure where. Perhaps in Tools - Options - errr, somewhere! Apols and regards from Tom :) --- On Wed, 16/11/11, David S. Crampton david_cramp...@ie2b.com wrote: From: David S. Crampton david_cramp...@ie2b.com Subject: [libreoffice-users] How do I enable Create new Python macros? To: Users discussions at global.libreoffice.org users@global.libreoffice.org Date: Wednesday, 16 November, 2011, 15:05 How do I enable Create new Python macros? In the Python Macros dialog the buttons for Create, Edit, Rename, Delete are greyed out. The Run button behaves correctly: it is greyed out until one of the sample Python macros is selected from the tree in the left hand pane. LO v3.4.4 on Windows XP Pro. --David S. Crampton --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] How do I report an error in Help web pages?
This is now in bugzilla as #42924. Status is unconfirmed at this writing -- David S. Crampton On Mon, 07 Nov 2011 07:44:34 -0800, webmaster for Kracked Press Productions webmas...@krackedpress.com wrote: Thanks for the report of the error. This is a good place to put it if you have not signed up for the documentation or web site lists. I will forward this on to the web site list. On 11/07/2011 10:16 AM, David S. Crampton wrote: At page: http://help.libreoffice.org/Calc/Array_Functions there are errors in the display of the sample arrays. The text of the example is correct but the error in the example array makes the explanation less effective... putting it kindly. The top row of each array should have its content shifted right by one cell. The top-leftmost cell in the example should be empty. The top row and left column are intending to display, respectively, the column numbers and row numbers. The errors are the same for all the example arrays and also in at least several of the languages. The login to 'help.libreoffice.org' is apparently different than 'www.libreoffice.og'. I don't want to create so many different credentials. How, then, to report this error? If not sufficiently done here. -- 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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
I wish to comment on this issue. It' more in the nature of how to design the UI rather than a defect in the Suite. I used MSO both in corporate environments and personally for many years. Rarely did I use M$'s My Documents as the storage location for any document. In MSO, it is My Documents that is the default location for any File Open or File Save operation. MSO insistence on having My Documents be the default location was a universal hindrance. We in IT constantly struggled to thwart it. The most we could do was redirect it to a networked share. It is not clear in Mike's posting what exactly he would like the behavior to be. I would hope Mike is not requesting the M$ paradigm. I prefer the existing behavior in LO. Mike's suggestion about an option somewhere to control this behaviour? is very worthy. Some will like the My Documents paradigm; me, not so much. I most frequently use the Recent Documents list within LO. The 10 listed items there are just right historical coverage. Respectfully blustering, -- David S. Crampton On Wed, 09 Nov 2011 07:13:41 -0800, Mike Moratz-Coppins mc_lego...@yahoo.co.uk wrote: Platform: Win7 SP1 64-bit LibreOffice 3.4.3 release (though I have had this problem with OpenOffice and LibreOffice since I started using Win7) If I do File Open and open a document from there (which isn't in the default documents folder), then close LibreOffice, re-start it and do File Open again, it opens the location that I went to for the previous document. The same applies for the save dialog. My workaround at present is to enable 'use libreoffice dialogs' in Tools Options, but that is quite a feature-light UI in comparison. It doesn't matter whether I use Writer, Calc or Impress. Also, if I start by using Writer but close LO and move on to say Impress, then Impress remembers the path I last loaded/saved in with Writer. I've also seen this behaviour on more than one fresh install Win7 64-bit / OpenOffice / LibreOffice, and while I haven't tested it for this behaviour on every OS install I've done that includes Open/LibreOffice, on every one I've tested it, it had the problem. Is there an option somewhere to control this behaviour? -- 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] Problem: LibreOffice remembers the last folder I was in (open/save dialog)
Mike, I fully agree that it should be made as an optional behavior. I don't know how to submit that idea. As a feature request perhaps in Bugzilla? On Wed, 09 Nov 2011 08:26:22 -0800, Mike Moratz-Coppins mc_lego...@yahoo.co.uk wrote: If the behaviour I'm seeing is the intended behaviour, then an option to configure that behaviour between 'default documents folder' and 'last used folder' would be much appreciated. -- David S. Crampton -- 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] How do I report an error in Help web pages?
At page: http://help.libreoffice.org/Calc/Array_Functions there are errors in the display of the sample arrays. The text of the example is correct but the error in the example array makes the explanation less effective... putting it kindly. The top row of each array should have its content shifted right by one cell. The top-leftmost cell in the example should be empty. The top row and left column are intending to display, respectively, the column numbers and row numbers. The errors are the same for all the example arrays and also in at least several of the languages. The login to 'help.libreoffice.org' is apparently different than 'www.libreoffice.og'. I don't want to create so many different credentials. How, then, to report this error? If not sufficiently done here. -- David S. Crampton -- 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] name-define-edit causes crash in LO Calc v3.4.3
Context: in Calc of LO v3.4.3 on Windows XP Pro. I I record my checkbook into Calc. Four columns are, Check #, Debit$, Credit$, Balance. Each month adds about 40 rows (checks and other transactions) to the columns. At the end of each month some of the transactions have not yet cleared the into my bank statement. I have a named range, outstanding checks, which spans these uncleared items. There are, say, 10 items in this range. In October, for example, outstanding checks is $A1:$D9. At the end of November I want to redefine outstanding checks to be, say, $A31:$D40. The named range outstanding checks is used in links in other related spreadsheet files. It is necessary to have this name remain constant. What fails: Insert | Names | Define: brings up Define Names dialog; Initially, in the Define Names dialog, Scope=Global, Name=empty, Listbox contains my outstanding checks, Assigned To is greyed out. Click on outstanding checks in the listbox; Assigned To becomes active and shows the currently defined $A1:$D9. Observe that the button Add becomes relabeled to Modify. Ignoring, in this first case, the Modify button: Click into the Assigned To box. Type in the edits to rewrite $A1:$D9 to $A31:$D40. Click button OK. LO Calc crashes. Every time. Upon restart LO Calc does file recovery. Recovery is successful. Range is still defined as the original $A1:$D9. Alternate GUI method: Click Modify button to initiate the same edit. Same crash behavior. Other info: OOo v3.3.0 (the last version I used prior to LO) performs this op successfully; that is, the manually typed redefinition is accepted and behaves properly. Workaround: Create a newly named defined range each month. For example, outstanding checks October; outstanding checks November, etc. However... The named range is used in other Calc sheets files to report on each month. The linkages in those target files must be similarly edited. Pain! I did an amateur's search of Bugzilla prior to writing this. Hundreds of define results but not on this AFAIK. If no clues come from Users forum I will post as new bug. Regards -- David S. Crampton -- 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] flip columns in calc
I would think of each column as a row of a database. Add a row above the db range. Populate it with characters in a sequence which, when sorted in ascending order, will put the data columns in your desired order. Use Data | Sort GUI processes to sort the columns as columns in that ascending order. Transpose converts rows to columns and columns to rows. -- David S. Crampton On Wed, 02 Nov 2011 21:12:08 -0700, Jason Paul Joines ja...@joines.org wrote: I'm using LibreOffice 3.4.3 on Kubuntu 11.04. Is there any way to reverse the order of columns in a Calc spreadsheet? For example, if I have columns A through Z, I want to re-order them so that the contents of Z are in A, Y in B, X in C, ..., A in Z, B in Y, C in X. In reality I need to leave the first 9 columns in order and have many more than 26 columns. Is there something that works similarly to transpose in Paste special... but to reverse columns instead? Jason === -- 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] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow
I entered my description into Bugzilla: Assigned Bug # 42535 Bug 42535 - Editing UI: Ctrl+Shift-RightArrow faulty extension result -- David S. Crampton On Tue, 01 Nov 2011 23:30:34 -0700, Stephan Zietsman szi...@gmail.com wrote: David S. Crampton wrote: I don't think the bugs described in those 2 articles are the same behavior issue. Those descriptions and the discussion of is it a bug or is it emulating Excel are too dense for my brain at least this evening. [...] In short, I think I'm reporting something different. Please file a bug report (bugs.freedesktop.org). But first make sure to check if someone has not reported it already. Please let us know when you've reported (or found) the bug, along with the bug number; I'd like to add my comments. Regards Stephan -- 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] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow
Stephan, I don't think the bugs described in those 2 articles are the same behavior issue. Those descriptions and the discussion of is it a bug or is it emulating Excel are too dense for my brain at least this evening. I'm an experienced, if somewhat uncreative, Excel user. I never tried to extend a range dependent on the filled range of an adjacent column/row. My thought process in observing the behavior on which I reported had no such expectation. In short, I think I'm reporting something different. David On Mon, 31 Oct 2011 23:36:08 -0700, Stephan Zietsman szi...@gmail.com wrote: David S. Crampton wrote: The keystokes: In L154: Ctrl+C Down Arrow: moves to L155 Ctrl+V: paste Esc: terminate the dotted border focus on L154 F2: make the small edit Enter: terminate the edit Ctrl+Shift+RightArrow: SHOULD extend to AB156 where it finds the next filled cell in the row. ~: ACTUALLY extends selection to the entire column L. () This unexpected column selection is, of course, very disorienting to one's eyeballs and brain. This behaviour sounds similar to a bug that I've come across before. Please have a look through these bug reports and let us know if this is what you're talking about: https://bugs.freedesktop.org/show_bug.cgi?id=39212 https://bugs.freedesktop.org/show_bug.cgi?id=37230 If these bugs address your problem, please add your comments to them. Regards Stephan -- 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] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow
Context: in Calc of LO 3.4.3 on WinXP Pro The cell range L155:AA155 contains empty cells. The cells on either end of that range are filled with numbers. The cell above L155 contains a formula. The task is to copy the formula from L154 to L155, make an edit, extend the range from L155 to AA155, Edit | Fill Right. The keystokes: In L154: Ctrl+C Down Arrow: moves to L155 Ctrl+V: paste Esc: terminate the dotted border focus on L154 F2: make the small edit Enter: terminate the edit Ctrl+Shift+RightArrow: SHOULD extend to AB156 where it finds the next filled cell in the row. ~: ACTUALLY extends selection to the entire column L. () This unexpected column selection is, of course, very disorienting to one's eyeballs and brain. Workaround start as above until: F2: make the small edit Enter: terminate the edit RightArrow (once): shift focus from L155 to M155 LeftArrow (once): shift focus from M155 to L155 Ctrl+Shift+RightArrow: SHOULD and DOES extend to AB156 where it finds the next filled cell in the row. I use the M$ Natural Keyboard. The defective behavior results using either of the possible keys for RightArrow: the 4-keypad compass set or the NumberPad (NumLock off). -- David S. Crampton -- 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] How may I read the value of a cell into a macro variable?
This question has two parts: simple and more complex: simple: I wish to read the value of the currently selected cell (in Calc, of course) into a variable in the macro language (Libre Basic). Script example please. and thank you! more complex: AFAIK the LibreHelp does not document the stuff like: dispatcher.executeDispatch(document, .uno:GoToCell, , 0, args2()) I used to be pretty skilled at recording macros and then modifying them. Where do I go to find things related to uno:GoToCell? Universal Network Objects? Can't find the starting point. Thank you for an orientation, -- David S. Crampton -- 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: OO Base will not run in LO Base
A common technique for testing data structures is to populate the data with lorem ipsum text. See: www.lipsum.com. You obtain the text, parse it and de-duplicate as necessary. Load it into your structures. There are many advantages to this technique. In this case the db could be populated, fully functioning, and no personal data is interchanged. -- David S. Crampton On Fri, 28 Oct 2011 18:20:59 -0700, Brian Barker b.m.bar...@btinternet.com wrote: At 17:58 28/10/2011 +0200, Alexander Thurgood wrote: Le 28/10/11 14:49, Ian Whitfield a écrit : I would be happy to put my DB up for examination but I am _VERY_ protective of the contents as it is all personal information of the Members in my Group and I don't want that getting into the 'wrong' hands!! If you send me the ODB file in private [...], I can assure you it will remain confidential (I'm an attorney). I'm always puzzled by this sort of claim. The subjects of this personal information presumably expect that it will remain confidential: that is, not be distributed beyond the audience they anticipated when they provided the information. If it gets to you, that expectation - that confidence - has already been betrayed. It doesn't matter what you promise to do or not to do with the information: if you have it, it is no longer confidential. Perhaps you think that confidentiality is respected if you undertake not to pass the information on to others. But that idea fails too. Suppose that I ask you for the information; following this argument, you would be justified in passing it on to me, provided I promised also to keep it confidential - presumably meaning that I would not pass it further. But there is nothing to stop me then making use of the same exception that you have applied. Do you see where the argument is leading? By this theory, it is perfectly permissible for everybody on the planet to see the information, provided they all undertake to keep the information confidential - with this new, looser, useless meaning. When I offer someone information in confidence, I expect that it will go no further - not even to the recipient's lawyer, let alone someone else's. But you are by no means alone: many people think they can betray any secret as long as they are assured that the next person will behave the same way, receiving the same empty assurance. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] my LO 3.4.3 has no macro recorder
In Calc, there is no Record macro item on the Tools | Macros menu. As workaround, I recorded my simple macro in OOo, saved it into the ods file; opened in LO; works OK. Kind of a house of cards though. How do I add macro recorder to my LO Calc? on Windows XP Pro -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] my LO 3.4.3 has no macro recorder
Cor, And so it is. Now it's extra cool to be running experimental stuff too! Thank you, David On Wed, 19 Oct 2011 15:05:31 -0700, Cor Nouws oo...@nouenoff.nl wrote: Hi David, How do I add macro recorder to my LO Calc? Tools Options General ... turn on Experimental features (bottom) Restart ... There it is ;-) Cheers, -- 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