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

[nasrin khaksar]

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/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 Intel Core 2 Duo, 4 GB RAM,
> Mac OS X  10.11.2
> LibreOffice 4.4.5
> Scribus 1.4
> Parallels Desktop 11.02
> Ubuntu 14.04
> LibreOffice 4.4.4
> Libre Project 1.5.19
> LibreCAD Qt/QMake
>
>
>
>
>
>
>
> --
> 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
>
>


-- 
Those who follow the Messenger-Prophet, the Ummi, whom they find
written down with them in the Taurat and the Injeel [who] enjoins them
good and forbids them evil, and makes lawful to them the good things
and makes unlawful to them impure things, and removes from them their
burden and the shackles which were upon them; so [as for] those who
believe in him and honor him and help him, and follow the light which
has been sent down with him, these it is that are the successful.
holy quran, chapter 7, verse 157.
best website for studying islamic book in different languages
al-islam.org

-- 
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] technical question about libreoffice and compatibility with microsoft office!

[tonybsa]

> 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 Intel Core 2 Duo, 4 GB RAM,  
Mac OS X  10.11.2
LibreOffice 4.4.5
Scribus 1.4
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4
Libre Project 1.5.19
LibreCAD Qt/QMake







-- 
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] LO Calc - style in formulae

[Remy Gauthier]

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.
However, if the cell you want to look at has been set to a style which
identifies its formatting via a formula, you can use the FORMULA()
function to extract that information. For instance:
Cell A1 contains 25
Cell A2 contains =A1*1.8+32+STYLE("STYLE_BOLD")
You can create a formula like:
=IF(NOT(ISERROR(FIND("STYLE_BOLD";FORMULA(A2;"Bold";"Not bold")
to find out if the cell has been formatted as bold or not. Of course,
you will need to create and assign the styles to the various cells, but
you should be able achieve something with this method.
I hope this helps.
Rémy Gauthier.

-- 
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] LO Calc - style in formulae

[toki]

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 are made. Not can be
made, but will be made, because edge cases were ignored. Almost
everything is, at least initially, an edge case.

^1: IIRC, it was on the order of 10,000 additional cells, for each cell
in which the comparison was made.

jonathon


-- 
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] technical question about libreoffice and compatibility with microsoft office!

[toki]

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, the following are rough equivalents.

* Microsoft Word:   Write;
* Microsoft Excel:  Calc;
* Microsoft Outlook:Not Available.
Suggested options are Evolution, 
Thunderbird with either Lightning
or Sunbird;
* Microsoft Powerpoint: Impress;
* Microsoft Access: Base, dbase3 clone;
Can connect to SQLite, Oracle, MySQL, 
PostGress, amongst other
database engines;
* Microsoft Infopath:   Not Available:
I think I've seen third party frameworks that 
incorporate LibO as
part of their process workflow, in providing this functionality;
* Microsoft Visio:  Draw;
* Microsoft Office Picture Manager: There are third party extensions and
templates utilizing Draw, Base, and Write that provide this functionality;
* Microsoft Publisher:  Write; Draw;
* Microsoft Onenote:Not available:
There are third party extensions and templates 
utilizing Base, and
Write that provide this functionality;
Suggested option:  Zotero, Docear;
* Microsoft Communicator;   Not available: Suggested options are Pidgin,
Thunderbird;
* Microsoft Interconnector; Not available:
There are third party extensions and templates 
utilizing Base, and
Write that provide this functionality;
* Microsoft Frontpage:  HTML Editor;
* Microsoft Accounting: Not available:
There are third party extensions and templates 
utilizing Calc, Base,
and Write that provide this functionality;
Suggested options are GnuCash, LedgerSMB;
* Microsoft Entourage:  Not Available.
Suggested options are Evolution, Thunderbird 
with Lightning or Sunbird;
* Microsoft Binder; Not available: No suggested options.
* Microsoft Schedule Plus;  Note available:
There are third party extensions and templates 
utilizing Calc, Base,
and Write that provide this functionality;
Suggested options are Evolution, Thunderbird 
with Lightning or Sunbird;
* Microsoft Mail;   Not Available.
Suggested options are Evolution, Thunderbird 
with Lightning or Sunbird;
* Microsoft Visact; Not available: No recommendations;
* Microsoft Liquid Motion:  Not available: No recommendations;
* Microsoft Photodraw;  Draw;
* Microsoft Picture it; Draw;
* Microsoft Expression Web; Not available: No recommendations;
* Microsoft Front page; Write/HTML Editor;
* Microsoft Sharepoint services:Not available: No recommendations;
* Microsoft Office Assistant;   Assuming that it hasn't be removed during
the ongoing code refactoring, there is one;
* Microsoft Visual BasicStarBasic, Java, Python, PERL, Ruby, R, etc,
etc, etc;
* Microsoft Visual Basic Applications:  Built in IDE when using
StarBasic, Java, Python, PERL, Ruby, R, etc, etc, etc;
* Equation Editor;  Math;
* Microsoft Project:Not Available;
There are third party extensions and templates 
utilizing Calc, Base,
and Write that provide this functionality;
Suggested options are: OpenProj from 
http://openproj.org/;
GanttProject from  http://ganttproject.biz/

* Microsoft Lync:   Not Available: Suggested options are Pidgin, 
Thunderbird;

How well these work for you, depends upon your specific use-case. In
most circumstances, the suggestions here provide a viable solution.

AOo, EU, and LibO can read/write/edit most MSO File formats.

The most significant MSO file formats which AOo can not read/write are
MSO Publisher and MSBinder;
The most significant MSO file format which EO can not read/write is
MSBinder;
The most significant MSO file format which LibOo can not read/write is
MSBinder;

jonathon









-- 
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] LO Calc - style in formulae

[Brian Barker]

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", since any cell could have a 
mixture of bold and not bold contents.


What could in principle be retrieved would be the cell style of a 
cell. If that facility had been provided, I imagine it would have 
been as part of the CELL() function - something like

=CELL("STYLE";Xn)
- but that's not available.

I trust this helps.

Brian Barker


--
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] technical question about libreoffice and compatibility with microsoft office!

