[libreoffice-users] Re: helping Users and LibreOffice - proposal
Hi Cour (none of the following criticisms are directed at you, who are one of the few (only?) members of the SC who sees this project as a productivity tool for the users) I don't know if you are aware that installing LibO 3.4.0 under Windows silently uninstalls 3.3 without asking (even if the installer is run in customized mode). Therefore it is not possible to have both versions installed under Windows. I know this is possible under Linux but this project doesn't care a f*ck about Windows users (even though they are the majority of users, but hey, who cares?) so one can only recommend one version OR the other. Given the degree of regression and bugs added (I totally agree with Tom that 3.4.0 sounds more like a beta-release) and that the developers are not too worried about regressions, in my opinion if someone is using 3.3.2 for work (and believe me: even if the LO site has a disclaimer about 3.4 being experimental, all other download sites/mirrors don't, so expect a LOT of angry users in the near future) I will not recommend 3.4 for anything other than playing around. In my opinion, releasing 3.4.0 as Stable was a major error and a shot on the foot for this project. But the all-mighty Release Schedule as to be met, no matter what comes out of it... Regards, Pedro -- View this message in context: http://nabble.documentfoundation.org/helping-Users-and-LibreOffice-proposal-tp3051441p3052293.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.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: hide white space
A quick Google search provides the answer http://office.microsoft.com/en-us/word-help/show-or-hide-white-space-in-print-layout-view-HP003072013.aspx http://support.microsoft.com/kb/297564 Does anyone know if this feature exists in LO? If not a feature request could be added ;) -- View this message in context: http://nabble.documentfoundation.org/hide-white-space-tp3044835p3047544.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.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: Has anyone tested the backward-compatibility of LibreOffice 3.4?
Hi Stephan I will test this one later. With don't you simply name the range Jack? It's much easier to use and modify ;) I think that there is no need to know the second, third, etc text celss. You only need to know the first error to go there and fix it. One error at a time :) Thanks! -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3038516.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Release dates/versions
Can someone explain why the latest daily build is named libreoffice-3-4~2011-06-07_11.47.03_LibO_3.4.0rc1_Win_x86_install_multi.exe ? This was compiled yesterday but it is still named 3.4.0rc1? Build 3.4.0 final was announced on June 3rd while the files are dated from May 26th (because the final build is in fact RC2 so there was no point in re-uploading). Why rc1? -- View this message in context: http://nabble.documentfoundation.org/Release-dates-versions-tp3040743p3040743.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Re: Re: SVG embedding in LibreOffice
I just inserted the arrow.svg into a ODS using OOo 3.4 Beta. The interesting results are: 1) Opening the ODS in LibreOffice shows the blur (while if I insert the svg in LO it won't) 2) Exporting to PDF has higher quality in LO than OOo -- View this message in context: http://nabble.documentfoundation.org/SVG-embedding-in-LibreOffice-tp3033541p3042519.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
Jack wrote: array formulas in LibO/OOo are a little tricky (little more so than in Excel). If you've entered the formula correctly and pressed ENTER (instead of CTRL+SHIFT+ENTER), then obviously it does not work. If you then select the cell/formula again and press CTRL+SHIFT+ENTER, then it *still* won't work, because it doesn't register that you've changed the formula (thus won't take the CTRL+SHIFT+ENTER). You'll need to physically change the formula again and then press CTRL+SHIFT+ENTER (I usually type and erase a space). I pasted your formula so there were no typing errors. Of course that triggered the bug you have already found a workaround. Well done ;) But that is definitely a BUG. I have reported it here https://bugs.freedesktop.org/show_bug.cgi?id=38014 and I will use your explanation to provide further details. Thanks! Even with the array working it's not detecting non-numeric cells properly. Can you upload your spreadsheet somewhere so I can see what I'm doing wrong? -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3033666.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: SVG embedding in LibreOffice
Actually I am almost sure LibreOffice added that feature first http://www.libreoffice.org/download/new-features-and-fixes/ I don't know if the code was shared with both projects but OpenOffice does that too :) -- View this message in context: http://nabble.documentfoundation.org/SVG-embedding-in-LibreOffice-tp3033541p3033677.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: SVG embedding in LibreOffice
Nuno J. Silva wrote: Like this one? http://upload.wikimedia.org/wikipedia/commons/9/91/Arrows_bend.svg So if I understand you correctly, the blurred shadow is correctly imported in OOo. I can confirm that inserting the linked SVG into a OOo 3.4 Beta Writer document does show up a blurred shadow (looks the same as opening the SVG in Firefox or Inkscape) -- View this message in context: http://nabble.documentfoundation.org/SVG-embedding-in-LibreOffice-tp3033541p3034602.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: A huge bug in Calc (writting/reading xls files)
Hi Ismael You can't attach files to this mailing list. You have to upload the files somewhere and post the link here. LibreOffice 3.4.0 was released on June 3rd. But if someone manages to fix the bug you are reporting it will be incorporated in a future release (3.4.1, 3.5.0,etc ) In any case bugs that apply to a single file format (i.e. don't apply to all file formats) are not considered a priority. Version 3.4.0 is extremely buggy. I would advise you to test and use 3.3.3RC1 -- View this message in context: http://nabble.documentfoundation.org/A-huge-bug-in-Calc-writting-reading-xls-files-tp3034966p3035113.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LibreOffice Manager disc usage
From my experience and from reports here at the Users list, the MS filters are much more stable in version 3.3.x If you want to test a new version I would recommend 3.3.3RC1 (Go to Download, Pre-Releases on the libreoffice.org site) -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-Manager-disc-usage-tp3035033p3035390.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Is this list unmoderated?
Nabble just LOOKS like a forum. Functionally, it's not. You have to subscribe to each section because each is a separate mailing list. If Mono works in the same way, then it's not an alternative. Please TDF consider setting up an OFFICIAL forum! -- View this message in context: http://nabble.documentfoundation.org/Is-this-list-unmoderated-tp3016333p3029116.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
Hi Jack I couldn't make it work. In fact I just found out that array functions don't work in Lib (3.3 or 3.4) nor in OOo (3.4 beta) I don't know if it ever worked (I use it every now and then, so I couldn't say if I used it before in OOo/LO) but if it did, someone broke it :) Another bug to fix for 3.5 :) -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3032323.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Is this list unmoderated?
Caesar wrote: On Fri, 3 Jun 2011 21:10:39 -0700, Robert Holtzman lt;hol...@cox.netgt; Which is precisely the reason I dislike forums. Way too many brainless questions from users (and I use the term loosely) who barely know how to turn on their computer. +1 on that. They certainly don't know how to read simple unsubscribe instructions. So, you two guys stick to the mailing list. Those who are brave enough will bother to answer the brainless questions. I think that a project that wants to be an alternative to MS Office can not afford to snob on anyone. (In fact that shouldn't happen in any project, but that is just my opinion) -- View this message in context: http://nabble.documentfoundation.org/Is-this-list-unmoderated-tp3016333p3022540.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
It must be a new feature :) I advise you to test 3.3 RC1 and update to 3.3 when it is released. Version 3.4 is not ready for real work as stated in the release announcement http://nabble.documentfoundation.org/The-Document-Foundation-announces-LibreOffice-3-4-0-tt3019206.html -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3022791.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
Actually I had never noticed that spreadsheets (all including Excel) ignore text values mixed with numbers. This worries me a lot! I work with 300.000+ line spreadsheets and if one line has a text value (because of a typo) I wouldn't notice that. Is there any setting that triggers a warning (instead of ignoring the cell(s)) in this situation? -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3023116.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
Michael D. Setzer II wrote: If you use count on a range it only counts numeric cells, but counta counts numeric and non-empty cells, so if they don't give the same results for the same range, there is an error? Yes, that would work but it forces me to do this verification for each column. And still it won't tell me where the error is (although I can find it with some filters) It would be much better if there was some AI in these functions warning me that Data in Cell A12345 is not a number. What do you want to do? A) Jump to cell A12345 and manually fix it or B) Ignore this warning and Sum all other cells? Why not use the computing power of the PC to help us? -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3023698.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?
Brian Barker wrote: One useful facility in this case is Value Highlighting. Go to View | Value Highlighting or press Ctrl+F8. The font colour for text (temporarily) becomes black, for numbers and other values blue, and for formulae green. (Formulae should be no problem, since it's possible to construct them sufficiently carefully that you can be sure of the type of the result, of course.) Repeat the process to toggle the facility back off. I didn't know that. Could be useful sometime ;) If I wanted to visually check I would use Conditional formatting and set Font to Red and Bold and the Background to Bright Yellow :) But as you said, I really don't want to browse 300.000 lines to spot errors ;) -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3023917.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: no 3.4.0 Windows all-language link
No, it's not. The branch 3.4 no longer has the ALL Languages pack. This means there is only one pack for Windows users: the Multi pack which includes all languages that are still maintained (many of the languages had been so neglected that most of the items were in English, so they were removed). Hope this helps ;) -- View this message in context: http://nabble.documentfoundation.org/no-3-4-0-Windows-all-language-link-tp3020172p3020701.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Is this list unmoderated?
Hi Tom ;) Tom Davies wrote: Some kind user did kindly develop a Forum but people here seem more interested in creating blockages and creating restrictions rather than diversifying to suit a variety of different people's needs. Relax bud and have a good weekend :) I'm not stressed ;) Just saying that there should be an Official Forum for those who prefer it, and maintain this mailing list for those who prefer it. (Actually I think someone did build a Drupal site which included all tools but it was rejected by the SC or some members) There is no point in arguing which is best. It is better to offer alternatives IMO. Have a great weekend too ;) -- View this message in context: http://nabble.documentfoundation.org/Is-this-list-unmoderated-tp3016333p3020730.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: TDF - Novos membros em 31-05-2011
I agree with you Vitorio. The list should in fact be sorted alphabetically (I think that the date is irrelevant) I would suggest that a third column with Nationality should be added just to show off how international this project is ;) Greetings from the other side of the Atlantic ;) -- View this message in context: http://nabble.documentfoundation.org/TDF-Novos-membros-em-31-05-2011-tp3021079p3021425.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Is this list unmoderated?
It is benevolently moderated in the sense that real spam and commercial spammers are eliminated. But I haven't noticed any post from a real user being eliminated or any user banned. I guess some of the off-topic can be annoying but that is the price of freedom of speech ;) -- View this message in context: http://nabble.documentfoundation.org/Is-this-list-unmoderated-tp3016333p3017893.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: AutoCorrect/AutoFormat issue
Earl Melton wrote: I thought Lotus 1-2-3 used the Shift+2 (or @ character), i.e., @SUM(A1..A12). Did I think wrong? Maybe we're talking about different flavors of Lotus. Or maybe I'm having another one of those darned senior moments. No you didn't. It was my mistake (I noticed the minute I posted and since this isn't a forum I couldn't edit it :) ). I meant using + to start a formula. Lotus functions started with an @ indeed (which on the Portuguese keyboard is Alt Gr + 2 :( ) In any case, people who used Lotus (for DOS) are entitled to forget some things :) Have a great week! ;) -- View this message in context: http://nabble.documentfoundation.org/AutoCorrect-AutoFormat-issue-tp3007549p3009823.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: AutoCorrect/AutoFormat issue
You can use an old school trick: type +1/3 ;) (In fact Lotus used + as an indicator for a formula which was much more practical than = since it's already on the Num Pad... But everybody started following Excel... :( ) -- View this message in context: http://nabble.documentfoundation.org/AutoCorrect-AutoFormat-issue-tp3007549p3007676.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Dollars Cents in Spreadsheet
Cor Nouws wrote: Simply FormatCells Or via the Styles window (F11) you can also define styles for (different) cells That wouldn't work, Cor ;) It's not a question of formatting. The OP wants to type 123 and for the cell to display $1.23 The only solution I can see is to have a column where you type the values with no point (e.g. 123, 300, 98) and have it divided by 100 in another column and formatted as currency. These calculated values can even be on a separate worksheet so that you have one column for quick data entry and another worksheet where all is presented neatly :) -- View this message in context: http://nabble.documentfoundation.org/Dollars-Cents-in-Spreadsheet-tp3002443p3003620.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Dollars Cents in Spreadsheet
(can even give a clumsy work around). If it's better than having calculations in another column, please do. I could use a trick that saves me from typing the dot (because I often type the dot twice and then have to go back to correct it...) -- View this message in context: http://nabble.documentfoundation.org/Dollars-Cents-in-Spreadsheet-tp3002443p3003716.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Dollars Cents in Spreadsheet
:) In fact, after a quick search in Google, I found out that there is such a feature in a competing product ;) http://www.teachexcel.com/excel-help/ev.php?i=2957 Maybe this could be added as a feature request for Calc? -- View this message in context: http://nabble.documentfoundation.org/Dollars-Cents-in-Spreadsheet-tp3002443p3004072.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Trivia Question - Further Observation
Excellent post, Alexander. I agree that it is essential to have written rules of what to expect and what not to expect from a project. I totally disagree with LO's philosophy of Even if we broke something we might not fix it but it is better to know that than for users to complain and demand pointlessly. And the advice for people to get support from LO supporting companies is also an excellent point. I think TDF should use your post to make things clear to everybody instead of leaving it all in the grey area Kudos! -- View this message in context: http://nabble.documentfoundation.org/changes-for-this-mailing-list-tp2983621p2998110.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?
Are you aware that, at least in Win. that you can move between documents using Alt+tab? I find that much faster than trying to use a mouse. If you have a bunch of tasks running it's not so handy, but normally you are only switching between a few windows and it is very quick. Are you aware that if you press Ctrl+Tab you can do the same between documents (or tabs) within the same program? :) -- View this message in context: http://nabble.documentfoundation.org/tabs-in-LibreOffice-like-you-can-do-for-MS-Word-tp2993290p2994666.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?
@toki, thank you for the tip. The extension does work with LO version 3.4. It's a shame it has no options. I would rather have the tabs on top (like in Firefox :) ) Maybe one of the developers (I heard there are nearly 200 :) ) can do a quick fix to this extension ;) It would surely be useful when I have 6 or 7 spreadsheets open at once... -- View this message in context: http://nabble.documentfoundation.org/tabs-in-LibreOffice-like-you-can-do-for-MS-Word-tp2993290p2994678.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Yay! Parallel dev builds at last :)
Actually for a few days now (since the 19th) You can get an installer (for Windows and Mac currently) for the current code on the master (trunk). Browse here http://dev-builds.libreoffice.org/daily/ This includes the fix that allows to install a dev version simultaneously with a stable build. WARNING: this is available for en_US only. If you need a localized version stick with the 3.4 branch Congratulations to Dev Team for listening to the users! -- View this message in context: http://nabble.documentfoundation.org/Yay-Parallel-dev-builds-at-last-tp2987896p2987896.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc: set page number
Format, Page, Sheet tab, in the Page Order section change First Page Number to 26 ;) Enjoy ;) -- View this message in context: http://nabble.documentfoundation.org/Calc-set-page-number-tp2988097p2988344.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
The simple explanation is that the MSO file is missing many ODF features ;) Interestingly both your files fail the ODF validation on this site http://tools.odftoolkit.org/odfvalidator/ Does it make any sense that only when I create an identical file under OOo 3.4 Beta the file is valid? Should LibreOffice worry about this? Is the validator an accurate tool? Shouldn't OASIS be providing such a tool??? -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2985444.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
Hi Tom ;) If you re-write the document from scratch using exactly the same formatting in both then i would guess that LibreOffice generates the best and possibly smallest .odt. I did. It is not :) Since the MS ODF is so incomplete it manages to be the smallest. And the OOo file is the second smallest (and in addition, valid!) My only concern here is that TDF makes sure that the ODF files created with LibreOffice are valid. It doesn't make sense otherwise. And since Oracle seems to be dropping the ball on OpenOffice it would make sense to have a validation tool on the TDF or LibreOffice site (I wouldn't wait for OASIS...) MSO's odf is inherently broken apparently (as mentioned fairly often by a variety of people) so it's not really a fair contest. A broken jug in millions of pieces can take up a lot less space than a full jug but it probably can't hold water. TBH I'm glad that MS Office 2007/2010 even has ODF support. Of course they aren't going to make it that good... After all it is in their best interest that you use their proprietary file formats :) Cheers! -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2986245.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
But, it is clear that OOo/LO could use some 'fine tuning' in the file size/image compression/conversion area - at least with respect to Impress. If I get time if it is interest to anyone I can just build a 1 slide Impress presentation using the extracted .ppt jpg compare. I've only MS Office 2003 on a virtual machine, so I wouldn't be able to test with anything later in that department. I don't mind doing a comparison if you post a link to the PPS file. But this only has any usefulness if LO developers consider that optimizing the ODF files is an interesting task. Otherwise it's an academical waste of time ;) -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2986509.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Odt size difference between MS Office 11 and LO 3.3.2
Hi Gary I don't have a link for it - M. Henri Day sent it to me directly. But I'll be happy to email it to you if you'd like. Note: I had to do considerable timing adjustments to get it to sync with the external .wav file in order to get it to work in OOo with gstreamer. I meant upload it somewhere and send me the link :) But email is fine. I'm a Windows user so I hope it will be considerably easier to handle the pps ;) Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/Odt-size-difference-between-MS-Office-11-and-LO-3-3-2-tp2978634p2986763.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Test for Error Conditions in Calc
Here is an example: =IF(ISNA(A1); None; A1) See the Information Functions on this page for more http://www.techonthenet.com/excel/formulas/index.php -- View this message in context: http://nabble.documentfoundation.org/Test-for-Error-Conditions-in-Calc-tp2982777p2983265.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Fwd: [tdf-announce] failure notice
This is a polite way of telling you that you were NOT selected as one of the ESC members :) -- View this message in context: http://nabble.documentfoundation.org/Fwd-tdf-announce-failure-notice-tp2975606p2975783.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] RE: using libre office with portable apps
Probably the files in the pen are badly fragmented. Since that is a pen (and not a hard disk) the easiest, fastest and most efficient way to defrag is simply to MOVE all contents to a folder in another disk (preferably a HDD) and then move them back. Since files are moved sequentially they will be written in consecutive clusters and therefore defragmented. HTH ;) -- View this message in context: http://nabble.documentfoundation.org/using-libre-office-with-portable-apps-tp2960571p2964849.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: lower part of dialog boxes not visible
Hi NoOp You didn't say he was what? It is helpful if you'd quote what you are replying to. Snipping is good, but simply replying without some quote attribution isn't helpful - particularly if someone is sorting through the archives. I didn't snip anything. I simply replied through Nabble, which doesn't quote or append the message I'm replying to. Since it works in Threads my answer was linked to your post http://nabble.documentfoundation.org/lower-part-of-dialog-boxes-not-visible-tt2951830.html#none To answer as I am doing now, I have to use Gmail which for me is not so practical ;) We finally figured out that Thomas is using the 'Medium - 125%' setting in Win7 (Control Panel|All Control Panel Items|Display). There is a warning when setting that in Win7, it states: quote Some items may not fit on your screen if you choose this setting while your display is set to this resolution /quote Actually many (all?) Asus netbooks use this setting as default. So they will not see that warning :) Did/can you replicate on a netbook? I can't on an HP Mini w/Win7-Starter. If you can, then I agree it would be a good idea for you to file a bug report. Since the extended dialog is well over 500 pixels high I know it won't fit at least on any of the 7 inch netbooks which have a screen resolution of 800x480. On 10 inch netbooks it will depend on the DPI (as you mentioned) but also on the Theme font size Of course LO can't predict all these situations but in this particular case there is a lot of vertical space wasted on the dialog which could be optimized. -- View this message in context: http://nabble.documentfoundation.org/lower-part-of-dialog-boxes-not-visible-tp2951830p2956251.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: lower part of dialog boxes not visible
In the Ubuntu version of LibreOffice, some of the taller dialogs have been rearranged so the bottom half is to the side, so they fit better into a widescreen display such as found on many netbooks and laptops. (PDF Options is an example.) AFAIK, the standard version of LibO (downloaded from the website) does not use this side-by-side layout. Great to know - thanks for sharing ! (I usually work with all kind of betas and test stuff, hardly with default installed versions.) Would be good to have that in the vanilla LibreOffice too, IMO That is really interesting. It shows that Ubuntu has people concerned and working on usability. Since that is a modification of the open source code (and since Canonical IS a LO Supporter) shouldn't these modifications be contributed back to the source repository (or whatever the name is) in the spirit of Open Source Software (maybe it is and it's not incorporated?) -- View this message in context: http://nabble.documentfoundation.org/lower-part-of-dialog-boxes-not-visible-tp2951830p2956267.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: lower part of dialog boxes not visible
Hi again Thomas I think this is a pretty good solution: http://sourceforge.net/projects/fp-winmngr/ Just download and unpack the program in any folder. Execute FP Windowmanager and press the Hide button. From now on, to move the top window anywhere just press Win+Alt+Cursor keys It does work perfectly with the LO Find Replace dialog ;) (I apologize for recommending Winsize 2 without testing it first... I couldn't make it work...) -- View this message in context: http://nabble.documentfoundation.org/lower-part-of-dialog-boxes-not-visible-tp2951830p2959386.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: lower part of dialog boxes not visible
Of course LO can't predict all these situations but in this particular case there is a lot of vertical space wasted on the dialog which could be optimized. ... Agree. Just for fun I re-organized the dialog (this is a mock-up screen) http://dl.dropbox.com/u/2347109/Find_Replace.png Without too much effort I was able to reduce nearly 100 pixels in the 500 pixels high dialog ;) Now we just need a developer to do the same in the code :) -- View this message in context: http://nabble.documentfoundation.org/lower-part-of-dialog-boxes-not-visible-tp2951830p2959428.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: lower part of dialog boxes not visible
@Thomas You can use this Open Source program to solve your problem http://winsize2.sourceforge.net/en/index.html But I think that the options in the dialog should be rearranged. There is a lot of empty space on the dialog and this creates a problem with low resolution devices such as netbooks. -- View this message in context: http://nabble.documentfoundation.org/lower-part-of-dialog-boxes-not-visible-tp2951830p2953150.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: lower part of dialog boxes not visible
@NoOp I didn't say he was. I said this should be fixed because this will affect netbook users (and it is quite easy since there is a lot of wasted space on the dialog) Maybe Thomas is simply using a Theme with a Large Font... -- View this message in context: http://nabble.documentfoundation.org/lower-part-of-dialog-boxes-not-visible-tp2951830p2953547.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Draw extra slow with 4 slides
I assume you are adding notes to a PDF (since you mention Adobe Acrobat) Since you are using Windows I would recommend for such a task the free program PDF Xchange Viewer. It is a lightweight PDF reader with annotation tools. The advantage over Draw is that it doesn't convert the PDF. The disadvantage is that you are adding object over the PDF (so you can't actually modify the objects in the PDF, if that is important for you). -- View this message in context: http://nabble.documentfoundation.org/Draw-extra-slow-with-4-slides-tp2936703p2940292.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: No Help
Hi Jeff The help pack is in a separate RPM. If you go to http://www.libreoffice.org/download/ and choose Linux x86 there are two downloads: the 147Mb installer which you already have, and a 8.6Mb helppack. Just get this and install it (don't ask me how because I'm a Windows user :) ) Enjoy ;) -- View this message in context: http://nabble.documentfoundation.org/No-Help-tp2916725p2916767.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Pronunciation of LibreOffice in English
Actually if you read Libre as a Spanish word (instead of French) then the closest pronunciation for English speakers is probably Lee-Brea : Lee as Bruce and Brea as the word Bread but without pronouncing the final d This means that there are (at least) two correct pronunciations :) Just my 2 cents ;) -- View this message in context: http://nabble.documentfoundation.org/Pronunciation-of-LibreOffice-in-English-tp2914617p2916817.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Opening/converting a Lotus wk4 file for Calc?
FYI Symphony doesn't open Lotus spreadsheets (to Lotus users dismay) According to this page I found, Openoffice 3.2 does? http://www.ehow.com/how_6462332_convert-wk4-xls.html Then LO should do it too... (Can you link to one of this files?) -- View this message in context: http://nabble.documentfoundation.org/Opening-converting-a-Lotus-wk4-file-for-Calc-tp2907370p2907538.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Opening/converting a Lotus wk4 file for Calc?
I use Gnumeric and I couldn't find any information on opening wk4. It does mention that it opens wk1 and wks but I suspect that wk4 is quite different. Yes, there is a Windows version and it is kept up-to-date. TBH if Gnumeric had a Pivot Table/Data Pilot function it would be light years ahead of Calc ;) -- View this message in context: http://nabble.documentfoundation.org/Opening-converting-a-Lotus-wk4-file-for-Calc-tp2907370p2908252.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Opening/converting a Lotus wk4 file for Calc?
I'm glad you solved your problem ;) That is why Microsoft makes sure that it is easy to get and use irregular copies: when other programs fail you can always go back to MS Office :) -- View this message in context: http://nabble.documentfoundation.org/Opening-converting-a-Lotus-wk4-file-for-Calc-tp2907370p2909236.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: .docx can't be read
Could this be simply because LibO (and OOo) is not handling correctly windows OLE objects in the docx format? See my post on the previous page (on the nabble site for this topic) about Equations. -- View this message in context: http://nabble.documentfoundation.org/docx-can-t-be-read-tp2889232p2902529.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: List of download mirrors
I have been looking for such a page for ages. Thanks! It would be easier to find a mirror if they were simply sorted alphabetically. It the page was on a wiki I would sort it myself...-- View this message in context: http://nabble.documentfoundation.org/List-of-download-mirrors-tp2883129p2884415.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: -convert-to command line option on Windows
There is no problem with this function if you use the installed LibreOffice. The problem is that you are passing the parameters to the PortableApps executable which is probably not passing it correctly to soffice.exe So, if you intend to use the Portable LOffice you need to report this to whoever is creating the portable version ;) -- View this message in context: http://nabble.documentfoundation.org/convert-to-command-line-option-on-Windows-tp2866363p2870459.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Chart how to
CohoMike, actually if you do that in Excel and open the file in Calc, the Chart tab will show up as a regular spreadsheet tab with a large chart on top of the cells :) -- View this message in context: http://nabble.documentfoundation.org/Chart-how-to-tp2861232p2872014.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Chart how to
If you used Excel you would know what CohoMike is talking about. Excel allows to create a special type of Sheet named Chart where the only object is a Chart using data from one of the other Sheets. It is particularly useful when you have large spreadsheets with many tabs. It makes it easy to locate a chart and it is very easy to switch to/from this mode and to create Chart tabs. -- View this message in context: http://nabble.documentfoundation.org/Chart-how-to-tp2861232p2872396.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Opening a PPS file in not-presentation mode
Double clicking a PPS opens the file in slideshow as expected. The problem is that starting Impress and then opening a PPS file should open it in Edit mode (as PowerPoint does). Instead it opens it in slideshow mode and closes Impress on ESC. This is indeed a bug which makes it impossible to edit a PPS file (without using the rename hack which is not a solution ;) ) -- View this message in context: http://nabble.documentfoundation.org/Opening-a-PPS-file-in-not-presentation-mode-tp2833269p2838333.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LibreOffice Update Mechanism
Hi Arief Yes, it is planned but there is no schedule for when it will be available http://nabble.documentfoundation.org/update-service-td2479818.html -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-Update-Mechanism-tp2838224p2838957.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Ellison's Oracle washes hands of OpenOffice
@Wayne I think that the BEST option would be to have 3 options available: 1) Classic menu 2) Ribbon and 3) the Future ;) (By the Future I'm referring to this topic http://nabble.documentfoundation.org/Impressive-mockups-td2389105.html) The UI could be selected on first use (or later in some configuration option) by presenting the user with a screenshot of each of the possibilities ;) Returning to the topic, I think that if there isn't a paid version with professional support, the future looks dark for OOo/LO. So, Oracle dropping support for OOo is extremely bad for LO as well. -- View this message in context: http://nabble.documentfoundation.org/Ellison-s-Oracle-washes-hands-of-OpenOffice-tp2826546p2834650.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Spreadsheet Problem
It's hard to guess what happened to the file or what format it is in... If the data is not confidential, please upload it somewhere (e.g. http://depositfiles.com/en/) and post the link here. -- View this message in context: http://nabble.documentfoundation.org/Spreadsheet-Problem-tp2830785p2830909.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Ellison's Oracle washes hands of OpenOffice
Good morning Tom ;) Although I agree with most of your arguments, Microsoft's position on Office has changed a lot lately. First it is almost impossible to buy a new Win7 machine which doesn't have some version of Office bundled. It varies from a Trial version to a Starter version and sometimes even the whole Office is included. On a second (and probably more important) front, Microsoft silently retired the Office Genuine Advantage check which prevented illegal copies to be updated http://www.zdnet.com/blog/bott/microsoft-quietly-shuts-down-office-genuine-advantage-program/2798 I think that Microsoft is taking measures to prevent it's users to shift to an Open Source Office suite ;) -- View this message in context: http://nabble.documentfoundation.org/Ellison-s-Oracle-washes-hands-of-OpenOffice-tp2826546p2827501.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Impress: Importing multiple pictures, one per slide?
This add-on does exactly what you asked and works perfectly under LibreOffice 3.3.2 (tested in Windows XP) http://extensions.services.openoffice.org/en/project/PhotoAlbum -- View this message in context: http://nabble.documentfoundation.org/Impress-Importing-multiple-pictures-one-per-slide-tp2666781p2790419.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LO Calc very slow and freezes
Gnumeric supports up to 16777216 lines (yes, 16 million...) Maybe you are using an older version. The current build is 1.10.13 -- View this message in context: http://nabble.documentfoundation.org/LO-Calc-very-slow-and-freezes-tp2710811p2712956.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Day zero is 1904-01-01 for new spreadsheets
This is puzzling: if day Zero is 0-Jan-1900 and day 1 is 1-Jan-1900 for Excel and day Zero is 30-12-1899 and day 1 is 31-12-1899 for both LibO 3.3.1 and OOo Dev101, how come =now() returns the same value in both spreadsheets? -- View this message in context: http://nabble.documentfoundation.org/Day-zero-is-1904-01-01-for-new-spreadsheets-tp2589349p2589990.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Day zero is 1904-01-01 for new spreadsheets
Very interesting, Andreas. Today I learned something about leap years thanks to you ;) http://kalender-365.de/leap-years.php I'm glad I don't have any time series of data going back to the 19th century :) -- View this message in context: http://nabble.documentfoundation.org/Day-zero-is-1904-01-01-for-new-spreadsheets-tp2589349p2590985.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc trumps Excel
T.R. Valentine When you open a tab delimited file in Excel it automatically recognizes the data types. Therefore your string e.g. 2011-02-26 10:23:47 is correctly interpreted as a value. Therefore it is natural that using FIND, VALUE, LEFT or any other functions would not work. As I said in the previous post you need to use other functions. LibO and OOo don't have any problem with tab delimited files. The only difference is that you can not Open a tab delimited file (otherwise it is loaded in Writer). You need to Insert, Sheet from File. Luuk Indeed there is a lot of work... I just found another bug: typing =now() in a cell shows the value instead of a date (of course you can format it yourself...) -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2581181.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc trumps Excel
That doesn't make any sense, does it? The format of the values depends on the width of the cell??? There are only two logical options: 1) the cell width is automatically adjusted to show the whole data (as Excel does) or 2) the data is correctly formatted (in this case in the DATE TIME format) and only part is shown (depending on the width of the column). The user must manually adjust the column width. -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2581281.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc trumps Excel
Hi Tom I'm sorry to say but you are wrong on this one. LibO and OOo don't auto-resize but Excel does. Just type =now() on any cell and watch one of the reasons why Excel is the number one spreadsheet bar none ;) Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2584477.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc trumps Excel
VALUE and TIMEVALUE apply to TEXT strings ONLY both in Excel and LibO If you want to parse a value field you have to use different functions How did you import the Tab delimited file to LibO? -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2574555.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Missing function: Bankers Rounding
What I meant was: if the original numbers have a mixed number of decimal cases you can't apply my solution because of the base 2 calculations. But I assume that in a table you don't have values with 3 decimal cases mixed with one decimal case? Therefore you could go from 4 decimal cases to 1 in 3 steps using my method... In any case, the short answer is: there isn't such a round function in any of the 3 spreadsheets. Apparently the round() function in Visual Basic for Applications (VBA) does a bankers' rounding. http://groups.google.com/group/microsoft.public.excel.charting/msg/107fce6145b70d69?pli=1 Hope this helps -- View this message in context: http://nabble.documentfoundation.org/Missing-function-Bankers-Rounding-tp2530641p2533054.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Missing function: Bankers Rounding
I had never heard of bankers rounding before. Interesting concept. There is no such function in OOo/LO, Excel or Gnumeric... But you can easily create a function =IF(A1-INT(A1)=0.5;IF(ISEVEN(INT(A1));A1-0.5;A1+0.5);ROUND(A1)) (Adjust if your separator is a comma instead of a semi-colon) What this does is check if the fractional part is 0.5 and adds 0.5 to the number if the integer is odd and subtracts if it is even. If it is not 0.5 then it uses the regular Round() function ;) Hope this helps! -- View this message in context: http://nabble.documentfoundation.org/Missing-function-Bankers-Rounding-tp2530641p2530764.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Installing LibreOffice under Ubuntu 9.10 aka Karmic
Yes, that does work. But I was looking for a solution that didn't involve manually downloading, unpackaging, etc... In theory, adding the PPA options would not only install the current version but also allow updates when available. What puzzles me is that unless Hit means something different, most of the folders and files are there, except for Packages.gz Am I correct? -- View this message in context: http://nabble.documentfoundation.org/Installing-LibreOffice-under-Ubuntu-9-10-aka-Karmic-tp2507198p2509040.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Open pps as ppt
I did try and the result is the same (starts Slideshow). In any case even if that did work it would be a workaround, not the expected action ;) -- View this message in context: http://nabble.documentfoundation.org/Open-pps-as-ppt-tp2457168p2513898.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Installing LibreOffice under Ubuntu 9.10 aka Karmic
I'm an advanced Windows user but absolute Linux newbie. I was trying to install Libreoffice under Ubuntu Netbook Edition 9.10 (the only version that has drivers for my eeePC netbook) following these instructions http://www.omgubuntu.co.uk/2011/01/new-ppa-makes-installing-libreoffice-on-ubuntu-easy/ But got this error messages ubuntu@ubuntu:~$ sudo apt-get update sudo apt-get install libreoffice Hit http://archive.ubuntu.com karmic Release.gpg Ign http://ppa.launchpad.net karmic Release.gpg Hit http://archive.ubuntu.com karmic Release Hit http://security.ubuntu.com karmic-security Release.gpg Ign http://ppa.launchpad.net karmic Release Hit http://security.ubuntu.com karmic-security Release Hit http://archive.ubuntu.com karmic/main Packages Ign http://ppa.launchpad.net karmic/main Packages Hit http://archive.ubuntu.com karmic/restricted Packages Hit http://archive.ubuntu.com karmic/multiverse Packages Hit http://archive.ubuntu.com karmic/universe Packages Hit http://archive.ubuntu.com karmic/main Sources Hit http://archive.ubuntu.com karmic/restricted Sources Ign http://ppa.launchpad.net karmic/main Packages Hit http://security.ubuntu.com karmic-security/main Packages Err http://ppa.launchpad.net karmic/main Packages 404 Not Found Hit http://security.ubuntu.com karmic-security/restricted Packages Hit http://security.ubuntu.com karmic-security/multiverse Packages Hit http://security.ubuntu.com karmic-security/universe Packages Hit http://security.ubuntu.com karmic-security/main Sources Hit http://security.ubuntu.com karmic-security/restricted Sources W: Failed to fetch http://ppa.launchpad.net/libreoffice/ppa/ubuntu/dists/karmic/main/binary-i386/Packages.gz 404 Not Found E: Some index files failed to download, they have been ignored, or old ones used instead. I suppose this means there is a specific build for Karmic (something similar as a specific build for Windows 2000) but not all needed files are available for that specific OS version? Thank you in advance for any help ;) -- View this message in context: http://nabble.documentfoundation.org/Installing-LibreOffice-under-Ubuntu-9-10-aka-Karmic-tp2507198p2507198.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Open pps as ppt
There is indeed a bug (or at least a different behaviour from MS Office and OOo) with .pps files If a user double clicks or opens with a pps file with MS Powerpoint or LO Impress it is supposed to autostart the presentation. However if you open Powerpoint and use File Open to open the pps file it does so in Edit mode. OOo Impress does the same LO Impress does not. Opening a pps file immediately enters presentation mode and pressing Esc to stop, exits LO Impress. It is arguable to say that this is a bug. But it is not the expected behaviour. (this was tested under Windows XP SP3 with OOo 3.3.0 and LO 3.3.1 RC1) -- View this message in context: http://nabble.documentfoundation.org/Open-pps-as-ppt-tp2457168p2493716.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc
I have four comments on relative paths in OOo/LO: 1) It doesn't work. I changed to relative paths, created a new file with a relative path, moved both files (source and reference) to another drive and it kept looking for the file in the original location 2) It doesn't make any sense to save a path as relative and show it as absolute 3) It doesn't make sense that the option is called Save URLs relative to file system. I consider myself an advanced user and I would never consider that this option refers to the location of files my PC. URLs are usually associated (maybe incorrectly) with resources on the web. In any case it's not an obvious name. 4) It doesn't make any sense that the OOo/LO default is the opposite of what users are expecting. If OO / TDF want to create an alternative to the established Office they should follow the same functionality, improving but not disrupting. -- View this message in context: http://nabble.documentfoundation.org/Calc-tp2475968p2480367.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] RE: Poor formatting and extremely slow performance
I know this won't help a bit, but it looks as bad under OOo 3.3.0, OOo 3.4.0 m99 and Abiword (all under Windows XP SP3) If these files are not meant for editing I advise you to export to PDF using the fantastic FLOSS program PDF Creator. (BTW the reason most documents work in MS programs is that they have relaxed rules i.e. ignore errors instead of pointing them out :) ) -- View this message in context: http://nabble.documentfoundation.org/Poor-formatting-and-extremely-slow-performance-tp2474417p2476186.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?
IMO the project has the potential to become internationalized. Are you joking? I can't even understand why the other national teams aren't taking advantage of this initiative! Congratulations! I hope others will follow the German example! (I'm curious: why is the Slimcase Inlay so low res? Isn't the original an SVG like for the labels? Can someone post the original?) -- View this message in context: http://nabble.documentfoundation.org/where-is-the-guidelines-on-what-to-put-on-a-CD-DVD-distro-of-LibreOffice-tp2455707p2457291.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?
Hi Stefan, indeed much better. I can see now why the original is not shared ;) In any case you should replace those low res labels ASAP ;) Here is a much nicer PNG (BTW I have no idea why the corner crop marks grow inside the light green area in your PDF...) http://dl.dropbox.com/u/2347109/libo_dvd_inlet_feb2011_01.png Thank you for the link, Marc. I can see there are a lot of proposals... :) Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/where-is-the-guidelines-on-what-to-put-on-a-CD-DVD-distro-of-LibreOffice-tp2455707p2458753.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?
Yes, you are right. I failed to notice the _de detail but if you read this thread you are now aware that there is a wiki page on this subject ;) http://wiki.documentfoundation.org/Marketing#Documents_and_Resources -- View this message in context: http://nabble.documentfoundation.org/where-is-the-guidelines-on-what-to-put-on-a-CD-DVD-distro-of-LibreOffice-tp2455707p2458919.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc too slow in opening Excel spreadsheets
Yes, this has been reported. The problem is not restricted to the xls format... See a similar topic http://nabble.documentfoundation.org/Why-is-LO-OOo-so-slow-loading-a-spreadsheet-td2006665.html Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/Calc-too-slow-in-opening-Excel-spreadsheets-tp2450688p2450788.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Libreoffice and openoffice issues
Yes, they are. And in my (short) experience here at LibreOffice they seem to be more efficient in solving bugs than the guys at OO.org That doesn't mean it will be fixed tomorrow ;) In any case there is a separate bug tracker for LO here https://bugs.freedesktop.org/ -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-and-openoffice-issues-tp2322574p2332679.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: How to sort this dataset in Calc?
Actually it does work. Just select columns A and B and press the sort icon or choose Data, Sort for more options. The only situation where LO and OOo don't accept whole columns is in cell formulas :( -- View this message in context: http://nabble.documentfoundation.org/How-to-sort-this-dataset-in-Calc-tp2278989p2279456.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: How to sort this dataset in Calc?
Stefan, you can either move the cell or use Data, Sort instead. I prefer to see the options I'm choosing instead of relying on focus. Regarding selecting only one column, currently LO and OOo have the same behaviour as Excel 2003 (I refuse to use newer versions): ask if the user wants to expand the selection. Which I think is the best solution: ask the user instead of trying to guess what s/he is doing... -- View this message in context: http://nabble.documentfoundation.org/How-to-sort-this-dataset-in-Calc-tp2278989p2279528.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Dictionaries and Language Packs
I'm currently installing RC3 (under Windows) and something puzzles me: why is the list of dictionaries available different from the language packs? If there is some criteria for including languages in the multi package, shouldn't it be consistent? E.g. I can choose the Portuguese language pack but not the Portuguese dictionary. On the other hand I can choose the Portuguese (Brazil) language pack but the dictionary is for Brazilian Portuguese I know that the multi package is temporary due to space restrictions but as we move up the RC ladder (I know that OOo is currently on RC9) shouldn't this start to be fixed? -- View this message in context: http://nabble.documentfoundation.org/Dictionaries-and-Language-Packs-tp2248527p2248527.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Including a ods in a odt
No, it's not equal at all. Your data will be updated dinamically as you modify if it the ods file. There is no similarity with a static HTML table. I'm glad I could help ;) -- View this message in context: http://nabble.documentfoundation.org/Including-a-ods-in-a-odt-tp2200869p2216108.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Including a ods in a odt
You can include up to 4000 rows (do you think you will have more than that?) and it will always be updated. Before delivering the report you just need to delete the lines in excess (or leave them in...) The other option (mail merge) I was suggesting would require one page per post instead of a table... -- View this message in context: http://nabble.documentfoundation.org/Including-a-ods-in-a-odt-tp2200869p2212949.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Including a ods in a odt
I'm not sure I understand your problem, but if you would refer to the ODS cells in the ODF document like a mail merge then you could create a document which will have all your up-to-date cell contents when you print it to a final document (in addition to what you type in the ODF document, of course) The only limitation I could find is that you need to have one post per column and you are currently limited to 1024 columns in the ODS format -- View this message in context: http://nabble.documentfoundation.org/Including-a-ods-in-a-odt-tp2200869p2206893.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Including a ods in a odt
Actually that is not what I imagined from your first post. I thought it would be a spreadsheet with a single column used where each line would be a new post to your journal. Maybe you can upload an example of the ods (two lines of fake data are enough) and what you expect the final odf to look like (a table within the text? a quoted post?) I'm not sure what you mean with merged text: something like C1 cell content is =A1B1 ? -- View this message in context: http://nabble.documentfoundation.org/Including-a-ods-in-a-odt-tp2200869p2207297.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Including a ods in a odt
I thought it was something more complex :) The easiest way to include it is to open the ods file, select the cells with data and then switch to the Appendix and choose Paste Special, DDE Link. From now on, each time you open the file it will ask you if you want to Update all links. You should keep the ods and odf files on the same folder. Unfortunately relative paths doesn't work (or I can't find the option to activate it) so you must always work on the same drive and folder otherwise the table won't be updated. Hope this helps... -- View this message in context: http://nabble.documentfoundation.org/Including-a-ods-in-a-odt-tp2200869p2208601.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Including a ods in a odt
I thought it was something more complex :) The easiest way to include it is to open the ods file, select the cells with data and then switch to the Appendix and choose Paste Special, DDE Link. From now on, each time you open the file it will ask you if you want to Update all links. You should keep the ods and odf files on the same folder. Unfortunately relative paths doesn't work (or I can't find the option to activate it) so you must always work on the same drive and folder otherwise the table won't be updated. Hope this helps... NOTE: I'm not sure if the DDE Link option is available under other OSes. These instructions apply to the Windows version. -- View this message in context: http://nabble.documentfoundation.org/Including-a-ods-in-a-odt-tp2200869p2208611.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Closing LibreOffice results in a crash
RC2 is already available for download on selected mirrors... This one for instance http://ftp.heanet.ie/mirrors/tdf/libreoffice/testing/ -- View this message in context: http://nabble.documentfoundation.org/Re-Closing-LibreOffice-results-in-a-crash-tp2128832p2132613.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Idea about Ideas
I found Ubuntu Brainstorm very dis-satisfying. The main problem with it (imo) is that the first few pages are all old ideas that have received a lot of votes. If the first page had the most easily viable ideas along with the most innovative and interesting ideas then it would work a lot better. The problem is how could that be automated?? That is quite simple. If the ideas are outdated they should simply be dismissed by the devs as Outdated :) The voting process is the most democratic (anyone can suggest an idea) and the most meritocratic (the best ideas climb to the top independently of who suggested them) Of course this forces the devs to take a look at the list, say once a month, discuss the top 10 items and classify them as Planned, Outdated, Portponed, Rejected, etc (this is a mix of options available in Dropbox and Sourceforge) As soon as an idea is classified as Completed it is archived and the next most voted idea will rise to the top 10 automagically ;) -- View this message in context: http://nabble.documentfoundation.org/Idea-about-Ideas-tp2117657p2125442.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: vlookup is hard to use
This is a know limitation/feature of OpenOffice and now of LibreOffice. In my opinion it should be modified to make it consistent with other spreadsheets. There is no easy way other than to type a high number (currently it can be as high as 1048576) or to make it faster just type 1 followed by 6 zeros) This is faster than selecting with the mouse (given the limitation that you can't simply select a column or row) -- View this message in context: http://nabble.documentfoundation.org/vlookup-is-hard-to-use-tp2069838p2072723.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: On Applications Exit
It had already been reported https://bugs.freedesktop.org/show_bug.cgi?id=31494 and a workaround has already been committed to the branch (meaning it will be solved in the next build) Thanks! -- View this message in context: http://nabble.documentfoundation.org/On-Applications-Exit-tp1950798p1964197.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: On Applications Exit
Same here on two machines. Same Win version, same LO build. Is this an XP problem only? LO 3.3 b2 didn't have this bug. -- View this message in context: http://nabble.documentfoundation.org/On-Applications-Exit-tp1950798p1956061.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
Bill, do the cells in the range contain only natural numbers? I suspect that you are having a problem with the decimal separator. Your cells are probably identified as text because of that (are the values aligned to the left?) Paste this in cell D2 to check =VALUE(C2) -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p1847724.html Sent from the Users mailing list archive at Nabble.com. -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work
Actually it depends on your Language Settings. And LibreOffice inherited the problems from OpenOffice... E.g. for Portuguese (European) the decimal separator is a comma(,) but if I prefer to use a point (because most international publications are formatted according to US notation) when I disable the box Same as locale setting it will type the point and as soon as I press enter it will convert it to a date. This is a clear mistake since a point is not a separator in Portugal... i.e. typing 2.3 is converted to 02-03-2010 which is value 40239 -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p1843520.html Sent from the Users mailing list archive at Nabble.com. -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted