Re: [libreoffice-projects] Re: [libreoffice-users] Need help To convert Excel Sheet to Libre sheet

[Stephan Bergmann]

On 09/11/2015 06:39 AM, David Johnson wrote:

Thanks for your valuable inputs, appreciate it. Is there any
professional, whom you know, could help me to redevelop the same in
Libre Calc.


see the list of certified migration professionals at 



--
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: Strategies for securing a document with an embedded picture of signature

[avamk]

Good idea, I should really start using different signatures for
different things. I'll probably need a "signature" manager just like a
password manager to help me keep track of all those signatures!

On 11/09/2015, steveedmonds [via Document Foundation Mail Archive]
 wrote:
>
> In some respects your signature was safer on a piece of paper in the
> filing cabinet.
> I have a different signature I use on electronic documents, not the same
> as the one at the bank or the lawyer.
> It's still me signing it (statement of CE conformity, drawings, etc.)
> but no one can get my money with it.
> steve
>
> On 11/09/15 7:46 am, avamk wrote:
>> That's true!! I guess it doesn't really matter how I try to secure the
>> document if the receiver will see it on their screen, oh well. Thank
>> you for the reminder!
>>
>> Encryption is helpful though to ensure that at least only my intended
>> recipient will see the file.
>>
>> On 10/09/2015, steveedmonds [via Document Foundation Mail Archive]
>>  wrote:
>>> On 2015-09-11 03:06, avamk wrote:
 Hello,

 I think this is a rather outdated procedure, but I've come across cases
 where I am required to include a scanned image of my handwritten
 signature
 in a word processing document to "sign" it. Just to be clear, I am not
 talking about signing with a certificate, but rather an image of a
 handwritten signature inserted into the document.

 I am always scared of doing this, because what if an adversarial entity
 gets
 ahold of the document and starts using my signature for nefarious
 purposes??? So, is there a way to make this document (say, a .odt or
 .docx
 file) more secure that problem won't happen? Ideally I'd like to
 minimise
 complications/troubles when the receiver opens the file.

 Thank you!
>>> Anyone who can view the document can take a screen snap (clip) of your
>>> signature image and use it as they like. The security issue is more
>>> likely uncontrollable at the receivers end.
>>> Are you suggesting something like a pass phrase required to open and
>>> view a document, you can do this by just encrypting the file and
>>> emailing with something like Enigmail.
>>> Steve
>>
>>
>>
>> --
>> View this message in context:
>> http://nabble.documentfoundation.org/Strategies-for-securing-a-document-with-an-embedded-picture-of-signature-tp4159938p4159970.html
>> Sent from the Users mailing list archive at Nabble.com.
>
>
> --
> 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
>
>
>
>
>
> ___
> If you reply to this email, your message will be added to the discussion
> below:
> http://nabble.documentfoundation.org/Strategies-for-securing-a-document-with-an-embedded-picture-of-signature-tp4159938p4160008.html
>
> To unsubscribe from Strategies for securing a document with an embedded
> picture of signature, visit
> http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code=4159938=YXZrYXBsbWt0QGdtYWlsLmNvbXw0MTU5OTM4fC02MzM5MDA3MDg=




--
View this message in context: 
http://nabble.documentfoundation.org/Strategies-for-securing-a-document-with-an-embedded-picture-of-signature-tp4159938p4160012.html
Sent from the Users mailing list archive at Nabble.com.
-- 
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: Strategies for securing a document with an embedded picture of signature

[Steve Edmonds]

In some respects your signature was safer on a piece of paper in the 
filing cabinet.
I have a different signature I use on electronic documents, not the same 
as the one at the bank or the lawyer.
It's still me signing it (statement of CE conformity, drawings, etc.) 
but no one can get my money with it.

steve

On 11/09/15 7:46 am, avamk wrote:

That's true!! I guess it doesn't really matter how I try to secure the
document if the receiver will see it on their screen, oh well. Thank
you for the reminder!

