nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Spreadsheet color one line from cell values

Nicolas Goutte

"The formula cannot refer to its own cell, which will lead to inaccurate calculation results"

I am expecting that with "$" the formatting will be applied on the whole line, which is the case but with an error !

Thank you.
Spreadsheet color one line from cell values_3.png

Accepted answers

All comments

Laurie Sciutti

Hi @Nicolas Goutte ~ this should work:

Nicolas Goutte

Hi @Laurie Sciutti

It could have been a good I idea, but I can't edit selection values from Atlassian Spreadsheet, I can only select cells.
Your proposition is from Excel, not Atlassian Spreadsheet.
I tested it with Edge and Chrome ...

How could I find a way to edit in order to insert the '$'?

Thank you,

Nicolas

Stiltsoft support

Hi @Nicolas Goutte ,

Please define what app and what macro you are using, there are no any spreadsheet macros in Confluence out of the box.

Our company develops the Table Filter, Charts & Spreadsheets for Confluence app that provides the Table Spreadsheet macro with a similar interface.

So, in case if we are talking about our app, I suggest referring to our support portal. Please export your problem spreadsheet in the .tfss format and attach it to the ticket (the portal is confidential). Also if your tags are wrong and you are on Data Center, please specify the app's version.

Meanwhile, we couldn't reproduce the issue:

Mon 1-1.png

Mon 1-2.png

Mon 1-3.png

=AND($B1="status",$E1="EXPECTED")

Seems that we've got the expected result.

Aliaksei Mikhailau {Stiltsoft}

Hello @Nicolas Goutte,

If you use Confluence Cloud, you should definitely expect no issue already, as we have released the corresponding fix. Could you please check and confirm?