#include "toonzqt/spreadsheetviewer.h"

#include "toonzqt/gutil.h"

#include "toonz/preferences.h"

#include "toonz/toonzfolders.h"

#include "toonz/tframehandle.h"

#include "orientation.h"

#include <qkeyevent></qkeyevent>

#include <qwheelevent></qwheelevent>

#include <qlabel></qlabel>

#include <qscrollbar></qscrollbar>

#include <qpainter></qpainter>

#include <qgridlayout></qgridlayout>

#include <qpaintevent></qpaintevent>

#include <qtooltip></qtooltip>

#include <assert.h></assert.h>

#include <qmainwindow></qmainwindow>

#include <qdockwidget></qdockwidget>

#include <qsettings></qsettings>

namespace Spreadsheet {

//=============================================================================

FrameScroller::FrameScroller()

    : m_orientation(Orientations::topToBottom())

    , m_scrollArea(nullptr)

    , m_lastX(0)

    , m_lastY(0)

    , m_syncing(false) {}

FrameScroller::~FrameScroller() {}

void FrameScroller::setFrameScrollArea(QScrollArea *scrollArea) {

  disconnectScrollbars();

  m_scrollArea = scrollArea;

  connectScrollbars();

}

void FrameScroller::disconnectScrollbars() {

  if (!m_scrollArea) return;

  disconnect(m_scrollArea->verticalScrollBar(), &QScrollBar::valueChanged, this,

             &FrameScroller::onVScroll);

  disconnect(m_scrollArea->horizontalScrollBar(), &QScrollBar::valueChanged,

             this, &FrameScroller::onHScroll);

}

void FrameScroller::connectScrollbars() {

  if (!m_scrollArea) return;

  m_lastX = m_scrollArea->horizontalScrollBar()->value();

  m_lastY = m_scrollArea->verticalScrollBar()->value();

  connect(m_scrollArea->verticalScrollBar(), &QScrollBar::valueChanged, this,

          &FrameScroller::onVScroll);

  connect(m_scrollArea->horizontalScrollBar(), &QScrollBar::valueChanged, this,

          &FrameScroller::onHScroll);

}

void FrameScroller::onVScroll(int y) {

  QPoint offset(0, y - m_lastY);

  if (isSyncing()) return;

  m_lastY = y;

  int senderMaximum     = 0;

  QScrollBar *scrollBar = dynamic_cast<qscrollbar *="">(sender());</qscrollbar>

  if (scrollBar) senderMaximum = scrollBar->maximum();

  setSyncing(true);

  handleScroll(offset, senderMaximum, y);

  setSyncing(false);

}

void FrameScroller::onHScroll(int x) {

  QPoint offset(x - m_lastX, 0);

  if (isSyncing()) return;

  m_lastX = x;

  int senderMaximum     = 0;

  QScrollBar *scrollBar = dynamic_cast<qscrollbar *="">(sender());</qscrollbar>

  if (scrollBar) senderMaximum = scrollBar->maximum();

  setSyncing(true);

  handleScroll(offset, senderMaximum, x);

  setSyncing(false);

}

static QList<framescroller *=""> frameScrollers;</framescroller>

void FrameScroller::handleScroll(QPoint &offset, int senderMaximum,

                                 int senderValue) {

  if ((m_orientation->isVerticalTimeline() && offset.x()) ||

      (!m_orientation->isVerticalTimeline() &&

       offset.y()))  // only synchronize changes by frames axis

    return;

  // If the scroller has the same maximum size, assume it as the scroll bar in

  // the neighbor panel with the same height & scale. In such case just set the

  // same value as the sender without zoom adjusting whichi may cause error due

  // to rounding off.

  QList<framescroller *=""> scrollBarCue;</framescroller>

  for (auto frameScroller : frameScrollers)

    if (frameScroller != this) {

      if (!frameScroller->isSyncing()) {

        if (!frameScroller->exactScroll(senderMaximum, senderValue)) {

          // If the size is different from the sender, then put it in the cue

          // for adjusting offset and scrolling.

          scrollBarCue.append(frameScroller);

        }

      }

    }

  if (scrollBarCue.isEmpty()) return;

  QPointF offsetF(offset);

  // In case of a zoomed viewer is sending this out, adjust the

  // zoomed offset back to a standardized offset

  emit zoomScrollAdjust(offsetF, false);

  CellPositionRatio ratio = orientation()->xyToPositionRatio(offsetF);

  for (auto frameScroller : scrollBarCue)

    if (frameScroller != this) {

      if (!frameScroller->isSyncing()) {

        frameScroller->onScroll(ratio);

        break;

      }

    }

}

void adjustScrollbar(QScrollBar *scrollBar, int add);

// Check if the scroll bar has the same size as the sender and just put the

// value

bool FrameScroller::exactScroll(const int senderMaximum,

                                const int senderValue) {

  QScrollBar *scrollBar = (m_orientation->isVerticalTimeline())

                              ? m_scrollArea->verticalScrollBar()

                              : m_scrollArea->horizontalScrollBar();

  if (scrollBar->maximum() == senderMaximum) {

    scrollBar->setValue(senderValue);

    return true;

  }

  return false;

}

void FrameScroller::onScroll(const CellPositionRatio &ratio) {

  QPointF offset = orientation()->positionRatioToXY(ratio);

  // In case of a zoomed viewer is receiving this, adjust the

  // standardized offset to zoomed offset

  emit zoomScrollAdjust(offset, true);

  // scroll area should be resized before moving down the scroll bar.

  // SpreadsheetViewer::onPrepareToScrollOffset() will be invoked immediately

  // since the receiver is in the same thread.

  // when moving up the scroll bar, resizing will be done in

  // SpreadsheetViewer::onVSliderChanged().

  if (offset.x() > 0.0 || offset.y() > 0.0) emit prepareToScrollOffset(offset);

  if ((int)offset.x())

    adjustScrollbar(m_scrollArea->horizontalScrollBar(), (int)offset.x());

  if ((int)offset.y())

    adjustScrollbar(m_scrollArea->verticalScrollBar(), (int)offset.y());

}

void adjustScrollbar(QScrollBar *scrollBar, int add) {

  scrollBar->setValue(scrollBar->value() + add);

}

void FrameScroller::registerFrameScroller() {

  if (!frameScrollers.contains(this)) frameScrollers.append(this);

}

void FrameScroller::unregisterFrameScroller() {

  if (frameScrollers.contains(this)) frameScrollers.removeAll(this);

}

void FrameScroller::prepareToScrollOthers(const QPointF &offset) {

  CellPositionRatio ratio = orientation()->xyToPositionRatio(offset);

  for (int i = 0; i < frameScrollers.size(); i++)

    if (frameScrollers[i] != this)

      frameScrollers[i]->prepareToScrollRatio(ratio);

}

void FrameScroller::prepareToScrollRatio(const CellPositionRatio &ratio) {

  QPointF offset = orientation()->positionRatioToXY(ratio);

  emit prepareToScrollOffset(offset);

}

//=============================================================================

void SetFrameDragTool::click(int row, int col, QMouseEvent *e) {

  m_frameHandle->setFrame(row);

}

void SetFrameDragTool::drag(int row, int col, QMouseEvent *e) {

  if (row < 0) row = 0;

  m_frameHandle->setFrame(row);

}

void SetFrameDragTool::release(int row, int col, QMouseEvent *e) {}

//=============================================================================

//

// SelectionDragTool

//

//-----------------------------------------------------------------------------

SelectionDragTool::SelectionDragTool(SpreadsheetViewer *viewer)