Encryption is helpful though to ensure that at least only my intended
recipient will see the file.

On 10/09/2015, steveedmonds [via Document Foundation Mail Archive]
 wrote:

On 2015-09-11 03:06, avamk wrote:

Hello,

I think this is a rather outdated procedure, but I've come across cases
where I am required to include a scanned image of my handwritten
signature
in a word processing document to "sign" it. Just to be clear, I am not
talking about signing with a certificate, but rather an image of a
handwritten signature inserted into the document.

I am always scared of doing this, because what if an adversarial entity
gets
ahold of the document and starts using my signature for nefarious
purposes??? So, is there a way to make this document (say, a .odt or
.docx
file) more secure that problem won't happen? Ideally I'd like to minimise
complications/troubles when the receiver opens the file.

Thank you!

Anyone who can view the document can take a screen snap (clip) of your
signature image and use it as they like. The security issue is more
likely uncontrollable at the receivers end.
Are you suggesting something like a pass phrase required to open and
view a document, you can do this by just encrypting the file and
emailing with something like Enigmail.
Steve




--
View this message in context: 
http://nabble.documentfoundation.org/Strategies-for-securing-a-document-with-an-embedded-picture-of-signature-tp4159938p4159970.html
Sent from the Users mailing list archive at Nabble.com.



--
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] LibreOffice Damaged

[Gabriele Ponzo]

You mentioned 4 LO versions. From what I know on Windows it's not possible
to install more than one unless you use a specific software which name i
can't recall at the moment.

So the question is: why do you have so many version installed? And how did
you install them?
Il 12/set/2015 00:15, "Taang Zomi"  ha scritto:

> I had my laptop computer (Toshiba Satellite L55-B5276; Windows 8.1)
> repaired, and when I got it back, I found that my LibreOffice (4.4.4) could
> not be used. I got a message:
>
> ==
>
> LibreOffice 4.4.4  -- Fatal Error
> ---
> The program cannot be started.
>
> The service manager is not available.
>
> ("premature end of file:///C:/Users/
>
> Taang/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/commom.rdb")
>
> Start setup application to repair indtallation from CD, or the folder
> containing the installation packages.
>
> [OK]
>
> ==
>
> I did not understand what the message meant.
>
> Thinking that I could repair it, I went to the folder where I saved the
> program, and I clicked the program twice.   When the the time came for
> installation, I clicked "repair",  and it was successfully installed. But
> when I clicked LibreOffice 4.4.4 twice,  the same message appeared.
>
> Every time I clicked LibreOffice 4.4.5,  5.0.0 and 5.0.1, I got the same
> message, except for the heading, which changed to
>
>
> LibreOffice 4.4.5  -- Fatal Error
> LibreOffice 5.0.0  -- Fatal Error
> LibreOffice 5.0..1 -- Fatal Error
>
> How can I use my LibreOffice again? What do I need to do?
>
> Sincerely,
>
> Taang Zomi
>
> --
> 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] LibreOffice Damaged

[Taang Zomi]

I had my laptop computer (Toshiba Satellite L55-B5276; Windows 8.1)
repaired, and when I got it back, I found that my LibreOffice (4.4.4) could
not be used. I got a message:

==

LibreOffice 4.4.4  -- Fatal Error
---
The program cannot be started.

The service manager is not available.

("premature end of file:///C:/Users/
Taang/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/commom.rdb")

Start setup application to repair indtallation from CD, or the folder
containing the installation packages.

[OK]

==

I did not understand what the message meant.

Thinking that I could repair it, I went to the folder where I saved the
program, and I clicked the program twice.   When the the time came for
installation, I clicked "repair",  and it was successfully installed. But
when I clicked LibreOffice 4.4.4 twice,  the same message appeared.

Every time I clicked LibreOffice 4.4.5,  5.0.0 and 5.0.1, I got the same
message, except for the heading, which changed to


LibreOffice 4.4.5  -- Fatal Error
LibreOffice 5.0.0  -- Fatal Error
LibreOffice 5.0..1 -- Fatal Error

How can I use my LibreOffice again? What do I need to do?

Sincerely,

Taang Zomi

-- 
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] LibreOffice Damaged

