set value for whole row/colum

[pdobkes]

Hi

I am looking for ability to set one value (it may be a label or something else) for whole row,

like cell group option in excel

Thanks

[RobertoBozzolo]

Hi, VAL_TABLE_COLUMN_RANGE and VAL_TABLE_ROW_RANGE macros are what you need to access a whole column in a table and store a value in it. Look at the sample project I attached to this message.

[pdobkes]

Thanks for you example, but it set one value to each column. I looking for option like group in excel: when i set group range, excel deletes cell borders of all cells in range, and show all cells in range as one cell. So that's the ability that i am looking for.

Do you have any suggestions?

Thanks

[RobertoBozzolo]

Unfortunately as far as I know cells in a table are not groupable: even if you can hide horizontal and vertical grid for some of them, nevertheless they remain individial cells.

I understand that what I am saying can be a *big* overshoot, but depending on the complexity of your application and on the presence of excel on the target machine you could consider using an excel worksheet embedded into your application to do what you need. Particularly, you can set a range of cells and apply to it the property of merged.

Wendy posted a sample project in this discussion that can illustrate how to handle a spreadsheet embedded into a CVI panel: it may worth a look at least to check if this can be a feasible solution.