    : m_viewer(viewer), m_firstRow(-1), m_firstCol(-1) {}

void SelectionDragTool::click(int row, int col, QMouseEvent *e) {

  m_firstCol = col;

  m_firstRow = row;

  QRect selectedCells(col, row, 1, 1);

  m_viewer->selectCells(selectedCells);

}

void SelectionDragTool::drag(int row, int col, QMouseEvent *e) {

  int r0 = std::min(row, m_firstRow);

  int r1 = std::max(row, m_firstRow);

  int c0 = std::min(col, m_firstCol);

  int c1 = std::max(col, m_firstCol);

  QRect selectedCells(c0, r0, c1 - c0 + 1, r1 - r0 + 1);

  m_viewer->selectCells(selectedCells);

}

void SelectionDragTool::release(int row, int col, QMouseEvent *e) {}

//=============================================================================

PanTool::PanTool(Spreadsheet::GenericPanel *panel)

    : m_panel(panel), m_viewer(panel->getViewer()), m_lastPos() {}

void PanTool::click(int row, int col, QMouseEvent *e) {

  m_lastPos = e->pos();  // m_panel->mapToGlobal(e->pos());

}

void PanTool::drag(int row, int col, QMouseEvent *e) {

  QPoint pos = e->pos();  // m_panel->mapToGlobal(e->pos());

  // QPoint delta = p - m_lastPos;

  // m_lastPos = p;

  // QToolTip::showText(p,"delta="+QString::number(delta.x())+","+QString::number(delta.y()));

  m_viewer->scroll(m_lastPos - pos);

}

void PanTool::release(int row, int col, QMouseEvent *e) {

  // QToolTip::hideText();

}

//=============================================================================

ScrollArea::ScrollArea(QWidget *parent, Qt::WindowFlags flags)

