Re: [libreoffice-users] Conditional Formatting On Date

[Brian Barker]

At 22:10 13/09/2015 +0200, Dave Barton wrote:
In Calc I have column with a series of calculated dates (ie. the 
result of a formula). I am looking to find a way of using 
conditional formatting to set the background colour (eg. green) for 
those dates which fall on a Saturday or Sunday (eg. Condition: = 
WEEKDAY (A2; 2)>5 sets Format: Cell Background = Green)


Can anyone offer any pointers to a solution?


I think you have (almost?) answered your own question.

o Select *one* cell of your range - e.g. your A2.
o Go to Format | Conditional Formatting... .
o With "Condition 1" ticked, select "Formula is".
o In the Cell Value Condition box, enter: WEEKDAY(A2;2)>5
o For Cell Style, select Green. You need either already to have 
defined a "Green" cell style or else to create one on the fly using 
the New Style... button.
o Now copy that formatting to other cells in your range. You can do 
this either by using the Format Paintbrush or by copying A2 and 
pasting it over the range, but using Paste Special... and selecting 
*just* Formats in the Paste Special dialogue.


Alternatively there is a quite different technique using the STYLE() 
function. Modify your original formulae to read:

=+STYLE(IF(WEEKDAY(CURRENT();2)>5;"Green"))

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] Re: LibreOffice 5.0 does not open

[Serguti]

Brian, thank you for your advice, spot-on. I installed SP3 and then
LibreOffice 5.0.1.2. It opens and run normally. I will try all the programs
later to verify is there is any further issue.
Thanks again




--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-0-does-not-open-tp4160139p4160211.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

[Advrk Aplmrkt]

Hello,

Thanks for your thoughtful reply!

I agree the best option is to use a propoer digital signature. When
properly done, it might be even more secure than a handwritten
signature?

Interesting point about the Creative Commons license, do you have
examples of how it's used in a real-world case?

Thanks!

On 11/09/2015, Tom Davies  wrote:
> Hi :)
> I think Steve is referring to "electronic signatures" rather than something
> resembling and pen&ink 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&ink 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&paste 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&ink 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 i

Re: [libreoffice-users] Images stop displaying after TOC update

[Steve Edmonds]

Sorry, pages 6 and 7

On 2015-09-14 09:25, steveedmonds wrote:

I have a document where images in a table stop displaying after a TOC update.
Can't find a bug related to this.
If I adjust the table row height the images display again.
LO Version: 4.3.7.2 Build ID: 430m0(Build:2) Opensuse on Linux
It doesn't do this on 4.1.6.2 on Win 7.
It does do it on 4.3.7.2 on mac. Yosemite.
It does do it on 4.4.5.2 on win  7.

I don't know if it is a regression requiring a bug or already resolved.

Attached (via nabble) file and before/after pdfs. (and yes, I have yet to
resize my images)
Steve
imageDisappears.odt

imageDisappears.pdf

imageDisappears2.pdf




--
View this message in context: 
http://nabble.documentfoundation.org/Images-stop-displaying-after-TOC-update-tp4160204.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

[libreoffice-users] Re: Images stop displaying after TOC update

[steveedmonds]

The images that disappear are anchored "as character". If I change them to
"anchor to paragraph, wrap through" they no longer stop displaying.
steve



--
View this message in context: 
http://nabble.documentfoundation.org/Images-stop-displaying-after-TOC-update-tp4160204p4160206.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

[libreoffice-users] Re: Conditional Formatting On Date

[Andreas Säger]

Am 13.09.2015 um 22:10 schrieb Dave Barton:
> In Calc I have column with a series of calculated dates (ie. the result
> of a formula). I am looking to find a way of using conditional
> formatting to set the background colour (eg. green) for those dates
> which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5
> sets Format: Cell Background = Green)
> Can anyone offer any pointers to a solution?
> TIA
> Dave
> 
> 
> 

Try =ISTEXT(A2) first.


-- 
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] Images stop displaying after TOC update

[steveedmonds]

I have a document where images in a table stop displaying after a TOC update.
Can't find a bug related to this.
If I adjust the table row height the images display again.
LO Version: 4.3.7.2 Build ID: 430m0(Build:2) Opensuse on Linux
It doesn't do this on 4.1.6.2 on Win 7.
It does do it on 4.3.7.2 on mac. Yosemite.
It does do it on 4.4.5.2 on win  7.

I don't know if it is a regression requiring a bug or already resolved.

