Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 22:21:57 +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