[Joel Madero]

Did you pay to have it repaired? If so, maybe take it back to that place
and say they corrupted your software and you need it fixed.

BTW - I'm not sure if I'm speaking out of line but it's generally a no-no
to cc individuals on list emails ;) Just because they've helped you before
does not imply that they want to be cc'ed every time you need help as then
it's almost as if they are your not-paid personal support system :-D

Just for future reference - again, maybe they don't mind at all, but
generally on mailing lists it's frowned upon to cc people unless they've
explicitly told you that it's okay.

Best,
Joel

On Fri, Sep 11, 2015 at 3:13 PM, Taang Zomi 
wrote:

> I had my laptop computer (Toshiba Satellite L55-B5276; Windows 8.1)
> repaired, and when I got it back, I found that my LibreOffice (4.4.4) could
> not be used. I got a message:
>
> ==
>
> LibreOffice 4.4.4  -- Fatal Error
> ---
> The program cannot be started.
>
> The service manager is not available.
>
> ("premature end of file:///C:/Users/
>
> Taang/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/commom.rdb")
>
> Start setup application to repair indtallation from CD, or the folder
> containing the installation packages.
>
> [OK]
>
> ==
>
> I did not understand what the message meant.
>
> Thinking that I could repair it, I went to the folder where I saved the
> program, and I clicked the program twice.   When the the time came for
> installation, I clicked "repair",  and it was successfully installed. But
> when I clicked LibreOffice 4.4.4 twice,  the same message appeared.
>
> Every time I clicked LibreOffice 4.4.5,  5.0.0 and 5.0.1, I got the same
> message, except for the heading, which changed to
>
>
> LibreOffice 4.4.5  -- Fatal Error
> LibreOffice 5.0.0  -- Fatal Error
> LibreOffice 5.0..1 -- Fatal Error
>
> How can I use my LibreOffice again? What do I need to do?
>
> Sincerely,
>
> Taang Zomi
>
> --
> 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
>



-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com

-- 
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

Fwd: [libreoffice-users] LibreOffice Damaged

[Taang Zomi]

I did not mamage to install all those versions. I downdoaded all those
versions, and when I was unable to install a version , I attempted to
install the next one. But as I said, I was not successful in installing any
one of them. I got that message.


-- Forwarded message --
From: Gabriele Ponzo 

Date: Fri, Sep 11, 2015 at 6:56 PM
Subject: Re: [libreoffice-users] LibreOffice Damaged
To: Taang Zomi 
Cc: Brian Barker , Tom Davies ,
"LibreOffice, users" , Thudik Zomi <
thudikz...@gmail.com>


You mentioned 4 LO versions. From what I know on Windows it's not possible
to install more than one unless you use a specific software which name i
can't recall at the moment.

So the question is: why do you have so many version installed? And how did
you install them?
Il 12/set/2015 00:15, "Taang Zomi"  ha scritto:

> I had my laptop computer (Toshiba Satellite L55-B5276; Windows 8.1)
> repaired, and when I got it back, I found that my LibreOffice (4.4.4) could
> not be used. I got a message:
>
> ==
>
> LibreOffice 4.4.4  -- Fatal Error
> ---
> The program cannot be started.
>
> The service manager is not available.
>
> ("premature end of file:///C:/Users/
>
> Taang/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/commom.rdb")
>
> Start setup application to repair indtallation from CD, or the folder
> containing the installation packages.
>
> [OK]
>
> ==
>
> I did not understand what the message meant.
>
> Thinking that I could repair it, I went to the folder where I saved the
> program, and I clicked the program twice.   When the the time came for
> installation, I clicked "repair",  and it was successfully installed. But
> when I clicked LibreOffice 4.4.4 twice,  the same message appeared.
>
> Every time I clicked LibreOffice 4.4.5,  5.0.0 and 5.0.1, I got the same
> message, except for the heading, which changed to
>
>
> LibreOffice 4.4.5  -- Fatal Error
> LibreOffice 5.0.0  -- Fatal Error
> LibreOffice 5.0..1 -- Fatal Error
>
> How can I use my LibreOffice again? What do I need to do?
>
> Sincerely,
>
> Taang Zomi
>
> --
> 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

Fwd: [libreoffice-users] LibreOffice Damaged

[Taang Zomi]

Thank you for telling me that it s inappropriate for  me to cc individuals
in a list email. One of the email addresses is mine, and the two other
email addresses belong to two people who helped me in the past.

Yes, I paid t have it repaired. And yes, I would go back to them.
-- Forwarded message --
From: Joel Madero 
Date: Fri, Sep 11, 2015 at 6:39 PM
Subject: Re: [libreoffice-users] LibreOffice Damaged
To: Taang Zomi 
Cc: Brian Barker , Tom Davies ,
"LibreOffice, users" , Thudik Zomi <
thudikz...@gmail.com>


Did you pay to have it repaired? If so, maybe take it back to that place
and say they corrupted your software and you need it fixed.

BTW - I'm not sure if I'm speaking out of line but it's generally a no-no
to cc individuals on list emails ;) Just because they've helped you before
does not imply that they want to be cc'ed every time you need help as then
it's almost as if they are your not-paid personal support system :-D

Just for future reference - again, maybe they don't mind at all, but
generally on mailing lists it's frowned upon to cc people unless they've
explicitly told you that it's okay.

Best,
Joel

On Fri, Sep 11, 2015 at 3:13 PM, Taang Zomi 
wrote:

> I had my laptop computer (Toshiba Satellite L55-B5276; Windows 8.1)
> repaired, and when I got it back, I found that my LibreOffice (4.4.4) could
> not be used. I got a message:
>
> ==
>
> LibreOffice 4.4.4  -- Fatal Error
> ---
> The program cannot be started.
>
> The service manager is not available.
>
> ("premature end of file:///C:/Users/
>
> Taang/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/commom.rdb")
>
> Start setup application to repair indtallation from CD, or the folder
> containing the installation packages.
>
> [OK]
>
> ==
>
> I did not understand what the message meant.
>
> Thinking that I could repair it, I went to the folder where I saved the
> program, and I clicked the program twice.   When the the time came for
> installation, I clicked "repair",  and it was successfully installed. But
> when I clicked LibreOffice 4.4.4 twice,  the same message appeared.
>
> Every time I clicked LibreOffice 4.4.5,  5.0.0 and 5.0.1, I got the same
> message, except for the heading, which changed to
>
>
> LibreOffice 4.4.5  -- Fatal Error
> LibreOffice 5.0.0  -- Fatal Error
> LibreOffice 5.0..1 -- Fatal Error
>
> How can I use my LibreOffice again? What do I need to do?
>
> Sincerely,
>
> Taang Zomi
>
> --
> 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
>



-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com

-- 
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] Style a text value if a value is present, after a vlookup

[Wade Smart]

This fills out the team rosters:
Sheet 1
G16=VLOOKUP($E16,$Teams.$A$12:$I$23,($O$13+1),0)

Sheet 2
Column B2:B9 = team name
Column C2:C9 = captain name

What I would like to do is bold the capt name for each team.
How would you go about doing this (automatically)?
How do you style a element based on a range with a IF statement?

Wade

--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

-- 
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] Writer - footer on last page only?

