Re: [libreoffice-users] Calc: wildcard use to intercept a string

At 09:08 14/11/2016 -0700, Fonly Bonly wrote: how can I match the string XYZ in a cell? Example: count.if(interval; XYZ ) string ---> result XZ 0 GXYZ 1 GXP 0 AABXYZC 1 Try: =NOT(ISERROR(FIND("XYZ";A1))) This will give TRUE if XYZ is found and FALSE if not. If you format those as numbers,

Re: [libreoffice-users] Marginal references

At 17:03 14/11/2016 +, Gary Collins wrote: I'm wanting to prepare a document in writer with a main text body (justified) and marginal references on the right (and possibly also different ones on the left). Each paragraph will have at least one reference. The references need to be tied to

Re: [libreoffice-users] Marginal references

El 2016-11-14 18:03, Gary Collins escribió: Hi, I'm wanting to prepare a document in writer with a main text body(justified) and marginal references on the right (and possibly also different ones on the left). Each paragraph will have at least one reference. The references need to be tied to

[libreoffice-users] Marginal references

Hi, I'm wanting to prepare a document in writer with a main text body(justified) and marginal references on the right (and possibly also different ones on the left). Each paragraph will have at least one reference. The references need to be tied to their relevant paragraphs. If a subsequent

[libreoffice-users] Calc: wildcard use to intercept a string

HI, ho can I match the string XYZ in a cell? Example: count.if(interval; XYZ ) string ---> result XZ 0 GXYZ 1 GXP 0 AABXYZC 1 Thank you ! --

Re: [libreoffice-users] Mail Merge from Calc spreadsheet.

Yes, it is possible and works much the same way. https://help.libreoffice.org/Writer/Mail_Merge Regards, On Thu, Nov 10, 2016 at 4:38 PM, lismurn wrote: > I have, for many years been writing letters to several hundred people > detailing their donations to various charities.

[libreoffice-users] Re: Can't enter 12:12:52 in calc cell

This was a known issue tdf#97191 introduced with support for emoji. The :10:, :11:, and :12: text sequence would convert to their Unicode clock-face glyph: U+1F559 CLOCK FACE TEN OCLOCK --  U+1F55A CLOCK FACE ELEVEN OCLOCK -- 

[libreoffice-users] Re: Can't enter 12:12:52 in calc cell

On 11/13/2016 8:09 PM, James wrote: I make a new spreadsheet, formatted A1 as hh:mm:ss, tried to type "12:12:52". After the second colon, the contents change to 12 (the one is overlapped by another character). Version: 5.1.4.2 Build ID: 1:5.1.4-0ubuntu1 OS: lubuntu 4.4 Win10 Version: 5.0.5.2

[libreoffice-users] Can't enter 12:12:52 in calc cell

I make a new spreadsheet, formatted A1 as hh:mm:ss, tried to type "12:12:52". After the second colon, the contents change to 12 (the one is overlapped by another character). Version: 5.1.4.2 Build ID: 1:5.1.4-0ubuntu1 OS: lubuntu 4.4 -- To unsubscribe e-mail to: