Shortener.cs

/*
 * NanoXLSX is a small .NET library to generate and read XLSX (Microsoft Excel 2007 or newer) files in an easy and native way
 * Copyright Raphael Stoeckli © 2025
 * This library is licensed under the MIT License.
 * You find a copy of the license in project folder or on: http://opensource.org/licenses/MIT
 */
 
using NanoXLSX.Exceptions;
using NanoXLSX.Styles;
 
namespace NanoXLSX
{
    public class Shortener
    {
        private Worksheet currentWorksheet;
        private readonly Workbook workbookReference;

        public Shortener(Workbook reference)
        {
            this.workbookReference = reference;
            this.currentWorksheet = reference.CurrentWorksheet;
        }

        public void SetCurrentWorksheet(Worksheet worksheet)
        {
            workbookReference.SetCurrentWorksheet(worksheet);
            currentWorksheet = worksheet;
        }

        internal void SetCurrentWorksheetInternal(Worksheet worksheet)
        {
            currentWorksheet = worksheet;
        }

        public void Value(object cellValue)
        {
            NullCheck();
            currentWorksheet.AddNextCell(cellValue);
        }

        public void Value(object cellValue, Style style)
        {
            NullCheck();
            currentWorksheet.AddNextCell(cellValue, style);
        }

        public void Formula(string cellFormula)
        {
            NullCheck();
            currentWorksheet.AddNextCellFormula(cellFormula);
        }

        public void Formula(string cellFormula, Style style)
        {
            NullCheck();
            currentWorksheet.AddNextCellFormula(cellFormula, style);
        }

        public void Down()
        {
            NullCheck();
            currentWorksheet.GoToNextRow();
        }

        public void Down(int numberOfRows, bool keepColumnPosition = false)
        {
            NullCheck();
            currentWorksheet.GoToNextRow(numberOfRows, keepColumnPosition);
        }

        public void Up()
        {
            NullCheck();
            currentWorksheet.GoToNextRow(-1);
        }

        public void Up(int numberOfRows, bool keepColumnPosition = false)
        {
            NullCheck();
            currentWorksheet.GoToNextRow(-1 * numberOfRows, keepColumnPosition);
        }

        public void Right()
        {
            NullCheck();
            currentWorksheet.GoToNextColumn();
        }

        public void Right(int numberOfColumns, bool keepRowPosition = false)
        {
            NullCheck();
            currentWorksheet.GoToNextColumn(numberOfColumns, keepRowPosition);
        }

        public void Left()
        {
            NullCheck();
            currentWorksheet.GoToNextColumn(-1);
        }

        public void Left(int numberOfColumns, bool keepRowRowPosition = false)
        {
            NullCheck();
            currentWorksheet.GoToNextColumn(-1 * numberOfColumns, keepRowRowPosition);
        }

        private void NullCheck()
        {
            if (currentWorksheet == null)
            {
                throw new WorksheetException("No worksheet was defined");
            }
        }
 
 
    }
}