Hide columns

[eevleevs]

Details for the issue

I often use a db instead of a spreadsheet, and I would use the possibility to hide columns in order to focus only on certain fields. Views don't seem a solution to this because they cannot edit data.

I'm opening this issue because:

• DB4S is crashing
• DB4S has a bug
• DB4S needs a feature
• DB4S has another problem

I'm using DB4S on:

• Windows: ( version: ___ )
• Linux: ( distro: ___ )
• Mac OS: ( version: ___ )
• Other: ___

I'm using DB4S version:

• 3.9.1
• 3.9.0
• Other: ___

I have also:

• Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows
• Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20

[justinclift]

Interesting thought. Yep, it does sound like it would be useful. 😄

[chrisjlocke]

A possible 'temporary workaround' is that columns can be resized down to quite a small size.

These can also be saved if the database is saved as a 'project', which is handy...
So not perfect, but 'workable'.... ;)

Maybe if the minimum size could be removed or made smaller?

[justinclift]

Yep, that'd probably work too. 😄

[iKlsR]

How would one go about showing back the hidden column, do we want to selectively hide columns and then have a mass show all hidden? Or maybe put them in a list?

[eevleevs]

Mass show works for me, if you want to make it simple.
For hiding, would be good if one could select several columns, and hide all at once.

[lpirl]

for references, resolving #141 (edit views) would resolve this issue as well

[peteristhegreat]

I implemented this feature recently on 3.9.0. I'll see if I can put together a git pull request soon. The corner case for if all columns gets hidden, it unhides the first column (not the zeroth).

// Add two actions in MainWindow.ui called "actionHideColumns" and "actionShowAllColumns"

// add two lines to MainWindow::init()

popupBrowseDataHeaderMenu->addAction(ui->actionHideColumns);
popupBrowseDataHeaderMenu->addAction(ui->actionShowAllColumns);

// add two slots to MainWindow.cpp
void MainWindow::on_actionHideColumns_triggered()
{
     int myCol = -1;
     if(ui->dataTable->selectedCols().size() == 0)
     {
          myCol = ui->actionBrowseTableEditDisplayFormat->property("clicked_column").toInt();
     }

     foreach(int col, ui->dataTable->selectedCols())
     {
          ui->dataTable->hideColumn(col);
     }
     if(myCol != -1)
          ui->dataTable->hideColumn(myCol);

     // check to see if all the columns are hidden

     bool allHidden = true;
     for(int col = 1; col < ui->dataTable->model()->columnCount(); col++)
     {
          if(!ui->dataTable->isColumnHidden(col))
          {
                allHidden = false;
                break;
          }
     }

     if(allHidden  && ui->dataTable->model()->columnCount() > 1)
     {
          ui->dataTable->showColumn(1);
          ui->dataTable->resizeColumnToContents(1);
     }
}

void MainWindow::on_actionShowAllColumns_triggered()
{
     for(int col = 1; col < ui->dataTable->model()->columnCount(); col++)
     {
          if(ui->dataTable->isColumnHidden(col))
          {
                ui->dataTable->showColumn(col);
                ui->dataTable->resizeColumnToContents(col);
          }
     }
}

[justinclift]

@peteristhegreat Cool. Yep, please get that info a PR when you have a few minutes. 😄

[peteristhegreat]

Built and tested on Qt 5.6.1, MingW 4.9.2 32bit.

See #1135

[justinclift]

Thanks @peteristhegreat, just saw the PR. The placement of the options looks good to me. Right-click context menu being where people generally expect this kind of thing. 😄

[MKleusberg]

@eevleevs We've just added this feature to our code. Are you interested in downloading tomorrow's nightly build and testing if it works for you? 😄 Thanks again to @peteristhegreat for implementing this!

[eevleevs]

Works perfectly, thank you 👍

[justinclift]

Awesome, thanks for verifying @eevleevs. 😄

[KimlongSeng]

Is there a way to hide it until I turn it back on ? So far, when I click refresh, it will reappear.

[MKleusberg]

@KimlongSeng Which version are you using? And can you try again with the latest nightly build from here? In theory it should stay hidden in that version.