[Cley Faye]

2015-09-11 13:23 GMT+02:00 Gordon Burgess-Parker :

> Is there any way of inserting a footer on the last page only of a document?
>
>
​Yes. Define a different page style, and apply it to the last page. Footers
are different for each page style​, so by doing this you can add a footer
only to the page having this style, and leave the other untouched.

-- 
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] Writer - footer on last page only?

[Gordon Burgess-Parker]

Is there any way of inserting a footer on the last page only of a document?

Cheers

Gordon

--
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: Need help To convert Excel Sheet to Libre sheet

[Andreas Säger]

Am 10.09.2015 um 08:24 schrieb Gabriele Ponzo:
> What's your problem specifically?
> 
> Unless there are macros, usually it's enough to open LibreOffice Calc and
> let it open the excel file. Then save it in odf (.ods) format.
> 
> Let is know of there are troubles with these steps, and please report
> specific problems.
> 

In India they do virtually _everything_ on Excel sheets. They have
incredible (and hair-raising) VBA applications for each and every purpose.



-- 
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] Need help To convert Excel Sheet to Libre sheet

[David Johnson]

Dear Joel,
It is a paid processional, we need to recreate the same excel in Libre 
office, we need this at the earliest.

--
Thanks ,
*|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi 
Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, 
Bangalore - 560027*|***|***www.janalakshmi.com**|*
*|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91 
95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*

