[libreoffice-users] How to change the line color of the comments once and for all
Dear all, In Libreoffice Calc 3.6, the line color of the comments is black. But in Libreoffice Calc 4.3.7, the color is changed. Although we can change the color back to black by Right click the comment -- click [Line] -- change the color, it is really troublesome for all the calc files. Please help to give the setting that we can do once and for all. Thank you and best regards. Michael -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to change the line color of the comments once and for all
Emil Payne 於 2015/5/22 上午 02:07 寫道: On 05/21/2015 04:13 AM, Michael Wu wrote: Dear all, In Libreoffice Calc 3.6, the line color of the comments is black. But in Libreoffice Calc 4.3.7, the color is changed. Although we can change the color back to black by Right click the comment -- click [Line] -- change the color, it is really troublesome for all the calc files. Please help to give the setting that we can do once and for all. Thank you and best regards. Michael Have you tried OPTIONS LIBREOFFICE APPEARANCE ? Hi Emil, Thank you for your suggestion. However, I can change the background color of the comments by Options -- Libreoffice -- Appearance -- Spreadsheet -- Notes background, but I don't find one that can change the line color of the comments. Thank you and best regards. Michael -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice Sort Bug ?
Valter Mura 於 2015/4/1 上午 04:07 寫道: Il 25/03/2015 23:42, Richard VINCK ha scritto: Hello at the nice people at LibreOffice! (especially you :-) ) I'm using LibreOffice version 4.4.1.2 I was very surprised to see a bug (?!) in the internal SORT function of Calc. Please fill the following cells with a simple letter: L17=Z L18=B L19=Y L20=R L21=Q L22=P Now select those 6 cells and click on the Down/Up arrow in the toolbar (Sort), select Sort Key 1 : Z, Ascending, then click OK. Expected result was B-P-Q-R-Y-Z, but the Z did not move at all ! =-O This is undoubtedly a serious bug... and nobody has detected this before? How strange. For me, the bug is confirmed. First cell doesn't sort. LibreOffice 4.3.3.2 Build ID: 430m0(Build:2) Linux Environment Ciao It is seemed the first cell is used as a label, not data. If we add one more cell L16, set L16=Test, and select those 7 cells ( L16 ~ L22 ) to sort, then we will get the result B-P-Q-R-Y-Z. Hope it helps and best regards. Michael -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] The hidden comments may get disappeared in the 4.2.0.4 release
Dear all, If you use the hidden comments in your libreoffice spreadsheet, I suggest not using the current release 4.2.0.4 because the hidden comments may get disappeared without any warning. I have reported this issue to the bugzilla as the bug 75236. Please be careful to use the 4.2.0.4 release. Thank you and regards. Michael -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to transfer customised styles between documents in LO 4
Dear all, From one reply shown below on 2012/05/04 in this mailing list, we can transfer customized styles between documents. .. File Templates Organize In the lower drop-down-list choose Documents. In the upper left part double-click source document and in the upper right target document. Double click Styles of the source document. Drag the style _while holding down Strg-key_ to the target document Styles. Close dialog. The imported style is available immediately. Kind regards Regina However, it is seemed this feature is disappeared in LO 4. Please help to check if there is any way that we can transfer customized styles between documents ? Thank you and Regards, Michael -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] A function doesn't work on cell whihc is a link to another cell
Hi Pál, Please check to see whether the problem can be fixed if you use Shift + Ctrl + F9 to recalculate all formulas in the file2. Good luck and regards from Michael csanyipal 提到: Hi, Grade_CellBehavior.ods http://nabble.documentfoundation.org/file/n4061013/Grade_CellBehavior.ods In the uploaded Calc file 'Grade_CellBehavior.ods' the column AE and BH are just simple cells with number values. The Sheet '1.' in this file is a sheet from another, bigger Calc file ( called here 'file1' ) in which I have such sheets for every pupil. I have also a Calc file 'file2' in which I have too such columns, as AE and BH, but cells in these columns are not just cells with number values, but links for 'file1'. So, in the school I fill out the cells in the 'file1' file, come home, copy the 'file1' into approppriate directory, open the 'file2' Calc file and get the values into it from 'file1' automatically. I hope this is cleare so far. As one can see in 'Grade_CellBehavior.ods' when one change the value '3' in AE6 to value '2' then the value in AD6 changes automatically to value !?. This shows me that that a teacher closed the grade for that Subject badly. But this doesn't work in the 'file2', because eg. the value in AE6 is not just a number, but a value that we get is a link from 'file1'. I hope this is clear. How can I solve this to works in the 'file2' too? - Best Regards from Pál -- View this message in context: http://nabble.documentfoundation.org/A-function-doesn-t-work-on-cell-whihc-is-a-link-to-another-cell-tp4061013.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] calc problem
Jay Lozier 提到: On 03/28/2013 01:23 PM, Tom Davies wrote: Hi :) So it meant that instead of discovering a bug with LibreOffice it was a discovered problem with the 3rd party's website and their strange way of setting up their downloads. The question was whether reporting a bug against LibreOffice might improve LibreOffice's handling of Xls files but the answer to that is just No and that solves the problem. Regards from Tom :) IMHO it not necessarily a bug but certainly a feature request. Because I can open the downloaded xls and csv file with gnumeric without problem, maybe something in LibreOffice is needed to be checked. Regards from Michael From: Tim Lloyd tim.ll...@gmx.com To: nvrk nvrk.89...@gmail.com Cc: users@global.libreoffice.org Sent: Thursday, 28 March 2013, 3:23 Subject: Re: [libreoffice-users] calc problem It was not a matter of preferences. It was because calc could not open a .XLS file. On further investigation it was found that it is not an XLS file hence the problem Cheers On 03/28/2013 01:48 PM, nvrk wrote: Is there a reason why the .xls file version is preferred to the .csv version from the afr.com site? nvsoar On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu m...@tercel.com.tw wrote: On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd tim.ll...@gmx.com mailto:tim.ll...@gmx.com wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on the wrong table by accident and tried to open it. Calc locked up! No problem with the files I normally look at, Calc opened them fine. So I tried again today and waited for an error - LibreOffice 4.0.1.2 General input/output error. So I hopped over to the windows PC and tried LO portable. Same error. The error was repeated whether I tried to open directly from the website or if I saved to disk and then attempted to open the file. MS Excel has no problems. The file in question is accessible using this link: http://www.afr.com/share_tables/ Just click on the xls link next to Warrant Market Any comments? Cheers Hi Tim, Since you use Fedora Linux, maybe you can try gnumeric as a temporary alternative. Hope it helps and regards, Michael -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] calc problem
I have filed a bug report with the ticket number 62888. Regards from Michael Tom Davies 提到: Hi :) You are welcome to post it as a bug. One of the drop-down menus lets you choose enhancement request or something if you want https://wiki.documentfoundation.org/BugReport Regards from Tom :) From: Michael Wu m...@tercel.com.tw To: users@global.libreoffice.org Sent: Friday, 29 March 2013, 1:13 Subject: Re: [libreoffice-users] calc problem Jay Lozier 提到: On 03/28/2013 01:23 PM, Tom Davies wrote: Hi :) So it meant that instead of discovering a bug with LibreOffice it was a discovered problem with the 3rd party's website and their strange way of setting up their downloads. The question was whether reporting a bug against LibreOffice might improve LibreOffice's handling of Xls files but the answer to that is just No and that solves the problem. Regards from Tom :) IMHO it not necessarily a bug but certainly a feature request. Because I can open the downloaded xls and csv file with gnumeric without problem, maybe something in LibreOffice is needed to be checked. Regards from Michael From: Tim Lloyd tim.ll...@gmx.com To: nvrk nvrk.89...@gmail.com Cc: users@global.libreoffice.org Sent: Thursday, 28 March 2013, 3:23 Subject: Re: [libreoffice-users] calc problem It was not a matter of preferences. It was because calc could not open a .XLS file. On further investigation it was found that it is not an XLS file hence the problem Cheers On 03/28/2013 01:48 PM, nvrk wrote: Is there a reason why the .xls file version is preferred to the .csv version from the afr.com site? nvsoar On Wed, Mar 27, 2013 at 5:47 PM, Michael Wu m...@tercel.com.tw wrote: On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd tim.ll...@gmx.com mailto:tim.ll...@gmx.com wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on the wrong table by accident and tried to open it. Calc locked up! No problem with the files I normally look at, Calc opened them fine. So I tried again today and waited for an error - LibreOffice 4.0.1.2 General input/output error. So I hopped over to the windows PC and tried LO portable. Same error. The error was repeated whether I tried to open directly from the website or if I saved to disk and then attempted to open the file. MS Excel has no problems. The file in question is accessible using this link: http://www.afr.com/share_tables/ Just click on the xls link next to Warrant Market Any comments? Cheers Hi Tim, Since you use Fedora Linux, maybe you can try gnumeric as a temporary alternative. Hope it helps and regards, Michael -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] calc problem
On Tue, Mar 26, 2013 at 7:44 AM, Tim Lloyd tim.ll...@gmx.com mailto:tim.ll...@gmx.com wrote: Hi, before I log this as a bug I would like to know whether anyone has seen it before/potential fix identified. I normally use Fedora linux and I download (.XLS) share tables from a financial newspaper here in Oz. Yesterday I inadvertently clicked on the wrong table by accident and tried to open it. Calc locked up! No problem with the files I normally look at, Calc opened them fine. So I tried again today and waited for an error - LibreOffice 4.0.1.2 General input/output error. So I hopped over to the windows PC and tried LO portable. Same error. The error was repeated whether I tried to open directly from the website or if I saved to disk and then attempted to open the file. MS Excel has no problems. The file in question is accessible using this link: http://www.afr.com/share_tables/ Just click on the xls link next to Warrant Market Any comments? Cheers Hi Tim, Since you use Fedora Linux, maybe you can try gnumeric as a temporary alternative. Hope it helps and regards, Michael -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: Re: [libreoffice-users] Re: Problem reading Word 2003 document
Hi all, According to my own experience, it is truly some regression problem in the version 3.5.7.2 to open the document http://beachware.org/Dec12.doc . It cannot be improved by using a new profile. Thanks and Regards Michael Tom Davies 提到: Hi :) Here is a link to help with that http://wiki.documentfoundation.org/Documentation/UserProfile Regards from Tom :) From: NoOp gl...@sbcglobal.net snip / Recommend that you rename your LO profile and then try. If it works, then you most likely have an issue with your profile. snip / -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Fail to set double-line border in LibreOffice 3.6.2 Calc
Dear all, After I upgrade LibreOffice to 3.6.2., I have found that I cannot set the double-line border in Calc. Please help to confirm if it is a bug and a bug report is needed. Thank you for your assistance. Michael -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Impress: Why does bold font in full screen look ugly?
Please disable the hardware acceleration ( Tools Options LibreOffice View Graphics output ) to see if it helps. Regards, Michael --- 原始郵件 --- 主旨: [libreoffice-users] Impress: Why does bold font in full screen look ugly? 從: Liang Wang frank0...@gmail.com 到: users@global.libreoffice.org 日期: Mon, 6 Aug 2012 21:47:57 -0400 Impress: Why does bold font in full screen look ugly? Hi everyone, I found an annoying issue with bold fonts in full screen mode. They look normal when I zoom in many times in editing mode but become stretched in full screen mode. They also look normal in font manager or in libreoffice write PS: the font is copied from Windows regards, Liang edit mode zoomed: [image: Inline image 1] full screen mode: [image: Inline image 2] -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Workaround for the Java 1.7.x compatibility problem
Dear all, There is a workaround for the Java 1.7.x compatibility problem on the Windows platform mentioned in earlier discussion. Please refer to Bugzilla https://bugs.freedesktop.org/show_bug.cgi?id=50371 to install MSVC2010 redistributable from http://www.microsoft.com/en-us/download/details.aspx?id=8328 . Thank you and Regards, Michael -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: latest java update has broken my install ofLibre Office.
--- 原始郵件 --- 主旨: [libreoffice-users] Re: latest java update has broken my install ofLibre Office. 從: V Stuart Foote vstuart.fo...@utsa.edu 到: users@global.libreoffice.org 日期: Wed, 27 Jun 2012 07:51:33 -0700 (pdt) Michael, Have marked your File -- Send Java Bug https://bugs.freedesktop.org/show_bug.cgi?id=50863 50863 as duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=50371 50371 . It is probably related to the JRE problems folks are having with the Java Access Bridge based Accessibility features. But the JRE 1.7 misconfiguration issues are really only affecting Windows users (32-bit and 64-bit) the problems are with Windows unique configruation issues with the LibreOffice build and in JRE configuration under Windows (registry, system environment, user environment). More activity on the earlier 50371 report, and I have added the primary Windows build maintainer to the Bug. Stuart -- View this message in context: http://nabble.documentfoundation.org/latest-java-update-has-broken-my-install-of-Libre-Office-tp3992173p3992534.html Sent from the Users mailing list archive at Nabble.com. Hi Stuart, Thank you for helping to mark the bug 50863 as the duplicate of 50371 and hope the problem can be solved smoothly. Regards, Michael -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] latest java update has broken my install ofLibre Office.
A bug report is already filed with the number 50863. However, no further status is given. Regards Michael --- 原始郵件 --- 主旨: Re: [libreoffice-users] latest java update has broken my install ofLibre Office. 從: Tom Randall kf6...@comcast.net 到: users@global.libreoffice.org 日期: Mon, 25 Jun 2012 20:20:19 -0700 Thank you very much for this, this has at least fixed it so L.O. will at least start up again so that is half the battle. I am still going to have to install java 631 once I actually find it because L.O. definitely does not like this java 7 update. If I try to enable accessibility it says that this JRE is defective. Fortunately I may have the old installer laying around somewhere. Thanks again. Tom -Original Message- From: Bjørn K Nilssen Sent: Monday, June 25, 2012 9:52 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] latest java update has broken my install ofLibre Office. På Mon, 25 Jun 2012 16:24:03 +0200, skrev Tom Randall kf6...@comcast.net: Hi all. Well the subject pretty much says it, I got a notification there was an update to Java, I believe it is java 7 update five. Once I did the update my install of Libre Office no longer works. As soon as I try to start the program I get the standard windows 7 message about a problem has caused libre office to stop working, Windows will close the program, blah blah blah. I have tried repairing the install and when that did not do anything I went so far as to remove the whole install and re- install Libre Office. Still no joy. I am not sure if this is an accessibility problem or not, I do know that the java update did totally screw my install of access bridge as well and I had to re-install that too. This is the first time I’ve ever had a java update screw things up this way. Needless to say I am not a happy camper, I depend on this program to do paperwork for work here at home. Has anyone else had this happen with this java update? I am running the 32-bit version of windows 7. I have posted this to the accessibility list too but am posting it here in case it is not related to the accessibility settings and is a general problem. One user on the accessibility list suggested that I try putting the java 631 version back on the system and see if that solves the problem. I know the java folks don’t recommend you do things like this but I’m frankly willing to if it will get this fixed for now. If anyone has any other ideas on how to fix this or if you need more info just let me know. Thanks in advance. I had the same problem here, running jre 7 on XP and installing the newest LibreOffice. The problem was fixed by removing javasettings_Windows_x86.xml (I actually just renamed it to javasettings_Windows_x86.xm0) and then when I started LibreOffice a new and correct version was created. The old xml file contained info about the jre6, which was not there any longer. Apparently LO 3.5.4.2 didn't detect the correct Java version when upgrading from LO 3.4.xx. That xml file was located inside \LibreOffice\3\user\config\ inside the user\AppData folder -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Oracle Java 1.7.0_04 is not compatible with the Writer of LibreOffice 3.5.4.2 on the Windows platform
Dear all, I have filed a bug report with ticket number 50863 and hope to get the problem solved as expected. Thank you and Regards, Michael --- 原始郵件 --- 主旨: [SPAM] Re: [libreoffice-users] Oracle Java 1.7.0_04 is not compatible with the Writer of LibreOffice 3.5.4.2 on the Windows platform 從: Tom Davies tomdavie...@yahoo.co.uk 到: users@global.libreoffice.org 日期: Thu, 7 Jun 2012 12:36:25 +0100 (bst) Hi :) It is quite likely to be true for everyone. A bug-report would be nice. Both of these links do the same thing and i am not sure which you would prefer using http://wiki.documentfoundation.org/BugReport https://www.libreoffice.org/get-help/bug/ The official one is quite pretty and helpful. The wiki one gives a lot of info. Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] IMPRODUCT() does not work in Calc
--- 原始郵件 --- 主旨: Re: [libreoffice-users] IMPRODUCT() does not work in Calc 從: Jay Lozier jsloz...@gmail.com 到: users@global.libreoffice.org 日期: Wed, 06 Jun 2012 23:02:05 -0400 On 06/06/2012 10:07 PM, Dan Lewis wrote: IMPRODUCT() is suppose to calculate products of complex numbers. However, its answers are not correct: only the real portion of the complex numbers seem to be used. =IMPRODUCT(2+i2,2-i2) = 2*2+2*i2-2*i2-i2*i2 = 4 +i4 -i4 -(4) [i2*i2=-4] = 8 But Calc lists the answer as 4. Are there any complex functions that really work other than IMREAL()? (It only reads the real part of a complex number. --Dan I confirm this result with 3.5.4.2, Ubuntu 12.04 According to the help document http://help.libreoffice.org/scalc/SC_HID_AAI_FUNC_IMPRODUCT?Language=en_USSystem=WINVersion=3.5#bm_id3150661;, the formula should be IMPRODUCT(2+2j,2-2j) Thank you. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LO 3.5: Cannot Access Writer Templates
Hi Rich, Please refer to the forum discussion http://user.services.openoffice.org/en/forum/viewtopic.php?f=6t=48030 , maybe you need to delete the user directory to fix the problem. But be sure to save the necessary templates and other setting files before the deletion. Hope it helps. Regards Michael --- 原始郵件 --- 主旨: Re: [libreoffice-users] LO 3.5: Cannot Access Writer Templates 從: Rich Shepard rshep...@appl-ecosys.com 到: users@global.libreoffice.org 日期: Mon, 26 Mar 2012 17:38:05 -0700 (pdt) On Mon, 26 Mar 2012, Rich Shepard wrote: There's nothing there. See attached screenshot.png. Selecting 'Commands - Update' produces nothing. Well, the mail list manager strips attachments. Both the templates and documents windows are blank. Rich -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [Solved]Re: LibreOffice 3.5.1 for Windows is failed to play the slide show of the pps files normally.
Thank you Pedro, my problem is solved. Although it is a little bit strange that the slide show can be played normally with LibreOffice 3.5.0, the problem is solved and thank you again !! Michael --- 原始郵件 --- 主旨: [libreoffice-users] Re: LibreOffice 3.5.1 for Windows is failed to play the slide show of the pps files normally. 從: Pedro pedl...@gmail.com 到: users@global.libreoffice.org 日期: Tue, 20 Mar 2012 22:53:50 -0700 (pdt) This is a Windows specific bug. http://ask.libreoffice.org/question/1367/cant-see-pictures-in-impress-presentation -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-3-5-1-for-Windows-is-failed-to-play-the-slide-show-of-the-pps-files-normally-tp3844694p3844810.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LibreOffice 3.5.1 for Windows is failed to play the slide show of the pps files normally.
Dear all, After I upgrade LibreOffice for windows from 3.5.0 to 3.5.1, I have found that the Impress cannot play the slide show of the pps files normally. The windows platform is XP +SP3. However, if we use LibreOffice for Linux on Fedora 15, there is no problem to play the slide show of the pps files. Please help to check if there is anything that we can do to fix the problem. Thank you for your assistance. Michael -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted