OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

>3Conditional formats imported from Excel: where are they

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
jmpoyser
Newbie
Newbie


Joined: 01 May 2012
Posts: 3

PostPosted: Wed May 02, 2012 8:18 pm    Post subject: >3Conditional formats imported from Excel: where are they Reply with quote

I had an Excel spreadsheet with 12 conditional formats applied to an area. I have converted the workbook by opening with OpenOffice and Save As a Calc spreadsheet. My conditional formatting is still working but I can only access 3 of them via the GUI. Where can I look to view/modify the other conditions? I can see them in the list of styles but don't know where they are being triggered from.
Back to top
View user's profile Send private message
karolus
OOo Advocate
OOo Advocate


Joined: 22 Jun 2011
Posts: 210

PostPosted: Wed May 02, 2012 9:55 pm    Post subject: Reply with quote

Hi
The Limit to 3 Condition is only over GUI

Try Mottco( http://www.ooowiki.de/KomplexeBedingteFormatierungen?action=AttachFile&do=get&target=mottco_102b.oxt)

or install http://www.libreoffice.org/

Karo
Back to top
View user's profile Send private message
jmpoyser
Newbie
Newbie


Joined: 01 May 2012
Posts: 3

PostPosted: Wed May 09, 2012 3:26 pm    Post subject: SOLVED Reply with quote

Thanks Karo.

Mottco did the trick, although I now have to learn Dutch....

Smile
Back to top
View user's profile Send private message
karolus
OOo Advocate
OOo Advocate


Joined: 22 Jun 2011
Posts: 210

PostPosted: Wed May 09, 2012 9:33 pm    Post subject: Reply with quote

Hi

Dutch != German

Karo
Back to top
View user's profile Send private message
jmpoyser
Newbie
Newbie


Joined: 01 May 2012
Posts: 3

PostPosted: Wed May 09, 2012 9:40 pm    Post subject: Reply with quote

Sorry, that's just what Google told me Very Happy
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group