On 11-09-2015 10:40, Joel Madero wrote:
You mean a paid professional? I could ask one or two people - if 
you're instead asking for a volunteer to assist, best bet is to just 
asked around on the email thread and maybe the OOo forum (there are a 
few great macro people over there).


Best,
Joel

On 09/10/2015 09:39 PM, David Johnson wrote:

Dear Joel & Tim,
Thanks for your valuable inputs, appreciate it. Is there any 
professional, whom you know, could help me to redevelop the same in 
Libre Calc.

--
Thanks ,
*|David Johnson|***|***H**O* - Technology & Process*|**|**Janalakshmi 
Financial Services Limited**|***|**No.34/1 Andree Road, Shantinagar, 
Bangalore - 560027*|***|***www.janalakshmi.com**|*
*|**Phone :* +91 080-42595100/700*|**|**Ext*-242*|**|**Mobile*: +91 
95-38-455118*||**E-Mail *: david.john...@janalakshmi.com*|*

On 11-09-2015 04:20, Joel Madero wrote:
That is a true statement - LibreOffice does not support the 
proprietary Microsoft VBA (it may in a very very limited way but not 
enough for most test cases that I've seen) - you'll have to rewrite 
it in Basic.


Best,
Joel

On Thu, Sep 10, 2015 at 2:04 PM, Tim Lloyd > wrote:


Hi David,

my understanding is that macros in excel and calc are written in
different languages so need to be rewritten.

Maybe one of the more learned members of the forum can confirm
or otherwise.

Cheers


On 10/09/15 19:48, David Johnson wrote:


Dear Gabriele and Tim,
PFA; This is the Excel Macro sheet we are trying to convert.
Could you please help me.

-- 
Thanks ,

*|David Johnson|***|***H**O* - Technology &
Process*|**|**Janalakshmi Financial Services
Limited**|***|**No.34/1 Andree Road, Shantinagar, Bangalore
- 560027*|***|***www.janalakshmi.com
**|*
*|**Phone :* +91 080-42595100
/700*|**|**Ext*-242*|**|**Mobile*:
+91 95-38-455118 *||**E-Mail *:
david.john...@janalakshmi.com
*|*
On 10-09-2015 12:17, Tim Lloyd wrote:

Hi David,

as noted below. It could just work! Which version were
you think of using? I think there is some consensus that
5.0 may be a little too "fresh" for an enterprise
environment. So the still version of 4.4.5 may be a good
base. Download this version and give it a go:

http://www.libreoffice.org/download/libreoffice-still/

There may also be some value having a hunt around the
bugzilla to see if any issues are relevant to yourselves.

https://bugs.documentfoundation.org/

Cheers

On 10/09/15 16:24, Gabriele Ponzo wrote:

What's your problem specifically?

Unless there are macros, usually it's enough to open
LibreOffice Calc and
let it open the excel file. Then save it in odf
(.ods) format.

Let is know of there are troubles with these steps,
and please report
specific problems.

All the best.
Il 10/set/2015 07:16, "David Johnson"
 ha
scritto:

Dear Users,
I'm David Johnson, from the Technology team from
Janalakshmi Financial
Services, Bangalore based NDFC. Currently we are
migrating our excel based
application to Libre office; hence I need Help
on the same. We have been
using a survey kind of tool which is developed
in Excel to be converted in
to Libre office. Can anybody advice us how we go
about it. It has to work
on all the platforms. Please advice.

If there is anybody (a consultant) in around
Bangalore. Who can support us
are welcomed. Look forward for your support at
the earliest.

-- 
-- 
Thanks ,

*|David Johnson|***|***H**O* - Technology &
Process*|**|**Janalakshmi
Financial 

[libreoffice-users] Re: LO 5.0.1.2 Writer: Tab icon pixels do not refresh

[daibutsu]

Thanks.

I did a search on the bugzilla database and found that this bug was already
filed a few days ago by a number of users. It affects Windows as well as
Linux. 

Latest news is that a fix will be available in LO 5.0.2





--
View this message in context: 
http://nabble.documentfoundation.org/LO-5-0-1-2-Writer-Tab-icon-pixels-do-not-refresh-tp4159170p4160015.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: Need help To convert Excel Sheet to Libre sheet

[Joel Madero]

Indeed the certified migrators are a good place to start to poke people.
You can also contact CIB who may be able to help.
https://libreoffice.cib.de/

Best,
Joel

On 09/11/2015 06:00 AM, Andreas Säger wrote:
> Am 10.09.2015 um 08:24 schrieb Gabriele Ponzo:
>> What's your problem specifically?
>>
>> Unless there are macros, usually it's enough to open LibreOffice Calc and
>> let it open the excel file. Then save it in odf (.ods) format.
>>
>> Let is know of there are troubles with these steps, and please report
>> specific problems.
>>
> In India they do virtually _everything_ on Excel sheets. They have
> incredible (and hair-raising) VBA applications for each and every purpose.
>
>
>


-- 
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] Writer - footer on last page only?

