Do you want to request a feature or report a bug?
Did you test against the latest CI build?
In my current xlsx file, I use the ROW() formula to get the number of the row for a particular cell; but, ClosedXML wasn't able to parse the formula. You can find its use here:
https://support.google.com/docs/answer/3093316?hl=en
Version of ClosedXML
0.95.4
What is the current behaviour?
When I try to parse my xlsx file, I get the error Identifier 'ROW' was not recognized which stops me from continuing.
What is the expected behaviour or new feature?
=ROW() should return an integer matching the current row of the cell being parsed, while =ROW(A1), for example, should return 1 and so on.
ReproducibilityCode to reproduce the problem:
public class Example //A basic class to try to parse the data.
{
public string Name { get; set; }
public int ID { get; set; }
}
public void Main() //Try to get the data as normal and the formula will flag.
{
string filePath = System.IO.Path.GetFullPath("ROW_Usage_Example.xlsx");
using (var reader = new ExcelParser(filePath))
{
Console.WriteLine("File found!");
using (var csv = new CsvReader(reader))
{
Console.WriteLine("Beginning parsing...");
var PokeList = csv.GetRecords<Example>().Where(x => !string.IsNullOrWhiteSpace(x.Name)).ToList();
}
}
}
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4