| /******************************************************************************* |
| * You may amend and distribute as you like, but don't remove this header! |
| * |
| * EPPlus provides server-side generation of Excel 2007/2010 spreadsheets. |
| * See http://www.codeplex.com/EPPlus for details. |
| * |
| * Copyright (C) 2011 Jan Källman |
| * |
| * This library is free software; you can redistribute it and/or |
| * modify it under the terms of the GNU Lesser General Public |
| * License as published by the Free Software Foundation; either |
| * version 2.1 of the License, or (at your option) any later version. |
| |
| * This library is distributed in the hope that it will be useful, |
| * but WITHOUT ANY WARRANTY; without even the implied warranty of |
| * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
| * See the GNU Lesser General Public License for more details. |
| * |
| * The GNU Lesser General Public License can be viewed at http://www.opensource.org/licenses/lgpl-license.php |
| * If you unfamiliar with this license or have questions about it, here is an http://www.gnu.org/licenses/gpl-faq.html |
| * |
| * All code and executables are provided "as is" with no warranty either express or implied. |
| * The author accepts no liability for any damage or loss of business that this product may cause. |
| * |
| * Code change notes: |
| * |
| * Author Change Date |
| * ****************************************************************************** |
| * Mats Alm Added 2015-12-28 |
| *******************************************************************************/ |
| using System.Text.RegularExpressions; |
| using OfficeOpenXml.FormulaParsing.LexicalAnalysis.TokenSeparatorHandlers; |
| |
| namespace OfficeOpenXml.FormulaParsing.LexicalAnalysis { |
| public class TokenHandler : ITokenIndexProvider { |
| public TokenHandler( |
| TokenizerContext context, |
| ITokenFactory tokenFactory, |
| ITokenSeparatorProvider tokenProvider) { |
| _context = context; |
| _tokenFactory = tokenFactory; |
| _tokenProvider = tokenProvider; |
| } |
| |
| private readonly TokenizerContext _context; |
| private readonly ITokenSeparatorProvider _tokenProvider; |
| private readonly ITokenFactory _tokenFactory; |
| private int _tokenIndex = -1; |
| |
| public string Worksheet { get; set; } |
| |
| public bool HasMore() { |
| return _tokenIndex < (_context.FormulaChars.Length - 1); |
| } |
| |
| public void Next() { |
| _tokenIndex++; |
| Handle(); |
| } |
| |
| private void Handle() { |
| var c = _context.FormulaChars[_tokenIndex]; |
| Token tokenSeparator; |
| if (CharIsTokenSeparator(c, out tokenSeparator)) { |
| if (TokenSeparatorHandler.Handle(c, tokenSeparator, _context, this)) { |
| return; |
| } |
| |
| if (_context.CurrentTokenHasValue) { |
| if (Regex.IsMatch(_context.CurrentToken, "^\"*$")) { |
| _context.AddToken(_tokenFactory.Create(_context.CurrentToken, TokenType.StringContent)); |
| } else { |
| _context.AddToken(CreateToken(_context, Worksheet)); |
| } |
| |
| //If the a next token is an opening parantheses and the previous token is interpeted as an address or name, then the currenct token is a function |
| if (tokenSeparator.TokenType == TokenType.OpeningParenthesis |
| && (_context.LastToken.TokenType == TokenType.ExcelAddress |
| || _context.LastToken.TokenType == TokenType.NameValue)) { |
| _context.LastToken.TokenType = TokenType.Function; |
| } |
| } |
| if (tokenSeparator.Value == "-") { |
| if (TokenIsNegator(_context)) { |
| _context.AddToken(new Token("-", TokenType.Negator)); |
| return; |
| } |
| } |
| _context.AddToken(tokenSeparator); |
| _context.NewToken(); |
| return; |
| } |
| _context.AppendToCurrentToken(c); |
| } |
| |
| private bool CharIsTokenSeparator(char c, out Token token) { |
| var result = _tokenProvider.Tokens.ContainsKey(c.ToString()); |
| token = result ? token = _tokenProvider.Tokens[c.ToString()] : null; |
| return result; |
| } |
| |
| private static bool TokenIsNegator(TokenizerContext context) { |
| return TokenIsNegator(context.LastToken); |
| } |
| |
| private static bool TokenIsNegator(Token t) { |
| return t == null |
| || t.TokenType == TokenType.Operator |
| || t.TokenType == TokenType.OpeningParenthesis |
| || t.TokenType == TokenType.Comma |
| || t.TokenType == TokenType.SemiColon |
| || t.TokenType == TokenType.OpeningEnumerable; |
| } |
| |
| private Token CreateToken(TokenizerContext context, string worksheet) { |
| if (context.CurrentToken == "-") { |
| if (context.LastToken == null && context.LastToken.TokenType == TokenType.Operator) { |
| return new Token("-", TokenType.Negator); |
| } |
| } |
| return _tokenFactory.Create(context.Result, context.CurrentToken, worksheet); |
| } |
| |
| int ITokenIndexProvider.Index { |
| get { return _tokenIndex; } |
| } |
| |
| void ITokenIndexProvider.MoveIndexPointerForward() { |
| _tokenIndex++; |
| } |
| } |
| } |