#pragma warning disable CA1822 // Mark members as static
public Cell Cell(object?value, DefaultStyle template, UInt32Value styleIndex)
#pragma warning restore CA1822 // Mark members as static
{
string excelValue = value == null ? "" :
template == DefaultStyle.DateTime ? ExcelExtensions.ToExcelDate(((DateTime)value)) :
template == DefaultStyle.Date ? value is DateTime dt?ExcelExtensions.ToExcelDate(dt) : ExcelExtensions.ToExcelDate(((DateOnly)value).ToDateTime()) :
template == DefaultStyle.Time ? ExcelExtensions.ToExcelTime((TimeOnly)value) :
template == DefaultStyle.Decimal ? ExcelExtensions.ToExcelNumber(Convert.ToDecimal(value)) :
template == DefaultStyle.Boolean ? ToYesNo((bool)value) :
template == DefaultStyle.Enum ? ((Enum)value).NiceToString() :
value.ToString() !;
Cell cell = IsInlineString(template)?
new Cell(new InlineString(new Text {
Text = excelValue
}))
{
DataType = CellValues.InlineString
} :
new Cell {
CellValue = new CellValue(excelValue), DataType = null
};
cell.StyleIndex = styleIndex;
return(cell);
}
public TextSpanDescriptor Span(string?text)
{
var style = DefaultStyle.Clone();
var descriptor = new TextSpanDescriptor(style);
if (text == null)
{
return(descriptor);
}
var items = text
.Replace("\r", string.Empty)
.Split(new[] { '\n' }, StringSplitOptions.None)
.Select(x => new TextBlockSpan
{
Text = x,
Style = style
})
.ToList();
AddItemToLastTextBlock(items.First());
items
.Skip(1)
.Select(x => new TextBlock
{
Items = new List <ITextBlockItem> {
x
}
})
.ToList()
.ForEach(TextBlocks.Add);
return(descriptor);
}
public CODService()
{
Workbook = new HSSFWorkbook();
BoldFont = Workbook.CreateFont();
BoldFont.IsBold = true;
BoldFont.FontName = "Calibri";
BoldFont.FontHeightInPoints = 11;
DefaultFont = Workbook.CreateFont();
DefaultFont.FontName = "Calibri";
DefaultFont.FontHeightInPoints = 11;
HeadStyle = Workbook.CreateCellStyle();
HeadStyle.SetFont(BoldFont);
GreenStyle = Workbook.CreateCellStyle();
GreenStyle.SetFont(DefaultFont);
GreenStyle.FillForegroundColor = HSSFColor.LightGreen.Index;
GreenStyle.FillPattern = FillPattern.BigSpots;
GreenStyle.FillBackgroundColor = HSSFColor.LightGreen.Index;
DefaultStyle = Workbook.CreateCellStyle();
DefaultStyle.SetFont(DefaultFont);
PresentationService = new PresentationService();
JobService = new JobService();
}
public virtual T VisitDefaultStyle(DefaultStyle defaultStyle)
{
foreach (var styleAttr in defaultStyle.StyleAttributes)
{
styleAttr.Accept(this);
}
return(default(T));
}
public void Visit(DefaultStyle defaultStyle)
{
_current = defaultStyle.Type;
foreach (var style in defaultStyle.Styles)
{
style.Accept(this);
}
}
public object Clone()
{
CustomTheme customTheme = new CustomTheme(this._getStyleDelegate);
if (DefaultStyle != null)
{
customTheme.DefaultStyle = (IStyle)DefaultStyle.Clone();
}
return(customTheme);
}
static Cairo.Color[,,,,] CreateColorMatrix(TextEditor editor, bool isError)
{
string typeString = isError ? "error" : "warning";
Cairo.Color[,,,,] colorMatrix = new Cairo.Color[2, 2, 3, 2, 2];
ColorScheme style = editor.ColorStyle;
if (style == null)
{
style = new DefaultStyle(editor.Style);
}
var baseColor = style.GetChunkStyle("bubble." + typeString + "").CairoBackgroundColor;
AdjustColorMatrix(colorMatrix, 0, baseColor);
var hsl = (HslColor)baseColor;
hsl.S *= 0.6;
baseColor = hsl;
AdjustColorMatrix(colorMatrix, 1, hsl);
double factor = 1.03;
for (int i = 0; i < 2; i++)
{
for (int j = 0; j < 2; j++)
{
for (int k = 0; k < 3; k++)
{
HslColor color = colorMatrix [i, j, k, 0, 0];
color.L *= factor;
colorMatrix [i, j, k, 1, 0] = color;
}
}
}
var selectionColor = ColorScheme.ToCairoColor(style.Selection.BackgroundColor);
for (int i = 0; i < 2; i++)
{
for (int j = 0; j < 2; j++)
{
for (int k = 0; k < 3; k++)
{
for (int l = 0; l < 2; l++)
{
var color = colorMatrix [i, j, k, l, 0];
colorMatrix [i, j, k, l, 1] = new Cairo.Color((color.R + selectionColor.R * 1.5) / 2.5, (color.G + selectionColor.G * 1.5) / 2.5, (color.B + selectionColor.B * 1.5) / 2.5);
}
}
}
}
return(colorMatrix);
}
public override object VisitDefaultStyle(DefaultStyle defaultStyle)
{
_currentDataType = defaultStyle.DataType;
foreach (var styleAttr in defaultStyle.StyleAttributes)
{
styleAttr.Accept(this);
}
return null;
}
public override object VisitDefaultStyle(DefaultStyle defaultStyle)
{
_currentDataType = defaultStyle.DataType;
foreach (var styleAttr in defaultStyle.StyleAttributes)
{
styleAttr.Accept(this);
}
return(null);
}
void SetColors ()
{
ColorScheme style = editor.ColorStyle;
if (style == null)
style = new DefaultStyle (editor.Style);
errorGc = (HslColor)(style.GetChunkStyle ("bubble.error").Color);
warningGc = (HslColor)(style.GetChunkStyle ("bubble.warning").Color);
errorMatrix = CreateColorMatrix (editor, true);
warningMatrix = CreateColorMatrix (editor, false);
gcSelected = (HslColor)style.Selection.Color;
gcLight = new Cairo.Color (1, 1, 1);
}
private TextPageNumberDescriptor PageNumber(Func <IPageContext, int?> pageNumber)
{
var style = DefaultStyle.Clone();
var descriptor = new TextPageNumberDescriptor(DefaultStyle);
AddItemToLastTextBlock(new TextBlockPageNumber
{
Source = context => descriptor.FormatFunction(pageNumber(context)),
Style = style
});
return(descriptor);
}
private static bool IsInlineString(DefaultStyle template)
{
return(template switch
{
DefaultStyle.Title or
DefaultStyle.Header or
DefaultStyle.Text or
DefaultStyle.General or
DefaultStyle.Boolean or
DefaultStyle.Enum => true,
DefaultStyle.Date or
DefaultStyle.DateTime or
DefaultStyle.Number or
DefaultStyle.Decimal => false,
_ => throw new InvalidOperationException("Unexpected"),
});
public StyleFactory(IEnumerable <Declaration> declarations)
: this()
{
var copyOfStyle = Style;
foreach (var declaration in declarations)
{
var action = _styleConverters[declaration.Name];
action(ref copyOfStyle, declaration);
}
if (!DefaultStyle.Equals(Style))
{
copyOfStyle.Id = Guid.NewGuid();
}
Style = copyOfStyle;
}
private bool IsInlineString(DefaultStyle template)
{
switch (template)
{
case DefaultStyle.Title:
case DefaultStyle.Header:
case DefaultStyle.Text:
case DefaultStyle.General:
case DefaultStyle.Boolean:
case DefaultStyle.Enum:
return(true);
case DefaultStyle.Date:
case DefaultStyle.DateTime:
case DefaultStyle.Number:
case DefaultStyle.Decimal:
return(false);
default:
throw new InvalidOperationException("Unexpected");
}
}
public TextSpanDescriptor SectionLink(string?text, string sectionName)
{
if (IsNullOrEmpty(sectionName))
{
throw new ArgumentException("Section name cannot be null or empty", nameof(sectionName));
}
var style = DefaultStyle.Clone();
var descriptor = new TextSpanDescriptor(style);
if (IsNullOrEmpty(text))
{
return(descriptor);
}
AddItemToLastTextBlock(new TextBlockSectionlLink
{
Style = style,
Text = text,
SectionName = sectionName
});
return(descriptor);
}
public Cell Cell(object?value, DefaultStyle template, UInt32Value styleIndex)
{
string excelValue = value == null ? "" :
(template == DefaultStyle.Date || template == DefaultStyle.DateTime) ? ExcelExtensions.ToExcelDate(((DateTime)value)) :
(template.ToString().StartsWith("Decimal")) ? ExcelExtensions.ToExcelNumber(Convert.ToDecimal(value)) :
(template == DefaultStyle.Boolean) ? ToYesNo((bool)value) :
(template == DefaultStyle.Enum) ? ((Enum)value).NiceToString() :
value.ToString();
Cell cell = IsInlineString(template)?
new Cell(new InlineString(new Text {
Text = excelValue
}))
{
DataType = CellValues.InlineString
} :
new Cell {
CellValue = new CellValue(excelValue), DataType = null
};
cell.StyleIndex = styleIndex;
return(cell);
}
public TextSpanDescriptor Hyperlink(string?text, string url)
{
if (IsNullOrEmpty(url))
{
throw new ArgumentException("Url cannot be null or empty", nameof(url));
}
var style = DefaultStyle.Clone();
var descriptor = new TextSpanDescriptor(style);
if (IsNullOrEmpty(text))
{
return(descriptor);
}
AddItemToLastTextBlock(new TextBlockHyperlink
{
Style = style,
Text = text,
Url = url
});
return(descriptor);
}
static Cairo.Color[,,,,] CreateColorMatrix(TextEditor editor, bool isError)
{
string typeString = isError ? "error" : "warning";
Cairo.Color[,,,,] colorMatrix = new Cairo.Color[2, 2, 3, 2, 2];
Style style = editor.ColorStyle;
if (style == null)
{
style = new DefaultStyle(editor.Style);
}
colorMatrix [0, 0, 0, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble." + typeString + ".light.color1").Color);
colorMatrix [0, 1, 0, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble." + typeString + ".light.color2").Color);
colorMatrix [0, 0, 1, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble." + typeString + ".dark.color1").Color);
colorMatrix [0, 1, 1, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble." + typeString + ".dark.color2").Color);
colorMatrix [0, 0, 2, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble." + typeString + ".line.top").Color);
colorMatrix [0, 1, 2, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble." + typeString + ".line.bottom").Color);
colorMatrix [1, 0, 0, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble.inactive." + typeString + ".light.color1").Color);
colorMatrix [1, 1, 0, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble.inactive." + typeString + ".light.color2").Color);
colorMatrix [1, 0, 1, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble.inactive." + typeString + ".dark.color1").Color);
colorMatrix [1, 1, 1, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble.inactive." + typeString + ".dark.color2").Color);
colorMatrix [1, 0, 2, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble.inactive." + typeString + ".line.top").Color);
colorMatrix [1, 1, 2, 0, 0] = Mono.TextEditor.Highlighting.Style.ToCairoColor(style.GetChunkStyle("bubble.inactive." + typeString + ".line.bottom").Color);
double factor = 1.03;
for (int i = 0; i < 2; i++)
{
for (int j = 0; j < 2; j++)
{
for (int k = 0; k < 3; k++)
{
HslColor color = colorMatrix [i, j, k, 0, 0];
color.L *= factor;
colorMatrix [i, j, k, 1, 0] = color;
}
}
}
var selectionColor = Style.ToCairoColor(style.Selection.BackgroundColor);
for (int i = 0; i < 2; i++)
{
for (int j = 0; j < 2; j++)
{
for (int k = 0; k < 3; k++)
{
for (int l = 0; l < 2; l++)
{
var color = colorMatrix [i, j, k, l, 0];
colorMatrix [i, j, k, l, 1] = new Cairo.Color((color.R + selectionColor.R * 1.5) / 2.5, (color.G + selectionColor.G * 1.5) / 2.5, (color.B + selectionColor.B * 1.5) / 2.5);
}
}
}
}
return(colorMatrix);
}
public Cell Cell(object?value, DefaultStyle template)
{
return(Cell(value, template, DefaultStyles[template]));
}
public Cell Cell(object?value, Type type)
{
DefaultStyle template = GetDefaultStyle(type);
return(Cell(value, template));
}
public Cell Cell <T>(T value, UInt32Value styleIndex)
{
DefaultStyle template = GetDefaultStyle(typeof(T));
return(Cell(value, template, styleIndex));
}
public Cell Cell <T>(T value)
{
DefaultStyle template = GetDefaultStyle(typeof(T));
return(Cell(value, template));
}
public Cell Cell(Type type, object value, UInt32Value styleIndex)
{
DefaultStyle template = GetDefaultStyle(type);
return(Cell(value, template, styleIndex));
}
private void Populate(
Document document
)
{
/*
* NOTE: In order to insert a field into a document, you have to follow these steps:
* 1. Define the form fields collection that will gather your fields (NOTE: the form field collection is global to the document);
* 2. Define the pages where to place the fields;
* 3. Define the appearance style to render your fields;
* 4. Create each field of yours:
* 4.1. instantiate your field into the page;
* 4.2. apply the appearance style to your field;
* 4.3. insert your field into the fields collection.
*/
// 1. Define the form fields collection!
Form form = document.Form;
Fields fields = form.Fields;
// 2. Define the page where to place the fields!
Page page = new Page(document);
document.Pages.Add(page);
// 3. Define the appearance style to apply to the fields!
DefaultStyle fieldStyle = new DefaultStyle();
fieldStyle.FontSize = 12;
fieldStyle.GraphicsVisibile = true;
PrimitiveComposer composer = new PrimitiveComposer(page);
composer.SetFont(
new StandardType1Font(
document,
StandardType1Font.FamilyEnum.Courier,
true,
false
),
14
);
// 4. Field creation.
// 4.a. Push button.
{
composer.ShowText(
"PushButton:",
new PointF(140, 68),
XAlignmentEnum.Right,
YAlignmentEnum.Middle,
0
);
Widget fieldWidget = new Widget(
page,
new RectangleF(150, 50, 136, 36)
);
fieldWidget.Actions.OnActivate = new JavaScript(
document,
"app.alert(\"Radio button currently selected: '\" + this.getField(\"myRadio\").value + \"'.\",3,0,\"Activation event\");"
);
PushButton field = new PushButton(
"okButton",
fieldWidget,
"Push" // Current value.
); // 4.1. Field instantiation.
fields.Add(field); // 4.2. Field insertion into the fields collection.
fieldStyle.Apply(field); // 4.3. Appearance style applied.
{
BlockComposer blockComposer = new BlockComposer(composer);
blockComposer.Begin(new RectangleF(296, 50, page.Size.Width - 336, 36), XAlignmentEnum.Left, YAlignmentEnum.Middle);
composer.SetFont(composer.State.Font, 7);
blockComposer.ShowText("If you click this push button, a javascript action should prompt you an alert box responding to the activation event triggered by your PDF viewer.");
blockComposer.End();
}
}
// 4.b. Check box.
{
composer.ShowText(
"CheckBox:",
new PointF(140, 118),
XAlignmentEnum.Right,
YAlignmentEnum.Middle,
0
);
CheckBox field = new CheckBox(
"myCheck",
new Widget(
page,
new RectangleF(150, 100, 36, 36)
),
true // Current value.
); // 4.1. Field instantiation.
fieldStyle.Apply(field);
fields.Add(field);
field = new CheckBox(
"myCheck2",
new Widget(
page,
new RectangleF(200, 100, 36, 36)
),
true // Current value.
); // 4.1. Field instantiation.
fieldStyle.Apply(field);
fields.Add(field);
field = new CheckBox(
"myCheck3",
new Widget(
page,
new RectangleF(250, 100, 36, 36)
),
false // Current value.
); // 4.1. Field instantiation.
fields.Add(field); // 4.2. Field insertion into the fields collection.
fieldStyle.Apply(field); // 4.3. Appearance style applied.
}
// 4.c. Radio button.
{
composer.ShowText(
"RadioButton:",
new PointF(140, 168),
XAlignmentEnum.Right,
YAlignmentEnum.Middle,
0
);
RadioButton field = new RadioButton(
"myRadio",
/*
* NOTE: A radio button field typically combines multiple alternative widgets.
*/
new Widget[]
{
new Widget(
page,
new RectangleF(150, 150, 36, 36),
"first"
),
new Widget(
page,
new RectangleF(200, 150, 36, 36),
"second"
),
new Widget(
page,
new RectangleF(250, 150, 36, 36),
"third"
)
},
"second" // Selected item (it MUST correspond to one of the available widgets' names).
); // 4.1. Field instantiation.
fields.Add(field); // 4.2. Field insertion into the fields collection.
fieldStyle.Apply(field); // 4.3. Appearance style applied.
}
// 4.d. Text field.
{
composer.ShowText(
"TextField:",
new PointF(140, 218),
XAlignmentEnum.Right,
YAlignmentEnum.Middle,
0
);
TextField field = new TextField(
"myText",
new Widget(
page,
new RectangleF(150, 200, 200, 36)
),
"Carmen Consoli" // Current value.
); // 4.1. Field instantiation.
field.SpellChecked = false; // Avoids text spell check.
FieldActions fieldActions = new FieldActions(document);
field.Actions = fieldActions;
fieldActions.OnValidate = new JavaScript(
document,
"app.alert(\"Text '\" + this.getField(\"myText\").value + \"' has changed!\",3,0,\"Validation event\");"
);
fields.Add(field); // 4.2. Field insertion into the fields collection.
fieldStyle.Apply(field); // 4.3. Appearance style applied.
{
BlockComposer blockComposer = new BlockComposer(composer);
blockComposer.Begin(new RectangleF(360, 200, page.Size.Width - 400, 36), XAlignmentEnum.Left, YAlignmentEnum.Middle);
composer.SetFont(composer.State.Font, 7);
blockComposer.ShowText("If you leave this text field after changing its content, a javascript action should prompt you an alert box responding to the validation event triggered by your PDF viewer.");
blockComposer.End();
}
}
// 4.e. Choice fields.
{
// Preparing the item list that we'll use for choice fields (a list box and a combo box (see below))...
ChoiceItems items = new ChoiceItems(document);
items.Add("Tori Amos");
items.Add("Anouk");
items.Add("Joan Baez");
items.Add("Rachele Bastreghi");
items.Add("Anna Calvi");
items.Add("Tracy Chapman");
items.Add("Carmen Consoli");
items.Add("Ani DiFranco");
items.Add("Cristina Dona'");
items.Add("Nathalie Giannitrapani");
items.Add("PJ Harvey");
items.Add("Billie Holiday");
items.Add("Joan As Police Woman");
items.Add("Joan Jett");
items.Add("Janis Joplin");
items.Add("Angelique Kidjo");
items.Add("Patrizia Laquidara");
items.Add("Annie Lennox");
items.Add("Loreena McKennitt");
items.Add("Joni Mitchell");
items.Add("Alanis Morissette");
items.Add("Yael Naim");
items.Add("Noa");
items.Add("Sinead O'Connor");
items.Add("Dolores O'Riordan");
items.Add("Nina Persson");
items.Add("Brisa Roche'");
items.Add("Roberta Sammarelli");
items.Add("Cristina Scabbia");
items.Add("Nina Simone");
items.Add("Skin");
items.Add("Patti Smith");
items.Add("Fatima Spar");
items.Add("Thony (F.V.Caiozzo)");
items.Add("Paola Turci");
items.Add("Sarah Vaughan");
items.Add("Nina Zilli");
// 4.e1. List box.
{
composer.ShowText(
"ListBox:",
new PointF(140, 268),
XAlignmentEnum.Right,
YAlignmentEnum.Middle,
0
);
ListBox field = new ListBox(
"myList",
new Widget(
page,
new RectangleF(150, 250, 200, 70)
)
); // 4.1. Field instantiation.
field.Items = items; // List items assignment.
field.MultiSelect = false; // Multiple items may not be selected simultaneously.
field.Value = "Carmen Consoli"; // Selected item.
fields.Add(field); // 4.2. Field insertion into the fields collection.
fieldStyle.Apply(field); // 4.3. Appearance style applied.
}
// 4.e2. Combo box.
{
composer.ShowText(
"ComboBox:",
new PointF(140, 350),
XAlignmentEnum.Right,
YAlignmentEnum.Middle,
0
);
ComboBox field = new ComboBox(
"myCombo",
new Widget(
page,
new RectangleF(150, 334, 200, 36)
)
); // 4.1. Field instantiation.
field.Items = items; // Combo items assignment.
field.Editable = true; // Text may be edited.
field.SpellChecked = false; // Avoids text spell check.
field.Value = "Carmen Consoli"; // Selected item.
fields.Add(field); // 4.2. Field insertion into the fields collection.
fieldStyle.Apply(field); // 4.3. Appearance style applied.
}
}
composer.Flush();
}
public void Visit(DefaultStyle defaultStyle)
{
}