/* ==================================================================== Licensed to the Apache Software Foundation (ASF) Under one or more contributor license agreements. See the NOTICE file distributed with this work for Additional information regarding copyright ownership. The ASF licenses this file to You Under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed Under the License is distributed on an "AS Is" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations Under the License. ==================================================================== */ namespace HH.WMS.Utils.NPOI.HSSF.EventUserModel { using System; using System.Collections; using HH.WMS.Utils.NPOI.HSSF.Record; using HH.WMS.Utils.NPOI.HSSF.UserModel; using System.Collections.Generic; using HH.WMS.Utils.NPOI.SS.UserModel; using System.Globalization; /** * A proxy HSSFListener that keeps track of the document * formatting records, and provides an easy way to look * up the format strings used by cells from their ids. */ public class FormatTrackingHSSFListener : HSSFListener { private HSSFListener childListener; private Dictionary customFormatRecords = new Dictionary(); private DataFormatter formatter = new DataFormatter(); private List xfRecords = new List(); public FormatTrackingHSSFListener(HSSFListener childListener) { this.childListener = childListener; } public int NumberOfCustomFormats { get { return customFormatRecords.Count; } } public int NumberOfExtendedFormats { get { return xfRecords.Count; } } /** * Process this record ourselves, and then * pass it on to our child listener */ public void ProcessRecord(Record record) { // Handle it ourselves ProcessRecordInternally(record); // Now pass on to our child childListener.ProcessRecord(record); } /** * Process the record ourselves, but do not * pass it on to the child Listener. * @param record */ public void ProcessRecordInternally(Record record) { if (record is FormatRecord) { FormatRecord fr = (FormatRecord)record; customFormatRecords[fr.IndexCode] = fr; } else if (record is ExtendedFormatRecord) { ExtendedFormatRecord xr = (ExtendedFormatRecord)record; xfRecords.Add(xr); } } /** * Formats the given numeric of date Cell's contents * as a String, in as close as we can to the way * that Excel would do so. * Uses the various format records to manage this. * * TODO - move this to a central class in such a * way that hssf.usermodel can make use of it too */ public String FormatNumberDateCell(CellValueRecordInterface cell) { double value; if (cell is NumberRecord) { value = ((NumberRecord)cell).Value; } else if (cell is FormulaRecord) { value = ((FormulaRecord)cell).Value; } else { throw new ArgumentException("Unsupported CellValue Record passed in " + cell); } // Get the built in format, if there is one int formatIndex = GetFormatIndex(cell); String formatString = GetFormatString(cell); if (formatString == null) { return value.ToString(CultureInfo.InvariantCulture); } else { // Format, using the nice new // HSSFDataFormatter to do the work for us return formatter.FormatRawCellContents(value, formatIndex, formatString); } } /** * Returns the format string, eg $##.##, for the * given number format index. */ public String GetFormatString(int formatIndex) { String format = null; if (formatIndex >= HSSFDataFormat.NumberOfBuiltinBuiltinFormats) { FormatRecord tfr = (FormatRecord)customFormatRecords[formatIndex]; if (tfr == null) { Console.Error.WriteLine("Requested format at index " + formatIndex + ", but it wasn't found"); } else { format = tfr.FormatString; } } else { format = HSSFDataFormat.GetBuiltinFormat((short)formatIndex); } return format; } /** * Returns the format string, eg $##.##, used * by your cell */ public String GetFormatString(CellValueRecordInterface cell) { int formatIndex = GetFormatIndex(cell); if (formatIndex == -1) { // Not found return null; } return GetFormatString(formatIndex); } /** * Returns the index of the format string, used by your cell, * or -1 if none found */ public int GetFormatIndex(CellValueRecordInterface cell) { ExtendedFormatRecord xfr = (ExtendedFormatRecord) xfRecords[cell.XFIndex]; if (xfr == null) { Console.Error.WriteLine("Cell " + cell.Row + "," + cell.Column + " uses XF with index " + cell.XFIndex + ", but we don't have that"); return -1; } return xfr.FormatIndex; } } }