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
Exce
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 dozen
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 a
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, Andreas
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 overlooking
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/
Post
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, Visio,
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", sinc
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 thumb
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 a
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.
Ho
> 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 15 inch Mid 2009
2.8 GHz
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 wrote:
>
>> On 15/
13 matches
Mail list logo
