Re: [libreoffice-users] I want to add formulas and functions to calc

[Stefan Weigel]

Hi,

Am 23.10.2011 04:35, schrieb Alberto Sanchez:

> Is there a way that the community can benefit from this?

>>> so my question is, how can I add that function
>>> so that many others in my position can benefit from them?

Make an Extension and put into the Extensions Repository.

http://www.libreoffice.org/features/extensions/
http://extensions-test.libreoffice.org/

If you do not know how to create an extension and if you do not want
to learn it (which isn´t difficult), you could post the Code and a
description of your new function and hope that some other old man
will pick it up and create and publish it as an extension.

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@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] I want to add formulas and functions to calc

[Alberto Sanchez]

Is there a way that the community can benefit from this?

On Sat, Oct 22, 2011 at 10:20 PM, Steve Edmonds
wrote:

> Hi.
> http://help.libreoffice.org/Calc/User-Defined_Functions
> steve
>
> On 23/10/11 14:12, Alberto Sanchez wrote:
> > Hi all,
> > I'm a finance major so I use excel a lot, but I don't have the money for
> it
> > so I use calc.  I see that there's is a lot of financial formulas that
> are
> > missing but that excel has, so my question is, how can I add that
> function
> > so that many others in my position can benefit from them?
> >
> >
>
> --
> For unsubscribe instructions e-mail to: users+h...@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
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@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] I want to add formulas and functions to calc

[Steve Edmonds]

Hi.
http://help.libreoffice.org/Calc/User-Defined_Functions
steve

On 23/10/11 14:12, Alberto Sanchez wrote:
> Hi all,
> I'm a finance major so I use excel a lot, but I don't have the money for it
> so I use calc.  I see that there's is a lot of financial formulas that are
> missing but that excel has, so my question is, how can I add that function
> so that many others in my position can benefit from them?
>
>   

-- 
For unsubscribe instructions e-mail to: users+h...@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] I want to add formulas and functions to calc

[Alberto Sanchez]

Hi all,
I'm a finance major so I use excel a lot, but I don't have the money for it
so I use calc.  I see that there's is a lot of financial formulas that are
missing but that excel has, so my question is, how can I add that function
so that many others in my position can benefit from them?

-- 
For unsubscribe instructions e-mail to: users+h...@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] LibO 3.4.3 cannot open password protected Word 2010 file

[Dennis E. Hamilton]

Thank you, Nguyen,

The workaround is to store in Word 97-2003 .doc format and use the weaker 
security that provides.  This is the only case of a password-protected 
Microsoft Word document that I have seen be readable by OpenOffice and 
LibreOffice software.  

You'll have to experiment to see if your read-only and revision-tracking locks 
are preserved in that case and, if preserved, whether they are preserved in 
LibreOffice opening of the document.  I expect that these will be dropped or 
the recipient, even you, might be unable to release those locks because the 
password verifier used in the ODF format is not derived the same way.

 - Dennis E. Hamilton
   tools for document interoperability,  
   dennis.hamil...@acm.org  gsm: +1-206-779-9430  @orcmid

ADDITIONAL DOCUMENT FORENSICS

I was able to download and open the Aaa.docx file in Word 2010 without 
difficulty. (The first of 4 words on the single-page document is "Aaa".)  I was 
also able to open the file in Word 2007 too.  I was also able to allow editing 
of the document by using the same password.  Oh, and I see change-tracking is 
enabled.  So the fourth word in the document is actually a tracked deletion and 
not an underlined word in red.  Oh, and change-tracking is forced in the 
document settings.  Nice.

This password protection is not part of the OOXML specification as far as I 
know.  It is a separate technique, documented as MS-OFFCRYPTO, by which the 
entire file is encrypted with a "wrapper" that allows Word to recognize it.  
The name of the file is unchanged, and Word will recognize the special format 
and request that the password be provided.  This particular form of encryption 
is unlike anything that is used with ODF documents (although there are 
discussions to provide something comparable to achieve improved document 
security).  

Word 2007 and Word 2010 use stronger encryption techniques on DOCX files than 
are supported with DOC files, so that is another reason to try the workaround. 

I notice that if I use "Open with" LibreOffice Writer 3.3.2, nothing happens - 
Writer starts to open and then closes automatically.

If I use "Open with"  OpenOffice.org 3.2, the file format is not recognized at 
all.

-Original Message-
From: Nguyen Vu Hung (kiei) [mailto:vuh...@ki-ei.com] 
Sent: Saturday, October 22, 2011 05:04
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] LibO 3.4.3 cannot open password protected Word 
2010 file