[jorge]

Hi all:

I think you can use: Menu-Insertar-Nota al Pie / Nota Final

And if you want to hide the character, you can reduce its size.

I hope this help

Regards,

Jorge Rodríguez


El vie, 11-09-2015 a las 12:23 +0100, Gordon Burgess-Parker escribió:
> Is there any way of inserting a footer on the last page only of a document?
> 
> Cheers
> 
> Gordon
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
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: Strategies for securing a document with an embedded picture of signature

[Tom Davies]

Hi :)
I think Steve is referring to "electronic signatures" rather than something
resembling and pen type scrawl.  I've not looked into this as most
office workers i've ever known would be completely baffled by it and not
trust it despite it being much more secure and trustworthy.

Another way that seems quite common these days is to print-out the
document, sign it with pen properly and then scan the document back
into the computer.  However there are numerous security and other problems
with this approach too!

Something i might consider, because it's highly user-friendly, is to treat
the document as a piece of "electronic art" and use a Creative Commons
License generated for that one specific document.  It is easily possible to
create a Creative Commons License to cover all the various documents you
might want to "sign", just as a signal signatures can be added to multiple
different documents, but that gets back to the same security issue of just
about anyone being able to copy it onto anything they like.

http://creativecommons.org/choose/

The Creative Commons route is not ideal as it's not what their licenses
were designed for but it might work.  Probably have to upload the document
somewhere in order to have a "Source URL"/weblink for the document.  The
drop-down at the bottom can be changed to an "off-line" mark to paste into
the document.


Part of the problem is that people want to do a visual quick comparison
between your signature on this and then compare that to another copy of
your signature that they do have complete trust in having been done by you
- just as passwords need to be compared against whatever you registered
your password as for that purpose.  The problem is that such things can be
accessed and maybe even decrypted given enough time and processing power.
Retinal scans and finger-prints are just jpegs (or pngs or whatever other
image format) so in a few years time i'm sure we will all be "shocked" to
discover that they are no more secure than current systems.  At the moment
they are just new and therefore criminals might need a bit of time to
catch-up but there is a good chance that many are already ahead of the game
anyway.