    : QScrollArea(parent) {

  setFrameStyle(QFrame::Panel | QFrame::Raised);

  setLineWidth(6);

  setContentsMargins(10, 10, 10, 10);

}

ScrollArea::~ScrollArea() {}

void ScrollArea::keyPressEvent(QKeyEvent *e) { e->ignore(); }

void ScrollArea::wheelEvent(QWheelEvent *e) { e->ignore(); }

//=============================================================================

GenericPanel::GenericPanel(SpreadsheetViewer *viewer)

    : QWidget(viewer), m_viewer(viewer), m_dragTool(0) {

  setFocusPolicy(Qt::NoFocus);

}

GenericPanel::~GenericPanel() {}

void GenericPanel::paintEvent(QPaintEvent *e) {

  QPainter p(this);

  p.setPen(m_viewer->getLightLineColor());

  for (int c = 0;; c++) {

    int x = getViewer()->columnToX(c);

    if (x > width()) break;

    p.drawLine(x, 0, x, height());

  }

  for (int r = 0;; r++) {

    int y = getViewer()->rowToY(r);

    if (y > height()) break;

    p.drawLine(0, y, width(), y);

  }

  p.setPen(Qt::magenta);

  p.drawLine(e->rect().topLeft(), e->rect().bottomRight());

}

void GenericPanel::mousePressEvent(QMouseEvent *e) {

  assert(!m_dragTool);

  if (e->button() == Qt::MiddleButton)

    m_dragTool = new PanTool(this);

  else

    m_dragTool = createDragTool(e);

  CellPosition cellPosition = getViewer()->xyToPosition(e->pos());

  int row                   = cellPosition.frame();

  int col                   = cellPosition.layer();

  if (m_dragTool) m_dragTool->click(row, col, e);

}

void GenericPanel::mouseReleaseEvent(QMouseEvent *e) {

  CellPosition cellPosition = getViewer()->xyToPosition(e->pos());

  int row                   = cellPosition.frame();

  int col                   = cellPosition.layer();

  m_viewer->stopAutoPan();

  if (m_dragTool) {

    m_dragTool->release(row, col, e);

    delete m_dragTool;

    m_dragTool = 0;

  }

}

void GenericPanel::mouseMoveEvent(QMouseEvent *e) {

  CellPosition cellPosition = getViewer()->xyToPosition(e->pos());

  int row                   = cellPosition.frame();

  int col                   = cellPosition.layer();

  if (e->buttons() != 0 && m_dragTool != 0) {

    if ((e->buttons() & Qt::LeftButton) != 0 &&

        !visibleRegion().contains(e->pos())) {

      QRect bounds = visibleRegion().boundingRect();

      m_viewer->setAutoPanSpeed(bounds, e->pos());

    } else

      m_viewer->stopAutoPan();

    m_dragTool->drag(row, col, e);

  }

}

//=============================================================================

RowPanel::RowPanel(SpreadsheetViewer *viewer)

