title: OpenXML Spreadsheet- Preserve space before or after the value when writing a cell value
body: <p>I am using OPENXML SDK 2.0 to stream the spread sheet file. The source data is come from data table and writing this to Spreadsheet using openxml. If there is a one of the column data of a data table has <strong>"      Treshold%"</strong> (this text has tab space on it preceding) and the same being written excel but which is writing it to <strong>"Treshold%"</strong> in excel cell and removing the tab space.</p>
  
  <p>I am using the code as below. Using <code>workSheetWriter.PasteText</code> and <code>workSheetWriter.PasteValue</code> methods.</p>
  
  <pre class="lang-cs prettyprint-override"><code>WorksheetWriter workSheetWriter = new WorksheetWriter(spreadSheet, workSheet);
  
  int intValue = 0;
  if (strValue.Contains("$"))
  {
      strValue = strValue.Replace("$", "");
      strValue = strValue.Replace(",", "");
  
      workSheetWriter.PasteValue(cellLocation, strValue, CellValues.Number);
  }
  else if (int.TryParse(strValue, out intValue))
  {
      workSheetWriter.PasteValue(cellLocation, strValue, CellValues.Number);
  }
  else if (string.IsNullOrEmpty(strValue))
  {
      workSheetWriter.PasteText(cellLocation, strValue);
  }
  else
  {
      workSheetWriter.PasteText(cellLocation, strValue);
  }
  </code></pre>
  
  <p>Please help on this. How can write the value which a tab space in the begining (    Treshold%) into excel cell as same format ?</p>