zertovitch/excel-writer

Excel Writer: a standalone, portable Ada package for producing Excel spreadsheets

excel-writer's Issues

Check for reaching maximum fonts and number formats

Display results, not formulas

I use excel-writer to produce BIFF2 (or BIFF 3 or BIFF 4) documents which I open with Libreoffice Calc and MS Excel 2013

Currently the formulas are displayed.
This is already very good.

I want the results of the formulas to be displayed.

page 216 - 217
https://www.openoffice.org/sc/excelfileformat.pdf

Record WINDOW2, BIFF 2:
0 = Show formula results 1 = Show formulas

Record WINDOW2, BIFF 3-BIFF 5:
0 = Show formula results 1 = Show formulas
Bits 0 Mask= 0001 0 = Show formula results 1 = Show formulas

In

procedure Write_Window2 is
    begin
      --  5.110 WINDOW2
      case xl.format is
        when BIFF2 =>
          WriteBiff (xl, 16#003E#,
            (0, -- Display formulas, not results
             1, -- Show grid lines
             1, -- Show sheet headers
             Boolean'Pos (xl.frz_panes),
             1  -- Show zero values as zeros, not empty cells
            )
             &
            Intel_16 (0) & -- First visible row
            Intel_16 (0) & -- First visible column
            (1, -- Use automatic grid line colour
             0, 0, 0, 0) -- Grid line RGB colour
          );
        when BIFF3 | BIFF4 =>  --  NB: more options in BIFF8
          WriteBiff (xl, 16#023E#,
            --  http://msdn.microsoft.com/en-us/library/dd947893(v=office.12).aspx
            Intel_16 (   -- Option flags:
              0 *   1 + -- Display formulas, not results
              1 *   2 + -- Show grid lines
              1 *   4 + -- Show sheet headers
              Boolean'Pos (xl.frz_panes)
                *   8 + -- Panes are frozen
              1 *  16 + -- Show zero values as zeros, not empty cells
              1 *  32 + -- Gridlines of the window drawn in the default window foreground color
              0 *  64 + -- Right-to-left mode
              1 * 128 + -- Show outlines (guts ?!)
              0 * 256   -- Frozen, not split
            ) &
            Intel_16 (0) & -- First visible row
            Intel_16 (0) & -- First visible column
            Intel_32 (0)   -- Grid line colour
          );
      end case;
    end Write_Window2;

i try

          WriteBiff (xl, 16#003E#,
            (1, -- Display formulas, not results

I don't get the expected result no (in LibreOffice or MS Excel 2013).
It may be a problem with LibreOffice (which would read BIFF 2 differently than openoffice ?) ...

when Define_format total number exceed 62, execution error occurs.

When I define define_format exceed 44, the execution error occurs.
error message:
"raised CONSTRAINT_ERROR:
excel_out.adb:700 index check failed"