    : GenericPanel(viewer), m_xa(12) {}

//-----------------------------------------------------------------------------

DragTool *RowPanel::createDragTool(QMouseEvent *) {

  TFrameHandle *frameHandle = getViewer()->getFrameHandle();

  if (frameHandle)

    return new SetFrameDragTool(frameHandle);

  else

    return 0;

}

//-----------------------------------------------------------------------------

void RowPanel::drawRows(QPainter &p, int r0, int r1) {

  QString fontName = Preferences::instance()->getInterfaceFont();

  if (fontName == "") {

#ifdef _WIN32

    fontName = "Arial";

#else

    fontName = "Helvetica";

#endif

  }

  static QFont font(fontName, -1, QFont::Bold);

  font.setPixelSize(12);

  p.setFont(font);

  QRect visibleRect = visibleRegion().boundingRect();

  int x0            = visibleRect.left();

  int x1            = visibleRect.right();

  int y0            = visibleRect.top();

  int y1            = visibleRect.bottom();

  bool simpleView = getViewer()->getFrameZoomFactor() <=

                    Orientations::topToBottom()->dimension(

                        PredefinedDimension::SCALE_THRESHOLD);

  int currentRow = getViewer()->getCurrentRow();

  int r;

  int y = getViewer()->rowToY(r0);

  for (r = r0; r <= r1; r++) {

    int next_y = getViewer()->rowToY(r + 1);

    // draw horizontal line

    bool isMarkSecRow = getViewer()->isMarkSecRow(r);

    bool isMarkRow    = getViewer()->isMarkRow(r);

    QColor color      = (isMarkSecRow) ? getViewer()->getSecMarkerLineColor()

                        : (isMarkRow)  ? getViewer()->getMarkerLineColor()

                                       : getViewer()->getLightLineColor();

    p.setPen(QPen(color,

                  (isMarkSecRow)                                    ? 3.

                  : (getViewer()->isSecMarkerActive() && isMarkRow) ? 2.

                                                                    : 1.,

                  Qt::SolidLine, Qt::FlatCap));

    p.drawLine(x0, y, x1, y);

    if (simpleView && r > 0 && !getViewer()->isMarkRow(r + 1)) {

      y = next_y;

      continue;

    }

    // draw numbers

    p.setPen((r == currentRow) ? getViewer()->getCurrentRowTextColor()

                               : getViewer()->getTextColor());

    QString number = QString::number(r + 1);

    p.drawText(QRect(x0, y + 1, width() - 4, next_y - y - 1),

               Qt::AlignVCenter | Qt::AlignRight, number);

    y = next_y;

  }

}

//-----------------------------------------------------------------------------

void RowPanel::drawCurrentRowGadget(QPainter &p, int r0, int r1) {

  int currentRow = getViewer()->getCurrentRow();

  // int y          = getViewer()->rowToY(currentRow);

  if (currentRow < r0 || r1 < currentRow) return;

  int top    = getViewer()->rowToY(currentRow);

  int bottom = getViewer()->rowToY(currentRow + 1) - 1;

  QRect rect(1, top, width() - 1, bottom - top);

  p.fillRect(rect, getViewer()->getCurrentRowBgColor());

}

//-----------------------------------------------------------------------------

void RowPanel::paintEvent(QPaintEvent *e) {

  QRect toBeUpdated = e->rect();

  QPainter p(this);

  CellRange visible = getViewer()->xyRectToRange(toBeUpdated);

  // range of visible rows

  int r0 = visible.from().frame();

  int r1 = visible.to().frame();

  p.setClipRect(toBeUpdated);

  p.fillRect(toBeUpdated, QBrush(getViewer()->getLightLightBGColor()));

  drawCurrentRowGadget(p, r0, r1);

  drawRows(p, r0, r1);

}

//=============================================================================

ColumnPanel::ColumnPanel(SpreadsheetViewer *viewer) : GenericPanel(viewer) {}

//=============================================================================

CellPanel::CellPanel(SpreadsheetViewer *viewer) : GenericPanel(viewer) {}

DragTool *CellPanel::createDragTool(QMouseEvent *) {

  // FunctionSheetCellViewer::createDragTool is called instead

  // when clicking on the CellPanel in NumericalColumns

  return new SelectionDragTool(getViewer());

}

void CellPanel::paintEvent(QPaintEvent *e) {

  QPainter painter(this);

  QRect toBeUpdated = e->rect();

  painter.setClipRect(toBeUpdated);

  int x0 = toBeUpdated.left() - 1;

  int y0 = toBeUpdated.top();

  int x1 = toBeUpdated.right(), y1 = toBeUpdated.bottom();

  QRect alteredRect(QPoint(x0, y0), QPoint(x1, y1));

  CellRange cellRange = getViewer()->xyRectToRange(alteredRect);

  // visible rows range

  int r0 = cellRange.from().frame();

  int r1 = cellRange.to().frame();

  // visible columns range

  int c0 = cellRange.from().layer();

  int c1 = cellRange.to().layer();

  // cambia colore alle celle prima di rowCount()

  int rowCount = getViewer()->getRowCount();

  // fill with bg color

  painter.fillRect(toBeUpdated, getViewer()->getLightLightBGColor());

  // scene range bg

  int yLast = getViewer()->rowToY(rowCount);

  if (yLast < y1)

    painter.fillRect(x0, y0, x1 - x0, yLast - y0, getViewer()->getBGColor());

  else

    painter.fillRect(toBeUpdated, getViewer()->getBGColor());

  // draw cells

  drawCells(painter, r0, c0, r1, c1);

  // draw columns

  painter.setPen(getViewer()->getVerticalLineColor());

  for (int col = c0; col <= c1; col++) {

    int x = getViewer()->columnToX(col);

    painter.drawLine(x, y0, x, y1);

  }

  // draw rows

  int currentRow = getViewer()->getCurrentRow();

  for (int r = r0; r <= r1; r++) {

    int y             = getViewer()->rowToY(r);

    bool isMarkSecRow = getViewer()->isMarkSecRow(r);

    bool isMarkRow    = getViewer()->isMarkRow(r);

    QColor color      = (isMarkSecRow) ? getViewer()->getSecMarkerLineColor()

                        : (isMarkRow)  ? getViewer()->getMarkerLineColor()

                                       : getViewer()->getLightLineColor();

    painter.setPen(QPen(color,

                        (isMarkSecRow)                                    ? 3.

                        : (getViewer()->isSecMarkerActive() && isMarkRow) ? 2.

                                                                          : 1.,

                        Qt::SolidLine, Qt::FlatCap));

    painter.drawLine(x0, y, x1, y);

  }

}

}  // namespace Spreadsheet

