Re: [libreoffice-users] Functions in Calc 4.4.2.2
Piet van Oostrum wrote: edo1 wrote: I hate to ask this, since I thought of myself as pretty competent in Calc. But here goes: I can't run even the simplest functions in the spreadsheet. E.g, =3-2 shows up in the designated cell as a text string =3-2 rather than the digit 1. I also get text strings instead of proper results for =SUM(A1:A10), say, and all other functions. This happens in LO 4.4.2.2 as well as in ver. 4.3.5, which previously worked fine. A virus scan of the LO installation folder turned up nothing. Since I haven't used Calc for a long time, I'm reluctant to go back to a previous restore point without trying some other things first. Can anyone suggest what I might do now? I'm running Win7x64. - edo1 Check your preferences, I guess this is Tool-Options on Windows. then LibreOffice Calc-View-Display- uncheck Formulas Another possibility is that the cells are formatted as Text, rather than General or a numerical format. Make sure they're formatted as either General or the required numerical format before entering the formulas. General is usually the default for all cells in new documents, but it is possible to change the default template. Mark. -- 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: How to concat CTRL+ENTER to a string?
James E Lang - jim+...@lang.hm wrote: On a Windows platform I use CHAR(13)CHAR(10) [CR+LF] instead of just CHAR(10) [LF] which I use on a Linux platform or just CHAR(13) [CR] which I would expect to use on a MAC platform Those are the conventions for plain text files on those systems. Although I believe Mac OSX uses LF, same as Unix, while Mac OS up to version 9 used CR. Even in the case of plain text, now that files are so readily transferred between systems, most decent text editors cope fine with all 3 formats regardless of which system they're running on. Do I over complicate the process? For LibreOffice documents, I think you do. What do you do in a document which might be transferred between different systems? Does CHAR(13) in a LibreOffice formula on Mac even have the intended effect of splitting lines? Come to that, does LibreOffice even run on Mac OS 9 or before? I suspect LibreOffice only uses CHAR(10) regardless of OS, although I don't have a Mac (let along one before OSX) to try. On Windows LibreOffice, all that's needed is CHAR(10). CHAR(13) has no apparent effect, other than cluttering the formula. Mark. -- 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] Complex Text Layout Confusion
For the record, I’m using Writer Version: 4.3.3.2, Build ID: 9bb7eadab57b6755b1265afa86e04bf45fbfc644 running on Ubuntu 14.04 LTS. This is a question about the dialog box resulting from Tools Options Language Settings Languages in LibreOffice, and very specifically the check box for “Complex text layout (CTL)” under “Default languages for Documents” as well as its interaction with the check box “For the current document only.” The help facility and “official” documentation shy away from any discussion of how all this works, although the LibreOffice 4.2 Writer Guide (page 67) does explicitly say “If you want the language setting to apply to the current document only, instead of being the default for all new documents, select For the current document only, which is consistent with what I would expect it to mean. What seems to happen, however, is that regardless of whether I check “For the current document only,” the status of the check box for “Complex text layout (CTL)” then seems to be set for any and all documents I open (whether in the same of different sessions) thereafter. What am I missing? The box doesn’t seem to do anything. The documentation also states that this check box enables “support for CTL (complex text layout) languages such as Hindi, Thai, Hebrew, and Arabic.” I can’t comment on Hindi, Hebrew, or Arabic, but when using Thai, all this setting does is permit me to “correct” what seems to be odd behavior with Writer, but I’ll save that for last. Several things seem clear when using Thai: the status of the Complex Text Layout check box (checked or unchecked) doesn’t seem to have any effect on correct positioning of single and multiple diacritics (see the snippet below – every text editor I have does this correctly as well, although obviously there needs to be one or more suitable fonts installed); – clicking within any Thai text correctly identifies and displays the language in use in the bar at the bottom of the screen; – double-clicking within any Thai text correctly selects individual words, such as ใคร from within the phrase โม่มีใครอยู่ทีนั่น (Thai doesn’t use spaces between words); – and finally, longer sections of Thai text wrap lines at word breaks (these last two of course also require an installed Thai dictionary). So, is CTL irrelevant? Now to the odd and rather annoying behavior: If the Complex Text Layout check box is UNCHECKED, and my default paragraph style indicates that the FreeSerif font is in use, when I begin typing English, FreeSerif is indeed used. If I switch to Thai (I use iBus as an input method), Writer doesn’t use the perfectly good Thai characters (u+0e00 etc) from within FreeSerif, but instead indicates that it is using Liberation Serif which, interestingly, contains no Thai characters at all. This can be confirmed by placing the cursor within the Thai text and using the Insert Special Character command. So what font is it actually using? I exported the file as both an fodt and a pdf to see what I could find. In the fodt, the only clue I can find is in the following section: office:font-face-decls style:font-face style:name=FreeSerif svg:font-family=FreeSerif style:font-family-generic=roman/ style:font-face style:name=Liberation Serif svg:font-family=apos;Liberation Serifapos; style:font-family-generic=roman/ style:font-face style:name=FreeSans svg:font-family=FreeSans style:font-family-generic=swiss/ style:font-face style:name=Liberation Sans svg:font-family=apos;Liberation Sansapos; style:font-family-generic=swiss/ style:font-face style:name=DejaVu Sans svg:font-family=apos;DejaVu Sansapos; style:font-family-generic=system style:font-pitch=variable/ /office:font-face-decls The only font which isn’t explicitly used in this document is Deja Vu Sans; could Writer be getting the Thai glyphs from there? No, the only Thai glyph in Deja Vu Sans is for the Baht (Thai currency) glyph, so that isn’t the font being used. Hmmm In the pdf export, Adobe Reader informs me that Kinnari is embedded. Kinnari is a perfectly good Latin/Thai font, but certainly not the best match for FreeSerif that I have installed (one can’t argue matters of taste, of course, but the Thai characters in FreeSerif seem to be a decent enough match to the Latin characters in FreeSerif). If the Complex Text Layout check box is CHECKED, and I set the CTL font also to FreeSerif, things seem to work as I would expect, but where does the Writer come up with its default Lohit Hindi font (which also has no Thai glyphs and isn’t even installed on my system)? And why do I need to set anything at all? I can’t find any straightforward explanation of how all this is supposed to work (or actually works), so while attempting to figure this out (I do actually mix multiple languages within single documents and it’s a pain), I began keeping notes, having a vague idea that I could pass them on to Jean Hollis Weber and her crew to incorporate into the documentation, but I’ve become
Re: [libreoffice-users] Is a blunder a bug?
Hi :) Yeh, i think that is the sort of thing that normal users would call a bug but it doesn't cause anything to crash or leak memory or anything like that (at least that is not the main problem) = so i think post as a feature request using the drop-downs in the bug-reporting system. Good luck! Regards from Tom :) On 10 April 2015 at 17:04, Brad Rogers b...@fineby.me.uk wrote: On Fri, 10 Apr 2015 11:27:20 -0400 marianne-x mxkeat...@comcast.net wrote: Hello marianne-x, Although the initial A is underlined in both cases, neither can be selected by keystroke, due to the obvious ambiguity. As far as I can tell, only the rodent can advance the user in this context. As a result of tests here, I concur with Robert's findings; Pressing A toggles between Address Book Source AutoCorrect Options - then Return selects whichever is highlighted. Maybe the highlighting is too subtle with your chosen colour palette or because of, possibly, shortcomings with the display device, IDK (just putting it out there). As Address Book Source is only displayed when in LO Writer perhaps it should have its choice letter changed. To my way of thinking, this isn't a bug per se, because both can be chosen without resorting to mouse, albeit with extra key presses, so you'd have to create a 'bug' report with a status of 'enhancement' or 'feature request' to get the selection letter changed. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Every single one of us Devil Inside - INXS -- 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] Is a blunder a bug?
Hello everyone, Thank you for bringing clarity to this issue. I have 2 suggestions at this stage : * ensure there is no existing bug/rfe report already filed for this topic before filing your existing report * try to follow up on this with our design team or ask someone here willing to do it. As it looks to me this is an User Experience problem and not a developer one. The design team may want to jump in then. Best, Charles. On 10 avril 2015 23:30:27 CEST, Tom Davies tomc...@gmail.com wrote: Hi :) Yeh, i think that is the sort of thing that normal users would call a bug but it doesn't cause anything to crash or leak memory or anything like that (at least that is not the main problem) = so i think post as a feature request using the drop-downs in the bug-reporting system. Good luck! Regards from Tom :) On 10 April 2015 at 17:04, Brad Rogers b...@fineby.me.uk wrote: On Fri, 10 Apr 2015 11:27:20 -0400 marianne-x mxkeat...@comcast.net wrote: Hello marianne-x, Although the initial A is underlined in both cases, neither can be selected by keystroke, due to the obvious ambiguity. As far as I can tell, only the rodent can advance the user in this context. As a result of tests here, I concur with Robert's findings; Pressing A toggles between Address Book Source AutoCorrect Options - then Return selects whichever is highlighted. Maybe the highlighting is too subtle with your chosen colour palette or because of, possibly, shortcomings with the display device, IDK (just putting it out there). As Address Book Source is only displayed when in LO Writer perhaps it should have its choice letter changed. To my way of thinking, this isn't a bug per se, because both can be chosen without resorting to mouse, albeit with extra key presses, so you'd have to create a 'bug' report with a status of 'enhancement' or 'feature request' to get the selection letter changed. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Every single one of us Devil Inside - INXS -- 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 -- Envoyé de mon téléphone avec Kaiten Mail. Excusez la brièveté. -- 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: Is a blunder a bug?
@trj, *, Actually there is no issue with the repetition in this case as these Accelerators in Writer module (as opposed to Short-cuts *) do not have any conflicting actions. Another example of a benign configuration is on the main Tools - Options menu where in English we have Appearance, Accessibility and Advanced--since they are single action buttons as in this post, they cause no issue. But, for an example of a conflicting assignment (e.g. multiple accelerators assigned, to split lists) see tdf#65021 https://bugs.documentfoundation.org/show_bug.cgi?id=65021 --in that case C is assigned as accelerators to three different split list menu items. So, there is no blunder or bug--in this instance--but there is always the potential and why we appreciate active participation in the QA process so any actual issues can be identified early in a release cycle and rectified. Stuart *Accelerators are adjusted during i18n Pootle translations. Shortcuts are hard coded and non-language dependent. -- View this message in context: http://nabble.documentfoundation.org/Is-a-blunder-a-bug-tp4145859p4145904.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Heads up -- LibreOffice 5.0 is on the horizion
If folks have not been paying attention, there has been sufficient movement in the project to warrant a 5.0 branding of the next major release. From the Release plan https://wiki.documentfoundation.org/ReleasePlan 5.0.0 (freeze: week 21) Week 16 , Apr 13, 2015 - Apr 19, 2015 Week 31 , Jul 27, 2015 - Aug 2, 2015 The development master will be branched to a 5.0.0alpha0 effective next week. New to 5.0 will be a true 64-bit Windows build (for Windows = Vista), follow other tidbits in the evolving LibreOffice 5.0 release notes https://wiki.documentfoundation.org/ReleaseNotes/5.0 . What is needed from the community now, are your artistic talents. It is time for a new motif for 5.0, here is a progression of our StartCenter from 3.3 to current builds of master (pre-5.0). As can be seen, the color scheme is a bit stale. So, break out your graphics packages and draw. There is a stub for any proposals in the Design Wiki Whiteboards at: https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding Hope to see your work there! Stuart A historical look at LibreOffice's start center... http://nabble.documentfoundation.org/file/n4145906/3.png http://nabble.documentfoundation.org/file/n4145906/3.png http://nabble.documentfoundation.org/file/n4145906/3.png http://nabble.documentfoundation.org/file/n4145906/3.png http://nabble.documentfoundation.org/file/n4145906/4.png http://nabble.documentfoundation.org/file/n4145906/4.png http://nabble.documentfoundation.org/file/n4145906/4.png http://nabble.documentfoundation.org/file/n4145906/4.png http://nabble.documentfoundation.org/file/n4145906/4.png http://nabble.documentfoundation.org/file/n4145906/5.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
Well that didn't go as planned, Nabble ate the images--here they are one at a time... 3.3 release http://nabble.documentfoundation.org/file/n4145907/3.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145907.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
3.4release http://nabble.documentfoundation.org/file/n4145908/3.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145908.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
3.5 release http://nabble.documentfoundation.org/file/n4145909/3.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145909.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
3.6 release http://nabble.documentfoundation.org/file/n4145910/3.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145910.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
4.0 release http://nabble.documentfoundation.org/file/n4145911/4.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145911.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
4.1 release http://nabble.documentfoundation.org/file/n4145912/4.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145912.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
4.2 release http://nabble.documentfoundation.org/file/n4145913/4.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145913.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
4.3 release http://nabble.documentfoundation.org/file/n4145914/4.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145914.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
4.4 release http://nabble.documentfoundation.org/file/n4145915/4.png -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4145915.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