Solved

OO SCalsc Conditional formatting is not working as anticipated.

Posted on 2011-02-16
5
554 Views
Last Modified: 2012-05-11
I have these cells in row 69:
   W         X     Y        Z
-44.21      0      0      -42.34

I want to conditionally format the cell in W69 if Z69 < 0 AND W69 < Z69

This formula works:
(Z69 < 0) AND (W69 < Z69)

 But when I copy the cell 'W69' (CTRL+C) and then paste special to cell W70 (ALT+SHIFT+V and only select 'Formats" the cell is not highlighted even through the condition is true. I can double check that the paste was valid (Format-Cond. Formatting) and the formula is correct.

What is going on? Why is the formula not working?

0
Comment
Question by:John_2357
  • 3
  • 2
5 Comments
 
LVL 20

Expert Comment

by:ltlbearand3
ID: 34912148
Those steps should work and are working on my copy of CALC.  I am wondering if the formula is not working on line 70.  Can you post the values in Cells W & Z on line 70?  Or maybe even post your sheet?  What version of OOo Calc are you using?

-Bear
0
 
LVL 1

Author Comment

by:John_2357
ID: 34912874
W70 is   -23.1 and Z70 is -18.34
I inserted another new worksheet after the sheet causing the problem, it seems that the new sheet inherited the formatting from the previous sheet. I typed in some random numbers so that the formula would  be true and agaIN ROW 69 WORKS AND ROW 70 does not. The spreadsheet is too big to post, I am sorry.

Is there a setting that can be un-checked so that new sheets do not inherit the previous sheet formats/formulas etc?  Is there or can there be hidden formulas/formats that are somehow over-riding the ones I set? I am using OpenOffice.org 3.1.1  OOO310m19 (Build:9420)

Thank you for your help.
0
 
LVL 20

Accepted Solution

by:
ltlbearand3 earned 250 total points
ID: 34913011
John_2357,

You might look at upgrading OOo as the current version is 3.3, but I doubt that will help.  It is hard to say what is causing you problem without looking at the spreadsheet.  It could be a Macro, hidden value, etc.  It will depend on what all you have on that sheet on how you want to proceed.  One suggestion is to open up a new Calc document.  Then in your all document, click on any cell and press Cntrl-A (For Select All) and then Cntrl-C (For copy).  In the new document select past special (Cntrl-Shft-V which is what I assume you are doing and not Alt-Shft-V as you listed above since that opens the view menu).  Then in the list Text, Number, Date & time, Formulas.  Now add your conditional formatting back into W69 and then copy to the other cells you need.  

Another suggestion is to right click on cell W70 and click default formatting.  Then copy W69 and paste special into W70.

-Bear
0
 
LVL 1

Author Closing Comment

by:John_2357
ID: 34921397
Creating a new workbook solved the problem. I would like to know why the old workbook generated the headaches. However I do not have the time to worry about it. Thank you for your help.
0
 
LVL 20

Expert Comment

by:ltlbearand3
ID: 34922268
I glad you got it fixed.  The only way to determine the original problem is for us to look at the sheet.  By the way, before closing questions, I suggest you look at the following article to get a feel for use of EE's grading system.  
http://www.experts-exchange.com/Community_Support/General/A_2786-How-do-I-close-a-question-at-Experts-Exchange.html?sfQueryTermInfo=1+30+answer+rate

-Bear
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
REPEATED PRINTED HEADER ON EVERY PAGE 2 394
openoffice save to html 13 287
LibreOffice macro error -- #Value 4 802
OpenOffice/LibreOffice (CALC) cell color function 3 2,849
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now