//=============================================================================

SpreadsheetViewer::SpreadsheetViewer(QWidget *parent)

    : QDialog(parent)

    , m_columnScrollArea(0)

    , m_rowScrollArea(0)

    , m_cellScrollArea(0)

    , m_frameHandle(0)

    , m_columnWidth(50)

    , m_rowHeight(20)

    , m_scaleFactor(100)

    , m_timerId(0)

    , m_autoPanSpeed(0, 0)

    , m_lastAutoPanPos(0, 0)

    , m_rowCount(0)

    , m_columnCount(0)

    , m_currentRow(0)

    , m_markRowDistance(6)

    , m_markRowOffset(0)

    , m_markSecRowDistance(-1)

    , m_isComputingSize(false)

    , m_frameScroller() {

  // m_orientation = Orientations::topToBottom ();

  setFocusPolicy(Qt::NoFocus);

  // setFrameStyle(QFrame::StyledPanel);

  setObjectName("Viewer");

  // column header

  m_columnScrollArea = new Spreadsheet::ScrollArea;

  m_columnScrollArea->setObjectName("ScrollColumnArea");

  m_columnScrollArea->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);

  m_columnScrollArea->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);

  m_columnScrollArea->setFocusPolicy(Qt::NoFocus);

  // row area

  m_rowScrollArea = new Spreadsheet::ScrollArea;

  m_rowScrollArea->setObjectName("ScrollRowArea");

  m_rowScrollArea->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);

  m_rowScrollArea->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);

  m_rowScrollArea->setFocusPolicy(Qt::NoFocus);

  // cell area

  m_cellScrollArea = new Spreadsheet::ScrollArea;

  m_cellScrollArea->setObjectName("ScrollCellArea");

  m_cellScrollArea->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOn);

  m_cellScrollArea->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOn);

  // m_cellScrollArea->horizontalScrollBar()->setObjectName("XsheetScrollBar");

  // m_cellScrollArea->verticalScrollBar()->setObjectName("XsheetScrollBar");

  m_cellScrollArea->setFocusPolicy(Qt::NoFocus);

  m_columnScrollArea->setSizePolicy(

      QSizePolicy(QSizePolicy::Ignored, QSizePolicy::Fixed));

  m_rowScrollArea->setSizePolicy(

      QSizePolicy(QSizePolicy::Fixed, QSizePolicy::Ignored));

  m_rowScrollArea->setFixedWidth(30);

  if (Preferences::instance()->getLoadedXsheetLayout() == QString("Minimum") &&

      !Preferences::instance()->isShowXSheetToolbarEnabled() &&

      Preferences::instance()->isExpandFunctionHeaderEnabled() &&

      Preferences::instance()->getFunctionEditorToggle() !=

          Preferences::FunctionEditorToggle::ShowFunctionSpreadsheetInPopup)

    m_columnScrollArea->setFixedHeight(m_rowHeight * 2 - 4);

  else

    m_columnScrollArea->setFixedHeight(m_rowHeight * 3 - 4);

  m_frameScroller.setFrameScrollArea(m_cellScrollArea);

  connect(&m_frameScroller, &Spreadsheet::FrameScroller::prepareToScrollOffset,

          this, &SpreadsheetViewer::onPrepareToScrollOffset);

  connect(&m_frameScroller, &Spreadsheet::FrameScroller::zoomScrollAdjust, this,

          &SpreadsheetViewer::onZoomScrollAdjust);

  //---- layout

  QGridLayout *layout = new QGridLayout();

  layout->setMargin(0);

  layout->setSpacing(0);

  {

    layout->addWidget(m_columnScrollArea, 0, 1);

    layout->addWidget(m_rowScrollArea, 1, 0);

    layout->addWidget(m_cellScrollArea, 1, 1, 2, 2);

    int scrollBarWidth = 16;

    // upper-right

    QWidget *w = new QWidget(this);

    w->setFixedWidth(scrollBarWidth);

    w->setFixedHeight(m_columnScrollArea->height());

    layout->addWidget(w, 0, 2);

    // lower-left

    w = new QWidget(this);

    w->setFixedSize(QSize(30, scrollBarWidth));

    layout->addWidget(w, 2, 0);

    layout->setColumnStretch(0, 0);

    layout->setColumnStretch(1, 1);

    layout->setColumnStretch(2, 0);

    layout->setRowStretch(0, 0);

    layout->setRowStretch(1, 1);

    layout->setRowStretch(2, 0);

  }

  setLayout(layout);

  //---signal-slot connections

  // vertical slider: cell <=> row

  connect(m_rowScrollArea->verticalScrollBar(), SIGNAL(valueChanged(int)),

          m_cellScrollArea->verticalScrollBar(), SLOT(setValue(int)));

  connect(m_cellScrollArea->verticalScrollBar(), SIGNAL(valueChanged(int)),

          m_rowScrollArea->verticalScrollBar(), SLOT(setValue(int)));

  // horizontal slider: cell <=> column

  connect(m_columnScrollArea->horizontalScrollBar(), SIGNAL(valueChanged(int)),

          m_cellScrollArea->horizontalScrollBar(), SLOT(setValue(int)));

  connect(m_cellScrollArea->horizontalScrollBar(), SIGNAL(valueChanged(int)),

          m_columnScrollArea->horizontalScrollBar(), SLOT(setValue(int)));

  connect(m_cellScrollArea->verticalScrollBar(), SIGNAL(valueChanged(int)),

          SLOT(onVSliderChanged(int)));

  connect(m_cellScrollArea->horizontalScrollBar(), SIGNAL(valueChanged(int)),

          SLOT(onHSliderChanged(int)));

}

