/// <summary> /// Adds a new SharedStringItem and returns its index that is used as cell value /// </summary> /// <param name="item"></param> /// <returns></returns> public int AddSharedStringItem(SpreadsheetSharedStringItem item) { var existingItem = _sharedStringItems.FindIndex(i => i.Text == item.Text); if (existingItem != -1) { return(existingItem); } _sharedStringItems.Add(item); return(_sharedStringItems.Count - 1); }
public void ChangeSharedStringItem(int itemIndex, SpreadsheetSharedStringItem newValue) { _sharedStringItems[itemIndex] = newValue; }