Confluence Spreadsheets: Data validation when inserting a new row

Gil Gordon
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 17, 2023

Dear community,

I am trying to implement a spreadsheet in confluence and several columns should have a data validation with pre-defined choices to choose from.

I insert the data validation and mark the entire column as such.

However, when inserting a new row (for example at the top, just under the table header), this row does not have the data validation in any of the cells.

Is there a way to keep the data validation throughout the entire column when inserting a new row?

Thank you for any help regarding this matter.

Best regards,

Gil

2 answers

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 11, 2023

Hi @Gil Gordon ,

As @Brant Schroeder has kindly mentioned, please clarify what app/solution you are using to create a spreadsheet in Confluence. Seems that there is no such feature out of the box.

Our company develops the Table Filter and Charts for Confluence app that provides the Table Spreadsheet macro - you'll be able to use data validation there. Maybe you are talking about our app?

Gil Gordon
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 11, 2023

Hello @Stiltsoft support 

we are using:

Screenshot 2023-12-11 134214.png

In the meantime, we have looked at different ways of accomplishing our goals, but the description in my first post still describes the issue perfectly.

We are not pasting from an Excel file.

Best regards,

Gil

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 12, 2023

Hi @Gil Gordon ,

Indeed there is no such definition as a "table" inside the Table Spreadsheet macro, so when you add a new row to the cell range, it will be added blank (without predefined formulas and dropdowns). Unfortunately, this is it's expected behavior.

Please note that if you have questions regarding our app, it will be more effective to refer to our support

Atlassian Community is more about sharing user experience and though we try to track related questions by the key words (app's name, macro names), we can miss them like we've missed your question (the macro name wasn't specified in the original post).

Like # people like this
0 votes
Brant Schroeder
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 10, 2023

@Gil Gordon Welcome to the Atlassian community

If you are copying excel and pasting into Confluence it will convert it to a table and it will not retain the data validation.  

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events