SpreadsheetViewer::~SpreadsheetViewer() {}

void SpreadsheetViewer::setFrameHandle(TFrameHandle *frameHandle) {

  if (m_frameHandle == frameHandle) return;

  if (m_frameHandle) m_frameHandle->disconnect(this);

  m_frameHandle = frameHandle;

  if (isVisible() && m_frameHandle) {

    connect(m_frameHandle, SIGNAL(frameSwitched()), this,

            SLOT(onFrameSwitched()));

    update();

  }

}

void SpreadsheetViewer::setRowsPanel(Spreadsheet::RowPanel *rows) {

  m_rowScrollArea->setWidget(rows);

}

void SpreadsheetViewer::setColumnsPanel(Spreadsheet::ColumnPanel *columns) {

  m_columnScrollArea->setWidget(columns);

  // columns->setFixedHeight(200);

}

void SpreadsheetViewer::setCellsPanel(Spreadsheet::CellPanel *cells) {

  m_cellScrollArea->setWidget(cells);

}

void SpreadsheetViewer::setButtonAreaWidget(QWidget *widget) {

  QGridLayout *lay = dynamic_cast<qgridlayout *="">(layout());</qgridlayout>

  lay->addWidget(widget, 0, 0);

}

void SpreadsheetViewer::setRowCount(int rowCount) {

  if (m_rowCount != rowCount) {

    m_rowCount = rowCount;

    refreshContentSize(0, 0);

  }

}

