http://blog.gmane.org/gmane.comp.documentfoundation.libreoffice.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31220 <pre>Hi, I'd like to disable the "save as" menu item and keep that setting within an odt (not as a global application setting). I can do this easily for the "save as" button in the TOOLBAR (I'm allowed to keep this setting within the .odt file). However, I can't seem to do it for the MENU (I can remove the "save as" entry but it's at the global application level, not at document level). Can this be done even if I were to hack the .odt file content? Thanks, Vieri </pre> Vieri 2013-06-19T07:41:11 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31217 <pre>Is there a way to make text selection be like the conventional method where when you select text there is no blinking cursor at the end and also be able to just Shift Click in the middle and make the selection smaller? I am attaching an image as what happens. There is a blinking cursors at the end of the text selection which I find confusing.Then I cannot for example change the text selection by just Shift click. Shift and click drag first in either direction? I am using LO v4 on Mac OS X Mountain Lion. &lt;http://nabble.documentfoundation.org/file/n4062108/Screen_Shot_2013-06-18_at_3.06.32_PM.png&gt; -- View this message in context: http://nabble.documentfoundation.org/Can-I-make-text-selection-conventional-tp4062108.html Sent from the Users mailing list archive at Nabble.com. </pre> wyattbiker 2013-06-18T19:19:24 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31216 <pre>Hello, My name is Matti Lammi. I have a feature request for Impress. I'm have not participated in the development of Libreoffice before and I don't know if this is the right place to make feature requests so please excuse me if it is not. I would like to be able to record macros in Impress. Currently it is possible in Writer and Calc but not with Impress. Why? Is there something in Impress' source code which makes implementing macro recording difficult or have the developers simply regarded this feature as unimportant and focussed on more important tasks? I would like to have this feature implemented. Can you tell how I can make it happen? I have only very basic coding skills so I don't know if I can implement this myself. Is there any developer out there who would be interested in implementing this feature? Regards, Matti Lammi </pre> mattij.lammi< at >kolumbus.fi 2013-06-18T23:03:03 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31207 <pre>Hi All, I'm running LibreOffice Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539) on Windows 7 64-bit. Files are saved in native ods format. I'm using a custom format code on a cell in Calc to get a value displayed as a rate per hour. This is the format code I want: [$R-1C09] #,##0.00 " / hour";[$R-1C09]-#,##0.00 " / hour" As it is, that code works fine. When I enter a value of 300, I can use it in calculations, and it gets displayed as "R 300 / hour", just as I want. The problem comes in when I close the file. Even if all I do is enter the correct formula as above, then save and close the file, when I re-open the file, the field now displays as "R 300.00 / hoRr". When I go to the cell format, I see the format code has changed to: [$R-1C09] #,##0.00" / hRRr";[$R-1C09]-#,##0.00" / hoRr" This happens every time I close the file. When I re-open it, the format has changed. This is not caused by the save, because once edited, the formula stays correct for the duration of the session, until I close the file. It's not just that "hour" has changed to "hRRr" and "hoRr", but the space between the "0.00" and the quote has gone (in fact, the quote now has two spaces after it, instead of the one before I closed the file). This space is very important. If I edit the formula as it is, and just change the "hRRr" to "hour", the format code is removed. On the previous version of LibreOffice I had (not sure which version that was, though, either 3.5 or 3.6 something), it would have no effect. After editing the format code, the value would still be displayed wrong, and going back to the cell format, I would see that the format code had reverted back to the wrong code. Only if I put a space between the "0.00" and quote would the code retain the "hour". Now, on this version of LibreOffice, if I don't put a space between the "0.00" and the quote, if I just change the "hRRr" and "hoRr" to "hour", the custom format code is entirely removed, and the format reverts to a standard number. If I correct the format, it stays until I close the file, and then once I re-open it, it has reverted to the incorrect custom format code. I have had this issue in several files, and can re-create it by opening a new file, putting "300" in the first cell, going to "Format | cells" choosing currency and putting ' " / hour"' after both "0.00". This shows correctly. Then I save the file, close it, and re-open it and it has mangled the custom format code. Can anybody else confirm that they are also having this problem? Does anybody know anything about this problem? Should I submit a bug for this problem, and if so, where? At https://bugs.freedesktop.org/ or at https://www.libreoffice.org/get-help/bug/ ? I have tried searching both the mailing list archive and the bugtracker for this problem, but didn't turn up anything relevant. Regards Paul Steyn </pre> Paul 2013-06-18T12:42:38 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31205 <pre>Hi, I have another problem with my charts in Calc. I need to present a series of data using column and line chart. Here you have a simplified set of data. DateABC 2012/10/120,8-247,9 2012/10/130,6-248,9 2012/10/140-248,7-248 2012/10/152,4-249,2 2012/10/160,2-248,3 2012/10/170,4-248,9 2012/10/180,2-248,9 2012/10/190,6-249,1 2012/10/200,2-248,6 2012/10/210-248,6-105 2012/10/222-248,2 2012/10/230,6-248,3 2012/10/240-248,5 2012/10/250,6-248,6 2012/10/261,6-248,7 2012/10/270,2-239,2 2012/10/280-235 2012/10/290-239,5 2012/10/300-229,6-229 Data in column A must be presented as a column chart, B and C as a line chart. The problem is that C data is discontinuous and is not drawn as a continuous line. What should I do? Any help will be appreciated. Regards, gordom </pre> gordom 2013-06-18T11:58:54 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31204 <pre> Hello! I was interested in the product  LibreOffice Online, but I could not find information on it Where can I read more details? We have a local network and over 2000 users. We consider software LibreOffice Online, so that users can work with "*.odf" files via web-browser. Will we be able to implement such LibreOffice Online. Thank you. </pre> Пузырев Алексей 2013-06-18T10:02:24 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31199 <pre>Hi, My name is Ryno, I have a question on writer regarding the page frames. If I want to place a fancy frame,i.e. picture, around my page how would I go about to do that. LibreOffice : 4.0.3.3 OS : Win7 64 bit Regards Ryno Labuschagne </pre> Ryno Labuschagne 2013-06-18T10:03:14 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31195 <pre>How can I show the result of an IF function as Text instead of Value? eg. IF test, 'Passed,'Failed Tink. -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4062008.html Sent from the Users mailing list archive at Nabble.com. </pre> Tinkerer 2013-06-18T09:26:41 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31189 <pre>Hi, I'm preparing a calc spreadsheet consisting of numerous charts. Because it's quite time consuming to make all necessary formatting, I would like to edit only one chart and apply this style to the rest of charts later on. How, if ever, is it possible (I tried to use Styles and Formatting applet but it didn't work)? Thanks for any help, gordom </pre> gordom 2013-06-17T12:29:41 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31186 <pre>Hi All I have LO 3.6.5.2 on PCLOS 2013 Is it possible to do the following in Calc?? I have two list of names (and other data) side-by-side in a Spreadsheet and I want to Split the Spreadsheet vertically to show the LH part on the left and the RH part on the right. This I can do but the two parts don't scroll vertically independently, there is only ONE Scroll Bar. So they remain in sync!! (What I need to do is scroll the RH part, without the LH part moving to find a match in the two lists) The Horizontal Split works like this with two Scroll Bars for each part. Is there a way of doing this Vertically?? Thanks for any help IanW Pretoria RSA </pre> Ian Whitfield 2013-06-17T11:10:15 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31185 <pre>I had just started on the document and only written half a page or so with notes from a trip, therefore did the error not make much problem for me, but it could have, if it had happen later. The file was saved in a Dropbox folder, I opened it yesterday, wrote a few more sentences and then I tried to put in a picture; got the wrong one first, deleted it and replaced it with the right image. When I then tried to save the document again did I get I/O error... and the file was overwritten by a 4.1kb empty document, which i attach to this email. My (unqualified) guess is that the problem might be related to inserting, removing and then inserting picture and frame, or to saving in Dropbox. Versjon 4.0.2.2 (Bygg-ID: 400m0(Build:2)) KDE 4.10.4 Ubuntu 13.04 Odd Karsten Hanken Hankevegen 117 6020 Ålesund +47 916 09 237 +47 71 49 10 33 skype: okh1953 </pre> Odd Karsten Hanken 2013-06-17T09:03:06 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31180 <pre>Hi, I'd like to know how to write a macro that displays a message box for x seconds and closes without user interaction. msgbox or print don't seem to support "timeouts". Thanks, Vieri </pre> Vieri 2013-06-17T08:12:04 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31178 <pre>To Users: I hope my apology is accepted, as I made the mistake of including the list in something NOT intended for the list. </pre> John Boyle 2013-06-16T22:35:40 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31176 <pre>To Users: I had that font, at one time, but when I upgraded to libre office 4, I seem to have lost it. I would like to know where I can go and download just one font, not 1000 fonts which I do not need? </pre> John Boyle 2013-06-16T22:38:02 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31174 <pre>Dear LibreOffice Team, My antivirus program under Windows is blocking the access to your website because it is infected with a malware. I'm accessing your website using a linux operating system (debian based distro). Is it possible for you to check if your website has been infected? And thank you for the excellent office suite you have created. Kind regards from Romania, Petre Borocan </pre> Petre Borocan 2013-06-16T18:55:51 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31169 <pre>Dear All, I have LibreOffice 4.0.3 from Debian Wheezy backports. Sadly this doesn not install the Linux Libertine G font. I wanted to download it from http://numbertext.org/linux/ (particularly http://www.numbertext.org/linux/e7a384790b13c29113e22e596ade9687-LinLibertineG-20120116.zip), but the link starts downloading a few bytes then stops, it does this for a few weeks. Is the download problem just on my side? Is there somewhere else I can download the font? Bonus question: will LibreOffice 4.1 use harfbuzz and thus make Linux Libertine G obsolete? Thank you, </pre> Élie Roux 2013-06-16T11:29:37 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31146 <pre>Is there such a thing as to many DDE links? -------- Original Message -------- From: Mike Shaul &lt;mike&lt; at &gt;shaulph.ca&gt; Sent: Thu Jun 13 15:04:39 PDT 2013 To: users&lt; at &gt;global.libreoffice.org Subject: [libreoffice-users] DDE Links from calc to writer Hello all, I have created a document in writer that has DDE links to a spreadsheet I created in calc. It has recently been acting funny, when I change a value in the calc spreadsheet it used to change all the values in the document in writer. Now, about 80% of the writer document responds to the changes in calc but about 20% does not. Could this be due to having too many links? I have about 3400 DDE links. I'm using: LibreOffice 3.5.4.2 Linux mint Cinnamon I should also say that on a scale from 1-10 on computer knowledge I'm at best a 5. Thank you in advance, -Mike </pre> Mike Shaul 2013-06-14T13:31:43 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31145 <pre>Hi, I'm using LibreOffice 4.0.3.3 (Build az.: 400m0(Build:3)). BetweenTwoNumbers.ods &lt;http://nabble.documentfoundation.org/file/n4061491/BetweenTwoNumbers.ods&gt; In the uploaded file BetweenTwoNumbers.ods there are four sheets: between 20-60, Num 1, Num 2, Num 3. On the 'between 20-60' sheet there are three functions to determine how many numbers can find on sheets Num 1, Num 2 and Num 3 respectivly ( one by one ) and there is a fourth function that sholud count that at once on all Num 1-3 sheets. As one can see, none of these three functions works: =COUNTIF('Num 1'.A1;AND('Num 1'.A1&gt;20;'Num 1'.A1&lt;60)) =COUNTIF('Num 2'.A3;AND('Num 2'.A3&gt;20;'Num 2'.A3&lt;60)) =COUNTIF('Num 3'.A5;AND('Num 3'.A5&gt;20;'Num 3'.A5&lt;60)) moreover, I don't know how to create fourth function. Can one advice me how to go further? ----- Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491.html Sent from the Users mailing list archive at Nabble.com. </pre> csanyipal 2013-06-14T13:25:06 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31141 <pre>Hi, I'm fighting LO (and OO) to get some basic stuff working and I think I found a bug. I'm running a Java macro which in turn calls a Basic macro that was installed in the global "share" directory. LO complains that the Java macro (which is being run correctly) is unable to find the following Basic macro: library: 'HMAN_SaveDoc' module: 'HMAN' method: 'SaySomething' location: 'share' However, as you can see in the screenshots I'm attaching, that macro is available (I can run it manually). Does anyone have any suggestions before I file a bug report? Thanks, Vieri </pre> Vieri 2013-06-14T11:28:09 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31133 <pre>Hello all, I have created a document in writer that has DDE links to a spreadsheet I created in calc. It has recently been acting funny, when I change a value in the calc spreadsheet it used to change all the values in the document in writer. Now, about 80% of the writer document responds to the changes in calc but about 20% does not. Could this be due to having too many links? I have about 3400 DDE links. I'm using: LibreOffice 3.5.4.2 Linux mint Cinnamon I should also say that on a scale from 1-10 on computer knowledge I'm at best a 5. Thank you in advance, -Mike </pre> Mike Shaul 2013-06-13T22:04:39 http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/31121 <pre>Hello, When trying to run a report under LO 4.0.4.1 LO crashes with the following message: kernel: [12362.147061] soffice.bin[28748]: segfault at 18 ip 00000018 sp bfc62c8c error 14 in soffice.bin[8048000+1000] My system is Linux-Debian-Wheezy, 32-bit. Regards H. S. </pre> Heinrich Stoellinger 2013-06-13T16:07:53 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.documentfoundation.libreoffice.user