Re: [libreoffice-users] technical question about libreoffice and compatibility with microsoft office!

thanks extremely for your help. i realy needed these complete informations. i pray for you and request devine blessings, mercy, graces, bounty, compassionate and eternal bliss of paradise for you. i dont know how should i appreciate you. only i pray for you! On 4/15/16, tonybsa

Re: [libreoffice-users] technical question about libreoffice and compatibility with microsoft office!

> On 15/04/2016, at 08:19, toki wrote: > > On 14/04/2016 16:58, nasrin khaksar wrote: A "couple" more to add to Toki's list Microsoft Front page; Scribus Microsoft Publisher; Scribus Microsoft Project; Libre project -- Tony Bray tony...@mac.com MacBook Pro

Re: [libreoffice-users] LO Calc - style in formulae

Le jeudi 14 avril 2016 à 12:18 -0400, Henry Sikkema a écrit : > I am wondering if it is possible in LO Calc to incorporate styles > into > formula: > > =if(*A1 is bold*, do this if true, do this if false) > > *Henry* > Hello, I do not think you can get the formatting information about a cell.

Re: [libreoffice-users] LO Calc - style in formulae

On 14/04/2016 16:18, Henry Sikkema wrote: > I am wondering if it is possible in LO Calc to incorporate styles into > formula: In theory, it can be done. In practice, forget it. It requires creating a number of additional (^1) rows and columns, and an exponential increase in places where errors

Re: [libreoffice-users] technical question about libreoffice and compatibility with microsoft office!

On 14/04/2016 16:58, nasrin khaksar wrote: > which programs in Microsoft office are compatible with libreoffice and Software compatibility is in the mind of the beholder. >I mean these software: >microsoft frontpage, InfoPath, Publisher, OneNote, Lync, Visio, Project. As a general rule of

Re: [libreoffice-users] LO Calc - style in formulae

At 12:18 14/04/2016 -0400, Henry Sikkema wrote: I am wondering if it is possible in LO Calc to incorporate styles into formula: =if(*A1 is bold*, do this if true, do this if false) If by "style" you mean local formatting - which is what "bold" is - then I think the answer has to be "no",

[libreoffice-users] technical question about libreoffice and compatibility with microsoft office!

hello every one. i have a technical question and i appreciate any help and guide from you. which programs in microsoft office are compatible with libreoffice and which one have free and open source replacements? i mean these softwares: microsoft frontpage, InfoPath, Publisher, OneNote, Lync,

[libreoffice-users] LO Calc - style in formulae

I am wondering if it is possible in LO Calc to incorporate styles into formula: =if(*A1 is bold*, do this if true, do this if false) *Henry* -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

[libreoffice-users] Extracting Character Count via a macro

Until about 2 months ago I successfully used Chars = oDoc.CharacterCount in a LO (5.0.3.2) Basic macro to retrieve the character count of a document. But now, oDoc.CharacterCount always returns 0 regardless of the document's size. Has something changed in the syntax? What am I

Re: [libreoffice-users] Re: Calc method to change whole column cell content

I regularly use UltraEdit (UE) and you can edit files beyond 4GB with millions of lines and it uses regular expressions. This would be a quite easy conversion in UE. It has a column mode editing ability so you can edit only in selected columns as well. *Henry* On 13 April 2016 at 19:27,

[libreoffice-users] Re: Calc method to change whole column cell content

If you would read the initial posts of the topics you are replying to ... MRZenwiz: > What I've been doing is loading the .csv file into a text editor, > change those fields and then reload into calc. This is terribly > cumbersome. > However, in the .csv file they send, the dollar transactions

[libreoffice-users] Re: Calc method to change whole column cell content

Am 13.04.2016 um 18:23 schrieb James E. Lang: > And there *are* text editors (even on Windows) that use regular expressions > and thus can perform the transformation relatively painlessly. > > All the best! > Writer is one of them. Calc supports regular expressions as well. I have tested

Re: [libreoffice-users] Re: Calc method to change whole column cell content

Hi :) Yes, as it happens. It would sweep up negatives in other columns and that might be a bonus. With a text-editor it's easier to remove the "s from around numbers too. A whole load of tidying-up can be done to convert non-standardised Csv files into something that works better in Calc or