[libreoffice-users] Re: Calc IF problem
Electricity.ods http://nabble.documentfoundation.org/file/n4077843/Electricity.ods Thank you both for the input. I have searched on Nabble and not found Brian's succint method and despite looking at the manual and the vlookup command was unable to apply it to my situation. I would be happy to change the many IF formulae I have to use vlookup, but I need some assistance in one cell on using the formula with the layout of the data I have. If you feel challenged towards producing better formulae usage or even feel mathematically challenged, please have a look on Nabble for the uploaded file and using the TAB Data2 try and get the currency value of H4 from the value in G4 using the sliding scale on F20:O20 What is strange is that on entering the Function Wizard on H4 to edit the formula, placing my cursor on the 2nd last line of the formulae I get the CORRECT answer displaying in the the 'Function Result' window but not in the 'Result' window of the Function Wizrd. Of course pressing OK then gives the incorrect answer ie 751.25 as opposed to the correct one of 751.52. Appreciated Hylton -- View this message in context: http://nabble.documentfoundation.org/Calc-IF-problem-tp4077544p4077843.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] stopping superscript text in Calc
On 10/13/2013 12:59 AM, Paul van Tooren wrote: John, After adding the rd insuperscript, you have to chance again back to normal script. Succes Paul van Tooren -Oorspronkelijk bericht- From: John R. Sowden Sent: Friday, October 11, 2013 8:21 PM To: users@global.libreoffice.org Subject: [libreoffice-users] stopping superscript text in Calc Been having the problem for a long time. Using Calc, I write a date, Oct 23rd, (I add the rd which shows as a superscript. Problem is whenever I add new text to the cell, it is in the superscript size, not regular text. John I took the list's advise of turning off the superscript function. If enough people are aggravated by the anomaly, it will be adjusted. Thanks, John -- 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] Feature Request: Lack of Outliner Functionality a Deal Breaker for Me
Le 11/10/2013 00:09, CougarB a écrit : When I was a full-time journalist in the 1980s, I became very successful using a dedicated outliner called PCOutline. When all the major Word Processers came along--MS Word, Word Perfect, etc, the lack of outliner functionality kept me with my archaic outliner until MS Word beat the functionality of PCOutline. As a partial workaround, did you try the menu File Send Create AutoAbstract... ? Best regards JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Feature Request: Lack of Outliner Functionality a Deal Breaker for Me
As I stated earlier in the thread, I have a working solution, right now, but I would prefer to stop using M$ for ideological reasons. I'm not looking for a work around, but a replacement. That's why I created this thread and that's why I also filed a feature request in Bugzilla for the same thing. And by the way, this single issue also is a deal breaker for using Linux, so this one issue influences everything. I had a Linux partition on my last computer, but I found that I had to duplicate resources by having them on both partitions. When I ran out of space and had to replace the partition, I resented Linux, because I was only using it for ideological reasons, and I could not leave Windows behind until I had a fully functioning Office suite, with an integrated outliner. So in reality, the lack of outliner functionality is a deal breaker for me for everything, including whether or not I use Linux. On Sun, Oct 13, 2013 at 2:26 AM, Jean-Baptiste Faure [via Document Foundation Mail Archive] ml-node+s969070n4077851...@n3.nabble.com wrote: Le 11/10/2013 00:09, CougarB a écrit : When I was a full-time journalist in the 1980s, I became very successful using a dedicated outliner called PCOutline. When all the major Word Processers came along--MS Word, Word Perfect, etc, the lack of outliner functionality kept me with my archaic outliner until MS Word beat the functionality of PCOutline. As a partial workaround, did you try the menu File Send Create AutoAbstract... ? Best regards JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- To unsubscribe e-mail to: [hidden email]http://user/SendEmail.jtp?type=nodenode=4077851i=0 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 -- If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Feature-Request-Lack-of-Outliner-Functionality-a-Deal-Breaker-for-Me-tp4077564p4077851.html To unsubscribe from Feature Request: Lack of Outliner Functionality a Deal Breaker for Me, click herehttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4077564code=Y291Z2FyLmJAZ21haWwuY29tfDQwNzc1NjR8LTExODk2NjEyNzI= . NAMLhttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context: http://nabble.documentfoundation.org/Feature-Request-Lack-of-Outliner-Functionality-a-Deal-Breaker-for-Me-tp4077564p4077878.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] Re: Feature Request: Lack of Outliner Functionality a Deal Breaker for Me
On 13/10/2013, CougarB couga...@gmail.com wrote: I took a look at Leo, Jedit, and OPML, and frankly, none of them are as convenient as M$ Word. I'm using Word as both a word processor and an outliner, and it's extremely convenient to be working on a document as an outline, then move over to a word processing mode without losing the outline structure, and work with formatting and other elements that are convenient in that view, and then move back to outlining without losing my formatting and other tools that are available in Word. When I'm writing in outline format, I even want to just experience my novel as it will be read on the page, and then go back to using the outliner. Without using m$, it would seem that the outliner feature may be one reason for document instability; how does moving of nodes cope with internal cross-references and bibliographic references for example? How stable is outliner functionality with images? The options to proceed: Change your behaviour and adapt to use LO writer styles Carry out benefit-cost analysis of you using m$ compared to learning programming to implement outline behaviour in LO, perhaps as an LO extension. In this case you should contact the LO programmers and others for further help to build such an extension. Use a text editor, then import to LO writer and apply styles accordingly (could use find replace function) -- 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] Re: Feature Request: Lack of Outliner Functionality a Deal Breaker for Me
On 13/10/2013, CougarB couga...@gmail.com wrote: I just got an email from someone who took notes at the same meeting as me. However, she brainstormed an entirely new direction, which was our agreement. Combining the two emails and breaking up every paragraph into separate points yielded 35 paragraphs of between 1 and 4 lines, totaling 78 lines, which is too much to display on a single page, especially with spaces between paragraphs. However with Word, with one click, I collapsed all the paragraphs into single lines--which is like code folding. As suggested by someone, freemind can achieve nice node collapse/expansion -- 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] Re: Feature Request: Lack of Outliner Functionality a Deal Breaker for Me
Hi :) I often make the GnuLinux partitions quite small and keep the majority of my files on the Windows side. Ironically my network file-shares are all on Debian so i kinda go from my GnuLinux system into the Windows side to hunt around and then use links from there into the Debian. (Unless i knew it was on the server right from the start and was able to dodge hunting through Windows folders. As we have probably said many times before on this list there is often 1 or 2 things that you don't know how to do on the newer system and that often means going back to Windows to do those 1 or 2 things. As you become more familiar the number of things you have to go back for drops quite a bit but it does usually leave 1 or 2 things that linger on for ages after. Obviously when you first start it's all new to you so you probably spend most time in Windows and only occasionally bounce over to the other but one day you find you have tipped the other way. For me it was when i found Wesnoth and the same weekend my neighbour fixed multimedia. Nowadays multimedia seems to work straight out of the box and 0AD looks better. Generally if i have to use Windows it's an older version of Windows or older software. I don't really need to keep things so up-to-date anymore. At the moment it is hilarious to watch people 'having to' shell out loads of money to replace their 'old' versions of MSO 2010 which are now out-dated compared to what people are buying on newer home machines. One chap has bought 3 different versions of MS Office within the last year and still has problems with people not being able to open his files because they are on a different version. Incidentally i am sorry we couldn't find a suitable replacement but i'm glad to hear you have at least found a work-around. It sounds like you are nearing your tipping point. Regards from Tom :) On Sunday, 13 October 2013, 15:14, CougarB couga...@gmail.com wrote: As I stated earlier in the thread, I have a working solution, right now, but I would prefer to stop using M$ for ideological reasons. I'm not looking for a work around, but a replacement. That's why I created this thread and that's why I also filed a feature request in Bugzilla for the same thing. And by the way, this single issue also is a deal breaker for using Linux, so this one issue influences everything. I had a Linux partition on my last computer, but I found that I had to duplicate resources by having them on both partitions. When I ran out of space and had to replace the partition, I resented Linux, because I was only using it for ideological reasons, and I could not leave Windows behind until I had a fully functioning Office suite, with an integrated outliner. So in reality, the lack of outliner functionality is a deal breaker for me for everything, including whether or not I use Linux. On Sun, Oct 13, 2013 at 2:26 AM, Jean-Baptiste Faure [via Document Foundation Mail Archive] ml-node+s969070n4077851...@n3.nabble.com wrote: Le 11/10/2013 00:09, CougarB a écrit : When I was a full-time journalist in the 1980s, I became very successful using a dedicated outliner called PCOutline. When all the major Word Processers came along--MS Word, Word Perfect, etc, the lack of outliner functionality kept me with my archaic outliner until MS Word beat the functionality of PCOutline. As a partial workaround, did you try the menu File Send Create AutoAbstract... ? Best regards JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- To unsubscribe e-mail to: [hidden email]http://user/SendEmail.jtp?type=nodenode=4077851i=0 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 -- If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Feature-Request-Lack-of-Outliner-Functionality-a-Deal-Breaker-for-Me-tp4077564p4077851.html To unsubscribe from Feature Request: Lack of Outliner Functionality a Deal Breaker for Me, click herehttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4077564code=Y291Z2FyLmJAZ21haWwuY29tfDQwNzc1NjR8LTExODk2NjEyNzI= . NAMLhttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- View this message in context:
Re: [libreoffice-users] Hyperlink not active on images
Hi :) Did you ever manage to solve this issue? My email client went somewhat weird with some new update meaning i have to try to figure out a new work-flow. The Users List also seems to have become uncharacteristically quiet although that might just be due to my email-client misrepresenting things Regards from Tom ) On Tuesday, 8 October 2013, 20:29, Contini Luciano lachi1...@hotmail.com wrote: Hi Tom, thanks for your answer. When you Export to Pdf does the link work in the Pdf even without using the ⌘ ? no, it doesn't work In the editable file when you do the equivalent of right-clicking the image and get the pop-up dialogue box and then click on the relevant tab does it still show the url starting with http? yes it does and the same link works flawlessly on text I have found that when i have an image inside a frame i tend to get the hyperlink either in the image or in the frame but seldom in both and that can cause some confusion. At first i started putting the links into both or deliberately used the fact they could be different to do 'clever' things but fairly soon i realised i didn't need the frames at all and that the whole document looked better without them. My guess is that you haven't fallen into the same tricky trap as me but it's worth asking just in case you are. no, it's unfortunately a different trap… Thanks a lot and best regards Luciano Am 02.10.2013 um 14:44 schrieb Contini Luciano lachi1...@hotmail.com: Hello everybody, I have an hyperlink problem: the ⌘-click doesn't activate the showed link when applied on a picture/ graphic, it just selects the picture. ⌘-clicking a text works fine as well as ctrl-click an image in Windows XP. Thanks in advance for helping Luciano MacBook Pro OSX 10.8.5, LibreOffice Version: 4.1.1.2 Build ID: 7e4286b58adc75a14f6d83f53a03b6c11fa2903 -- 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 -- 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] row_only and column_only cell references
Hi :) Is it possible to change the way Calc handles it's formulas by doing Tools - Options - Calc - Formula and then use the drop-down to make them use MS Excel ways. I can't help thinking that trying to copy MS Excel at a time when they have finally admitted, and corrected, some very fundamental errors in their formulas Regards from Tom :) On Saturday, 12 October 2013, 14:20, Andrew Douglas Pitonyak and...@pitonyak.org wrote: On 10/12/2013 07:55 AM, Ady wrote: Hello, I've been having problems with certain type of *references* in Calc. For example, the formula sum(1:2) works correctly in other spreadsheet software, but it errors in Calc. I was not aware that you could do that in any product. It is not supported in Calc of which I am aware. Villeroy has a messy solution (see post 6). Well, you probably should read all the posts... http://forum.openoffice.org/en/forum/viewtopic.php?f=9t=9527 So, the ony soltions I have seen based on a quick search is to either define a range, or to use offset. The most problematic cases are related to functions such as indirect(), address() and the like. For example, the following formula should tell whether a number in A1 is prime or not: =SUMPRODUCT(1*(MOD(A1,ROW(INDIRECT(1:INT(A1^0.5=0))=1 but Calc doesn't seem to accept the type of reference (ini_row:fin_row). Instead I have to add a column to the reference, as in: =SUMPRODUCT(1*(MOD(A1,ROW(INDIRECT(a1:aINT(A1^0.5=0))=1 to make it work in Calc. There are several settings that affect the way Calc parses and shows some type of cell references, so I wonder whether there is some setting that I should change for Calc to be able to accept this type of references (ini_row:fin_row), or whether this is some kind of bug or lack of a feature. A similar issue happens with column-only references, such as sum(A:B). To be clear, I'm not saying that row-only (or column-only) references are better in any way. I'm just trying to make them work as in (a.k.a compatible with) other spreadsheet software. If there is a better place (mailing list, irc, forum,...) to ask this question, please let me know. TIA, Ady. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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 -- 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] stopping superscript text in Calc
Hi :) In Writer when i type in a date i carry on with the rest of it and then select the couple of letters i wanted as superscript and then Format - Character - Font Effects - Superscript this ensures that subsequent characters have already been typed in so it's only the selected characters that get affected. Similarly with almost all other formatting. Otherwise i have to 1. turn the formatting on, 2. type in whatever text i wanted 3. turn the formatting off again which interrupts my train of thought twice rather than just once. With bold it's less of an issue because it's just Ctrl b rather than needing to reach for the mouse so it's easier to do on the fly. With Calc i suddenly realised i always write dates as numbers such as 23-10-2013 Other people seem to prefer 23/10/2013 but then find it a problem to interpret incomplete dates scribbled hastily on post-it's and have to quizz the original author as to what the date really was. Anyway i found i didn't know how to apply formatting to just parts within a cell in Calc! I'm sure i will figure it out through rtfm or by just playing around with it. Regards from Tom :) On Sunday, 13 October 2013, 9:36, John R. Sowden jsow...@americansentry.net wrote: On 10/13/2013 12:59 AM, Paul van Tooren wrote: John, After adding the rd insuperscript, you have to chance again back to normal script. Succes Paul van Tooren -Oorspronkelijk bericht- From: John R. Sowden Sent: Friday, October 11, 2013 8:21 PM To: users@global.libreoffice.org Subject: [libreoffice-users] stopping superscript text in Calc Been having the problem for a long time. Using Calc, I write a date, Oct 23rd, (I add the rd which shows as a superscript. Problem is whenever I add new text to the cell, it is in the superscript size, not regular text. John I took the list's advise of turning off the superscript function. If enough people are aggravated by the anomaly, it will be adjusted. Thanks, John -- 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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Feature Request: Lack of Outliner Functionality a Deal Breaker for Me
None of the work-arounds have the value of going back and forth constantly between outliner and word processor functions. It's not costing me tonnes of money--when I had to buy a new computer, since it had to be Windows because of the fact that nothing yet replaces Word, that's what I bought. Then I installed all my old software on it. My Adobe is out of date, so I used other stuff. My M$ Office 2003 works just fine, so I don't have to replace any software for my new computer. The Linux partition was the only reason I had to buy another computer at that time, but I would have run out of space sooner or later, anyway, so rather than eliminate the Linux computer, I just bought another one. But I only use Windows today for one reason--the outliner in Word. Nothing else is essential. And none of the workarounds suggested hold a candle to what I need. Maybe Scrivener, which has enough features that I like that I can see potentially using that as my means of dumping Windows. I have some PHP code that I haven't uploaded yet on the Linux partition of the old computer, so I had to keep that computer partition so that I wouldn't lose my work, mainly because I'm too lazy to deal with a low priority upload at this moment. My current IDE is ShiftEdit which runs on any OS, because I'm not going to let myself get trapped in one OS or the other until I'm ready to dump Windows all together, which depends on finding a full-featured word processor that allows seamless switching back and forth between outliner and print/normal modes. Literally everything about that switch depends on finding a Linux office suite that does everything I want regarding the outliner. Otherwise, I'm stuck with Windows forever. My new laptop has a 17-inch screen, which is better for the kind of work I'm constantly doing, but I'm annoyed at Windows 8, and it just makes me wish with more desire for LO to actually be able to replace what I do now. I do have one small fear, which is probably groundless. I have a document in Word which is almost 1.5 million words long, and which has around 15,000 cross references. In an early version of OO, I couldn't pull in an earlier version of this document without breaking OO. I'm a little nervous about my doc in LO, but I haven't tried it, and since what I have isn't broken, I'm not taking a whole lot of time to investigate. In addition, I've taken most of the cross references and imported them into the PHP and database, which is the ultimate destination of the entire 1.5 million-word project, thereby producing a prototype with 720 dynamic pages on the web. (This prototype only contains a small portion of the 1.5 million words, but it covers the entire set of cross-references.) So theoretically, the need to maintain all of those cross-references in a doc is no longer so important. This is a project I dreamed up when computers weighed twenty tonnes and ate punch cards, and when hypertext hadn't been invented yet. I've been collecting/inventing/writing the content ever since. I'm now actualizing it exactly as dreamed, including the UI. Where the hell did that dream come from, eh? Cougar PS. And by the way, I had the entire project visualized as some sort of open-source back in 1976, which is interesting, given that open-source was a rare concept back then. I don't yet have enough of the infrastructure built, yet, to begin to actualize that part of the vision, but then, I've at least started with the basic plugins that will form the infrastructure for opening up the content to allow multiple authors, and I've got plans. I'm used to thinking long-term. I'm a beginner in both PHP and JavaScript programming, so it will take a while. But then 1.5 million words already took a while. It'll take the time it takes. Working without a fully integrated outliner/word processor would slow me down. On Sun, Oct 13, 2013 at 9:42 AM, nabbler [via Document Foundation Mail Archive] ml-node+s969070n407789...@n3.nabble.com wrote: On 13/10/2013, CougarB [hidden email]http://user/SendEmail.jtp?type=nodenode=4077898i=0 wrote: I just got an email from someone who took notes at the same meeting as me. However, she brainstormed an entirely new direction, which was our agreement. Combining the two emails and breaking up every paragraph into separate points yielded 35 paragraphs of between 1 and 4 lines, totaling 78 lines, which is too much to display on a single page, especially with spaces between paragraphs. However with Word, with one click, I collapsed all the paragraphs into single lines--which is like code folding. As suggested by someone, freemind can achieve nice node collapse/expansion -- To unsubscribe e-mail to: [hidden email]http://user/SendEmail.jtp?type=nodenode=4077898i=1 Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive:
[libreoffice-users] Retrieve a specific message from the ML
Hello, I am trying to retrieve a specific message from the mailing list (so to reply to it), by sending an empty message to users+ge...@global.libreoffice.org as per the help from users+h...@global.libreoffice.org . I have already sent a mail according to the specific msg number I want to retrieve, but have not received an answer. If the msg number would be, say, 12345, is users+get-12...@global.libreoffice.org the correct address? Or, am I doing something wrong? TIA, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Retrieve a specific message from the ML
Am 13.10.2013 20:24, schrieb Ady: Hello, I am trying to retrieve a specific message from the mailing list (so to reply to it), by sending an empty message to users+ge...@global.libreoffice.org as per the help from users+h...@global.libreoffice.org . I have already sent a mail according to the specific msg number I want to retrieve, but have not received an answer. If the msg number would be, say, 12345, is users+get-12...@global.libreoffice.org the correct address? Or, am I doing something wrong? Looks fine. I just tried it with your mail and it worked (but took rather long, about 5 minutes) Are you sure you are subscribed to the list? Are you sending from your subscription address? Did you choose an appropriate N ? E.g. for your mail, to which I'm actually responding, it's the 34301 - the number from the Return-path header line. Nino -- 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] stopping superscript text in Calc
8-- snip --8 -Oorspronkelijk bericht- From: John R. Sowden Sent: Friday, October 11, 2013 8:21 PM To: users@global.libreoffice.org Subject: [libreoffice-users] stopping superscript text in Calc Been having the problem for a long time. Using Calc, I write a date, Oct 23rd, (I add the rd which shows as a superscript. Problem is whenever I add new text to the cell, it is in the superscript size, not regular text. John I took the list's advise of turning off the superscript function. If enough people are aggravated by the anomaly, it will be adjusted. Thanks, John Just for the record, it is not necessary to follow John's more extreme solution. For recent versions of LO (eg. 4.1.2.3) placing a full stop/period/dot or comma immediately after the superscript rd reverts any following text to normal size. Dave -- 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] Re: Calc IF problem
Hi. I think it is this. http://nabble.documentfoundation.org/Fwd-Re-libreoffice-users-VLOOKUP-for-Numbers-td4046030.html#a4046335 Steve On 2013-10-13 21:31, zr1hpc wrote: Electricity.ods http://nabble.documentfoundation.org/file/n4077843/Electricity.ods Thank you both for the input. I have searched on Nabble and not found Brian's succint method and despite looking at the manual and the vlookup command was unable to apply it to my situation. I would be happy to change the many IF formulae I have to use vlookup, but I need some assistance in one cell on using the formula with the layout of the data I have. If you feel challenged towards producing better formulae usage or even feel mathematically challenged, please have a look on Nabble for the uploaded file and using the TAB Data2 try and get the currency value of H4 from the value in G4 using the sliding scale on F20:O20 What is strange is that on entering the Function Wizard on H4 to edit the formula, placing my cursor on the 2nd last line of the formulae I get the CORRECT answer displaying in the the 'Function Result' window but not in the 'Result' window of the Function Wizrd. Of course pressing OK then gives the incorrect answer ie 751.25 as opposed to the correct one of 751.52. Appreciated Hylton -- View this message in context: http://nabble.documentfoundation.org/Calc-IF-problem-tp4077544p4077843.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] Re: Retrieve a specific message from the ML
Am 13.10.2013 20:24, schrieb Ady: Hello, I am trying to retrieve a specific message from the mailing list (so to reply to it), by sending an empty message to users+ge...@global.libreoffice.org as per the help from users+h...@global.libreoffice.org . I have already sent a mail according to the specific msg number I want to retrieve, but have not received an answer. If the msg number would be, say, 12345, is users+get-12...@global.libreoffice.org the correct address? Or, am I doing something wrong? Looks fine. I just tried it with your mail and it worked (but took rather long, about 5 minutes) Are you sure you are subscribed to the list? Are you sending from your subscription address? Did you choose an appropriate N ? E.g. for your mail, to which I'm actually responding, it's the 34301 - the number from the Return-path header line. Nino Thank you for the info. Well, apparently, finding the correct msg number is part of the problem. Let's assume I sent the wrong number, I should be able to receive at least the msg that corresponds to *that* number (since I am already subscribed to the list). I waited for much more than 5 minutes without receiving *any* reply to my request (sent to users+get...), independently of the number I used. But the more important issue regarding this matter is to be able to find out the correct number without having the original message (the one that I'm trying to retrieve). Evidently, I won't be able to read the Return-path value before I have the msg. I thought that the msg number would correspond with the number presented in the mail archives (34065 would correspond to my first email in this thread, according to the mail archives, which is of course different from 34301 from the aforementioned Return-path). So, let's start from the beginning, with the relevant info that is not included in the help of this ML: How a user can obtain the correct msg number so to use it in users+ge...@global.libreoffice.org ? I would expect for the answer to that question to be somehow related to the public mailing list archive, but it seems I am wrong. So, anyone knows the correct answer / method? TIA, Ady. -- 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] Installing LibreOffice Updates In Linux
I am currently running v4.1.2.3 on my copy of Linux Mint Cinnamon. No problem to speak of regarding this. However, my question is this from what I have seem (searched) online about installing LibreOffice on Linux, I saw a requirement to uninstall/remove any previous version of LibreOffice before installing the new version using the Terminal. is this still necessary? Thanks. -- View this message in context: http://nabble.documentfoundation.org/Installing-LibreOffice-Updates-In-Linux-tp4077939.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