Ngày 11/10/22 17:16, Frieder viết:
>> Ngày 11/10/22 16:33, Nguyen Vu Hung (kiei) viết:
>>> Hello all,
>>>
>>> It seems that LibO 3.4.3 cannot open password protected Word 2010 file.
>>> Attached is a Word file saved with Mac Word 2010.
>>>
>>> The password for opening and modifying is "123456".
>>>
>>> Any ideas?
>>>
>>
>>
> Hello
> you can't send attachments to this list.
> Pleas store the document somewhere on the web, and send a Link to this 
> list.
> You can use Google-Spreadsheets to store your document on the web, but 
> you need a googlemail address for this.
I did not know that.
Here we go: http://www.mediafire.com/?eqc9sh5hc49v6j5

Regards,

Nguyen Vu Hung


-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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] Documents Not Opening On External Drive

[Yogi]

I'm using LibreOffice 3.4.3 on a Windows 7 Ultimate machine.  All my work is
saved on the same hard drive as the installed copy of LibreOffice, F:\  All
works well there.

>From time to time I manually copy the files stored on my internal drive F:\
to a network attached storage (NAS) hard drive for backup purposes.  When I
double click the file on the NAS drive it will not open.  The right click
context menu will only open some files; most will not open.  The menu bar
File/Open... option likewise will open a few files but not all of them.

I would like to be able to open all my LibreOffice documents stored on my
NAS by simply double clicking on them.  Does anyone have an idea how to do
this?

--
View this message in context: 
http://nabble.documentfoundation.org/Documents-Not-Opening-On-External-Drive-tp3443972p3443972.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] LibO 3.4.3 cannot open password protected Word 2010 file

[Nguyen Vu Hung (kiei)]

Ngày 11/10/22 17:16, Frieder viết:

Ngày 11/10/22 16:33, Nguyen Vu Hung (kiei) viết:

Hello all,

It seems that LibO 3.4.3 cannot open password protected Word 2010 file.
Attached is a Word file saved with Mac Word 2010.

The password for opening and modifying is "123456".

Any ideas?





Hello
you can't send attachments to this list.
Pleas store the document somewhere on the web, and send a Link to this 
list.
You can use Google-Spreadsheets to store your document on the web, but 
you need a googlemail address for this.

I did not know that.
Here we go: http://www.mediafire.com/?eqc9sh5hc49v6j5

Regards,

Nguyen Vu Hung


--
For unsubscribe instructions e-mail to: users+h...@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] LibO 3.4.3 cannot open password protected Word 2010 file

[Frieder]

Am 22.10.2011 11:55, schrieb Nguyen Vu Hung (kiei):

I resend the attachment.

Ngày 11/10/22 16:33, Nguyen Vu Hung (kiei) viết:

Hello all,

It seems that LibO 3.4.3 cannot open password protected Word 2010 file.
Attached is a Word file saved with Mac Word 2010.

The password for opening and modifying is "123456".

Any ideas?





Hello
you can't send attachments to this list.
Pleas store the document somewhere on the web, and send a Link to this list.
You can use Google-Spreadsheets to store your document on the web, but 
you need a googlemail address for this.


Regards
Frieder


--
For unsubscribe instructions e-mail to: users+h...@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] LibO 3.4.3 cannot open password protected Word 2010 file

[Nguyen Vu Hung (kiei)]

I resend the attachment.

Ngày 11/10/22 16:33, Nguyen Vu Hung (kiei) viết:

Hello all,

It seems that LibO 3.4.3 cannot open password protected Word 2010 file.
Attached is a Word file saved with Mac Word 2010.

The password for opening and modifying is "123456".

Any ideas?




--
For unsubscribe instructions e-mail to: users+h...@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] LibO 3.4.3 cannot open password protected Word 2010 file

[Nguyen Vu Hung (kiei)]

Hello all,

It seems that LibO 3.4.3 cannot open password protected Word 2010 file.
Attached is a Word file saved with Mac Word 2010.

The password for opening and modifying is "123456".

Any ideas?

--
For unsubscribe instructions e-mail to: users+h...@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] balloons on specific words - please CC when replying.

[shirish शिरीष]

Hi all,
 I remember seeing sometime back in some presentation where people
choose to highlight some words and hovering or clicking on that words
would make a balloon or something which would tell about the word. It
was as if the word were saying something .

I don't remember if I saw this on libreoffice, openoffice.org or some
other presentation tool.

I do see there is something called comments. Does it do/have the same function ?

-- 
          Regards,
          Shirish Agarwal  शिरीष अग्रवाल
  My quotes in this email licensed under CC 3.0
http://creativecommons.org/licenses/by-nc/3.0/
http://flossexperiences.wordpress.com
065C 6D79 A68C E7EA 52B3  8D70 950D 53FB 729A 8B17

-- 
For unsubscribe instructions e-mail to: users+h...@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