void SpreadsheetViewer::setColumnCount(int columnCount) {

  if (m_columnCount != columnCount) {

    m_columnCount = columnCount;

    refreshContentSize(0, 0);

  }

}

void SpreadsheetViewer::scroll(QPoint delta) {

  int x = delta.x();

  int y = delta.y();

  QScrollBar *hSc = m_cellScrollArea->horizontalScrollBar();

  QScrollBar *vSc = m_cellScrollArea->verticalScrollBar();

  int valueH    = hSc->value() + x;

  int valueV    = vSc->value() + y;

  int maxValueH = hSc->maximum();

  int maxValueV = vSc->maximum();

  bool notUpdateSizeH = maxValueH > valueH && x >= 0;

  bool notUpdateSizeV = maxValueV > valueV && y >= 0;

  if ((!notUpdateSizeH) && (!notUpdateSizeV))

    refreshContentSize(x, y);

  else if (notUpdateSizeH && !notUpdateSizeV)

    refreshContentSize(0, y);

  else if (!notUpdateSizeH && notUpdateSizeV)

    refreshContentSize(x, 0);

  // Recheck in case refreshContentSize changed the max

  if (!notUpdateSizeH) maxValueH = hSc->maximum();

  if (!notUpdateSizeV) maxValueV = vSc->maximum();

  if (valueH > maxValueH && x > 0) valueH = hSc->maximum();

  if (valueV > maxValueV && y > 0) valueV = vSc->maximum();

  hSc->setValue(valueH);

  vSc->setValue(valueV);

}

void SpreadsheetViewer::onPrepareToScrollOffset(const QPointF &offset) {

  refreshContentSize((int)offset.x(), (int)offset.y());

}

void SpreadsheetViewer::onZoomScrollAdjust(QPointF &offset, bool toZoom) {

  double frameZoomFactor = (double)getFrameZoomFactor();

  // toZoom = true: Adjust standardized offset down to zoom factor

  // toZoom = false: Adjust zoomed offset up to standardized offset

  double newY;

  if (toZoom)

    newY = (offset.y() * frameZoomFactor) / 100.0;

  else

    newY = (offset.y() * 100.0) / frameZoomFactor;

  offset.setY(newY);

}

void SpreadsheetViewer::setAutoPanSpeed(const QPoint &speed) {

  bool wasAutoPanning = isAutoPanning();

  m_autoPanSpeed      = speed;

  if (isAutoPanning() && !wasAutoPanning && m_timerId == 0)

    m_timerId = startTimer(40);

  else if (!isAutoPanning() && wasAutoPanning && m_timerId != 0) {

    killTimer(m_timerId);

    m_timerId = 0;

  }

}

//-----------------------------------------------------------------------------

static int getAutoPanSpeed(int pixels) {

  int f = 40;

  return std::min(100, (f - 1 + pixels * f) / 100);

}

//-----------------------------------------------------------------------------

void SpreadsheetViewer::setAutoPanSpeed(const QRect &widgetBounds,

                                        const QPoint &mousePos) {

  QPoint speed;

  int limit = 100, factor = 30;

  if (mousePos.x() < widgetBounds.left())

    speed.setX(-getAutoPanSpeed(widgetBounds.left() - mousePos.x()));

  else if (mousePos.x() > widgetBounds.right())

    speed.setX(getAutoPanSpeed(mousePos.x() - widgetBounds.right()));

  if (mousePos.y() < widgetBounds.top())

    speed.setY(-getAutoPanSpeed(widgetBounds.top() - mousePos.y()));

  else if (mousePos.y() > widgetBounds.bottom())

    speed.setY(getAutoPanSpeed(mousePos.y() - widgetBounds.bottom()));

  setAutoPanSpeed(speed);

  m_lastAutoPanPos = mousePos;

}

int SpreadsheetViewer::xToColumn(int x) const {

  CellPosition pos = xyToPosition(QPoint(x, 0));

  return pos.layer();

}

int SpreadsheetViewer::yToRow(int y) const {

  CellPosition pos = xyToPosition(QPoint(0, y));

  return pos.frame();

}

