Hoogle Search

Within LTS Haskell 24.34 (ghc-9.10.3)

Note that Stackage only displays results for the latest LTS and Nightly snapshot. Learn more.

Exact lookup

1. formatPivotButton :: Lens' Format (Maybe Bool)

   xlsx	Codec.Xlsx.Formatted

   No documentation available.

2. formatProtection :: Lens' Format (Maybe Protection)

   xlsx	Codec.Xlsx.Formatted

   No documentation available.

3. formatQuotePrefix :: Lens' Format (Maybe Bool)

   xlsx	Codec.Xlsx.Formatted

   No documentation available.

4. formatWorkbook :: [(Text, Map (RowIndex, ColumnIndex) FormattedCell)] -> StyleSheet -> Xlsx

   xlsx	Codec.Xlsx.Formatted

   Build an Xlsx, render provided cells as per the StyleSheet.

5. formatted :: Map (RowIndex, ColumnIndex) FormattedCell -> StyleSheet -> Formatted

   xlsx	Codec.Xlsx.Formatted

   Higher level API for creating formatted documents Creating formatted Excel spreadsheets using the Cell datatype directly, even with the support for the StyleSheet datatype, is fairly painful. This has a number of causes:

   • The Cell datatype wants an Int for the style, which is supposed to point into the _styleSheetCellXfs part of a stylesheet. However, this can be difficult to work with, as it requires manual tracking of cell style IDs, which in turns requires manual tracking of font IDs, border IDs, etc.
   • Row-span and column-span properties are set on the worksheet as a whole (wsMerges) rather than on individual cells.
   • Excel does not correctly deal with borders on cells that span multiple columns or rows. Instead, these rows must be set on all the edge cells in the block. Again, this means that this becomes a global property of the spreadsheet rather than properties of individual cells.
   This function deals with all these problems. Given a map of FormattedCells, which refer directly to Fonts, Borders, etc. (rather than font IDs, border IDs, etc.), and an initial stylesheet, it recovers all possible sharing, constructs IDs, and then constructs the final CellMap, as well as the final stylesheet and list of merges. If you don't already have a StyleSheet you want to use as starting point then minimalStyleSheet is a good choice.

6. formattedCell :: Lens' FormattedCell Cell

   xlsx	Codec.Xlsx.Formatted

   No documentation available.

7. formattedCellMap :: Formatted -> CellMap

   xlsx	Codec.Xlsx.Formatted

   The final CellMap; see _wsCells

8. formattedColSpan :: Lens' FormattedCell Int

   xlsx	Codec.Xlsx.Formatted

   No documentation available.

9. formattedFormat :: Lens' FormattedCell Format

   xlsx	Codec.Xlsx.Formatted

   No documentation available.

10. formattedMerges :: Formatted -> [Range]

    xlsx	Codec.Xlsx.Formatted

    The final list of cell merges; see _wsMerges

Page 128 of many | Previous | Next