[nasrin khaksar]

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, Project.
thanks extremely for your help and god's mercy and blessings i pray for you!


- --
Those who follow the Messenger-Prophet, the Ummi, whom they find
written down with them in the Taurat and the Injeel [who] enjoins them
good and forbids them evil, and makes lawful to them the good things
and makes unlawful to them impure things, and removes from them their
burden and the shackles which were upon them; so [as for] those who
believe in him and honor him and help him, and follow the light which
has been sent down with him, these it is that are the successful.
holy quran, chapter 7, verse 157.
best website for studying islamic book in different languages
al-islam.org

-- 
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] LO Calc - style in formulae

[Henry Sikkema]

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/
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] Extracting Character Count via a macro

[paradox.herron]

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/doing wrong?

Thanks for helping.

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] Re: Calc method to change whole column cell content

[Henry Sikkema]

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 Säger  wrote:

> Am 13.04.2016 um 12:32 schrieb Tom Davies:
> > Hi :)
> > CSV format can be easily edited in normal text-editors before opening in
> > Calc.  Sometimes its easier to use a simpler tool to do a part of the job
> > rather than use a complicated route in a heavier tool such as Calc.
> > Regards from
> > Tom :)
>
> Really? And how do you convert (£1,234.98) into -1234.98 in columns 3,
> 17 and 23 across thousands of rows using a text editor? Are YOU able to
> do this actually?
> Don't you think that checking "English(UK)" and "Interprete Special
> Numbers" is by far easier?
>
>
> --
> 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: Calc method to change whole column cell content

[Andreas Säger]

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 are all
> given as text entries with ($xxx.xx) for negative entries and $xxx.xx
> for positive entries. 

which is perfectly well handled by Calc's csv importer. 90% of all text
import trouble can be answered with:
1. Choose the right locale which is English(USA) in this particular case
because of the $ currency, the point decimals and propably there are
also M/D/Y dates in the file.
2. Always check "interprete special numbers". A special number is
anything beyond digits with decimal separator. This option is obsolete
since it should be always on. You can mark individual columns as text
when you do not want them to be interpreted as special numbers. But once
the option has been checked it remains checked for subsequent csv imports.


-- 
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: Calc method to change whole column cell content

[Andreas Säger]

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 dozends of different csv flavours with all types of text,
numbers and subtypes of numbers. With one exception they imported all
well. The exception was $(123.98) for a negative amount which could be
fixed with a simple regex replacing "^\$\(" with "($". Calc is an
excellent csv import tool which imports correct cell values where other
spreadsheet apps import text and try to interprete the text on the fly.


-- 
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 method to change whole column cell content

[Tom Davies]

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
Excel or whatever.

Each of us has a different way of doing things and it's good to have such a
wide range of choices so that we can do things in a fairly comfortable,
or/and in a fairly familiar way or choose to learn new skills while doing
something.  OpenSource generally gives people freedom to choose their own
way of doing things, and that can be seen as a negative or a positive.
Regards from
Tom :)

On 14 Apr 2016 00:29, "Andreas Säger"  wrote:

> Am 13.04.2016 um 12:32 schrieb Tom Davies:
> > Hi :)
> > CSV format can be easily edited in normal text-editors before opening in
> > Calc.  Sometimes its easier to use a simpler tool to do a part of the job
> > rather than use a complicated route in a heavier tool such as Calc.
> > Regards from
> > Tom :)
>
> Really? And how do you convert (£1,234.98) into -1234.98 in columns 3,
> 17 and 23 across thousands of rows using a text editor? Are YOU able to
> do this actually?
> Don't you think that checking "English(UK)" and "Interprete Special
> Numbers" is by far easier?
>
>
> --
> 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