C++ (Cpp) cell_reference Examples

Example #1

File: cell_reference.cpp Project: Polymedia/xlnt

cell_reference cell_reference::make_offset(int column_offset, int row_offset) const
{
    // TODO: check for overflow/underflow
    auto relative_column = static_cast<column_t::index_t>(static_cast<int>(column_.index) + column_offset);
    auto relative_row = static_cast<row_t>(static_cast<int>(row_) + row_offset);
    return cell_reference(relative_column, relative_row);
}

Example #2

File: worksheet.cpp Project: lyntel/xlnt

void worksheet::append(const std::unordered_map<int, std::string> &cells)
{
    auto row = get_next_row();

    for (auto cell : cells)
    {
        get_cell(cell_reference(static_cast<column_t>(cell.first), row)).set_value(cell.second);
    }
}

Example #3

File: worksheet.cpp Project: lyntel/xlnt

void worksheet::append(const std::unordered_map<std::string, std::string> &cells)
{
    auto row = get_next_row();

    for (auto cell : cells)
    {
        get_cell(cell_reference(cell.first, row)).set_value(cell.second);
    }
}

Example #4

File: worksheet.cpp Project: tfussell/xlnt

void worksheet::freeze_panes(const cell_reference &ref)
{
    if (ref == "A1")
    {
        unfreeze_panes();
        return;
    }
    if (!has_view())
    {
        d_->views_.push_back(sheet_view());
    }

    auto &primary_view = d_->views_.front();
    if (!primary_view.has_pane())
    {
        primary_view.pane(pane());
    }

    primary_view.pane().top_left_cell = ref;
    primary_view.pane().state = pane_state::frozen;

    primary_view.clear_selections();
    if (ref.column() == "A") // no column is frozen
    {
        primary_view.add_selection(selection(pane_corner::bottom_left, ref));
        primary_view.pane().active_pane = pane_corner::bottom_left;
        primary_view.pane().y_split = ref.row() - 1;
    }
    else if (ref.row() == 1) // no row is frozen
    {
        primary_view.add_selection(selection(pane_corner::top_right, ref));
        primary_view.pane().active_pane = pane_corner::top_right;
        primary_view.pane().x_split = ref.column_index() - 1;
    }
    else // column and row is frozen
    {
        primary_view.add_selection(selection(pane_corner::top_right, cell_reference(ref.column(), 1)));
        primary_view.add_selection(selection(pane_corner::bottom_left, cell_reference(1, ref.row())));
        primary_view.add_selection(selection(pane_corner::bottom_right, ref));
        primary_view.pane().active_pane = pane_corner::bottom_right;
        primary_view.pane().x_split = ref.column_index() - 1;
        primary_view.pane().y_split = ref.row() - 1;
    }
}

Example #5

File: cell_reference.cpp Project: AlanIWBFT/xlnt-ue4

cell_reference::cell_reference(const std::string &string)
{
    bool absolute = false;
    auto split = split_reference(string, absolute, absolute);
    *this = cell_reference(split.first, split.second, absolute);
}

Example #6

File: cell_reference.cpp Project: AlanIWBFT/xlnt-ue4

cell_reference cell_reference::make_offset(int column_offset, int row_offset) const
{
    return cell_reference(column_index_ + column_offset, row_index_ + row_offset);
}

Example #7

File: worksheet.cpp Project: lyntel/xlnt

bool worksheet::has_frozen_panes() const
{
    return get_frozen_panes() != cell_reference("A1");
}

Example #8

File: worksheet.cpp Project: lyntel/xlnt

void worksheet::append()
{
    get_cell(cell_reference(1, get_next_row()));
}

Example #9

File: worksheet.cpp Project: lyntel/xlnt

void worksheet::unfreeze_panes()
{
    d_->freeze_panes_ = cell_reference("A1");
}

Example #10

File: worksheet.cpp Project: lyntel/xlnt

void worksheet::freeze_panes(const std::string &top_left_coordinate)
{
    d_->freeze_panes_ = cell_reference(top_left_coordinate);
}

Example #11

File: worksheet.cpp Project: tfussell/xlnt

const cell worksheet::cell(xlnt::column_t column, row_t row) const
{
    return cell(cell_reference(column, row));
}

Example #12

File: cell_reference.cpp Project: lyntel/xlnt

cell_reference cell_reference::make_offset(int column_offset, int row_offset) const
{
    //TODO: check for overflow/underflow
    return cell_reference(static_cast<column_t>(static_cast<int>(column_.index) + column_offset),
                          static_cast<row_t>(static_cast<int>(row_) + row_offset));
}

Example #13

File: cell_reference.cpp Project: lyntel/xlnt

bool cell_reference::operator!=(const std::string &reference_string) const
{
    return *this != cell_reference(reference_string);
}

Example #14

File: cell.cpp Project: fhaoquan/xlnt

cell cell::offset(int column, int row)
{
    return get_parent().get_cell(cell_reference(d_->column_ + column, d_->row_ + row));
}