Worksheet -Format Cells

[LeeElston]

I have a door schedule where i want to highlight some cells for attention later.. However the 'Format cells' command seems to add a fill to all of the cells in that column, not just the single cell I want to amend.. Is there a way of doing this, or will I need to export as an Excel file to get this level of control?

TIA

[rDesign]

Since those cells are part of a database, then all of the cells in that column will take on the formatting of that one cell. You can’t have separate formatting for individual cell(s) in a database Worksheet.
I believe that you’ll have to export to Excel to have that level of control.

Edited May 13, 2023 by rDesign

[Pat Stanford]

@rDesign is correct, data in a Database subrow will all use the same formatting. 

[LeeElston]

Is this something that can be addressed as an improvement to VW? Seems a fairly basic function of a spreadsheet to me....

[Pat Stanford]

Yes it could be, but I am not certain how high it would be on VW priority list.

 

It is not an easy thing to do.  Database Subrows are dynamic.  If you add an additional object or delete an object from the drawing, the number of subrows will change and the cell you highlighted could move up or down.

 

If you change the sort order, should the highlighted cell stay with the data highlighted? Or should it stay with the same absolute cell number?

 

If you SUMmarize subrows where one cell is highlighted, what would be the proper action?

 

I am not saying that having this ability should not be added, just that trying to do it properly on dynamic subrows if far more complicated than in a static worksheet like Excel.

 

But I would love to have the ability also.  I recommend that you add a post in the WishList forum and ask for this feature.

[LeeElston]

All above my technical ability I'm afraid....

[Tom W.]

I think VW should make the distinction between 'Database Reports' + 'Criteria Reports' much much clearer. When I was learning about Worksheets it was only @Jonathan Pickup who spelled it out clearly (in tutorials etc) + helped me get my head around it. Would make it a lot easier for people to understand when it comes to questions like above. (In the meantime we are very fortunate to have @Pat Stanford + his excellent explainers!)

[Jonathan Pickup]

Thank you Tom. I have uploaded my old 2017 course to YouTube. Of course, it's old, so the interface has changed, but the basic concept has not changed. You can find the uptodate movies on my web site. 

 

 

[Jonathan Pickup]

the second movie