I think the best option is to create a proper digital signature and have
that alongside (or elsewhere near) the copy of the pen signature.

Good luck!
Regards from
Tom :)


On 11 September 2015 at 09:10, avamk  wrote:

> Good idea, I should really start using different signatures for
> different things. I'll probably need a "signature" manager just like a
> password manager to help me keep track of all those signatures!
>
> On 11/09/2015, steveedmonds [via Document Foundation Mail Archive]
>  wrote:
> >
> > In some respects your signature was safer on a piece of paper in the
> > filing cabinet.
> > I have a different signature I use on electronic documents, not the same
> > as the one at the bank or the lawyer.
> > It's still me signing it (statement of CE conformity, drawings, etc.)
> > but no one can get my money with it.
> > steve
> >
> > On 11/09/15 7:46 am, avamk wrote:
> >> That's true!! I guess it doesn't really matter how I try to secure the
> >> document if the receiver will see it on their screen, oh well. Thank
> >> you for the reminder!
> >>
> >> Encryption is helpful though to ensure that at least only my intended
> >> recipient will see the file.
> >>
> >> On 10/09/2015, steveedmonds [via Document Foundation Mail Archive]
> >>  wrote:
> >>> On 2015-09-11 03:06, avamk wrote:
>  Hello,
> 
>  I think this is a rather outdated procedure, but I've come across
> cases
>  where I am required to include a scanned image of my handwritten
>  signature
>  in a word processing document to "sign" it. Just to be clear, I am not
>  talking about signing with a certificate, but rather an image of a
>  handwritten signature inserted into the document.
> 
>  I am always scared of doing this, because what if an adversarial
> entity
>  gets
>  ahold of the document and starts using my signature for nefarious
>  purposes??? So, is there a way to make this document (say, a .odt or
>  .docx
>  file) more secure that problem won't happen? Ideally I'd like to
>  minimise
>  complications/troubles when the receiver opens the file.
> 
>  Thank you!
> >>> Anyone who can view the document can take a screen snap (clip) of your
> >>> signature image and use it as they like. The security issue is more
> >>> likely uncontrollable at the receivers end.
> >>> Are you suggesting something like a pass phrase required to open and
> >>> view a document, you can do this by just encrypting the file and
> >>> emailing with something like Enigmail.
> >>> Steve
> >>
> >>
> >>
> >> --
> >> View this message in context:
> >>
> 

[libreoffice-users] Mysterious line in document (see image)

[DocPit_]

I'm attaching an image that shows a line in my Writer document that I can't
eliminate.  Can anyone tell me how to get rid of this?
 



--
View this message in context: 
http://nabble.documentfoundation.org/Mysterious-line-in-document-see-image-tp4160043.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: LO 5.0.1.2 Writer: Tab icon pixels do not refresh

[Tom Davies]

Hi :)
Thanks for checking and confirming this.  It's good to know! :)
Thanks and regards from
Tom :)

On 11 September 2015 at 10:04, daibutsu  wrote:

> Thanks.
>
> I did a search on the bugzilla database and found that this bug was already
> filed a few days ago by a number of users. It affects Windows as well as
> Linux.
>
> Latest news is that a fix will be available in LO 5.0.2
>
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/LO-5-0-1-2-Writer-Tab-icon-pixels-do-not-refresh-tp4159170p4160015.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> 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

Re: [libreoffice-users] Mysterious line in document (see image)

[jorge]

Hi all:

You can use CTRL-F10 to put or eliminate Non Print Characters like
that.

Regards,

Jorge Rodríguez



El vie, 11-09-2015 a las 07:18 -0700, DocPit_ escribió:
> I'm attaching an image that shows a line in my Writer document that I can't
> eliminate.  Can anyone tell me how to get rid of this?
>  
> 
> 
> 
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Mysterious-line-in-document-see-image-tp4160043.html
> Sent from the Users mailing list archive at Nabble.com.
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
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