int SpreadsheetViewer::columnToX(int col) const {

  QPoint xy = positionToXY(CellPosition(0, col));

  return xy.x();

}

int SpreadsheetViewer::rowToY(int row) const {

  QPoint xy = positionToXY(CellPosition(row, 0));

  return xy.y();

}

/*!Shift is a consequence of style sheet border.*/

CellPosition SpreadsheetViewer::xyToPosition(const QPoint &point) const {

  int row = (point.y() * 100 / m_scaleFactor) / m_rowHeight;

  int col = (point.x()) / m_columnWidth;

  return CellPosition(row, col);

}

/*!Shift is a consequence of style sheet border.*/

QPoint SpreadsheetViewer::positionToXY(const CellPosition &pos) const {

  int x = (pos.layer() * m_columnWidth);

  int y = pos.frame() * m_rowHeight * m_scaleFactor / 100;

  // int y = (pos.frame() * m_rowHeight * m_scaleFactor / 100) - 1;

  return QPoint(x, y);

}

CellRange SpreadsheetViewer::xyRectToRange(const QRect &rect) const {

  CellPosition topLeft     = xyToPosition(rect.topLeft());

  CellPosition bottomRight = xyToPosition(rect.bottomRight());

  return CellRange(topLeft, bottomRight);

}

bool SpreadsheetViewer::refreshContentSize(int scrollDx, int scrollDy) {

  QSize viewportSize = m_cellScrollArea->viewport()->size();

  QPoint offset      = m_cellScrollArea->widget()->pos();

  offset             = QPoint(std::min(0, offset.x() - scrollDx),

                              std::min(0, offset.y() - scrollDy));

  QSize contentSize(columnToX(m_columnCount + 1), rowToY(m_rowCount + 1));

  QSize actualSize(contentSize);

  int x = viewportSize.width() - offset.x();

  int y = viewportSize.height() - offset.y();

  if (x > actualSize.width()) actualSize.setWidth(x);

  if (y > actualSize.height()) actualSize.setHeight(y);

  if (actualSize == m_cellScrollArea->widget()->size())

    return false;

  else {

    m_isComputingSize = true;

    m_cellScrollArea->widget()->setFixedSize(actualSize);

    m_rowScrollArea->widget()->setFixedSize(

        m_rowScrollArea->viewport()->width(), actualSize.height());

    m_columnScrollArea->widget()->setFixedSize(

        actualSize.width(), m_columnScrollArea->viewport()->height());

    m_isComputingSize = false;

    return true;

  }

}

void SpreadsheetViewer::showEvent(QShowEvent *) {

  int viewportHeight = m_cellScrollArea->height();

  int contentHeight  = rowToY(m_rowCount * 0 + 50);

  QScrollBar *vSc    = m_cellScrollArea->verticalScrollBar();

  int actualContentHeight =

      std::max(contentHeight, vSc->value() + viewportHeight);

  m_rowScrollArea->widget()->setFixedSize(m_rowScrollArea->viewport()->width(),

                                          actualContentHeight);

  m_cellScrollArea->widget()->setFixedHeight(actualContentHeight);

  if (m_frameHandle)

    connect(m_frameHandle, SIGNAL(frameSwitched()), this,

            SLOT(onFrameSwitched()));

  // updateAreasSize();

}

void SpreadsheetViewer::hideEvent(QHideEvent *) {

  if (m_frameHandle) m_frameHandle->disconnect(this);

}

void SpreadsheetViewer::resizeEvent(QResizeEvent *e) {

  QDialog::resizeEvent(e);

  refreshContentSize(0, 0);

  /*

  int w = width();

  int h = height();

int hSpacing = 4;

int vSpacing = 4;

int x = m_rowScrollAreaWidth + hSpacing;

int y = m_columnScrollAreaHeight + vSpacing;

  m_cellScrollArea->setGeometry(x,y, w-x, h-y);

int sh = m_cellScrollArea->horizontalScrollBar()->height();

int sw = m_cellScrollArea->verticalScrollBar()->width();

  m_columnScrollArea->setGeometry(x, 0, w-x-sw, m_columnScrollAreaHeight);

m_rowScrollArea->setGeometry(0, y, m_rowScrollAreaWidth, h-y-sh);

updateSizeToScroll(0,0); //Non updateAreeSize() perche' si deve tener conto

degli scrollbar.