[libreoffice-users] Re: Estimating size of page with Calc
Am 02.11.2014 um 15:51 schrieb Marc Paré: Is there a way to have the sheets show as pages rather than just a series of unlimited rows and columns? Thanks for any help. Marc Did you try menu:FilePage Preview and menu:ViewPage Layout ? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Compress images
Am 02.11.2014 um 17:43 schrieb Bill: I am in the same boat as the OP. I have searched for a quick, simple solution to this for several years, always smiling at the discussion boards dismissal of it as a needed add-on... Just now decided the current solution remains to find someone with a copy of Word and use it for the 5 minutes it would take to do this. The 300 images in the documents I am working with are secondary to the text, but they are nice to have. The .odt file is occasionally emailed back and forth for editing of the text. The original file I am working with was created by others less technical and they embedded huge images. The production process will eventually led to an InDesign or Web based product but for now the ability to email the files back and forth is important. A single menu option to Save As and Compress to A. Small, B. Smaller or C. Smallest Image size would be awesome. But today I'll just take the files on a flashdrive to my neighbor next door... The odt file is a compressed zip archive. Compressing the contained pictures would hardly reduce the file size. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Recommended version of Java?
Am 01.11.2014 um 10:07 schrieb Alex Thurgood: Le 31/10/2014 21:12, Andreas Säger a écrit : Huh? Really? Which issue number was that? I can't believe that any LO version had been released with such a show stopper issue. Well, please reconsider your statement in light of the requirement for LibreOffice 4.3.3 on OSX Yosemite and current master 440 alpha to use an end of life Apple Java 6, in addition to Java 1.8, to remain even remotely stable with the default bundled extensions that require Java. The Java 1.8 invocation problem is Oracle's bug (known, slated for fix in Java 9), and the fact that on OSX LibreOffice bundles extensions requiring Java is the LibreOffice projects responsibility. FWIW : https://bugs.freedesktop.org/show_bug.cgi?id=74877 Alex Thank you. Just like Florian Reisinger I was unaware of this issue with OSX. Let me rewrite the 3 answers since I still don't know Tanstaafl's operating system. 1. Always use a 32 bit JRE with LO on Windows. It may be your second or third JRE which is perfectly OK. Nothing wrong with many JREs for different purposes. 2. Mac users need an outdated Java 6 in addition to their default JRE until Oracle fixed a bug. 3. Use whatever JRE comes from the distributor of your Linux platform. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Relationships: Update cascade not working
Am 01.11.2014 um 12:19 schrieb Marion Noel Lodge: Hi Andreas, Thanks for your detailed reply. After I had sent my message, I realised that I had neglected to mention that I am using the H2 database. I went back into Tools | Relationships and decided to remove the the relationship lines so that I could manually make the changes I wanted. I discovered that for two of the relationships it took three attempts to delete the lines. That made me wonder if I had somehow managed to link my tables three times! So I reinstated the relationships using the New Relation button rather than dragging the lines. Then, to my surprise, I discovered that Update cascade worked!! Learning a little bit of SQL you can save a lot of time and effort. The things you need to know learn about creation and modification of tables, fields and indexes are very simple. There are text editors which help you to compose statements from prepared snippets. Well, even a Writer template can be spiced up with some auto-text in SQL language. Even the most simple plain text editor lets me define a table with primary key, default values and foreign key faster than the Base GUI. Back to Base, you have to call menu:ViewRefresh Tables. And yes, sometimes it is a good idea to restart the office suite. Using an external database such as H2 keeps your data safe and warm. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: date acceptance patterns not sticking
Am 14.10.2014 um 22:20 schrieb bunk3m: Libreoffice is driving me nuts. I am in Canada. UI is set to English US; Locale settings to English Canada and Default Currency is CAD. I have my Mac set dates to dd.mm.. (OSX 10.9.x) For some reason Libreoffice (4.3.1.2) will only accept dates in the -MM-DD format. I'm happy that I can format the date to look DD.MM. but entering in the -MM-DD is totally unnatural for me. Modify your default template for spreadsheets if you have any. Add a German cell style for the dates. Apply number format code TT.MM. which means 2-digit Tag(day), 2-digit month and 4_digit Jahr (year) Use that style for all cells where you want to use this input method: 25. = 25.11.2014 (this month's 25th day) 25.12 = 25.12.2014 (this year's 25th of December). This can not work with any English locale because the point conflicts with the decimal point. Save this as your default template for your new spreadsheets: FileTemplatesSave... [some name] FIleTemplatesOrganize... pick your new spreadheet and choose Set Default from the command button on the right. Additionally you may define a custom shortcut to apply this style (ToolsCustomizeKeyboard, category Styles. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Forgotten where to look for template converting text dates to numeric and sortable form
Am 31.10.2014 um 04:01 schrieb Custfold: What do I put in the find replace boxes? Hi, First of all, it is easier to avoid this problem rather than fixing it. You turn on regular expressions and replace .+ with -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base Relationships: Update cascade not working
Am 31.10.2014 um 14:11 schrieb Marion Noel Lodge: Hi, I am trying to change some Primary Keys in my main table, and get the changes to be reflected in several Foreign Keys. I have gone into Tools | Relationships, have set up the 1 to n connections between the tables and chosen Update cascade. However when I open the main table and attempt to change a Primary Key, I get the message Referential integrity constrain violation. I thought that Update cascade would override this. Have I missed something, or is it a possible bug? Thanks, Noel -- Noel Lodge lodg...@gmail.com Hi, If it were a bug, then it would be a bug in the underlying database program which is HSQL and not Base. Base is not a database at all. Referencial integrity never lets you enter any foreign key value on the n-side if there is no corresponding value in the other table's primary key (the 1-side). Update cascade allows you to update a primary key value on the 1-side. This update will automatically change all the values in related foreign keys. Normally you don't want cascading updates, particularly when using auto-IDs which may be inserted and deleted but never updated. If you want to enter arbitrary values into some field then you must not make it a foreign key of some other table's primary key. You can make it optional (nullable) but an orphaned foreign key value is not possible. If you happen to work with an embedded HSQLDB (this is indicated in the status bar), http://www.hsqldb.org/doc/1.8/guide/ch09.html is the complete official documentation for the database program you are working with. Hope this helps, A.S. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Macro to abandon edits
Am 31.10.2014 um 12:20 schrieb rmg: I'm migrating a bunch of spreadsheets from Debian Lenny/Openoffice to Debian Wheezy/Libreoffice 3.5.x. This is a dedicated setup used by many once-a-year users (who aren't chosen for their familiarity with computers) and, for instance, boots straight into a front end when switched on and shuts down when you close the front end. All driven by a startup script which launches the front end and waits for it to close. This sounds like a horrible mess. As far as I know, you can control the entire office process through a real program (Java, Python, Java Script) which starts up the office suite in listening mode, connects to the listening office, plays games with the same UNO-Api as macros do and finally takes care of the proper shutdown. I would train my users instead. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Recommended version of Java?
Am 31.10.2014 um 19:10 schrieb Tanstaafl: On 10/30/2014 5:02 PM, Virgil Arrington arringto...@gmail.com wrote: In my experience on this list, Tom has been extremely helpful and, just as important, courteous. I agree for the most part, and he is always polite and cordial. I just really hate it when someone deigns to try to 'help' me as if I'm a child, rather than just answer a simple question. The fact is, Libreoffice, for a long time, simply did not work at all with Java7. So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... Sheesh... You are the one to check this out. We don't even know your operating system. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Recommended version of Java?
Am 31.10.2014 um 20:32 schrieb Tanstaafl: On 10/31/2014 3:26 PM, Andreas Säger ville...@t-online.de wrote: Am 31.10.2014 um 19:10 schrieb Tanstaafl: So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... You are the one to check this out. We don't even know your operating system. Please STOP it. If Libreoffice requires Java to do certain things (yes, I understand that iits reliance on Java is less and less as time goes on, but it still requires it for some things), then it is on LIBREOFFICE to provide information what version(s) of Java it supports, and for what platforms. THAT IS WHAT I ASKED FOR. SHEESH. And you got valid answers from me and from Florian for all operating systems (since you don't tell us yours). The fact is, Libreoffice, for a long time, simply did not work at all with Java7. Huh? Really? Which issue number was that? I can't believe that any LO version had been released with such a show stopper issue. The only issue I am aware of is that Windows users could not use any Java features because they pointed their 32 bit office suite to 64 bit Java runtimes. The issue was that the option dialog did not hide inadequate runtime versions. My LO 3.5 (64 bit, shipped with Ubuntu 12.4) works with any 64 bit Java I throw at it, including the latest Java 8.25, 6.33 shipped with Ubuntu 12.4 and 7.65. At least I can start the document wizards, Base forms, Base wizards and the report builder extension, configure another JRE, restart the office and start again document wizards, Base forms, Base wizards and report builder. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Recommended version of Java?
Am 31.10.2014 um 20:50 schrieb Sophie Gautier: Hi Andreas GSM Le 31 oct. 2014 20:27, Andreas Säger ville...@t-online.de a écrit : Am 31.10.2014 um 19:10 schrieb Tanstaafl: On 10/30/2014 5:02 PM, Virgil Arrington arringto...@gmail.com wrote: In my experience on this list, Tom has been extremely helpful and, just as important, courteous. I agree for the most part, and he is always polite and cordial. I just really hate it when someone deigns to try to 'help' me as if I'm a child, rather than just answer a simple question. The fact is, Libreoffice, for a long time, simply did not work at all with Java7. So, I figured I'd ask if Java8 was supported - meaning, expected to work properly in most cases... Sheesh... No, that was: THAT IS WHAT I ASKED FOR. SHEESH. See the difference? You are the one to check this out. We don't even know your operating system. This is your second not constructive comment on this thread. We really don't need them. We only need people able to help and respect each others. If you have problems with some persons here, please move to another list or to the Ask forum. Thanks. Sophie -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Recommended version of Java?
Any of the latest Java 6, 7 or 8 should work equally well with LibreOffice. The bitness of the _office_suite_ is the only limiting factor. All LibreOffice versions for Windows are 32 bit, so you need a 32 bit Java even on a 64 bit system. LibreOffice for the Mac comes with 32 or 64 bitness. So it has to be 32 or 64 bit of Java respectively. Under Linux you don't care. Everything is bundled by the maintainers. There is nothing wrong with installing as many Java versions as needed for all your software to run. All security issues of the past years were related to browser apps and their sand boxes. And Tom is a phony idiot who knows nothing. -- View this message in context: http://nabble.documentfoundation.org/Recommended-version-of-Java-tp4127301p4127372.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Date manipulation
For an embedded HSQL database the query goes like this: SELECT * FROM Your Table WHERE DATEDIFF('day', CURRENT_DATE, Date Field) BETWEEN -10 AND 10 Replace the double quoted names with the actual names of your table and field. -- View this message in context: http://nabble.documentfoundation.org/Date-manipulation-tp4126889p4127373.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Styles mess
Create your custom currency format +# ##0,00 [$kr-41D];# ##0,00 [$kr-41D] with a red and green variant -- View this message in context: http://nabble.documentfoundation.org/Styles-mess-tp4126946p4127068.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Serial Letters
Am 16.10.2012 09:31, Heinrich Stoellinger wrote: Hello, A couple of versions ago of LO I mentioned that I have a problem with serial letters using Writer and MySQL-Views through Base. When printing a letter populated with database-view variables from just ONE tuple (=record) everything is fine. Unfortunately, when selecting MORE than one tuple for printing, various different content of the letter gets left out in all letters following the first on. This might be fixed text (i.e. NOT from the db), graphics, but also variables that should be included from the database. Has anybody had the same experience? I am now at LO 3.6.3-rc1 under Linux-Mint-Maya and use the native MySQL-connector, but the same problem was present in earlier, stable releases of both LO and MySQL (using a JDBC or ODBC connection). When having to print - say - 150 letters, the fact that at present I would have to print EVERY letter individually is unacceptable. It certainly would prevent using LO in a business context! I wonder whether anybody else has had the same experience. Regards Heinz -- Can you rewrite the view as a native SQL query? If you can not tell us any bug report number, this bug may never be fixed because no developer with ever take notice of the 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: BASIC script how to read/write system files, like /dev/null in Linux
Am 14.10.2012 21:08, chaonis wrote: I am trying to write scripts accessing the system files, such as /dev/ttyS0. If I use Open I got the error Device I/O error message. Are there any special function call needed to be done for the system files? User permission is good as I can access to the file using any other Linux commands. You have so many programming languages availlable. Why StarBasic? StarBasic is the most primitive API-caller. It is almost useless for anything outside the UNO scope. (Apart from that, it is the worst implementation of an extinct language). -- 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: Fwd: Re: Re: BASIC script how to read/write system files, like /dev/null in Linux
Am 15.10.2012 13:31, Tom Davies wrote: Hi :) No-one is suggesting dropping Star Basic! That would be a huge nightmare for many people i'm sure. I was just curious what might be better. A quick look at what languages can be used for macros in LO reveals 4 choices; LO Basic, Python, BeanShell, or JavaScript. I was just wondering which was 'best'. Are all 4 really well implemented in LO? I guess LO Basic is the Star Basic being referred to in this thread? I think Andreas was just suggesting that choosing to use Star Basic is not the best choice. However one of the great things about OpenSource is that you do get choices. We can all disagree about almost everything and still end up co-operating with each other even if we didn't want to. Outside of IT choice is usually seen as a good thing. Many countries see democracy as good and ostensibly give a choice of who you can vote for to rule. In shops people would be outraged if there was nothing else to buy except baked beans. People expect to be able to buy a wide range of diferent products from different companies and for it all to work together well enough. Somehow IT seems to demand dictatorships and freedom FROM choice rather than freedom OF choice. We don't all do the same things and even if we did we probably wouldn't do them the same way so it's fairly insane to expect 1 product and 1 company to be the only thing worth using. I was just curious about other people's choices to help me understand more about a subject i know little about. Regards from Tom :) StarBasic is a separate lingo implemented to call the API of this particular software only. It can not do anything outside the scope of the office. It comes with a few convenience features related to this particular API and the code is easier to be stored within office documents. It does not include any math library beyond triangular functions and basic arithmetics. It handles arrays in the most complicated ways, it does not know any hashes, it has far too many bugs and short comings, it is extremely complex and awkward (Null, Nothing, Empty, Missing are different types of the same). Basic is a 100% procedural lingo talking to an strictly object oriented API which is the reason why you can not write any extensions in Basic. MS Office and this office are the last resorts of this extinct lingo of the MS dominated 90ies. The alternatives are full featured, popular and mature programming languages with dozends of modules to program anything you want. A little bit of glue code makes them UNO compatible, callable from within the office suite (ToolsMacros), from the command line and as UNO components as well. Plain souce code files are much easier to maintain and a programmer can use whatever source code editor he wants (the Basic editor is no more than a cheap plastic toy). All the object oriented languages can be used to write seamlessly integrated extensions. -- 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: Integer part of a number
Am 15.10.2012 09:49, Pertti Rönnberg wrote: if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (-- if c3 is '1' or bigger then -- ) use the integer of value in c3) =MIN(0;INT(C3)) -- 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: Integer part of a number
Am 15.10.2012 10:45, Brian Barker wrote: At 10:49 15/10/2012 +0300, Pertti Rönnberg wrote: On 14.10.2012 12:20, Gilles SICHE wrote: could anyone tell me which formula I should use for the integer part of a cell to be shown in another cell, ... The answer could be: =IF(C31;0;INT(C3)) You are overthinking the problem: if C3 is positive, that's no different from =INT(C3) Brian Barker Reportedly, negative numbers do exist. -- 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 crack a PW in LO?
Am 15.10.2012 15:49, rost52 wrote: LO files can be protected with PWs when doing save as. Fighting currently with an xls file and its lost PW, I wonder how LO files can be cracked? Can the MS related PW remover be used for LO as well? Thanks in advance for comments. xls does not encript your document. The only thing that gets encrypted is the password. Any old version of OpenOffice.org opens a password protected xls ignoring the password. -- 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 crack a PW in LO?
Am 15.10.2012 16:30, Dr. R. O Stapf wrote: However, my question was how to open an LO file if the PW get forgotten (not and MS file)? Hints are welcome for the future. There is no way to open encrypted ODF other than a brute force script working through a list of possible passwords. -- 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: Integer part of a number
Am 15.10.2012 16:20, Brian Barker wrote: At 14:42 15/10/2012 +0200, Andreas Säger wrote: Am 15.10.2012 09:49, Pertti Rönnberg wrote: if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (-- if c3 is '1' or bigger then -- ) use the integer of value in c3) =MIN(0;INT(C3)) This is getting sillier! This formula does not match the definition above - and indeed for non-negative C3 is identically zero! Try =0 instead. Brian Barker Sorry, should be: =MAX(0;INT(C3)) -- 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: LibreOffice in MacWorld Australia
Am 14.10.2012 03:33, anne-ology wrote: but MSFT products are NOT cheap - their limited editions are included on new PCs due to some agreement BGates made with the manufacturers; once the trial version runs its course and/or the user desires more than the trial version offers they must purchase the product - and the product is only good for a limited number of downloads - therefore if you must replace your computer more than once, you must re-purchase the product. Just ask your personal Windows geek how to get a free copy of any MSOffice product. http://www.zdnet.com/blog/bott/microsoft-quietly-shuts-down-office-genuine-advantage-program/2798 -- 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: Auto and Manual Spell do not work x
Am 14.10.2012 10:10, Lostsoul wrote: Ok now what the crap; why are abiword documents being saved as adobi docs how do i fix that can t get anything right crap . - later I strongly recommend some computer crash curse. File name associations are free. There is nothing hard wired to the system. You can open any file with any program you want. You can tell your desktop environment which programs can open which types of files and which single program is the preferred one to be used on double-click. First of all, any user who is forced to use MS Windows should turn off the option to hide known file name extensions. Since Windows '95 this is the major obstacle which prevents people from understanding their system. -- 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: Auto and Manual Spell do not work . .
Am 13.10.2012 03:53, Lostsoul wrote: Not thinking of using ubanta was just asking about it ; and does anyone out their use libre with win 7 so far i would guess its a huge no and your throwing out ramdom guess s as fixs. And libre comes in three sizes on various freeware sites; not their home page 28 mb and 120 mb and their web site has it at 210 mb and 10 mb for help; wonder what that is all about will get the biggy next hopefully that works with win 7 the way it should - later Various freeware sites are the best guarantee that you get your computer infected with anything *they* want. None of those packages between 28 and 120 MB contains LibreOffice. Apart from this, LibreOffice is not freeware. It is open source software (OSS) which makes a huge difference. The home of the LibreOffice is http://libreoffice.org where you get the original packages from the developers at any time. -- 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: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot
Am 13.10.2012 16:37, Dr. R. O Stapf wrote: On 12.10.2012 01:36, Gordon Burgess-Parker wrote: On 11/10/12 13:27, Andreas Säger wrote: This is not a free clone of some other program. All it can do is loading .doc files fairly well. Please switch to this software or stay with WinWord. And with that attitude on a help list, LO is never likely to become any sort of threat to MS Office, is it? I also would like to comment on the All it can do is loading .doc files fairly well.. I entirely switch over to LO and find especially Writer better than Word. The styles-functionality in Writer is great. About 2 years ago I had to put a master thesis in the right format and it was a nightmare Read again the original posting. This is not about better or worse. It is about how to transform a customized WinWord setup to Writer. WinWord and Writer are completely different applications. There is no normal.dot, templates and styles are differently organized, the API is completely incompatible. Any sort of compatibility with WinWord is about loading .doc files fairly well. This is much more than most other text processing applications can do in respect to Word files. Then there is a highly experimental macro compatibility which tries to map the WinWord elements in VBA to elements of its own API. As far as I know, no other software tries to run macros of some other application and in most cases this does not really work. Same with loading .docx files. -- 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: Color cursor (active cell) on calc
Am 11.10.2012 15:38, Àngel mompó wrote: I am using Libreofice Calc version 3.6.2.2 I have a group of cells witha a black 1pt border so i find dificult to see at witch cell the cursor is. Is there any way to change the color and or other characteristics of the cursor? A macro solution for those who can work with styles: http://forum.openoffice.org/en/forum/viewtopic.php?t=43531 -- 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: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot
Am 11.10.2012 18:36, Gordon Burgess-Parker wrote: On 11/10/12 13:27, Andreas Säger wrote: This is not a free clone of some other program. All it can do is loading .doc files fairly well. Please switch to this software or stay with WinWord. And with that attitude on a help list, LO is never likely to become any sort of threat to MS Office, is it? Personally, I do not want to threat anybody or anything. This software will never be any thread to anybody else's commercial product. When MS Office dies, LibreOffice will die as well simply because more and more people learn that nobody ever needed dinosaurs like these so called productivity suites. It is very different from what some people expect and somebody needs to tell about it to avoid hours of frustration. -- 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: From MS Word to Writer: keeping my styles, macros, toolbars from Normal.dot
Am 11.10.2012 19:59, Tom Davies wrote: Hi :) And all the offices will close and money will cease to be important and there will be peace and happiness everywhere like Star Trek. Regards from Tom :) However, Kyla R. asked how to fuel up her new e-car and the answer is that you must not fill any fuel into it even if the car looks very similar like the old one. -- 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: LibreOffice in MacWorld Australia
Am 11.10.2012 20:46, webmaster-Kracked_P_P wrote: It is nice to see that MacWorld Australia states that LibreOffice is a must have app/package. I wonder if the MacWorld for the USA and Europe would have the same statement. Be nice to have LO listed in the must have category in the various Windows magazines. We could use more Windows users, and free advertisements towards Windows users, as we can get. It would be nice to have a booth in a Windows version of the big software shows that happen for Linux and Mac. But those booths may be very expensive to rent for such an event. Windows users can run MS Office easily and for little money (if any). Why should they use LibreOffice if all they want is cheap MS Office? Idealism? Masochism? -- 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 in LibreOffice 3.5.6
Am 04.10.2012 19:40, Eliane Domingos de Sousa wrote: Hi all, I have a situation under LibreOffice 3.5.6 with a dialog that has several steps. In the LibreOffice IDE, I see only the last page of the dialog. The module that invokes the dialog uses the property Step as oDialog.Model.Step = 1 ' (...2,...3, or whatever page number) How do I edit the dialog pages in the IDE? . Is there a trick to see all the dialog pages? If not how do I change them? Thank you Eliane Domingos Each control has a step property. Step 0 means that the control is always visible. The dialog has a step property as well. While designing the dialog with the properties window visible, select the dialog border, change the dialog's step to 1 and hit tab to commit the change. Now you see all controls where step = 1 or 0. Set the dialog's step to 0, hit tab and you'll see all the controls of all steps. -- 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: removing AbiWord from Ubuntu 12.04 kills LO desktop-menus
Am 10.10.2012 17:21, webmaster-Kracked_P_P wrote: I noticed that AbiWord was the default ODF file reader when I right-click on a document created with LO. I just upgraded to Ubuntu 12.04.1 64-bit from 10.04. When I use the package manager to remove AbiWord, it removed things like the desktop menu listing for LO in Office and some other LO packages. When I did a reinstall, the desktop menu creation failed due to a LO-core issue. So I needed to remove all of the LO package files and do a fresh install. Running the same Ubuntu/Unity on a 64-bit ThinkPad I just tried $ sudo apt-get remove abiword which did not affect any of my other office suites (currently AOO and LibO from ppa). $ sudo apt-get remove abiword reinstalls the same abiword as before without affecting anything. I can double-click text documents, I can choose any application from the context menu of an .odt file. The only thing that drives me nuts is that Ubuntu refuses to open any ODF document with the graphical zip tool (unsupported archive) unless I change the file name suffix to .zip. This is most idiotic Windows style. -- 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: MS raised prices so people will now start renting their office products instead
Am 09.10.2012 09:14, Marcello Romani wrote: Il 08/10/2012 14:13, John Clegg ha scritto: OK, if I accept everything that has been said, then why wouldn't opening an in-memory r/w copy be the sensible default action? So that when the user would try to save it a Save As dialog would appear ? Sounds good to me. Again, it is not the office program which creates read-only files. In most cases some other application calls the office to *view* some document. In most cases the office is called by a browser, mail client or cloud application to view online content or mail attachments. There are many reasons why this application has a viewing mode. It must not open some document in unsaved template mode just because the file is read-only. That would be extremely annoying for many users. Most of our ODF documents (documentations, print-outs, database forms, reports) are strictly read-only because only one person (me, the file owner) is supposed to modify these. The co-workers can work with the contained material (read, print, mail as PDF, edit databases through forms). All you've got to do is hitting the edit button in order to get an editable new and unsaved document. All you've got to do is saving the same document in your own file system in order to get your own editable copy of the document. Some Microsoft feature carries over the read-only flag when an application saves a document under another name. I'd call this a bug. No other file system behaves that silly. You need to turn it off in the file properties (right-click file in Win ExplorerProperties...). There is also an internal read-only mode implemented in the office program (FileSave As... save with password, open read-only with password). But that is another story. The internal flag within the document does not protect the file from being manipulated by other applications and the read-only status is carried with every copy of 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: MS raised prices so people will now start renting their office products instead
Am 09.10.2012 11:24, John Clegg wrote: Forgive me, but I thought one of the aims of LO was improvements to usability. I open emails mailed to me dozens of times a day. Doing Save-As, or clicking the edit button takes little time I agree, but why is it so wrong to desire that as the default to save me time? As a third option you can tell your mail client to *detach* the attachment instead of viewing it. It is always your mail client which creates the read-only file for good reasons. The main reason is that you lose work when you save your modifications to a temporary file. Just open some attachment for viewing and get office-menu:FileProperties... On the first tab you see the location of the file that has been extracted from text encoded mail box content. It might be a file in a temporary folder. It may have a randomized file name. If it were writable you could edit the file for hours and hours without knowing where all your work gets written to. After a reboot everything could be lost because it is normal behaviour that the temporary directory is cleared on shutdown. It takes some tiny precautions to specify your own file in your own file system where you can recall your saved work. If you are not interested in your own copy of the file because you want to edit and forward via mail then a simple click on the edit button lets you edit, send and close without saving. But then you are aware that you are writing into the memory of your computer without saving to disk. Reportedly, there exists an extension for the Thunderbird mail client which saves all attachments as writable files in a dedicated directory on your own file system. I don't know any details. -- 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: regexp function
Am 09.10.2012 12:24, Tom Davies wrote: Hi :) Is there not some way to identify how far along the letter is through one of the count functions? If so then a +1 should give the required value? In the interests of release early and release often it might be faster for you to 'just' do a macro since you already have the skill-set for that. Regards from Tom :) A Python extension might be the most simple solution. Python supports the same well known and sensible regex syntax as the Perl language does. All it takes is a set of wrapper routines to handle the input string, the regular expressions and extra options distributed with some xml glue to register the functions as office components. -- 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: Libre office using MSVCR90.dll cause Explorer to crash?
[Solved] Dynamic link library MSVCR90.dll missing http://forum.openoffice.org/en/forum/viewtopic.php?f=15t=46996 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Update SQL does nothing using Run SQL directly button
Am 04.10.2012 01:27, David S. Crampton wrote: Register1a is a table with field Trans-Date of type TIMESTAMP. Field Trans-Date-Year is either TIMESTAMP or INTERGER. I have tried with both. Update Register1a Set Register1a.Trans-Date-Year = YEAR(Register1a.Trans-Date); Looks like is should be a very simple SQL statement. It does absolutely nothing. The statement won't run with the F5 key (the run button). It gives The given command is not a SELECT statement. I'm trying to apply SQL learned elsewhere, mostly in MicroBloat Access, and I'm getting nowhere. Help will be appreciated. David Hello, This is fundamental. It is a shame that this mailing list is unable to answer this simple question properly and in depth after all the lengthy topics on Base and Base documentation. menu:EditRun SQL directly (or the SQL toggle button on the tool bar) is the equivalent of the pass-through query in MS Access. The normal operation mode is a parsed query where Base handles the query string. Whenever you want to use backend specific functions (e.g. MySQL GROUP_CONCAT), the specific SQL syntax of the backend or one of the many things that are not (properly) implemented in Base, you can mark the query as direct SQL. Base will ignore the query string and pass it over to the underlying database engine waiting for a record set or some error message in return. A frequent issue with HSQLDB is the UNION statement which requires direct mode: SELECT Date, Text, Number FROM Table A UNION ALL SELECT Date, Text, Number FROM Table B Direct SQL is not the solution to all problems. -- The returned record set is always read-only. -- Parameter queries and nested queries are Base features. No backend can deal with that. -- Pairs of forms and subforms require two parsed queries, otherwise the subform ignores the binding to its parent. Hope this helps, A.S. -- 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: using \t in regular expression replace
Am 08.10.2012 09:03, Cor Nouws wrote: Of course I used this workaround. But I wondered if I did something wrong, or missed some special trick to replace $ with a tab in one run. The $ does not match any character. It matches a position. You may think of the position where the bar cursor blinks when you navigate behind last character of a paragraph. Likewise, the ^ represents the position before the first character of a paragraph. The paragraph break between the 2 positions is unmatchable. \ and \ represent the positions in front of the first or behind the last character of a word respectively. \n in the regex search field matches a line break (Shift+Enter in Writer, Ctrl+Enter in Calc). In the replace field the \n represents a paragraph break. It is a long standing and highly irritating issue that replacing \n with \n replaces line breaks with paragraph breaks. -- 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 list, was: Fw: Re: Update SQL does nothing using Run SQL directly button
Am 08.10.2012 12:01, Tom Davies wrote: Hi :) All the threads about Base are buried in the archives: scattered and hidden, incoherent amongst hundreds of threads about things that are nothing to do with Base. If there was a Base List then some of those threads might have been referenced on it. There isn't. So any thread about Base only has whoever happens to be on that particular list and anything about base gets swallowed up amongst all the threads about other issues. Regards from Tom :) Most of the Base community resides on http://user.services.openoffice.org/en/forum/ which is also reachable under the forum.openoffice.org domain. There you find a search utility, tutorials, screenshots, example documents and macros. On that forum you find two or three Base experts at any time. -- 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 list, was: Fw: Re: Update SQL does nothing using Run SQL directly button
Am 08.10.2012 14:15, Tom Davies wrote: Hi :) Thanks Andreas! :) I have been looking for that link for a while. It feels a bit cheeky to send people from here to AOO but it's probably a good idea if we are going to keep helping Base users. Regards from Tom :) When the whole OpenOffice.org project was at risk, LibreOffice could have had it all. Unfortunately, some extra smart meritocrats rejected the idea of taking over that forum at the price of hosting it. Now it is part of the Apache infrastructure. -- 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: MS raised prices so people will now start renting their office products instead
Am 08.10.2012 14:13, John Clegg wrote: OK, if I accept everything that has been said, then why wouldn't opening an in-memory r/w copy be the sensible default action? Tell your mail client, browser, whatever to call soffice with the -n switch. The -n switch treats every document as if it were a template. The builders of your mail client, browser, whatever can not know about this. -- 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: Label mail merge producing one page per record, not six records per page
Am 07.10.2012 05:53, robertjm wrote: Hi all, Sorry for the subject being confusing, but that's the best way I could describe it. I'm working with Avery 5384 Name Badge labels. These has six spots per page. I set up a layout in the upper left-hand label, and then clicked synchronize to make sure all the labels contained the same layout. Since I have 150 records, I expected to create 25 pages (6 unique labels per page). However, when I complete the mail merge, I get 150 pages (one duplicate label in all six positions). I'm sure it's something really simple I'm overlooking here as this is my first time venturing into making labels from a database. Here's a link to the .odt file, though I'm not sure if looking at it will help. ReunionBadgesLayout.odt https://www.dropbox.com/s/th3bs3s0183gc3h/ReunionBadgesLayout.odt Hi, Put the cursor behind the Last Name. Menu:InsertFieldsOther... Tab: Database Field type: Next Record [OK] -- 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: Count number of rows satisfying two conditions
Am 07.10.2012 12:28, Alaak wrote: Hi, I have the following problem. I need to count all rows from a table satisfying two conditions in separate columns. I know of the function COUNTIF (ZÄHLENWENN in german), but that one is only able to consider one condition. Let's look at a brief example. s1 s2 atrue btrue afalse atrue bfalse I would like to count all rows having the value a in s1 and true in s2. Using COUNTIF I could either count on a condition on s1 or s2 but not on both. Any ideas on how to solve this problem? Thanks and regards Counting all true a values =SUMPRODUCT($A$2:$A$999=a ; $B$2:$B$999=1) [assuming that the true/false are numeric 1/0 values] If the above assumption is true, you could also use =SUMIF($A$2:$A$999 ; a ; $B$2:$B$999) [each true value equals 1] For the false a values: =COUNTIF($A$2:$A$999 ; a) - SUMIF($A$2:$A$999 ; a ; $B$2:$B$999) [all a minus the true a] If the true/false values are text: =SUMPRODUCT($A$2:$A$999=a ; $B$2:$B$999=true) German name of SUMPRODUCT is SUMMENPRODUKT. -- 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: MS raised prices so people will now start renting their office products instead
Am 05.10.2012 14:09, John Clegg wrote: I thought LO was emulating MSO 97?? Read-only is the only sensible way to open other people's files (web downloads, mail attachments). -- 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: MS raised prices so people will now start renting their office products instead
Am 06.10.2012 19:16, John Clegg wrote: Whilst a condom is always wise I still prefer to put it on for myself If you prefer to not choose anything, the other side will take her own precautions. -- Your mail/cloud client creates a *temporary file for viewing* unless you explicitly *downloaded* your own copy of the document. You can never be sure about the life time, location or file name of a temporary file. Your modification on a temporary file will be all lost on restart. If you want an editable file you need to download your own copy to a location and file name of your choice. -- Any other application which allows me to edit a document loaded from a read-only file will not allow me to save the modified document to the same file. It will force me to choose another path-name to store my modifications. -- The application which displays the document loaded from a read-only file is not the application which is responsible for the read-only status of that file. -- LibreOffice never ever modifies the read-write status of any file on your entire file system. It has no means to do such things. -- 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: MS raised prices so people will now start renting their office products instead
Am 06.10.2012 19:59, Felmon Davis wrote: On Sat, 6 Oct 2012, Mirosław Zalewski wrote: On 06/10/2012 at 19:27, Felmon Davis dav...@union.edu wrote: I am still not sure how one gets an infection from saving a file as writable. on a Linux system it's not executable, not sure how it works on Windows. how would infection occur? It's rather that in read-only mode, office suite will not run any macros attached to document, despite macro security configuration. thank you for the clear and illuminating answer. F. ... which is plain wrong like so many answers on this particular list. -- 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: documentation for LO base
Am 06.10.2012 21:34, Wolfgang Keller wrote: Huh? Access is a pathological data shredder. Not as bad as Base's default type of database. This part of Base is not even a valid proof-of-concept. The whole concept is dysfunctional by design and nobody dares to stop this madness. Just like MSAccess, Base is extremely useful as a frontend for database engines. You must not use the built-in JET engine with Access. HSQL is an excellent platform independent database engine but you must not embed HSQL in extensions which are installed and repackaged every time you open or close the so called database document. -- 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: documentation for LO base
The ultimate guide by Mariano Casanova: http://www.scribd.com/doc/48635562/Base-Tutorial-OOo -- View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.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: Import XML files?
Mark Stanton wrote I hope not, XML is supposed to be a self defining file format surely? It's a meta-file format. You (who defines all the XML tags) are the one and only person able to develop import and export software for your particular flavour of XML. xml BLAH foo=bar blub x=121.43/blub scramble crucifix=Trueertzuiopdfghjklöxcvbnm/scramble /BLAH /xml How would you translate this into a spreadsheet? Is BLAH a row, a column? What is scramble? How to deal with the attributes? Nobody ever tells us anything about his/her user-defined file formats such as CSV or XML. So most of the topics becaome lengthy and some remain unsolved. A general importer ought to be easy, no? Google reveals plenty of examples about how to write XLST scritpts to import/export user-defined XML formats into/from ODF. This is development work just like writing macros or setting up a database. In all those years since OOo 1.0 nobody wrote a generic XML-to-Calc tool. I would search in the database world for existing XML tools for database engines. Once you have the data in a connectable database, you have it it in Calc and Writer as well. -- View this message in context: http://nabble.documentfoundation.org/Import-XML-files-tp4010875p4010988.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: Import XML files?
FoxPro export exports database fields like this: ?xml version=1.0?Document OrderUpdate OrderId12345/OrderId OrderDate01/01/2004/OrderDate Confirmation123/Confirmation Storage StorageId01/StorageId Quantity1450/Quantity /Storage Storage StorageId02/StorageId Quantity2480/Quantity /Storage /OrderUpdate /Document It might be comparatively easy to write a Base driver for structures like this one. A spreadsheet does not imply any such structure. As far as I know, Excel imports arbitrary flavours of tabular XML through a wizard analog to a CSV import wizard. You specify the column tags, the row tags and get raw data in a spreadsheet. In the following example each record represents one consecutive spreadsheet row (starting at row#1) and each value represents a consecutive column value within that row (starting at column A). First row has column labels. xml record value type=StringID/value value typ=StringOrder Date/value value typ=StringValue/value /record record value type=Number13/value value type=Date2010-12-28/value value type=StringSome Text/value /record record value type=Number14/value value type=Date2010-12-31/value value type=StringSome Other Text/value /record /xml This one represents the very same data in German tags: xml zeile wert typ=ZeichenID/wert wert typ=ZeichenOrder Date/wert wert typ=ZeichenValue/wert /zeile zeile wert typ=Zahl13/wert wert typ=Datum2010-12-28/wert wert typ=ZeichenSome Text/wert /zeile zeile wert typ=Zahl14/wert wert typ=Datum2010-12-31/wert wert typ=ZeichenSome Other Text/wert /zeile /xml Other flavours of xml may describe rows within columns, railway connections in time tables, articles and clients in invoices, ... Any tool to import arbitrary XML into sheets needs to import text, numbers, special numbers and blanks into columns and rows even if there is no rectangular structure of records and fields. If there is a database structure (like the above FoxPro XML) it needs to import each value (number, text, date, blank) under its given field name. Most people who ask for XML import into Calc mean the XML flavour produced by Excel 2003. But they do not know that this particular flavour of XML is specifically made for that particular application. Other applications to read Excel-XML can be written easily but they need to be written. XML is not a file format on its own right. XML lets you define your own file formats. -- View this message in context: http://nabble.documentfoundation.org/Import-XML-files-tp4010875p4011079.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: [Writer] Data to Fields is not working
You can not do anything useful with a blank new document. 1. Open your letter template with fields. 2. Hit F4 and get your row set (query or table) 3. Click a grey row selector left of the first column to select the record that represents the receipient of your letter. 4. Click data-to-fields which fills out the fields with actual data. 5. Print and deny printing a serial letter. -- View this message in context: http://nabble.documentfoundation.org/Writer-Data-to-Fields-is-not-working-tp4010898p4011129.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: Import XML files?
MySQL can import your customer-visibility-groups: http://dev.mysql.com/doc/refman/5.5/en/load-xml.html If there is any reason why you want customer-visibility-groups in a calculator software, connect a registerd Base document to your MySQL server and dump the imported data from the data source pane into a sheet which creates a refreshable link. XSLT and ODF office suites: http://www.ibm.com/developerworks/xml/library/x-oocalc/ http://www.ibm.com/developerworks/xml/tutorials/x-xsltopenoff/index.html [9 pages] There are various topics on the OOo forums: http://www.oooforum.org/forum/viewtopic.phtml?t=67906 http://forum.openoffice.org/en/forum/viewtopic.php?t=3490f=45 -- View this message in context: http://nabble.documentfoundation.org/Import-XML-files-tp4010875p4011135.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: Import XML files?
Am 03.10.2012 20:54, Mark Stanton wrote: I've got an XML file (I've generated myself, programmatically). I thought it ought to be easy to import it in LO (3.4.6), somehow. I thougth Calc would be a good bet, but it just gives me General I/O error. Base does the same. The website (help.libreoffice.org/Common/About_Import_and_Export_Filters) suggests it ought to be doable but gives no details whatsoever. Anyone got any pointers I could use? Regars Mark Stanton Well, if you implemented your own XML format then you should know the appropriate software for your particular data structures. If there is some reason why you want to open your file format in this office suite then you have to write an XSLT script translating your specific XML flavour into ODF for import and possibly vice versa for export. -- 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: MS raised prices so people will now start renting their office products instead
Am 03.10.2012 09:23, HBarr wrote: Hi, I am a database user and emphasis on the word *user*. I like learning new stuff too and Base is a challenge. I want LObase to work so I will contribute feedback whenever I can but no more than that because I haven't learnt to code or programme...yet. I have a couple of questions but I will start a new thread for them. Howard I am not a database user. I am a database developer. The users of my databases have no problem with Base since all they see is standard form controls. -- 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: Opening a CSV file with Calc
Am 29.09.2012 03:41, Jeff Hahn wrote: I download financial information from Yahoo Finance. The download is a CSV file format.Athought I am able to open it with MS Excel I am not able to open it using LO except as a text file. Any suggestions on how I can open the file with Calc? Thanks. Jeff After exchanging concrete data files via personal mail, it turned out that UTF-8 coding was the problem. Select UTF-8 and everything imports fine. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: No Java could be found: LO 3.6.1.2: Win7 pro sp1; java 1.7.0_07
Am 30.09.2012 20:57, David S. Crampton wrote: Geez, I'm feeling a right dunce on this. You were correct in that my architecture is 64-bit. I uninstalled Java and then installed from jre-7u7-windows-i586.exe as downloaded from filehippo. Restarted machine. Still same behavior in Base. Yes in Tools | Options | LibreOffice | Java there is only the one registered Java. In Windows Control Panel | Programs is listed only 1 entry: Java 7 update 7 Should I revert to the java 6? Thanks for your patience, You can install as many Java versions as needed to run your applications, office components, databases, plug-ins and development projects. Just don't ask me how to install many Javas on Windows. Yes, Java6 is still maintained to work with tons of software that is not compatible with the new shit. And yes, it needs to be 32-bit to be used with this 32-bit office suite. http://www.oracle.com/technetwork/java/javase/downloads/index.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: ZOOM: strange or bug??
Am 28.09.2012 14:00, manuel_songo...@yahoo.it wrote: hello i dont say GESTURES ON LO ok? i say why when my mouse on area zoom slider and why it's activated drag only when area zoom-slider do you undy? how i can record my screen video? so will send you to see what is problem ok? Save your work and close any running office. Just to be sure: $ killall soffice.bin Rename your user profile which is under ~/.config/libreoffice on my Ubuntu system: $ mv ~/.config/libreoffice ~/.config/libreoffice.backup Start your office, let it create a brand new profile and see if there is any difference. -- 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 lost in referenced calc fields
Am 27.09.2012 09:31, jef.peeraer wrote: So the thousands separator is lost. Shouldn't the formatting of the calculator fields be copied into the writer doc? Or do I have to format the fields again in the writer doc ? LO is version 3.6.0.4 on 32 bit linux. No, it shouldn't. You pull some raw data from somewhere (could be plain text, html, some type of database as well) and apply your individual formatting according to the capabilities of the reporting application (a spreadsheet in this case). Separation of data and formatting is an important feature even if spreadsheets suggest the opposite. -- 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 lost in referenced calc fields
Am 27.09.2012 13:56, jef.peeraer wrote: ok, but it would be nice if you could indicate to copy the formatting as wellI thought I saw this somewhere in a dialog jef This is not about copypaste. When you reference another cell ( =A1 ) you would not expect the format to carry over. A spreadsheet always references data and nothing but data which is a true feature. It is not a deficiency by any means. -- 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 - bar chart - does not list order properly for cell values
Hi, The Y-axis is a numeric scale with start, end and some interval. The scale can be adjusted to be logarithmic or in reverse order. Just double-click the chart and then the y-axis. The order of the corresponding cell vector does not matter as long as the cell values are numeric. -- 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 - bar chart - does not list order properly for cell values
Am 26.09.2012 16:12, Andreas Säger wrote: Hi, The Y-axis is a numeric scale with start, end and some interval. The scale can be adjusted to be logarithmic or in reverse order. Just double-click the chart and then the y-axis. The order of the corresponding cell vector does not matter as long as the cell values are numeric. Correction: In a vertical bar chart the vertical axis is the x-axis. It can be set to either one of Automatic (number or text), Date (number with special intervals) or Text. Text scales are shown in the order of appearance, numeric scales are sorted ascendingly or descendingly. If you have text data, there is no choice other than 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: [OT] Re: What's New in Evolution 3.6
Oh yes! Show us more software you have nothing to tell about. -- View this message in context: http://nabble.documentfoundation.org/What-s-New-in-Evolution-3-6-tp4008228p4008935.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: python reading calc
Instead of running tests, how about debugging your program and reading some documentation? -- View this message in context: http://nabble.documentfoundation.org/python-reading-calc-tp4008804p4008939.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: python reading calc
Am 23.09.2012 15:30, dutchguy69 wrote: Did some research but have not found many leads yet. Hoping someone might be able to shed some light on this. C:\Program Files\LibreOffice 3.5\share\Scripts\python\pythonSamples\TableSample.py -- 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: MS raised prices so people will now start renting their office products instead
You are free to use any database that works for you and connect a Base document to it. If Base is too simplistic and underdeveloped you are free to connect some other frontend to your database (I use to recommend MS Access as perfect desktop frontend for free databases). Databases do exist. They are ubiquitous online and behind your desktop. There are plenty of tools and database professionals. Professionals earn their living with software tools which are not availlable for free. It is not the duty of this project to provide a full featured environment for database developers. Anything beyond simple mail merge connections is a gift. Yes, I agree in that most parts of Base can and should be removed. Drop all wizards and drop the embedded database. Drop the odb document type. Nobody understands the odb document with no data in it but connected to something. Keep the connectivity and simple input forms. Restore stand-alone Writer reports as in OOo 1. Dumb down this office suite. And while you're in it: Drop StarBasic. Even pure read-only access with no input forms would be much better than the unfinished and misleading crap that had been added to OOo2. With pure read-only access, I had to replace my office forms with some browser based stuff. So what? -- View this message in context: http://nabble.documentfoundation.org/Re-MS-raised-prices-so-people-will-now-start-renting-their-office-products-instead-tp4008121p4008408.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: Libreoffice Read/Write to Calc
I think he meant ”from the command line”. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ $ mySetValueScript.py myfile.ods Sheet1.D5 1000 -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-Read-Write-to-Calc-tp4008273p4008445.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 Report Question
SELECT this|| '|' ||that FROM XTable The double-pipe is the SQL concatenation operator analog to in a spreadsheet. '|' is a literal pipe analog to | in a spreadsheet. -- View this message in context: http://nabble.documentfoundation.org/Base-Report-Question-tp4008153p4008175.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: Libreoffice Read/Write to Calc
Generate office valid documents without any office suite: http://opendocumentfellowship.com/projects/odftools Accessing the UNO API of LibreOffice/OpenOffice in Python: http://wiki.services.openoffice.org/wiki/PyUNO_bridge (similar things work with Java and some other languages) -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-Read-Write-to-Calc-tp4008273p4008283.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: MS raised prices so people will now start renting their office products instead
You can always have your free dose if you want: http://www.zdnet.com/blog/bott/microsoft-quietly-shuts-down-office-genuine-advantage-program/2798 -- View this message in context: http://nabble.documentfoundation.org/MS-raised-prices-so-people-will-now-start-renting-their-office-products-instead-tp4008030p4008038.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: MS raised prices so people will now start renting their office products instead
In Germany there is a legal market for used software including OEM versions of Windows and Office. -- View this message in context: http://nabble.documentfoundation.org/MS-raised-prices-so-people-will-now-start-renting-their-office-products-instead-tp4008030p4008079.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: Socket Creation Error in LibO 3.6.2.1 RC 1
I get a socket creation error on a Windows machine where the HSQLDB with the wrong IP address in the config file. -- View this message in context: http://nabble.documentfoundation.org/Socket-Creation-Error-in-LibO-3-6-2-1-RC-1-tp4008075p4008109.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: Array Formulas Do Not Work
Find out if it is a known issue or not: https://www.libreoffice.org/bugzilla/query.cgi May be the problem is not related to arrays? Debug your formulas to find out which part causes the problem. -- View this message in context: http://nabble.documentfoundation.org/Array-Formulas-Do-Not-Work-tp4007831p4007868.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: Automatically fill user informations from Sun LDAP
Am 13.09.2012 09:47, Nicolas ABEL wrote: Hi everybody. First of all, I'm sorry for the lack of informations; i'm going to explain a bit more. Yes, Alexander and Andreas, you got it. On 300 computers, I'd like to fill automatically the informations contained in LibreOffice ToolsOptionsUser Data (because they are the one kept up to date). Computer OS : Windows XP and 7. LDAP : SUN v6.3 User is logged through his LDAP username and password on a SAMBA server (installed on a specific Linux distribution called SCRIBE; used a lot in French education administrations). Every user and machine is in the same domain. In the LibO documentation, it's not clear for me wether this file : C:\Program Files\LibreOffice 3.5\share\registry\oo-ldap.xcd is used during the install process or anytime afterwards. I'm currently trying to set it correctly with the system team...but whatever, I don't know how to use it after it's correctly set ! Alexander, thank you for the informations about French MIMO. I'm currently corresponding with 2 members of this group but anyhow, I don't know yet how to subscribe to this mailing list. Any idea ? Thanks a lot for your help. I'm going to keep an eye on the list and do my best to give a hand. Best regards, Nicolas. Mailing lists do not work for end user support. I use to suggest http://user.services.openoffice.org/en/forum/index.php where you find many competent users for OpenOffice and all its derivatives. There you find tutorials, examples, thousands of answered topics and you can use attachments, screenshots, hyperlinks and text formatting. Write a program to fetch the user-ID, the LDAP record for the given ID and then manipulate the XML file which stores the user information. On my current Win7 system that is %appdata%\LibreOffice\3\user\registrymodifications.xcu with various user-data nodes. You may use the office API for this but for most programmers it is much easier to work with ordinary xml parsers, generic ldap access and system interfaces. All database access is configured through so called database documents. They start as mere configuration files with some preview capabilities. Such a database document can be accessed through the API. The office user settings can be accessed through the API. The user ID needs to be read from somewhere else. -- 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: Where to store a simple database?
Someone found his way to share a database on Dropbox: http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=41238 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=54988 http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=44131 -- View this message in context: http://nabble.documentfoundation.org/Where-to-store-a-simple-database-tp4007504p4007661.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: How do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.
Am 14.09.2012 12:25, Richard Quadling wrote: Hello. I'm new to using a Mac and some of the things I can do in Windows I'm unable to even work out the question for on a Mac, so please bear with me. The files are generated from an automated system, several hundred a day and have a .tsv extension (can't change it for every file). The files are UTF-8 encoded text files with TAB separated content. I need to be able to double click the file and have it open in Libre Office Calc. Even if it has to ask me to choose the delimiter to process it with. You can have it much easier. Collect them all in one directory. FileNewDatabase [X] Connect to existing database Type: Text Specify the directory of the collection, the .tsv suffix, the delimiter etc. [X] Register the database. Save the database file. It is just a configuration file without data. The data are only in your file collection. Usage: In Writer or Calc hit F4 and drag into your document what you need. Dragging a table icon from the left pane into Calc creates an import range linked to the file. The data view on the right pane can easily be filtered and sorted. YOu can drag (copy) selected rows into a spreadsheet. In Writer you can also drag column headers into the document which generates mail merge fields (place holders for one field value per print out). -- 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: Where to store a simple database?
Am 14.09.2012 16:41, John Clegg wrote: where I wouldn't be able to get at it without Internet access? (Dropbox of course keeps local copies which it synchronises). Or is this one use use where embedded HSQL really is the right answer?? All views appreciated! Of course you can not access cloud content without internet access. This office suite is a most conservative *desktop* application and Base is NOT a database program. Just like MS Access it lets you connect to various types of databases so you can access your data in this office suite. The whole thing does not know anything about a so called cloud. No, the *embedded* HSQLDB is not an option. It is even much worse than the JET database embedded in MS Access. A stand-alone HSQLDB server may be a very good database solution if it fits your needs. You can run the same tiny Java program on all platforms as server, as client and in cached mode. But again, all this has nothing to do with any cloud computing. It just works with client-server connections or with plain single-user file access. If you are able to backup your files, the medium should not matter. If you need to access the same database from various places, it is about nothing but database servers. -- 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 do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.
Am 14.09.2012 17:44, Richard Quadling wrote: The file arrive on the network automatically, I just want to open one when I need to, edit it and save it. Other apps deal with the files changing. And what prevents you from doing so? What's wrong with Writer or any other text editor? Even if you manage to load the text file into the calculator component, you will find out that it does not do what you want it to do. It is the exact same issue as in the last csv topic (Date will not format or sort when imported into calc (ods)). Base is the most convenient solution to deal with huge collections of similarly structured text tables. Instead of FileOpen... Type: Text(*.csv), import dialog ... and ending up with unformatted raw data in a completely useless stand-alone sheet, you can hit F4 and drag the tsv/csv/abc/xyz data into your sheet template which resembles the number formats you want to export after editing. In addition your template may include all the bells and whistles of a spreadsheet (formulas, conditional formattings, charts). F4, 2 clicks and a dragdrop. That's all it takes. -- 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 do I open a file with a .tsv extension as a .csv file on a Mac OSX (Lion?) using OpenOffice Calc.
A searchable forum with a subforum for Mac related questions, attachments, pictures and many competent contributors: http://user.services.openoffice.org/ Searching the Mac forum: http://user.services.openoffice.org/en/forum/viewtopic.php?f=17t=46590p=215738hilit=writer+calc#p215738 -- 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: Where to store a simple database?
Am 14.09.2012 19:03, John Clegg wrote: Whilst your answer is no doubt rigorous it lacks a little in the helpfulness class! You have explained many times before that base is not a database and embedded hsql is evil. You haven't really explained why in either case, but then I am much the same in declaiming Apple as the evil empire. Here we go again. Base with its embedded HSQLDB is known to destroy data beyond recovery because the embedded database behaves more like an add-on. Seemingly you open a database document. In fact you extract a package, install your HSQL database into a temporary directory and connect the office suite to the newly installed database. When you close the database document the database connection closes and the whole bundle gets repackaged again. When any process in this office suite has a hick-up while you install/uninstall the bundled database, the database goes to the binary trash can (preferably this happens due to a crash in form design mode). And as a matter of course, any version of HSQL is a database engine entirely written in Java. Working with embedded HSQL is slow, insecure, unsafe, it is limited to HSQL 1.8, it is limited to almighty single user access from this particular application only. It is a caricature of a database. With a tiny little bit of extra effort you set up a real database (say HSQLDB 2), connect a Base document to it and have a fast, reliable, full featured database up and running. Of course, this tiny little bit of extra effort is development work as you might know from MySQL. Your database is HSQLDB, MySQL or whatever and you access it from you beloved office suite through a bridge called Base, from your browser, from your scripts, from anywhere with all the security and safety of a mature database software. No matter what happens to Calc, Writer, Impress, your database will not be harmed. You write about a simple database and describe one table with 33 fields. Have you tried a dBase directory on your remote drive? One directory, one .dbf file for the table and may be some indices for fast access. Plain text is fine. HSQL and MySQL can edit linked plain text tables. I don't see any reason why not using MySQL for a tiny table. The amount of work is far less than writing all this shit into the list. -- 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 13.09.2012 00:49, JAMES MAJESKI wrote: Name one feature that makes a database better than a spreadsheet when flexibility of input is required. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4007128.html Sent from the Users mailing list archive at Nabble.com. *Because* spreadsheets are so flexible you can not edit databases with 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 13.09.2012 05:18, JAMES MAJESKI wrote: So far nobody has come up with a reason for me to switch to a database where I risk loosing data if I attempt to make a change to the layout. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4007154.html Sent from the Users mailing list archive at Nabble.com. Simply because all you have is a database excerpt in plain text. You never asked for flexibility. You asked for data integrity (keep the exact same date encoding when saving back to a database file). You do not want to use *flexibility*. What you ask for is automatic formatting on import. Yes, the Base component helps to import database data into preformatted spreadsheets and Writer documents. Base is *not* a database program. First and foremost it is a bridge to import various types of tabular data into preformatted documents. -- 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 13.09.2012 05:03, JAMES MAJESKI wrote: My only queries of the data are handled adequately by the calculations done in adjacent columns. Nothing special, complex, or complicated will easily replace it nor be more useful. Calc can do all this without very easily with the help of the Base component which you strictly reject. What you asked for in the first posting was about importing the correct values rather than text and then you want the application to derive the correct number format code for each cell. This does not happen. Not in Calc nor Excel nor any other spreadsheet. -- 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 13.09.2012 11:54, Andreas Säger wrote: Am 13.09.2012 05:03, JAMES MAJESKI wrote: My only queries of the data are handled adequately by the calculations done in adjacent columns. Nothing special, complex, or complicated will easily replace it nor be more useful. Calc can do all this without very easily with the help of the Base component which you strictly reject. What you asked for in the first posting was about importing the correct values rather than text and then you want the application to derive the correct number format code for each cell. This does not happen. Not in Calc nor Excel nor any other spreadsheet. Then you mentioned some co-editors. If they do not have have spreadsheet software at hand, what is the software they use? If you exchange data via csv, I would assume that they use some kind of database. Otherwise you could exchange spreadsheets in plain old xls 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 10.09.2012 22:30, Andreas Säger wrote: Am 10.09.2012 19:40, Andreas Säger wrote: Base is our database component. It is very, very underdeveloped, nevertheless underestimated. Even the worst database tool does a better database job than the best spreadsheet can do. Since nobody ever uses Base for plain text databases, here is another approach without Base and without macro programming: 1) Prepare a sheet template and format entire columns to your liking, according to the incoming fields. 2) Open the text file in a text editor. 3) Copy all. 4) Open a new spreadsheet from the prepared template, paste and fill out the text import dialog (US English, special numbers, delimiter). That was solution #1a (copy plain text into preformatted template). Solution #1b: Import correct values, copy, paste-special numbers, dates and text into a preformatted template. Solution #2: Import everything as plain text, calculate, filter and sort with function VALUE. Requires spreadsheet skills which seem to be rare these days. Solution #3: Hit F4 and dragdrop your text file into a preformatted sheet. Solution #3 is what I use to do if the source data allow this. It is by far the easiest and most convenient method to deal with tabular text data in office documents. All it takes is a little bit of setup work. Any solution that requires text-to-number conversion will not format the resulting numbers to your liking. So you are at the point where solution #1b applies. -- 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 12.09.2012 07:23, JAMES MAJESKI wrote: Two digit years have always been a problem. I always presume that the use two digit years was obsolete after the Y2K publicity, but bad habits continue. We are no longer in the era of eighty column punch cards, so there is no excuse for two digit years. A spreadsheet does not store 2-digit years nor 4 digits. All spreadsheets store numbers and nothing but numbers (or text). A date in a spreadsheet program is an integer day number (unless it is a string). Day zero is 1899-12-30, day 40,000 was 2009-07-06, today is day 41164. Today's So there can not be any problem with 2-digit years. Format the numbers to your liking so they show 2-digit years, 4-digit years or no year at all. But that will not change the cell value. If you really need to export your currently active sheet into plain text you can apply any format you want. Why csv? Which application do you try to exchange data with? -- 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 12.09.2012 08:00, JAMES MAJESKI wrote: My research has convinced me that I do not have neither the time nor the resources to set up and maintain a database. I might consider it if all of the data were received in the same layout, but the layout is as varied as are the sources. Since I am the only one that is using the data, a spreadsheet serves me best as I am able to freely add, delete, and modify the layout, format, calculations, etc. Something a for which a database has never been designed. Well, then you don't heve the time nor the resources to set up and maintain a database in spreadsheets. The latter scenario is the nightmare that never stops. A CSV file is an excerpt from a database and you can use any tool where your are free to modify layout, format, calculations etc. But then you save back a modified layout and format with additional calculations. A database program lets you freely handle all data in any shape while maintaining the underlying data structures automatically for you. -- 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
Am 12.09.2012 15:35, a a wrote: Hey, When i am creating a diagram i can change the numeric values of the y-axel, but when i try the same procedure for the x-axel, the template with options stay grey and imposible to change. How can i do to make this grey area black again so i can change the numeric values? /Magnus östlund Change the chart type to x/y-scatter chart. Ignore Tom Davies. He is the most verbose ignorant on this list. -- 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: not create a dot file in same folder as document when opening it for viewing
Am 12.09.2012 15:23, Enda wrote: OS: Ubuntu Calligra does not create a dot file when viewing files, is there an option to turn this off in LibreOffice? I give up. -- 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: Automatically fill user informations from Sun LDAP
Am 12.09.2012 07:52, Nicolas ABEL wrote: I would need a way to fill user informations from a Sun LDAP on a few hundred computers (Libreoffice 3.5.6.2 already installed). The best would be to update informations from the LDAP at each restart or on demand. Any clue to help us do that ? Thanks in advance. Nicolas. Fill user informations into what? ToolsOptionsUser Data? Where do you get the specific user ID from? From the system log-on? -- 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 do I save side panels layout in LibreOffice?
Am 10.09.2012 09:57, alci wrote: When using LibreOffice, I like to have the navigator and the stylist panels open. But to save space, I need to have them on top of the other, not side by side. I can achieve that by using Ctrl + moving the panel where I want it to be. But when I re-open the application later, that setting is lost. How do I make this setting persistant ? Thanks in advance, Franck (notice: this is a re-post of a question on askubuntu.com) Works for me with LibO 3.5 from package manager of Ubuntu 12.4 and with Apache OpenOffice as well. The docked positions of navigator and stylist are preserved for both components Writer and Calc throughout subsequent sessions. -- 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: not create a dot file in same folder as document when opening it for viewing
Am 11.09.2012 18:01, Enda wrote: Can Libreoffice not create a dot file in same folder as document when opening it for viewing? .~lock.file.doc# - Enda That's what it 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: not create a dot file in same folder as document when opening it for viewing
Am 11.09.2012 20:28, Brian Barker wrote: At 18:10 11/09/2012 +0200, Andreas Säger wrote: Am 11.09.2012 18:01, Enda Noname wrote: Can Libreoffice not create a dot file in same folder as document when opening it for viewing? .~lock.file.doc# That's what it does. I think the questioner is asking Can it please *not* do so [when viewing is all that is required]? This is a sensible question. Try setting the document file to read-only in the operating system before you open the file. That may achieve what you ask. I trust this helps. Brian Barker Is it really that difficult to tell us exactly about the situation? We don't even know the operating system. Is it really that difficult to copy some documents into a test directory, display hidden files and open them read-only? 4 tests on Linux: 1) libreoffice -view blah.odt [no lock file] 2) chmod -w blah.odt libreoffice blah.odt [no lock file] 3) menu:FileOpen... [X] Read Only [no lock file] 4) menu:Save As... [X]Password blah2.odt with a read-only password close, re-open blah2.odt [creates a lock 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: dBASE file access
Am 11.09.2012 22:34, Girvin R. Herr wrote: Greetings, I have several real old dBASE data files from 1985 that I would like to get the data from and convert to LO Base. I keep reading about LO being able to access a dBASE file, but I am having trouble doing so. I tried the new database wizard and although it created the new Base database structures, when I tried to open one of the dBASE files, it opens in writer, not Base. There are no tables listed in the new Base database. The wizard did not allow me to select the actual files, just the directory they are in. It didn't list any of the .DBF files. Maybe I am asking too much of LO, but I was hoping the dBASE data would show up in a Base table. Any help would be appreciated. Running: LO 3.5.3.2 under Linux. Thanks in advance. Girvin Herr Base is a mere database frontend. It opens its own .odb files only. An .odb file can be connected to various types of databases. Open Writer or Calc. Hit F4. Right-click Bibliography - Edit Database This loads the .odb file which is connected to the dBase Bibliography with one table named biblio. dBase is a database in a directory, so this .odb file is connected to a directory. The status bar of that database reads: dBase and the path to the connected directory having the file biblio.dbf. menu:EditDatabase lets you modify the connection parameters. Put your own dBase in a dedicated directory. FileNewDatabase... [X] Connect to existing db Type: dBase Specify the directory. Check the register option (never harms). Save the database. Drag the table icons from this database into the embedded HSQLDB. Warning: embedded HSQLDB must not be used with anything important. It's OK for educational demos and for your DVD. Base works best (fast, reliably and multi-user) with HSQL as stand-alone backend database. Embedded databases are just a caricature of a database. They are slow, single-user, limited and unsafe. -- 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: LibrreOffice 3.5.6
Am 10.09.2012 16:37, Dan Lewis wrote: What operating system are you using? Is it 32 bit or 64 bit? What version of Java are you using? (1.7 or 1.6.)? Is it 32 bit or 64 bit? Basic macros, Python macros and the macro recorder work without any Java. -- 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 10.09.2012 01:49, JAMES MAJESKI wrote: You are correct in that 12/31/12 is not ambiguous, but that is a special case. When each element is unique and without knowing the source preference, there are six different dates that may be generated from 10/11/12: 2010-11-12 2010-12-11 2011-10-12 2011-12-10 2012-10-11 2012-11-10 Your input data have 4 digit years. Before exporting csv from a spreadsheet you have to take care of unambiguous number formatting. Again, there are much better applications to load, edit and save csv. The Base component can be used as import configurator for pre-formatted spreadsheet templates, some spreadsheet geeks prefer macro programming. -- 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 10.09.2012 18:56, JAMES MAJESKI wrote: The following is a reply to my query from a private source: Data bases are for fixed data columns and standardized input methods and require manipulation by sql type query tools. Unless you are getting automatic feeds of significant amounts of data from your world wide operations I don't see what it would do for you. If you are putting together a business then a data base would be a good thing even if it is simple, but those are available pre-canned and some are open source. Unless you are doing something far more complex than I imagine spread sheets should serve you well and spread sheets have reporting capabilities. You want a standardized input method to generate text files with ISO dates. Unlike its users, a spreadsheet does not care about formatting attributes. The only thing that really counts is the cell value. Databases are designed to do what most of today's spreadsheet users try so desparately try to do in spreadsheets. Databases are ubiquitous online and offline. Valid CSV files are exported from databases and they are destined to be imported back into other databases. Each row represents a record, each record has the same amount of fields, each field has a distinct data type. A spreadsheet has no records nor fields and the only data types are text, number and boolean (in Calc even the booleans are numbers). There are various ways to load csv into a spreadsheet so you can process the imported data by means of spreadsheet formulas. Simple statistics, projections, what-if-scenarios are the most typical spreadsheet applications based on database data. You pull it into a sheet and let the spreadsheet do what spreadsheets use to do (which is not text editing). Base is our database component. It is very, very underdeveloped, nevertheless underestimated. Even the worst database tool does a better database job than the best spreadsheet can do. -- 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 change Calc default to NOT add 1 when drag-copying a cell
Am 09.09.2012 07:32, Roger Davis wrote: How do I change the Calc default of adding 1 (+1) when a cell is drag-copied? I just want it to copy to the location(s) drug to, NOT add 1 to each cell in sequence. I know that holding CTL when doing this will prevent the addition, but I need this to be the default action WITHOUT pressing CTL. Excel has this optional setting, so I presume Calc has it, or at least should have it. Thanks! Hold the Ctrl key. -- 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 - message in cell
Am 09.09.2012 12:19, IGraham wrote: Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any help There is no date type in a spreadsheet. You can leave it up to the user. Any of: 2012/9/13 2012-9-13 13 sep sep 13 13/ and many other input methods yields the exact same date of current month's 13th (which is unformatted day number 41165 in September 2012). Your suggestion 01/01/2012 is ambiguous anyway because it is unclear if 01/02/2012 refers to the 2nd of January (USA) or 1st of February (other planet). -- 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: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets
Am 09.09.2012 11:54, Tinkerer wrote: Use the extension CT2N. It Converts Text to Numbers. Simples. Tink. Nobody needs to install any extension to convert between numbers and text. CT2N may fail in this situation (dmy vs. mdy). If all the dates have been imported as text, a simple regex replacement converts in both directions. It would be better to simply import correct values instead of fixing wrongly imported ones. James knows how to import correct values but he expects automagic number formatting. The program should analyse the assumed formatting of the input strings and apply the corresponding number format codes to the respective target cells. Spreadsheets don't do that. Formatting has zero relevance for the tasks spreadsheets are designed for. Only values (numbers) are relevant. James Majeske wrote: I receive dates in three different formats; big endian [31 Dec 2012], mixed endian [Dec 31, 2012], and small endian [2012-12-31] (also known as ISO8601). With US loale setting and detect special numbers any of the above input strings yield cell value 41274 preformatted to show 41274 as 12/31/12 which is obviously and unambiguously the correct value. This value can be formatted at will and sorted by its numeric 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 Date issue
Am 09.09.2012 20:52, naomi.br...@gmail.com wrote: Hi, I've just had the same problem, I want to enter a year in the format , which I can't using the date/time field type. Having read this post I tried to choose an integer and have it set the length to 4, but it won't let me change the length of the integer. Any ideas? Thanks, Naomi A year is an integer. Trying to store an integer number in a date field makes no sense. -- 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