Attached (via nabble) file and before/after pdfs. (and yes, I have yet to
resize my images)
Steve
imageDisappears.odt
  
imageDisappears.pdf
  
imageDisappears2.pdf
  



--
View this message in context: 
http://nabble.documentfoundation.org/Images-stop-displaying-after-TOC-update-tp4160204.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

[libreoffice-users] Re: Conditional Formatting On Date

[Pedro]

Dave Barton wrote
> In Calc I have column with a series of calculated dates (ie. the result
> of a formula). I am looking to find a way of using conditional
> formatting to set the background colour (eg. green) for those dates
> which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5
> sets Format: Cell Background = Green)
> Can anyone offer any pointers to a solution?

One way to do this is to have another column with column Weekday using the
formula you suggested. Then you have two options: either use conditional
formatting to set the background of the Weekday column OR use conditional
formatting with Condition set to "Formula is" and point to the weekday in
the same row and have the background changed accordingly.

Hope this helps
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Conditional-Formatting-On-Date-tp4160195p4160203.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

[libreoffice-users] Conditional Formatting On Date

[Dave Barton]

In Calc I have column with a series of calculated dates (ie. the result
of a formula). I am looking to find a way of using conditional
formatting to set the background colour (eg. green) for those dates
which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5
sets Format: Cell Background = Green)
Can anyone offer any pointers to a solution?
TIA
Dave



-- 
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 5.0 does not open

[Luuk]

On 13-09-15 15:26, Tim---Kracked_P_P---webmaster wrote:


If you are getting the same error[s], then it may be that Win XP does 
not like to run LibreOffice 5.x.x


TDF release builds require Windows Vista or later.
( see: https://wiki.documentfoundation.org/ReleaseNotes/5.0#Windows )



--
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 5.0 does not open

[Tim---Kracked_P_P---webmaster]

Which version did you install 32-bit or 64-bit?
Since 99% of the XP systems are 32-bit, that is important.

I would uninstall it at the Control Panel / Programs menu and then 
restart the system.  Then download/install 4.4.5 to see if it works for 
you.  If so, then make sure you are downloading the 32-bit version of 
5.0.1, if you still want to upgrade to the 5.0.x line.

The direct link is . . .
http://downloadarchive.documentfoundation.org/libreoffice/old/5.0.1.2/win/x86/

You will need to download - - LibreOffice_5.0.1.2_Win_x86.msi

and if you are using USA English, download - - 
LibreOffice_5.0.1.2_Win_x86_helppack_en-US.msi


If you are getting the same error[s], then it may be that Win XP does 
not like to run LibreOffice 5.x.x



On 09/12/2015 05:32 PM, Serguti wrote:

I installed LibreOffice 5.0 in my HP laptop (Windows XP Home_SP2). When I try
to start any of the programs in the suite, I get this message:
The procedure entry point "GetLogicalProcessorInformation" coiuld not be
located in the Dynamic Link Library Kernel32.dll
The file Kernel32.dll is in the folder System32 in Windows. I do no have any
similar problem with any other program.
Does anybody have an idea what is this problem, and how to solve it?



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-5-0-does-not-open-tp4160139.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

[Tim---Kracked_P_P---webmaster]

This is slightly off the topic . . . .
Is there any reason[s] why you have not upgraded to the free version of 
Win10 [Home or Pro]?

Or, are you satisfied with the tiled desktop in Win8.1?

Although Win10 does have its issues, same with Win8.x, it does have the 
tiles in the new version of its "Start Menu".


-

As for the install issue[s]. . . .

You should go to the "Programs and Features" section of the Control 
Panel and try to uninstall an version of LibreOffice that is listed.


Then deal with the removal/renaming of the LibreOffice folders for both 
4.4.x and 5.0.x [at main  folder level] that hold the User Profile and 
all the other info/files there.  This link will point you in the correct 
area of the system folder[s] where the LibreOffice folders are located.
https://wiki.documentfoundation.org/Documentation/UserProfile#Resetting_the_User-Profile 




Restart the computer.

Then download a new install file - 4.4.5 or the 5.0.x version. Install 
LibreOffice again.


This should give you a clean, and working, install of LibreOffice.

This process has worked for me with XP, Vista, and Win7.
I have no Win 8.x systems.
I am installing Win10 on most of my Win7 systems, when I have time and 
can dig the "spare systems" out of under-counter storage and set it up 
somewhere there is space of another system.




On 09/11/2015 06: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