Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 16:55:44 +0000



Post From: spreadsheet for trading - cell formating and validation list

[2014-03-12 17:40:17]
User60591 - Posts: 39
Hi,

have a problem with Validation in Cell properties.
I windows i use ";" as list separator and when I use ";" in Input source validation works fine. Problem Is that when sierra restarts it changes ";" to "," and I must replace the comma each time I start Sierra.

Second thing is the cell formating issue with conditional formatting.
I wanna green colour fill ind the cell when the conditnon/ Value is TRUE. Only way I get this if I set:
Type: Cell Value
Operator: Not equal
Value: TRUE

After I close formating and I check it again Value is gone but it keeps on with propper cell formating.

pls check this out.


thank you