[libreoffice-users] Re: Data, Filter, Standard Filter won't filter blank cells
Am 25.03.2012 19:15, lagagnon wrote: I have a calc database of about 2000 records. I use Data, Filter, Standard Filter from the main database sheet to select only those records which are "-empty-" in one specific field, and I filter those records into a second calc sheet. Since version 3.5 the filter no longer filters these empty cells (and yes, they really are empty). If I copy a small subset of the database to a test sheet and try the filter it works! What is going on here? Any ideas greatly appreciated. Larry Gagnon -- View this message in context: http://nabble.documentfoundation.org/Data-Filter-Standard-Filter-won-t-filter-blank-cells-tp3855993p3855993.html Sent from the Users mailing list archive at Nabble.com. Works for me with version 3.5.1. Please test if some cell A13 which you assume to be empty: =ISBLANK(A13) -- 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: formatting emails
Am 23.03.2012 20:59, Doug wrote: Interesting problem: An email text is received which you need to format for publication. The email uses a carriage return at the end of each line, and a double carriage return for paragraph spacing. What I'd like to do is remove the cr's at the end of each line, so the text can be justified, and turn the double cr's into paragraph controls, or just leave as double cr's. Obviously all this can be done a line at a time by hand, but it's a pain. Is there any way someone can suggest to automate this? Thanx--doug File>Open... File type: Text Encoded Choose encoding and line feed. -- 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: mail merge duplicates entries
Am 23.03.2012 18:24, Ron Gregor wrote: Does anyone know how to fix this or is this another bug that needs to be filed. It is another bug that needs to be filed AND a simple query can fix it: SELECT DISTINCT * FROM "Your Table" -- 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: saving as docx crashes libreoffice 3.5.1 on windows 7
Am 20.03.2012 13:52, darwinev0lved wrote: Advice, thoughts? Jon There is no technical reason why a user of LibreOffice should save a file in OOXML as long as Microsoft Office provides full support for doc/xls/ppt. Office Open XML (OOXML) is simply a no go area. This pestilence of a file format has been developed to decrease the level of compatibility while having something with "Open Office" and "XML" in the name. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Date Difference formula required in Calc 3.5
Am 22.03.2012 20:01, Essex Lad wrote: Thank you very much - that has solved my query I know that other people a re asking the same question - can I send then your file? That's why it is on the internet. -- 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: Date Difference formula required in Calc 3.5
Am 22.03.2012 19:41, Essex Lad wrote: I realise that I can get a date difference of days or years in Calc, but what is needed is a way of getting a result in Years/Months/Days - any thoughts would be very welcome Dave H. http://user.services.openoffice.org/en/forum/download/file.php?id=7015 -- 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: saving as docx crashes libreoffice 3.5.1 on windows 7
Am 20.03.2012 22:58, Shari wrote: This person is only asking to do what the website says it can. Either it can or it can't. Shari Obviously it can't and e-letter makes a point. -- 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: saving as docx crashes libreoffice 3.5.1 on windows 7
Am 21.03.2012 01:09, Jon Rubin wrote: bangs head against wall. I'm in academia, they aren't going to buy me a copy of MS to use at home. I don't want to buy one. Who benefits? Bangs head again. *I* benefit, if LO can open and save docx with no probllems so that it is transparent. I normally ignore this kind of trolling, but as you rightly guessed, I've wasted several hours trying to get this to work and my patience is spent. Why don't you simply download the free Word Viewer from the MS Office site? -- 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: saving as docx crashes libreoffice 3.5.1 on windows 7
Am 20.03.2012 23:05, Shari wrote: You can try saving it as a 2003 xml and office 2007/2010 should be able to open that. I know in a previous version of Libre this worked for me. Shari 2003 xml is even worse. The one and only file format with 95% compatibility is .doc/.xls/.ppt. -- 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: Install RPM as non-superuser
Am 22.03.2012 18:08, Reinhard wrote: -- View this message in context: http://nabble.documentfoundation.org/Install-RPM-as-non-superuser-tp3848942p3848942.html Sent from the Users mailing list archive at Nabble.com. Simply extract the installation files to some place and call ./libreoffice3.5/program/soffice -- 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: Automate a Data Filter in Calc ?
Am 22.03.2012 00:32, lagagnon wrote: I have a 2500 line "database" in LO Calc with 10 fields per record (line). In a second sheet I want only specific records from the first sheet (the database) which match 3 criteria. I haven't quite figured out how to do that manually with Data, Filter, Standard Filter but it seems possible, but I cannot figure out how to post that filtered data to the second sheet. Under [More Options] you can specify OtherSheet.A1 as target. Also, is there a way to automate it so that, say with a click of a button the filtering takes place? Click a single cell in the source range and call Data>Refresh This reapplies the last filter and/or sort order. -- 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: [Calc} Compare contents of similar records on two sheets
Fields and records describe a database. A spreadsheet is a very poor surrogate for a database. You need to know *everything* about spreadsheet lookups in unordered "database mode": http://user.services.openoffice.org/en/forum/viewtopic.php?f=75&t=46746 -- 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: Indexing a text by concordance file failes
[Solved] Using Concordance for Indexing http://user.services.openoffice.org/en/forum/viewtopic.php?f=7&t=47581&hilit=concordance -- View this message in context: http://nabble.documentfoundation.org/Indexing-a-text-by-concordance-file-failes-tp3833634p3837173.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: AutoFilter Change
Tom wrote > > Hi :) > I don't think LO's Calc is aiming to look exactly like Excel but it does > aim to remain fairly similar so that people find it easy to migrate to > LO. I think it's a lot more configurable than Excel especially with the > Add-ons/Extensions. > Regards from > Tom :) > You may never used Excel. So you don't know about the thousands of Excel add-ons made by professional programmers. That's OK. But sometimes _I think_ you don't use LibreOffice neither. LibreOffice added some dysfunctional bullshit that makes Calc look like MS Excel. The "marching ants" border around a copied cell selection together with the related behaviour of the Enter key is the most prominent example why I prefer OOo Calc over LibO Calc. The switched meaning of Backspace and Delete is the second example, third example is cell back colour that superimpose some visual aid (view grid) but not the other visual aid (snap points). -- View this message in context: http://nabble.documentfoundation.org/AutoFilter-Change-tp3832199p3836745.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: BASE and HSQLDB 2
Am 18.03.2012 01:35, RustyRiley wrote: thanks, after reading the commentr about the "bastard" thought I'd go ahead aand install HSQLDB, especially after reading it was small, fast and siuitable for thr home user, but even this "tutorial" is too advanced for me -- like how do I install it? not familiar with Java program installation, so where do I read about that? thanks again, Russell J. Wilson Dunedin, New Zealand Read today's postings of mine in reply to Marc Stanton (Re: Urgent Base problem) -- 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: Urgent Base problem
Some additions for anybody who wants to follow my receipt: Am 18.03.2012 10:25, Andreas Säger wrote: Extract ./database/ from your embedded database somewhere to your files. Rename your database files with a common "dbname." prefix. The "dbname" in the below URL is "chargen" so I renamed the files "data", "properties" and "script" to "chargen.data", "chargen.properties" and "chargen.script" Connect a new Base document using JDBC with an URL like this one (refer to the downloaded documentation in your libs): jdbc: hsqldb:file:/home/andreas/hsqldb-2.2.5/databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false where "chargen" is the database name and the semicolon separated options improve the look and interoperability in Base. -- 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: Urgent Base problem
Am 18.03.2012 08:56, Mark Stanton wrote: I think the point Mark was making was to switch away from using the embedded back-end to pretty much any external one. Which is what you often suggest too. Yes indeed. Can HSQLDB be used as an external engine? I thought not, which is why I didn't include it. Mark Stanton One small step for mankind... http://hsqldb.org Download the latest version. Put it somewhere in your libraries (no installation required). Point your office Java to the extracted hsqldb.jar. Extract ./database/ from your embedded database somewhere to your files. Rename your database files with a common "dbname." prefix. Connect a new Base document using JDBC with an URL like this one (refer to the downloaded documentation in your libs): jdbc: hsqldb:file:/home/andreas/hsqldb-2.2.5/databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false Copy over the queries, forms and reports from your embedded thing. You get the latest version of a full featured HSQLDB without restrictions, many more functions, the access control and safety you would expect from a database application. You can write a configuration file to run a server for concurrent access. Drawbacks: - Embedded HSQL requires another Java config. I use OOo for embedded and LibO 3.3.4 for "normal" access. - Base can not handle user defined row filters with HSQLDB2. I use my own "power filters" anyway. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Urgent Base problem
Am 17.03.2012 21:20, Mark Stanton wrote: I would suggest replacing the bastard (are we really talking like this? :-) ) with MySQL or perhaps even better MariaDb (mebbe even Postgres). Replacing one excellent databse engine with another excellent (much bigger) database engine will not solve any problem. I run a HSQLDB server and it is the most reliable and fast little software on that Windows machine. On my Linux laptop I run the exact same Java software in cached mode, just like the embedded one but as an independent process with database files outside the Base document. The "embedded HSQLDB" works like an extension. Every time you access the package data, the database gets installed to . When you close the last connection to the installed database, the database is repackaged into the .odb "document". As the database grows, this thread consumes more and more time and during that time there must not happen anything serious to the office suite. IMHO HSQLDB is a well thought choice for a multi-platform database. However, databases should be installed as extension packages so the user data won't be shuffled this way. -- 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: BASE and HSQLDB 2
Am 17.03.2012 20:30, RustyRiley wrote: presuming that's worked out OK, what should I read next -- haven't used this type of technology, and haven't created anything but "embedded databases" before (unaware this was not the best /option). [Tutorial] Avoiding data loss with built in HSQLDB http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=17567 -- 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: handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3
Tinkerer wrote > > Hi Cor > > The way it is now is ideal for what I do, but needs vary. > Your question implies that I might need something extra, I cannot think > what though. > So. If it ain't broke, don't fix it. > > Best, Tink. > It used to work as usual. It has been broken in 3.5. It needs fixing. -- View this message in context: http://nabble.documentfoundation.org/handling-of-quotes-before-text-in-Calc-3-4-and-3-5-changed-compared-to-3-3-tp3810314p3834804.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: Urgent Base problem
Ian Whitfield wrote via personal mail: *Hi Andreas* Thanks for your reply!! Appreciated - although I don't "like" the answer!! I thought to ask you this rather 'off-list' in case. You say I must use a "Real Database Connection" if I want to work with this bastard!! By "Bastard" I guess you mean HSQLDB. OK - I'm fine with that. I do like the front-end of Base and the ease of working with it but am happy to change the DB Engine. (or anything else but would prefer a WYSIWYG development screen like Base has) But my problem is not knowing how to do this!! Or which is the best way to go. What do you suggest I do and where can I get detailed instructions please? My Database is _VERY_ important to me and I use it every day and all day. It contains about 2500+ records of the Members of my Group including two small photos on each record. Total about 70 fields per record and it is single user - just me!! Thanks very much for your kind help. Hi Ian, HSQLDB is an excellent, extensible, cross-platform, stable and fast database engine. Base is a set of tools to connect this office suite to databases which is best used when you avoid most of its most flashy and obvious "features". The HSQL database wrapped into the Base document is the "bastard" which deserves to be handled with a maximum of caution. [Tutorial] Avoiding data loss with built in HSQLDB http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=17567 Extracting an embedded HSQLDB manually under Linux: http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=46324 I'm sure this helps, Andreas Säger -- 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: More mailmerge woes
Am 17.03.2012 11:15, Mark Stanton wrote: The File / Print menu will ask if you want to print a mail merge. Just say yes then enjoy the olde OOo v1 wizard. So it does! That's cute. Unfortunately it only lists tables as data sources, and mine is a query :-( Mark Stanton One small step for mankind... I suspect that you have lots of database documents connected to the same data source because you used the mail merge wizard several times for the same job. Have a look at the database registration which exact .odb is registered as your data source. Open that file and look if it contains the query. If not, find the right .odb file, point the registration to that one. This is how you quickly rebuild the your merge fields: Open the letter, hit F4, point to the query, wait a moment and drag the right column headers next to the existing fields and remove the older ones. -- 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: Urgent Base problem
Am 17.03.2012 11:41, Ian Whitfield wrote: What "filter" must I selct or what must I do to get my Database going again?? You need to restore your database from a backup. It is lost. This would not have happened with a true database connection. The database wrapped in a single document (embedded HSQLDB) is just fine for drafts and demo purposes. If you really want to work with this bastard you should save a backup copy whenever you take a break. Close the file, wait a moment and make copy of it before you reopen the file. -- 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: AutoFilter Change
Am 16.03.2012 17:56, Shari wrote: Again, I don't think an OR is necessary for quickly filtering, that's an /advance/ filter imho. I wasn't aware that the project strove to "look like" Excel. I thought it was to provide an alternative that was free and open source. I've used either OpenOffice or Libre for over 10 years, pushed it into work locations, and many homes. If that is what is happening with this product, I'll be moving on. peace, Your requirements are not anybody elses requirements. I answered your question about the "why?" to the best of my knowledge. I can imagine that ORed auto-filters are useful to many who use Calc as poor man's database (the majority of today's spreadsheet users). -- 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: Address Books
Am 16.03.2012 15:40, Nino Novak wrote: On Friday 16 March 2012, 15:00:41 Andreas Säger wrote: Am 16.03.2012 11:09, Nino Novak wrote: It could be used as reference on how to use Base. Well, this would be like a reference on how to use a programming language. Either you can actually use it or you follow more or less obscure instructions. I rather thought of a reference implementation, not a language reference. A reference tutorial if you like :-) A non-theoretical primer for people keen to learn to create (simple) databases. An initial nucleus ;-) Don't you think, that this would help much more than saying, that it requires expert skills? Nino It would really help if LibO would drop the entire Base component with address sources and everything, letting the user import raw spreadsheet data as embedded XML structures into serial letters. So they get a feeling of empowerment when they freely drag around, import and export their data copies. They would not even blame anyone for the results. An abstraction layer like Base is beyond user's imagination even though it can be used in very creative ways. Using software tools in creative ways is mere expert skill. Erm - yes. However... Sort of ... I'm the wrong person for this kind of discussion. I'm a simple user, who wants to learn, no, wait, who wants to create his own address book using LibreOffice. So please, talk to LibreOffice component architects (or who ever regards himself as appropriate person to discuss dropping components). But please help me to create my simple address book :-) Nino The trick is that you can use any type of address book if you know how to work with software tools in creative ways. Dump your data in a text file, a spreadsheet or (much better) use dBase and then build a query with the right field names matching your letter template(s). This is what nobody really understands. Spreadsheets come very handy to compile lists from csv import, clipboard, keyboard and other connected sources. You can freely drag around data and compile the right male/female greetings together with snippets like [you | insurance owner | your son | your daughter]. But no matter which software I am using, finally the list should match with one of our well prepared letter templates. This requires a more or less sophisticated query with the right alias names. Nobody but YOU can build the right database for your purpose. If your address data cover information about company relations or family relations then you take advantage of a relational database instead of flat dBase, spreadsheet or plain text. This is more about user-ability than usability. But virtually nobody here ever talks about concrete *DATA* to process. Everybody expects some ready-made stuff without any clear specification about ready-made for what. We have several types of address sources and every now and then it is my part to compile tomorrow's address lists fitting to one of our letter templates. Then I leave a note to the co-worker about the source name and query name for the serial letter to print, she opens the template with prepared field masters for address, salutation and stuff, then she sets the right data source, writes the letter and due to a well known "unfixable bug" she specifies the source query once more when printing. She does not bother about file types nor database connections nor field names. That was my job. -- 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: handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3
Am 16.03.2012 16:31, Tinkerer wrote: Cor Showing the apostrophe in front of a number is a great help. If I total a column it immediately tells me which numbers are included in the total and, more important, which numbers are not. Real text does not need the apostrophe. Tink. And it still does the same with numbers and formulas. menu:View>Highlight Values [Ctrl+F8] gives a more clear indication since you see all text in black and numbers in blue. In addition, all text is left bound unless you format your sheet to death (by centered orientation for instance), The problem is that you could use the apostrophe with any type of input. With text it supressed auto-completion and auto-correction. -- 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: AutoFilter Change
Am 16.03.2012 17:23, Shari wrote: I guess I'm just not sure what it adds to change this simple filter. It worked and did what it was intended to do. Yes, if there isn't going to be an additional filter type, then then at least what your suggesting would make it usable. I guess I'm from the school of if it isn't broken why "fix" it. The additional functionality is that filter condition can be ORed now (Show "food" OR "clothing" OR "shoes"). The fix is that is looks like MS Excel now, which in this project is a value in its own right even when it does not work as in Excel. -- 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: Address Books
Am 16.03.2012 11:09, Nino Novak wrote: It could be used as reference on how to use Base. Well, this would be like a reference on how to use a programming language. Either you can actually use it or you follow more or less obscure instructions. Don't you think, that this would help much more than saying, that it requires expert skills? Nino It would really help if LibO would drop the entire Base component with address sources and everything, letting the user import raw spreadsheet data as embedded XML structures into serial letters. So they get a feeling of empowerment when they freely drag around, import and export their data copies. They would not even blame anyone for the results. An abstraction layer like Base is beyond user's imagination even though it can be used in very creative ways. Using software tools in creative ways is mere expert skill. -- 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: Address Books
Am 16.03.2012 11:09, Nino Novak wrote: On Thursday 15 March 2012, 21:49:10 Andreas Säger wrote: First you need some database up and running. The creation of a database requires expert skills and appropriate software tools for the database type in question. IMHO, we should offer a really *short* tutorial on how to create a simple address book with LibreOffice. It could be used as reference on how to use Base. Don't you think, that this would help much more than saying, that it requires expert skills? Nino Again, this is *impossible*. You can not describe how to do that by means of features. You have to describe the process by means of data. There are plenty of references on how to use Base. There are thousands of resources on relational database design in general. This is not a problem. The problem is that too many people try to learn this by doing. But this is something where you need to know some basics before you can do anything. Yes, database design is development work. IT professionals earn their living with this. No, there is no "intuitive" way to define abstract data structures even when you pay for a full featured development suite. The result should be inutuitive but not the development process. -- 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: handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3
Am 16.03.2012 10:30, Cor Nouws wrote: Hi all, Anyone an idea? Cor Nouws wrote (08-03-12 18:33) This is a petty because the leading apostrophe could be used to supress auto-correction and auto-completion of text values just like it supresses evaluation of numeric and formula expressions. -- 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: Address Books
Am 14.03.2012 21:22, Stephanie Dutcher wrote: I work for a non-profit youth organization, and we are trying to figure out a way to organize all of our members' information without a big cost to us. Would I be able to create something like an address book using a template in the LibreOffice Database? I am envisioning something where we can't see all the information right when we open it. I'd like it to be some kind of format where we have to click on a tab or something to view each member's information, and they would have an entire page dedicated to them. Is that possible to do? Thank you, Stephanie Dutcher Yes, you can type some name into a list box, hit tab, followed by enter and get the related record of the selected list box item or a table view with more than one item related to the list box item. This can be done without programming. No, there can not be any such template because each database structure depends on the exact data you are going to store in it. First you need some database up and running. The creation of a database requires expert skills and appropriate software tools for the database type in question. Then you can connect a Base document to that database and add your office related tools which are Writer templates for serial letters, reports and may be some analysis in Calc. Base can create a special type of database Base from scratch which is not suitable for anything more important than your private DVD collection. It is just fine for database tutorials and demos wrapped in a single file. Hope that helps -- 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: Generic formulas or inverse scenarii
Scenarios have a property "Copy Back". If this option is unset, you can still edit the scenario but when you switch to another one this one will be preserved. So this type of "Don't Copy Back" scenario works like a template. You can edit the template, then create a new one from the edited range and preserve the original. -- 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: Generic formulas or inverse scenarii
May be a use case for multiple operations? [Solved] Automatically generate data from a set of values: http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=48274 -- 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: Calc changes cells with . to 0
Am 15.03.2012 03:41, Andrew Koeser wrote: New question. When I selected the "quoted field as text" box in the import prompt, I never had to do this again. The setting was changed for future uses. However, when saving, the "quote all text cells" box is always unchecked. Is there anyway way I could make this the default setting? Quoted text is the default setting when exporting to text. Your last settings should be the default importing settings too, for the current session at least. Insert>SheetFromFile... with "Link" options saves import settings for a sheet within a spreadsheet document. You can save the import settings for a certain type of text files in a so called "Base document" and pull the data through the database component. Loading, editing and saving database exchange formats in spreadhsheets is extremely common but inappropriate since a spreadsheet is neither a database nor text editor. I use to recomment a dedicated text editor for this (and for Windows): http://csved.sjfrancke.nl/ Using some SQL database engine and Base, you can click together your own csv editor for your individual flavour of text tables. -- 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: Calc changes cells with . to 0
Am 14.03.2012 23:40, Andrew Koeser wrote: Hey everyone, I notice that Calc will sometimes change the value of a cell from a period to a zero. I notice it mostly when I save from .ods to csv. This is an issue, as one of the stats software programs I use denotes missing data with a "." Is there an auto-correct setting that I can change so that it will not do this again? Thanks! Andrew A period without any digits gives a text value. 3 tab separated columns of text, date and decimal with points: "a" 02/02/121.98 "." 03/03/1212.5 "b" "." 19 "c" 04/04/12"." -- 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: calc: how to label columns
Am 14.03.2012 20:04, matias kaukonen wrote: Hi all, I would like to assign labels to each of my columns and have them appear instead of A, B, C, ... Does calc support this feature? I searched the help but I did not find the instructions. What do you suggest? thanks. m like 90% of today's spreadsheet users you want a database actually. -- 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: Base and new Report Builder in 3.5
Am 13.03.2012 18:05, Fernand Vanrie wrote: Andreas , Thanks for your interest With "grouping" i meaned having the content of the grouped column on top or at the bottom off the items off the same group. We where thinking on a macro who use a resulstet to fill the spreadsheet cell by cell with some counters who are making a groupheader or footer when the content of a column changed to a different vallue. I look also a bit closer to the pivot tables Greetz Fernand Pivot tables group like this: CategoryA A1 A2 A3 CategoryB B1 B2 B3 B4 CategoryC C1 C2 A conditional format can do the same for flat import ranges. Apply number format "";"";"";"" when this value is the same as the previous value. -- 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: Base and new Report Builder in 3.5
Am 13.03.2012 12:11, Fernand Vanrie wrote: It would be handy to see some examples of how you make reports with calc. We have questions on how to Make headers , footers and grouping somes results ? Greetz Fernand Page headers and footers can not have database content unless you write a macro. But even with a macro the header/footer content will be the same on every page. Of course you can have column headers and column footers with additional formulas. Grouping can be done by the database software (SELECT ... GROUP BY ... ORDER BY ...) or by a pivot table (aka data pilot). Pivot tables are database reports. They follow the exact same logic as a SELECT ... GROUP BY ... query. In addition, a pivot table can utilize the horizontal dimension by means of column fields. http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot -- 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: malfunction opening docx document
Am 12.03.2012 22:39, Maurizio Sapienza wrote: the attached document when opened by Writer 3.4 is totally blank. Using the previous 3.3 release, it appeared missing of some formulas (that drove me to install the new relelase). The pdf file is how it appear using Microsoft word. Is a matter of some configuration parameter, or some fault during installation?Other docx file seem to be correctly managed, so I presume the formulas could be the problem.I hope this mail could help somebody to address the problem.thanksMaurizio Things work much better when you exchange .doc rather than .docx with WinWord users. The new MS Office file formats are not an option yet. Currently there is no technical reason to prefer docx over doc. -- 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: OOoBean
Am 12.03.2012 19:16, Robson Peixoto wrote: Hi, I'd like to embed the Write in a java application, but on Mac OS X doesn't has the libofficebean and OOoBean. Is possible embed the Writer without it ? How? Hi, http://www.oooforum.org/forum/viewtopic.phtml?t=9883 This is a macro which creates a new top window using the built-in UNO toolkit. Then it adds 2 subwindows with a new presentation and a new spreadsheet side by side. I think you can do the same with a Java window and a listening instance of LibreOffice. Hope this helps -- 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: Base and new Report Builder in 3.5
Am 11.03.2012 19:48, tops wrote: Hi all, I have been using OO and LibreOffice prior to 3.5 with Base and Reports. Now the Reports in 3.5 can not be used any further, instead I had to try (despair) and create new Reports using the Oracle Reports Tool. IMHO this is a major leap backwards… It is very, very slow on my Mac (2.13 GHz Core2Duo), it does somehow not save my new generates Reports. If I choose the Table Model it will write the Column Heading repeatedly (I did not find a way to prevent this) on each Row. To Adjust the Columns and Rows is REALLY Painful. It is no longer possible to use Fields i.e. Page Numbers. Despite setting the Format to A4 Landscape the GUI will limit placing Labels further than 200mm of a Portrait A4 Page. I prefer Calc as a simplified report engine. It supports more math functions than anything else. It provides the "natural" surrounding for charts. It supports dynamically linked, (conditionally) formattable import ranges, pivot tables, secondary filters and sort orders. It is the only report format which can be loaded from any form with a click on a simple hyperlink. All you have to take care of is the proper page layout. [Tutorial] Using registered datasources in Calc: http://user.services.openoffice.org/en/forum/viewtopic.php?f=75&t=18511 -- 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: Enable JRE Alert when starting Writer document
Am 11.03.2012 22:44, bernie12 wrote: Any ideas here? Thanks! This office suite runs perfectly well without any Java. Disable the use of Java in Tools>Options>Java. The following features will not work: File>Wizards>Letter,Fax,Agenda,Web page File>Export>XHTML Connections to Java databases. A new database will be created as dBase directory. -- 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: CELL() doesn't show the cell content of another CALC file
Am 10.03.2012 19:59, csanyipal wrote: Andreas Säger wrote The CELL function is there for some historic reasons. Very old documents from other applications may use it. Except for the "filename" option there is no use for it in Calc. So which function can be used instead of CELL function? =CELL("content";A1) returns the exact same value as =A1 does. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: CELL() doesn't show the cell content of another CALC file
The CELL function is there for some historic reasons. Very old documents from other applications may use it. Except for the "filename" option there is no use for it in Calc. -- 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: This is how I got LibreO installed and working
Am 09.03.2012 13:40, Pertti Rönnberg wrote: 4 >> the Java/JRE is said to be a must for both OO and LO; This is a rumor. Both suites run fine without any Java. You can check it out when you disable the use of Java components in the Office options. It is rather unlikely that the avarage user will miss anything. _On a Linux system_ you can install as many OOo/LibO suites as you like. I never uninstall anything before upgrading. If any of the office suites shows unspecific weird behaviour it is always some broken setting or incompatible extension in the profile folder which is not affected by any installation routine. It is possible to run an office suite from extracted package files only without any installation routines. This way minor releases (3.4.x and 3.4.y) can be used on the same machine. -- 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: Calc macro to open tab delimited data file?
Am 08.03.2012 06:54, Andrew Douglas Pitonyak wrote: I believe that a sample solution can be found in AndrewBase.odt, search for the macro listing "Prompt for a CSV file, and then display the data." Right, your AndrewBase.odt demonstrates how to load plain text database data into the database component, with or without macros. In the Base tutorials of http://user.services.openoffice.org/en/forum.php we find tutorials and examples about loading plain text database data into 2 different types of databases without any macro code and this is what I suggested in the first place. With the help of the built-in HSQLDB we can design your own csv editors for specific types of csv files. Once you have these data in Base, a drag&drop dumps them into any other component. Your latest draft of your macro document http://www.pitonyak.org/OOME_3_0.odt deals with MediaDescriptor and FilterOptions providing a routine to display all arguments that had been used to load a file. But the issue here is that "fork" insists in using one particular calculating tool called "spreadsheet" but in fact he hates using any tool at all which is why he nags people to write him a tool on top of the tool. Today's even more blatant example of not using a software tool: http://www.oooforum.org/forum/viewtopic.phtml?t=145216 Finally he hired a coder because he can not apply simple formulas. While "fork" is waiting for a lazy person who writes a csv import routine for tab separated files with unknown encoding, unknown text delimiters, suppressing evaluation for an unknown amount of columns, he may try a dedicated csv editor which helped so many spreadsheet non-users: http://csved.sjfrancke.nl/ -- 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: Calc macro to open tab delimited data file?
Am 08.03.2012 01:48, fork wrote: Andreas Säger t-online.de> writes: Am 07.03.2012 22:03, Johnny Rosenberg wrote: A Tab delimited text file – what more could we want to know? 4 different lines of tab delimited text each with 4 identical values: 2012/03/08 1,213.59text7-8 "2012-03-08" "1,213.59""text""7-8" 8.März1201213,59text7-8 03/08/2012 $1213.59"text""7-8" [...] to be continued with dozends of variants Ahh -- I think the reason behind some of the confusion is becoming clearer... I want to manipulate *dumb, uninterpreted* text. So "03/08/2012" would not be the same thing as "2012-03-08", since both cases would be just a bunch of meaningless characters, but different meaningless characters. Then you do not want any spreadsheet at all. At least there is no technical reason to use this dinosaur software for plain text. This is covered by a tiny but very powerful text editor for text tables and Windows: http://csved.sjfrancke.nl/ -- 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: Calc macro to open tab delimited data file?
Am 07.03.2012 22:03, Johnny Rosenberg wrote: A Tab delimited text file – what more could we want to know? 4 different lines of tab delimited text each with 4 identical values: 2012/03/08 1,213.59text7-8 "2012-03-08" "1,213.59""text""7-8" 8.März1201213,59text7-8 03/08/2012 $1213.59"text""7-8" [...] to be continued with dozends of variants The import dialog covers all these situations plus dozends of character encodings. If you google for macros to load csv you will find dozends of ready made solutions and all of them use a different set of FilterOptions. The FilterOptions are bundled in a complex string that reflects all the settings of the import dialog. http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/OfficeDev/Handling_Documents#MediaDescriptor http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide/StarDesktop http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options -- 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: Calc macro to open tab delimited data file?
Again, it is technically and logically impossible to write a program without knowing anything about the input. If you can not copy a few lines of text from a text editor, then I will have to explain too many details anyway. End of discussion. Bye. -- 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: Calc macro to open tab delimited data file?
Am 07.03.2012 19:24, fork wrote: Andreas Säger t-online.de> writes: May be you did not notice that LibreOffice remembers the import settings for text files. If you need to open the same type of file repeatedly, you can specify the import options once and next time you simply confirm the dialog. Yes, and that is great. The only steps I want to streamline are (1) the drop down to get to "csv/text", and the step where I choose all columns to be text format. And really, I would like to avoid confirming the dialogue. It works fine the way it is, it is just that I open hundreds of these things a day, and getting rid of 4 clicks per document would be a real time saver. How many different keystrokes does it take to write a macro compared to the Enter key you are supposed to hit in order to confirm the dialog 10 times a day? 50 times? Better you hit Enter a thousand times. My contingent of silly Basic code is exhausted for the rest of the week. -- 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: Calc macro to open tab delimited data file?
May be you did not notice that LibreOffice remembers the import settings for text files. If you need to open the same type of file repeatedly, you can specify the import options once and next time you simply confirm the dialog. -- 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: Calc macro to open tab delimited data file?
All that "Inelligent Technology" is about data processing. Input > Processing -> Output. Without knowing anything about the input there is no way to write any program to process data. Programmers are lazy because they know how to write routines to solve the same problem once for all times. You are not a programmer. You want others to write some program for you without the faintest specification. I showed you a way how a user can configure this integrated office suite so a most simple drag&drop reads text data into Calc (and Writer btw). For anything else you can hire a lazy person. -- 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: Calc macro to open tab delimited data file?
Am 07.03.2012 00:35, fork wrote: I can provide any more info if anyone would like. A couple of lines of actual data copied from a text editor tell more than thousand words. P.S. -- I don't really want to get good at macro writing, so I am hoping for the very quickest quick hack, rather than the 500 page introduction to LO Basic. No judgements implied, just expediency. So you need someone who does the entire work for you which is impossible without seeing any data. I use to suggest a configured solution rather than a programmed one. Collect all your similar csv in one dedicated directory. The similar files should share the same file name suffix, delimiters and encoding. Now you can read this directory of text files as if it were a collection of database tables. Database tables can be used seamlessly in Writer and Calc. File>New>Database... [X] Connect to existing database of type "Text" [X] Register the new database Save the new database which is just a configuration file Close the new database and forget about the database for now. In Calc: 1) Create a new file. 2) Hit F4 to get the data source window, select one of the tables _icons_ on the left and drag it into a cell. 3) Apply all the (conditional) cell styles, additional formulas, charts all the things why you want to use a calculator with text data. 4) menu:Data>Define... and pick the database "Import1" which represents the currently imported range of data, click "More Options" and check the 2nd and the 3rd option. 5) Save the file as a spreadsheet template. Using the newly configured spreadsheet template: 1) File>New>Template... 2) Hit F4 3) Drag the table over the existing import range and confirm to replace the old data with the new data. Alternatively, you can store a fixed document with an import range bound to one particular text file, say "CurrentData.csv". Check the additional 4th option for the import range so the data won't be stored with the document. Usage: Replace the file CurrentData.csv with a new version, open the document, confirm to refresh the unsaved import 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
[libreoffice-users] Re: Spell check problems
Am 06.03.2012 15:16, Edwin Matheson wrote: I want to thank everyone for trying to help me with my spell check problem. However, I still have the problem. Spell check tells me that every word in my doc. is spelled wrong. I still have OpenOffice on my computer and I was able to get into the system (it usually crashes) I pulled down every window in both OpenOfffice and Libreoffice and compared all the settings. English (USA) is set everywhere possible in both systems. Yet, spell check works perfectly in OpenOffice and won't work at all in Libreoffice. So I have no choice but to uninstall Libreoffice and look for another system. Thanks again for all your help. Ed Matheson When you open a new document in LibreOffice and then menu:File>Properties, do you see any template mentioned at the bottom of that dialog's first tab? -- 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: Subforms in LibreO-Base
Am 06.03.2012 19:28, Pertti Rönnberg wrote: Andreas Säger, In your answer to Sylvain Bromberber (about "Table format") you mentioned that you set /"that property to "Parent Form" for all subforms of the main form"/. Do you mean that you in LibreO-Base can have two or more subforms in one main form? Forms with subforms and list boxes let you edit related data across table boundaries. This requires that you can build arbitrary complex hierarchies of forms and subforms, including more than one independent main form on the same form document. Just leave behind that stupid form wizard, open the form navigator (5th button on tool bar "Form Design"), right-click the "Forms" icon to add a new main form or right-click an existing form to add a dependent subform. -- 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: Table Format
Am 06.03.2012 19:25, Sylvain Bromberber wrote: Hi Pertti, All that worked as you described. I found 'Navigation bar'. It was already marked "yes"! But no visible navigation bar with the icon on your example! Picking "Parent form" instead of yes made no difference. What is going on? Let me say again how much I appreciate the time and thought you put in helping me. Sylvain Something else disables this toolbar which is essential for using most database forms. Find your profile folder. You find the profile folder when you call Tools>Options>Paths and watch for the path that looks like .../LibreOffice/3/user/. The ... depends on your system. Shut down the office including the quick starter. Rename that folder. Then restart the office. It will create a new profile folder as if it were started for the very first time. Now you should be able to use all the toolbars. -- 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: Table Format
Am 06.03.2012 16:00, Sylvain Bromberber wrote: That picture was very helpful! However I still can't do it. I cannot get that Form Navigation tool bar to show up, as in your picture, or that icon to be added to any toolbar. I click on "Form Navigation" for toolbars when in a form and the option is available, and it is checked but nothing like the toolbar on your picture appears, nor does that icon seem available anywhere. Puzzle! As already mentioned, the designer of the form can disable the toolbar. By default it is enabled. Open the form in edit mode, get the form properties and enable the navigation bar on the "Data" tab. In my forms the toolbar always refers to the main form since I set that property to "Parent Form" for all subforms of the main form. -- 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: Table Format
Screenshot http://www.mediafire.com/i/?r49k545au99e2wb -- 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: Table Format
Am 05.03.2012 18:30, Sylvain Bromberber wrote: I don't think that I have that last button on. I either have the wrong toolbar on or I have to add a button to it, but I don't know what button. Thanks for your help. Sylvain The toolbar with all the buttons to let the form user interact with the loaded form by navigation, delete, save, reset, filter, sort. The last button is the one which opens the additional grid view. The navigation bar may have been disabled in the form properties. Download this: http://user.services.openoffice.org/en/forum/download/file.php?id=11250 and open any of the forms. The navigation bar refers to the records of the respective main form. -- 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: Table Format
Am 05.03.2012 02:43, Dennis E. Hamilton wrote: Are you on a laptop? Your function keys may have as default actions the control of laptop display functions and other provisions. (These are usually signified by a variety of symbols.) Usually, there is a way to obtain the F4 key function. If the legend is in blue, look for a blue Fn key down in the bottom row of the keyboard. Hold that key depressed and then press the F4 key, then release them both. - Dennis The F4 shortcut is the wrong answer because F4 calls the datasource window with tables and queries of the embedded form's database. Command .uno:ViewFormAsGrid is accessible from the navigation tool bar's last button. -- 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: Calc DATEVALUE() accepts only locale format
Am 04.03.2012 22:35, Ferry Toth wrote: Couldn't datavalue take the locale of the formatted cell? Or is there a better trick to ge this done? The same probably holds for other localized conversions as well. Ferry Convert the text to number using the appropriate formulas and locale. Copy&Paste-Special the resulting numbers without formulas. Format the numbers any way you like. -- 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: Table Format
Am 04.03.2012 19:12, drew jensen wrote: On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions? With any form open hit the F4 key...that should do it //drew Sylvain If Sylvain wants the additional grid view, that is accessible from the last button on the navigation tool bar or using a hyperlink button with URL ".uno:ViewFormAsGrid". -- 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: Presentation conversion to/from Powerpoint - layout
Am 04.03.2012 21:59, Dag Wieers wrote: Yet, the link you carefully removed from my mail was *your* answer to my mail to e-letter's mail: http://www.mail-archive.com/users@global.libreoffice.org/msg17560.html So we are not discussing whatever mail you initially send to Roger, we are discussing the tone and content of e-letter's mail and how the LibreOffice project is representing itself to users. And e-letter is doing it again, Roger is offering to report a bug and is discouraged from the very start. Way to go ! I can't see anything wrong with e-letters statements. If you don't like his style ignore him. -- 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: Help with date formatting
Am 03.03.2012 20:00, Duncan Murdoch wrote: - I want to be able to cut and paste lines from a web page into the file, to make small updates. This is why I'm using Calc for editing. OO lets me paste data and it gets treated as I want. Hopefully with your suggestions for configuring LO, it'll do the same. Collect the pasted HTML data on a sheet template if Calc handles the data the way you want. You can use a template sheet with the right locale and format settings in the right order of columns. Just paste the HTML as unformatted text which will preserve the formatting of the target cells rather than the HTML formatting of the source. Instead of saving the sheet as csv you may also paste the used cells into a text editor before saving which produces tab separated text with the numberic strings as displayed on the sheet. If some other software is supposed to read your data, English decimals with digits and one point only are the universally understood output formats for dcimal numbers, dates as ISO dates, percents as decimal fractions: Raw ISO data like this ... 23123.982009-08-30 13:45:59 0.23 are more universal than localized format strings: EUR 23'123,98 8 Aug 2009 1:45:59 pm 23,00% Including thousands separators, currencies, units or localized dates is counter productive when the importing software is interested in plain numbers or date values. All databases import English numerals and ISO dates without problems. -- 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: Queries wizard in Base
Am 03.03.2012 16:09, Sylvain Bromberber wrote: I do have Java installed. By the way, it worked fine while I was still using Open Office. It works with all versions of OpenOffice.org, LibreOffice 3.3.x and it broke unnoticed somewhere in the development process of LibreOffice 3.4. The other 2 methods to create a query still work fine. The wizard did not add anything that could not be done in the designer. -- 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: Queries wizard in Base
Am 03.03.2012 14:43, Sylvain Bromberber wrote: The Queries wizard in my Libre Office 3.05 simply does not work. Nothing happens when I click on it. Queries through Design works fine. I tried by starting a new Base file to determine whether the problem was with the base file on which I was working but same problem: nothing happens when I click on the wizard option to form a query form. Is there a fix? Sylvain Don't bother. That wizard is completely useless anyway. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Help with date formatting
Am 03.03.2012 14:19, Duncan Murdoch wrote: I have recently switched from OpenOffice to LibreOffice (version 3.5.0), and am having problems configuring it to handle dates in the same way. These are the problems: 1. I want to maintain a CSV file containing dates in the format DD/MM/YY. When I read that file into OO, the columns containing those dates were automatically recognized as date columns, not text columns, and the dates were read correctly. Is there a way to configure LO to do the same? For example, some typical lines at the top of the input file might look like "Date1","Date2","Text1","Value1","Text2","Text3","Value2","Value3","Value4" 02/03/12,02/03/12,"TEXT",,,"TEXT",,,-100 01/03/12,01/03/12,"TEXT",1,"TEXT","TEXT",,,5.95 and the dates are March 2, 2012 on the first line, March 1, 2012 on the second. 1) OOo 3.3 and LibO have a locale setting as import option. Any locale setting other than English(US) might import 2/3/12 correctly. Just try English(UK). 2) Check the "special numbers" option which evaluates any numeric expression even if it is not a plain decimal. 2. I would also like the dates to be displayed in the same format within LO. Currently it thinks those lines are text, and displays them like that, but of course sorting fails. If I manually tell it that those are DMY dates when I read the file, they are displayed as -MM-DD format after reading. I can manually set the format to the user defined DD/MM/YY format, but it doesn't display that way in the data entry line, it displays as -MM-DD format. This is impossible to do by means of direct text import. Calc interpretes the incoming raw text data according to your import settings and enters the resulting values into a brand new unformatted sheet. CSV includes raw data for data exchange between database applications. 1) With the help of the Base component you can import the raw data into preformatted sheets. 2) You may use the built-in database engine to create a customized edit form for your particular flavour of csv where the entered data always produce a specified flavour of csv. 3) I use to recommend this tiny but extremely useful text editor for csv: http://csved.sjfrancke.nl/ 3. If I manually enter a date into a cell, I would like the same thing to happen. Currently if I type 02/03/12 as data, it is converted to the date 2002-03-12. Nothing wrong with the ISO format as long as the value is the same as intended value. You are free to apply any locale setting (globally or document specific) and any number formatting you like. This has no effect on your cell values. 4. If I write that CSV file back out to CSV, I would like it to maintain the same DD/MM/YY format. A calculator is definitively not the most appropriate tool to edit and write database data. I suspect all of this could be fixed if I could find some localization setting that says dates are by default formatted as DD/MM/YY on both input and output, but I can't find that setting. Is there such a thing? Duncan Murdoch 1) Tools>Options>LanguageSettings>Languages: "Locale Setting". This is the default for all numerals in the entire suite, including brand new unformatted sheets. 2) Cell Stlye "Default", number format locale: overrides the locale for all dependent cell styles of this document. Does not affect brand new unformatted sheets. 3) Number format locale of any other cell style: Overrides the locale for a certain type of formatted cells. 4) Hard formatting the number format locale menu:Format>Cells... overrides all styles for the current cell selection But the last 4 points do not override the general concept that raw text data get imported into a completely unformatted new sheet. In this particular case the global locale setting "English(UK)" may tweak that unformatted new sheet so it meets your requirement. -- 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: Python uno object comparison change in 3.5
Hi, Your 3rd line is supposed to be: TABALIGN_LEFT = uno.Enum("com.sun.star.style.TabAlign", "LEFT") With this modification I can run your code with various Python runtimes of OpenOffice.org as well as LibreOffice 3.3: $ $OFFICE unocmp.py A: uno.com.sun.star.style.TabStop A: (com.sun.star.style.TabStop){ Position = (long)0x3e8, Alignment = (com.sun.star.style.TabAlign)LEFT, DecimalChar = (char)'.', FillChar = (char)' ' } B: uno.com.sun.star.style.TabStop B: (com.sun.star.style.TabStop){ Position = (long)0x3e8, Alignment = (com.sun.star.style.TabAlign)LEFT, DecimalChar = (char)'.', FillChar = (char)' ' } A==B: True True FIELDS: Position True Alignment True DecimalChar True FillChar True Python of LibreOffice 3.5 gives: terminate called after throwing an instance of 'com::sun::star::registry::InvalidRegistryException' This is my Python code including the correct indentation: import uno from com.sun.star.style import TabStop TABALIGN_LEFT = uno.Enum("com.sun.star.style.TabAlign", "LEFT") if __name__ == "__main__": a = TabStop() a.Position = 1000 a.Alignment = TABALIGN_LEFT a.DecimalChar = '.' a.FillChar = ' ' b = TabStop() b.Position = 1000 b.Alignment = TABALIGN_LEFT b.DecimalChar = '.' b.FillChar = ' ' print 'A:', type(a), a.__class__ print 'A:', a print 'B:', type(b), b.__class__ print 'B:', b print 'A==B:', a == b, a.value == b.value print 'FIELDS:' for field in ('Position', 'Alignment', 'DecimalChar', 'FillChar'): print ' ', field, getattr(a,field) == getattr(b,field) -- 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: Presentation conversion to/from Powerpoint - layout
Am 02.03.2012 19:25, Dag Wieers wrote: I didn't reply to your post in this thread. I was replying to e-letter's post. Maybe you got lost and assumed I was replying to your post, I don't know. I wonder who got lost in this thread actually. This is the only answer to e-letter: There is nothing sensible in spelling Microsoft as 'm$', being condescending to users and force your opinions on others. It is not followed by any other posting. -- 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: Presentation conversion to/from Powerpoint - layout
Am 02.03.2012 23:41, Roger Sawkins wrote: Well, having had your little spat I see we have got back to suggestions as to what I might do about my problem. Bear in mind I am new to this game. There is a suggestion of reporting a "bug". I realise there is a link for that, but what is the best way? Should I include a sample of a Ppt conversion (and vice versa) with examples of the problems, or just list them. Incidentally, there has been some comment about the 'different fonts on different machines'. I am using Times New Roman (plain and bold) and as far as I know that is available on any Windows machine, so presumably that is not causing the problem. Roger -- View this message in context: http://nabble.documentfoundation.org/Presentation-conversion-to-from-Powerpoint-layout-tp3782543p3794938.html Sent from the Users mailing list archive at Nabble.com. Thank you for the feedback. First register, then log-in and give a short description of your problem. Submit the report and finally attach the .ppt in question. Don't hold your breath. This type of conversion flaws is a never ending story because of the special ways how MS software interacts with their own specific file formats. This is supposed to be incompatible with anything else. That's how they run their big business. Greetings, Andreas P.S.: I forgot to mention another solution which adds full ODF compatibility to MS Office: http://sun-odf-plugin.soft-ware.net/download.asp -- 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: Presentation conversion to/from Powerpoint - layout
Am 02.03.2012 23:17, Dag Wieers wrote: On Fri, 2 Mar 2012, Andreas Säger wrote: So what do you reply to Roger Sawkins? That he can file a bug report hoping that some day in future LibreOffice will fully support the extinct ppt format? Yup, with the help of the community we can improve LibreOffice so that in the future people are more happy with the PPT import/export filter. For this to happen we need good information and simple test-cases showing the ill-behavior. IMO that's a better response than the original: Your are wasting your time. Make a cost-benefit analysis and decide whether to use either LO or m$; do not bother trying to use both. There's no guarantee that Roger will take the time to do this, and there is not guarantee that someone will pick up the bug reports. But it is guaranteed that if we tell people they are wasting their time using LibreOffice in a certain way, no progress is made on that front. Which would be a true shame. I did not write the above quote. My answer was a completely different one, trying to help based on the OP's current setup with both office suites LibO and MSO. Installing the same software on both machines is a solid and viable solution rather than a question of partisanship. This is a massive waste of developers time. After all those years of co-evolution of Star/Open/LibreOffice with MSOffice, open source experts still struggle with very subtile details of their legacy file formats plus the massive load of problems imposed by their "Office Open XML" type of thing. At the same time ODF goes down the drain because many commercial and non-commercial software projects do not get any support in supporting ODF. For MSOffice users another option is still available, despite the efforts that have been taken by Oracle to remove it from the scene: http://sun-odf-plugin.soft-ware.net/download.asp -- 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: Presentation conversion to/from Powerpoint - layout
So what do you reply to Roger Sawkins? That he can file a bug report hoping that some day in future LibreOffice will fully support the extinct ppt format? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Simple Base questions accessing a CVS file
Am 02.03.2012 18:12, Dan Lewis wrote: Specifically, a CVS formated file can be accessed by Base. Among the format choices is thousands separator. Will Base access a CVS file that uses a thousands separator and show the numbers with it? (1,000,000 or 1.000.000?) Or, will the field containing these numbers have to be formated to exhibit it? --Dan I would not call this "format choices". It is about import options which control how a snippet of text is going to be interpreted. First and foremost Base should be able to read the correct numbers. Then you can display these correct numbers in any way of formatting you like in table cells, Writer fields and form controls. If 1.000.000 is imported as text, number formatting has no effect. Same when you import csv into Calc where you choose the locale context of the numbers your are going to import. Each locale has one particular pair of decimal separators and thousands separators. Once you imported the correct numeric cell values the formatting is secondary. -- 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: Presentation conversion to/from Powerpoint - layout
Am 02.03.2012 12:33, Dag Wieers wrote: What does flying/swimming cars have to do with improving the existing PPT import and export filter ? It's the economy! Only dreams are free. Of course everybody wants the magic soft to open each and every proprietary file format of computing history. There are limitations in software development just like there are limitations in the physical technology. I am not denying there are limitations, but I refuse to believe we have come to the point we have reached any such limitation. Again, why don't you refer to the OP who does not work with a magic future version. His questions are about today's LibreOffice and the same user has MS Office installed on another computer. He can choose between both suites with their respective native file formats but realistically he can not expect too much interoperability for presentation documents, particularly when the font sets differ on both machines. I don't know what you are afraid of, but fear is the path to the dark side. Fear leads to anger. Anger leads to hate... All I wish is a little more self confidence regarding the ODF standard. We don't need a third decade where virtually everybody is occupied with MS interfaces, MS documents, MS browsers, MS APIs, MS protocols and extensions of all kinds. -- 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: Presentation conversion to/from Powerpoint - layout
Am 02.03.2012 12:40, Dag Wieers wrote: On Fri, 2 Mar 2012, Andreas Säger wrote: Am 02.03.2012 09:41, Andreas Säger wrote: Please read the original posting and my reply. Then try to contribute something helpful and substancial. This is far from religious war. It is all about a reasonable workflow with this software or with the other one and how to find some way to exchange documents between both office suites when it is really necessary. -- 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: Protection in Calc
Just like in Excel, OpenOffice.org and Gnumeric, the document protection protects the order, visibility and naming scheme of the sheets collection. You can not rename, insert, copy, move nor delete sheets. Sheet protection protects all locked cells against modification. By default all cells are locked. When you have unlocked the cells you want to be editable, sheet protection will protect all the locked cells. -- 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: Tell me it's not true
Am 02.03.2012 04:25, Andrew Douglas Pitonyak wrote: What is wrong with telling someone not to use base??? The purpose of free software is freedom to use other tools; noone said it had to be a traditional office software product. I remember being advised by OO users to use R for statistics; it was the appropriate advice at the time. Note that I did not advise against it, I merely stated why I don't use it much anymore. Nor did I. Base is our most used component. We run 4 PCs where at least one Base form is open all the time during the work day. And of course we use Base together with a free database server since the freedom of use includes the obediance to standardized interfaces. We have no spreadsheet nor letter template that is not bound to a data source of some kind. Base saves us a lot of money because we don't have to buy all the additional modules of our licensed software. Base has a lot of most prominently shown but most obsolete wizard tools which are not required to work productively with databases. Quite often these wizards do the wrong thing or they do the right thing wrongly. So I recommend not to use the most prominently shown parts of Base. Using the manual desingn tools together with the command line is by far more productive if you know what needs to be done. This is what this whole thread is about. Letting Mark Stanton build a Writer report based on alleged relations between his dBase tables although the built-in driver does not support relations, thus it can not merge the contents of different tables. -- 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: How to create a custom control on a form?
Am 01.03.2012 23:38, Ferry Toth wrote: Is there an easy way? We would like to put an 'agenda' (like daily/weekly/monthly tasks) control on a Base form. Any suggestions? Ferry You can use an ordinary one-to-many relation where each task has one period type (list box with period name and id) together with a subform which displays the last execution of the main form's task. "Execution" is another one-to-many relation where each action belongs to one task. -- 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: Tell me it's not true
Am 29.02.2012 14:36, e-letter wrote: Interesting; suggests that base exists just to answer the question by m$ fans: "where is the equivalent to acce$$? Right, at a first glance it is nothing but Access mimicry. Maybe base should be removed from LO entirely and a separate database product be developed, perhaps able to include some aspects of the "spreadsheet paradigm" to data manipulation. The "spreadsheet paradigm" does not work in a database. The purpose is to be compatible with *any* of the commonly used SQL servers while treating tabular files in the context of the database paradigm. For instance, Base reads a spreadsheet so its list content can be used as if it were a structured database. It is not intended to be the other way round. Apart from this, nothing will ever stop people using the calculator to organize their data in crude ways. They do not follow any design concepts and the spreadsheet allows them to dump their stuff any way they want. So be it. All the connectable external database servers do not provide anything like a "spreadsheet paradigm". The functionality of a database is completely different to spreadsheets. It is analogue to bitmaps and vector graphic. Something like the MS Works database rolls completely on its own proprietary rails. The development of such a component would be expensive and the result would not be as useful as the current database connectivity. Just drop these "easy peasy" database development toys. There is no need to create databases from scratch. Other programs do this perfectly well and the resulting structures can be connected to this office suite. Except for the report generators, the database toys are obsolete. Report generation is a unidirectional process which yields ODF documents. Form design is more like writing a program for an alleged end user. The program needs to read from and write to the underlying database. This is where wizard technology falls way too short unless you invest extreme amounts of development resources. The simple tools that are provided for manual from design are very well suited but unknown and undocumented. -- 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: Presentation conversion to/from Powerpoint - layout
Am 02.03.2012 09:41, Andreas Säger wrote: OK, can open source make my car fly and swim if I only wish hard enough? There are limitations in software development just like there are limitations in the physical technology. MS has the big truck and refuses to carry the comparatively small ODF payload. Instead they do nothing and watch how "we" spend a lot of time struggling with their huge payload on a comparatively small truck. Forgot something: MS is well aware of the psychological impact. To the innocent users our project looks silly in its ongoing struggle with an ever growing MS payload, whereas they do not expose any weakness simply doing nothing. Finally, LibreOffice 6 will be an alternative OOXML suite with ODF as legacy file format to be dropped in version 7. That will be the point when MS intruduces the next shit. -- 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: Presentation conversion to/from Powerpoint - layout
Am 02.03.2012 01:49, Dag Wieers wrote: Why are you so defensive ? Open Source thrives on people that are interested in a certain subject, and one of those subjects could be improving the PPT import and export filters. Even if you personally are not affected by such improvements, why would you go against any such progress ? Why can users that experience a problem not report this to the benefit for those who would like to see this fixed ? Why are you concerned with what other people are willing to spend their free time (or maybe even paid time) on ? It's one thing to have a personal preference over what *other* people do, it's a completely different subject if one is being condescending to users who have different expectations or use-cases than yourself. OK, can open source make my car fly and swim if I only wish hard enough? There are limitations in software development just like there are limitations in the physical technology. MS has the big truck and refuses to carry the comparatively small ODF payload. Instead they do nothing and watch how "we" spend a lot of time struggling with their huge payload on a comparatively small truck. Finally, LibreOffice 5 will be an alternative OOXML suite with ODF as legacy file format to be dropped in version 6. -- 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: Tell me it's not true
Am 01.03.2012 23:02, Mark Stanton wrote: Hi Andrew, Was that instability with an "internal" HSQL database? Mark Stanton One small step for mankind... The .odb file claims to be a document but in fact it is an extension. When you open the file and then open one of its objects, the embedded HSQLDB will be extracted to the temporary office directory so it works exactly like an external database in cached mode. If your form/report/other office component crashes during this installation process, the whole backend database is lost. Similar problem when you close the "document" and something weird happens during the repackaging. Sometimes you can reconstruct the backend from the temporary files. According to the forums, the total loss of an embedded HSQLDB happens quite often. This flaw is the total knock out for any program that claims to be a database. I used to use one fairly complex embedded HSQLDB for a period of 18 months. The development time was a full weekend for the backend and simple forms plus another weekend for the advanced forms. I worked with it one hour per work day beeing the one and only operator of that thing. It grew up to a document size of 5 MB. I made a backup before every session but this particular file always worked reliably and never crashed. I did not need any macros at all since I know some SQL tricks and I am not miffed because of one click more than necessary. So yes, I made my own positive experience with that "embedded HSQL". Nevertheless setting up a database server in order to work with "the real thing" is such a tiny effort and it can give so much more safety, security and performance that I do not recommend the embedded version. -- 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: Tell me it's not true
Am 01.03.2012 22:19, Andrew Douglas Pitonyak wrote: I created a few databases but I found them unstable By that, I mean that things would simply stop working after an upgrade or after too much data had been added (by large I mean too many images so the dataset took many MB rather than too many records). The last time it happened, I just stopped using it rather than attempting to find and fix the issue. Toying with writing my own application in C++. Images work well when you keep them in files and bind a picture control to a text field holding the relative URLs. Writing a macro to fill a list box with file names and creation times is easy. -- 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: Presentation conversion to/from Powerpoint - layout
Am 01.03.2012 15:20, Dag Wieers wrote: On Tue, 28 Feb 2012, e-letter wrote: On 28/02/2012, Roger Sawkins wrote: I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. However, when loading Ppt in Presentation it does not always convert font and layout properly. Occasional tabs or spaces are missing or duplicated; occasional text boxes have text outside the slide, etc. Your are wasting your time. Make a cost-benefit analysis and decide whether to use either LO or m$; do not bother trying to use both. Are we being rude today ? The case Roger describes is something we all encounter when exporting/importing PPT documents. And while we do not control how (various) Microsoft products behave when using ODF, we can undoubtedly do a better job at making sure the import from and export to PPT (and PPTX) is smoother. Really? Can we realistically do a better job when millions of users want another set of MS features each and every day? When downloading the Microsoft *viewers* for WinWord, Excel and Powerpoint, these three *viewers* cover the file formats doc(x), rtf, xls(x) and ppt(x). Their download size is close to the download size of OpenOffice.org (single language, no extensions but including additional components, 4 macro languages and read-write access to dozends of file formats). How much coding does it take if you are aiming to 100% compatibility with their proprietary file formats? What does it mean that the specification of OOXML weighs 8 times more print pages than the specification of ODF? For further reference (just scratching the surface): http://www.fokus.fraunhofer.de/de/elan/_docs/wp_doc-interop_en_09.pdf This White Paper in its two main parts describes typical effects which occur during the mixed usage of documents based on the standardized formats ISO/IEC 29500:2008 (OOXML) and ISO/IEC 26300:2006 (ODF). For each use case the following issues must have to be considered: Why translate a document from one standard to another? Which is the optimal document format to be used in the translation? Is it necessary to have a round-trip conversion of the document and if so, why? Which are the best tools to achieve these goals and who should use them? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Tell me it's not true
Am 29.02.2012 18:15, Dan Lewis wrote: This thread for the most part is exactly what should not be part of this mailing list. @Mark Stanton, Would you please visit us at http://user.services.openoffice.org/en/forum/index.php next time? What would most people who are new to Base think after reading the negative comments about Base? Statements about how hard it is to learn (comparing learning at least some of it to the difficulty of learning a new language). No one seems to be able to give references that would help. (No one has so far.) You should read what people think after trying to work with Base in a user interface that suggests something very similar to MS Access. Everybody working through the ungrateful topics of Base support has to put things straight regarding what Base is and what it's not. Drew Jensen is the single person who deserves all merits that some people (including me) found their way to do very productive things with this office suite's database connectivity. Actually it is easy enough to access arbitrary table data beyond file format issues in order to make them appear in our office documents (once you got used to the fact that in most cases a "database document" may not contain any database). Slightly advanced users can prepare data sources and queries that are easy to use by the less capable users. Your letter template may use some Name-Address-ZIP-City query from a MySQL server and then you advise the end user to use another Name-Address-ZIP-City query from a plain text file you created this morning. The end user does not notice any difference between MySQL server and plain text when he reconnects his letter to another data source item. Building a simple database application with data flowing from the office suite back to some connected database takes a conception of the database you are going to write to. This expert knowledge is beyond the scope of most users and it has nothing to do with ODF documents. It takes extremely complex tools to assist laymen in this effort. Even the expensive database suites can not do that much when you are not aware of some theoretical concepts. First you have a relational database ready to use, then building some ODF input forms to edit the relational data is no black art. The minimum tools are availlable in Writer, Calc, Draw, Impress. They are very simple and "simple" is not the same as "easy". The design process involves user-ability rather than usability. The resulting forms, reports and mail merge templates work very well for "my users" and me. "My users" refers to a group of rather computer illiterate professionals who need to write lots of info snippets into protocols, memos, inventories and serial letters collecting some 100 records per day in a small business network of 6 personal computers. If LibreOffice would drop 90% of "Base", keeping the mere connectivity, the primitive query parser and ODF forms, we could still work with it in the same way as we do today. All the convenient but misleading rubbish built around the core functionality is obsolete. Base should start again where OOo 2.0 left the well thought concept of OOo 1.x. Wrapping portable databases in extensions rather than documents would solve all the data loss problems of the embedded database. Reduce to the max! -- 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: Tell me it's not true
Am 29.02.2012 16:06, Mark Stanton wrote: perhaps able to include some aspects of the "spreadsheet paradigm" to data manipulation. That's an interesting thought. What sorts of aspects do you have in mind? Mark Stanton A database component without databases would be as interesting as a spreadsheet without references. -- 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: Headless mode examples for socket and pipe methods.
http://code.google.com/p/jodconverter/ -- 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: Headless mode examples for socket and pipe methods.
Am 29.02.2012 07:52, Andreas Säger wrote: 322 results for "headless" on the user forum: http://user.services.openoffice.org/en/forum/search.php?keywords=headless Dozends of tools have been written for OOo: http://www.oooforum.org/forum/viewtopic.phtml?t=11890 http://artofsolving.com/opensource/jodconverter Google shows dozends of other doc2txt tools that do not depend on a multi-megabyte office suite. WinWord and VBA might be the very best tool to convert their own proprietary file format to plain text. I forgot: Did you play with the command line options of LibreOffice? See soffice[.exe] -help -- 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: Delayed Execution of a Formula in Calc
Try MY_NUMERIC_FUNC(constant_params)+RAND() or MY_TEXT_FUNC(constant_params)&T(RAND()) The volatile randomizer enforces a recalculation on each and every change. -- 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: Headless mode examples for socket and pipe methods.
322 results for "headless" on the user forum: http://user.services.openoffice.org/en/forum/search.php?keywords=headless Dozends of tools have been written for OOo: http://www.oooforum.org/forum/viewtopic.phtml?t=11890 http://artofsolving.com/opensource/jodconverter Google shows dozends of other doc2txt tools that do not depend on a multi-megabyte office suite. WinWord and VBA might be the very best tool to convert their own proprietary file format to plain text. -- 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: Tell me it's not true
Am 28.02.2012 22:52, Mark Stanton wrote: Thanks for that Andreas, Hmmm, that document is nearly nine years old, nothing's happened with file based database access since then? Ok, might as well start at the deep end I suppose. Any pointers gratefully received, and in the meantime I'll start digging. Mark Stanton One small step for mankind... Almost nothing has changed since then, except for fixing things that should have been working right from the start 9 years ago. The Base developers wasted too much time with useless wizards covering no more than 30% of the program's capabilities and with a "self contained database" document that is a caricature of a database (unsafe, unsecure, low featured and slow). Base is best when you ignore most of its tools and helpers relying entirely on your own skills and on the capabilities of the underlying database driver. -- 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: Tell me it's not true
Am 28.02.2012 18:08, Mark Stanton wrote: That'll be a good stopgap, thanks. I'll have a look at the code, but it looks like you're saying it's a slightly wider scope than just dBase. Don't hold your breath :-) We get editable relations from relational database servers if the connecting database driver supports this. So called "file based databases" are: dBase, plain text (csv), spreadsheets, mail client address books, LDAP provide a minumum of functionality, mainly because most of them are no databases at all. dBase is the only editable and indexable type of file based database and the built-in driver should support relations as well. File based databases are important sources for mail merge. Spreadsheets are most commonly used but worst choice. Supported SQL functions of file based databases: http://www.openoffice.org/dba/specifications/file_based_functions.html -- 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: Can several instances of soffice be run in parallel?
Am 28.02.2012 16:37, Apollo wrote: Is there a way to enable Libreoffice to run multi-threaded, or simply to have Calc, Writer use a dedicated instance of soffice.bin? I can run LibO 3.3.x and 3.5 and OpenOffice.org in parallel. If the same office occurs twice in your task manager you should save your work and kill all instances because this state is rather unstable. -- 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: Tell me it's not true
Am 28.02.2012 12:09, John Talbut wrote: This is a very old bug with lots of people urgently wanting something done about it: https://issues.apache.org/ooo/show_bug.cgi?id=42464 That issue refers to the fact that you can only connect one database per database document. This topic is about joining tables of the same dBase source. SELECT * FROM "A" JOIN "B" ON "A"."F1" = "B"."F1" SELECT * FROM "A","B" WHERE "A"."F1" = "B"."F1" which is impossible in any of the file based database connections. The former Base developers did not recognize the importance of dBase. -- 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: Calc broke my document
With all the given information about the flaws in your content.xml it should be possible to fix the file mainly by removing some format attributes. -- 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: Unprotecting table cells
This is the same in OpenOffice.org, LibreOffice, Excel, Gnumeric and other spreadsheet programs. menu:Tools>Protection>Sheet=OFF opens the locks of all the cells on that sheet having a lock attached. Now you can edit any cell. Format>Cells>Tab:Protection allows you to add or remove a lock to selected cells. Cells without a lock remain editable when sheet protection closes all cell locks. By default all cells have a lock, so the sheet protection locks all cell. You have to remove the locks from those cells you want to keep editable. -- 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: Tell me it's not true
Am 28.02.2012 11:27, Mark Stanton wrote: Thanks Andreas, Unfortunately this isn't for a form, it's for a report. Mebbe I'll start having a look at that code, being on Linux you're other suggestion doesn't help me :-( Regards Mark Stanton One small step for mankind... Create a brand new database (relational, embedded HSQLDB). Drag the table icons from your dBase connection into the new database. Do what you want in the new database. Note: HSQL tables need a primary key in order to be editable. -- 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: Presentation conversion to/from Powerpoint - layout
Am 28.02.2012 01:10, Roger Sawkins wrote: I have Powerpoint on one machine and LibreOffice on another. I want to be able to edit and save PowerPoints on either machine. Hello Roger, It is not supposed to work like this. LibreOffice is not a drop in replacement for any other software. You can import complex and proprietary foreign file formats in order to create your own ODF documents to work with. The import accuracy is fairly well with .doc and .xls, it is not so good with .ppt. Your ODF documents should be fully compatible across several applications. Of course MS will never really support ODF. They do not support any file format they do not control. If and only if you want to share an office file with a co-editor who can not install ODF capable software, then you may send him doc/xls/ppt copies of your ODF documents together with a PDF version so he/she can compare the intended layout in a PDF viewer with the actual layout in his software. First of all you should care about the fonts used in your documents. This office suite can not transfer any fonts embedded in the sent documents. If your font is not installed on the other machine, the overall look and pagination will differ for sure. Since you are writing about 2 of your own computers, I'd suggest to use the same software on both machines. Hope this helps, Andreas -- 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: Tell me it's not true
Am 27.02.2012 23:38, Mark Stanton wrote: When I select the dBase connector it seems to say that queries cannot contain more than one table. Tekll me it's not true... Mark Stanton One small step for mankind... Sadly, this is true. You may use a hierarchy of forms and subforms to mimic relations on form level (display records in subform that are related to the selected item in the parent form). You may use another dBase driver. If I remember correctly, there is one for Windows ODBC. -- 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: calc problem
Am 27.02.2012 16:53, Johnny Rosenberg wrote: 2012/2/27 Václav Medek: Andreas, I tried it now on Windows 7 with Libre Office 3.5 and it is working right as expected. When ctrl+c/ctrl+v some email address to Calc, no dialogue appear and address is just filled into Calc cell (as link, not as clear text, but it is not important for me). But in Linux (tried on Ubuntu and Gentoo) dialogue is there... So maybe you are right that it is OS/browser problem. I tried it and I never saw a dialogue. The link was pasted into the cell as pure text. I don't know if that's what you are looking for, though. You see the text import dialog when you copy and paste multi-line text. This will never happen when you use the URL copy of the respective browser. Under Linux you can also use the system clipboard (middle mouse) to paste previously selected unformatted text. But this will also trigger a text table import in case of multiple lines. If you want multi-line text in one cell, you can always hit F2 before pasting. -- 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