Spreadsheet
CompleteUne feuille de calcul complète : formules et fonctions, mise en forme, cellules fusionnées, volets figés, graphiques, mise en forme conditionnelle, validation des données, plusieurs feuilles, annuler et rétablir, copier-coller, recopie, tri, recherche et remplacement, et fichiers CSV, .xlsx et JSON. Le moteur de formules et le code des fichiers font partie de RayCraft.Blazor.Office et ne contiennent aucun élément tiers.
Paramètres
Rules colour cells by their values. Rules are checked in order; when two rules set the same property, the first one wins. A Formula rule is written for the top-left cell of its range and applies to every cell relative to it.
| Paramètre | Type | Description |
|---|---|---|
Rule | Effect | |
GreaterThan, GreaterOrEqual, LessThan, LessOrEqual, Equal, NotEqual | Colours cells that compare that way with the value (a number, text or =formula). | |
Between, NotBetween | Colours cells inside or outside the two limits. | |
TextContains, TextNotContains, BeginsWith, EndsWith | Colours cells by their shown text, ignoring case. | |
Blank, NotBlank, Error | Colours empty cells, filled cells or cells showing an error. | |
Duplicate, Unique | Colours values that appear more than once, or only once, in the range. | |
Top, Bottom | Colours the highest or lowest numbers (default 10). | |
AboveAverage, BelowAverage | Colours numbers above or below the average of the range. | |
Formula | Colours cells where the formula is true; references move with the cell. | |
ColorScale | Fills numbers from one colour to another (Background = lowest, Color = highest, MidColor optional). | |
DataBar | Draws a bar behind each number, as long as its share of the largest value (Background = bar colour). |
Everything is reachable by keyboard and mouse, with the shortcuts people know from other spreadsheets.
| Paramètre | Type | Description |
|---|---|---|
Keys or gesture | What it does | |
Arrow keys, Tab, Enter | Move the active cell (Shift reverses Tab and Enter) | |
Shift + arrows / click / drag | Extend the selection | |
Ctrl + arrows | Jump to the edge of a block of filled cells | |
Ctrl + Home / End | Go to A1 / the last used cell | |
Home, End, PageUp, PageDown | Row start or end, page up or down | |
Ctrl + A, Ctrl + Space, Shift + Space | Select everything, the column or the row | |
Type, F2, double-click | Edit the cell (typing replaces its content, F2 keeps it) | |
Enter / Tab / Esc while editing | Accept and move down or right / cancel | |
Delete, Backspace | Clear the selected cells | |
Ctrl + C, X, V | Copy, cut and paste; formulas keep their relative references, and text from other programs is pasted as values | |
Ctrl + Z, Ctrl + Y | Undo and redo (also Ctrl + Shift + Z) | |
Ctrl + B, I, U | Bold, italic, underline | |
Ctrl + D, Ctrl + R | Fill the selection down or right from its first row or column | |
Ctrl + F | Find and replace | |
Drag the fill handle | Copy a cell, continue a number series (1, 2 gives 3, 4...) or count up text such as Item 1 | |
Click a column or row header | Select the whole column or row; drag across headers to select several | |
Drag a header edge, double-click it | Resize a column or row, or reset it | |
Right-click a cell, a column or row header, or a chart | Context menu with the commands that fit what you clicked | |
Click a chart, drag it, drag its corner, Delete | Select, move, resize and remove a chart | |
Arrow next to a cell with a list rule | Open the drop-down and pick a value | |
Name box (top left) | Type A1 or B2:D9 to jump to a cell or range | |
F7, cell with a coloured corner | Spelling and grammar panel; right-click a marked cell for its corrections |
The menu bar above the toolbar groups every command. Click a menu name (or move to it with the arrow keys) to open it; Left and Right switch between menus, Up and Down move through the entries, Right opens a submenu and Escape closes the menu. Right-click opens a context menu that fits what you clicked: a cell, a column header, a row header or a chart.
| Paramètre | Type | Description |
|---|---|---|
Menu | Contents | |
File | Import a file; export as CSV, XLSX or JSON. | |
Edit | Undo, redo, cut, copy, paste, paste special (values or formatting only), select all, clear contents or formatting, find and replace. | |
View | Show or hide the toolbar, formula bar, sheet tabs and status bar; freeze panes. | |
Insert | Rows and columns; open the chart, conditional formatting and data validation panels. | |
Format | Bold, italic, underline, strikethrough; number format, alignment, wrap text, borders; merge cells; clear formatting. | |
Data | Sort, fill down and right, data validation, conditional formatting. | |
Review | Spelling, grammar and formula checks. | |
Sheet | Add, rename, delete and move the current sheet. |
Operators and functions that take single values work on whole ranges and arrays, element by element: =SUMPRODUCT((A1:A5>2)*B1:B5), =SUM(IF(A1:A5>2,A1:A5,0)) or =TEXTJOIN(",",TRUE,IF(A1:A5>2,C1:C5,"")). A formula that produces several values (=A1:A5*2, =UPPER(C1:C5), =SORT(A1:A5), ={1,2,3}) fills the cells below or to the right and shows #SPILL! when one of them is not empty.
| Paramètre | Type | Description |
|---|---|---|
Group | Functions | |
Math | ABSSIGNSQRTPOWEREXPLNLOGLOG10MODQUOTIENTINTTRUNCROUNDROUNDUPROUNDDOWNCEILINGFLOOREVENODDFACTGCDLCMPIRANDRANDBETWEENSINCOSTANASINACOSATANATAN2DEGREESRADIANSSUMPRODUCTSUMSQSUMPRODUCTSINHCOSHTANHSQRTPIMROUNDCOMBINPERMUTSUBTOTAL | |
Statistics | AVERAGEMINMAXMEDIANMODECOUNTCOUNTACOUNTBLANKLARGESMALLRANKVARVARPSTDEVSTDEVPSUMIFSUMIFSCOUNTIFCOUNTIFSAVERAGEIFAVERAGEIFSMAXIFSMINIFSAVERAGEAPERCENTILEQUARTILECORRELSLOPEINTERCEPTFORECASTGEOMEANHARMEANAGGREGATE | |
Logic | IFIFSIFERRORIFNASWITCHANDORXORNOTTRUEFALSE | |
Text | LENUPPERLOWERPROPERTRIMCLEANLEFTRIGHTMIDCONCATCONCATENATETEXTJOINREPTSUBSTITUTEREPLACEFINDSEARCHEXACTVALUETEXTCHARCODETNTEXTBEFORETEXTAFTERNUMBERVALUEUNICODEUNICHAR | |
Lookup | VLOOKUPHLOOKUPINDEXMATCHCHOOSEROWCOLUMNROWSCOLUMNSINDIRECTLOOKUPXLOOKUPXMATCHOFFSETADDRESS | |
Date and time | TODAYNOWDATETIMEYEARMONTHDAYHOURMINUTESECONDWEEKDAYEDATEEOMONTHDAYSDATEDIFWEEKNUMISOWEEKNUMNETWORKDAYSWORKDAYDATEVALUE | |
Dynamic arrays | SEQUENCETRANSPOSEUNIQUESORTSORTBYFILTER | |
Financial | PMTFVPVNPERNPVIRRRATESLN | |
Number bases and numerals | BIN2DECOCT2DECHEX2DECDEC2BINDEC2OCTDEC2HEXBASEDECIMALROMANARABIC | |
Information | ISNUMBERISTEXTISNONTEXTISLOGICALISBLANKISERRORISERRISNAISEVENISODDNAERROR.TYPE | |
Distributions | NORM.DISTNORM.INVNORM.S.DISTNORM.S.INVPHIGAUSSLOGNORM.DISTLOGNORM.INVEXPON.DISTPOISSON.DISTBINOM.DISTBINOM.INVHYPGEOM.DISTNEGBINOM.DISTT.DISTT.DIST.2TT.DIST.RTT.INVT.INV.2TCHISQ.DISTCHISQ.DIST.RTCHISQ.INVCHISQ.INV.RTGAMMA.DISTGAMMA.INVWEIBULL.DISTBETA.DISTBETA.INVCONFIDENCE.NORMCONFIDENCE.TZ.TESTSTANDARDIZEFISHERFISHERINVERFERFCGAMMAGAMMALN | |
More statistics | AVEDEVDEVSQSKEWSKEW.PKURTSTDEVASTDEVPAVARAVARPAMAXAMINATRIMMEANRSQPEARSONSTEYXCOVARCOVARIANCE.PCOVARIANCE.SPERCENTRANKPERCENTRANK.EXCPERCENTILE.EXCQUARTILE.EXCRANK.AVGFREQUENCYMODE.MULTLINESTTRENDFORECAST.LINEAR | |
More financial | IPMTPPMTCUMIPMTCUMPRINCISPMTEFFECTNOMINALRRIPDURATIONMIRRXNPVXIRRFVSCHEDULEDBDDBSYDDOLLARDEDOLLARFRDAYS360YEARFRAC | |
Database | DSUMDAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDVARDVARP | |
More arrays | TAKEDROPCHOOSECOLSCHOOSEROWSVSTACKHSTACKTOCOLTOROWWRAPROWSWRAPCOLSEXPANDTEXTSPLITRANDARRAYMMULTMINVERSEMDETERMMUNIT | |
More math and information | ACOSHASINHATANHCOTCOTHCSCCSCHSECSECHACOTACOTHCEILING.MATHFLOOR.MATHCEILING.PRECISEFLOOR.PRECISEFACTDOUBLEMULTINOMIALSERIESSUMSUMX2MY2SUMX2PY2SUMXMY2BITANDBITORBITXORBITLSHIFTBITRSHIFTDELTAGESTEPCOMBINAPERMUTATIONATYPEISFORMULAFORMULATEXTISREFAREASCELLSHEETSHEETSHYPERLINKDOLLARFIXEDENCODEURLTIMEVALUEVALUETOTEXT | |
Lambda | LETLAMBDAMAPREDUCESCANBYROWBYCOLMAKEARRAY | |
Engineering | NETWORKDAYS.INTLWORKDAY.INTLCONVERTCOMPLEXIMREALIMAGINARYIMABSIMARGUMENTIMCONJUGATEIMSUMIMSUBIMPRODUCTIMDIVIMPOWERIMSQRTIMEXPIMLNIMSINIMCOSBIN2HEXBIN2OCTHEX2BINHEX2OCTOCT2BINOCT2HEX | |
Other | BINOMDISTCHIDISTCHIINVCONFIDENCECRITBINOMERF.PRECISEERFC.PRECISEEXPONDISTFINDBGAMMADISTGAMMAINVGAMMALN.PRECISEHYPGEOMDISTMODE.SNGLNORMDISTNORMINVNORMSDISTNORMSINVPERCENTILE.INCPERCENTRANK.INCPOISSONQUARTILE.INCRANK.EQSEARCHBSTDEV.PSTDEV.STDISTTINVVAR.PVAR.SWEIBULLZTEST |
=A1+B1*2
| Paramètre | Type | Description |
|---|---|---|
Error | Meaning | |
#DIV/0! | Division by zero. | |
#VALUE! | A value has the wrong type, for example text where a number is needed. | |
#REF! | A reference points to a cell that was deleted or to a sheet that does not exist. | |
#NAME? | A function or name is not known. | |
#N/A | A lookup found nothing. | |
#NUM! | A number is not valid for the function, or the calculation is too deep. | |
#CIRC! | The formula depends on itself. | |
#ERROR! | The formula could not be understood. |
API
| Paramètre | Type | Description |
|---|---|---|
AllowFileTransfer | bool | Affiche les commandes d'import et d'export (true par défaut). |
AllowSheetChanges | bool | Permet d'ajouter, de renommer et de supprimer des feuilles (true par défaut). |
Class | string | Classes CSS supplémentaires ajoutées à l'élément racine. |
FileName | string | Nom donné aux fichiers exportés, sans extension (workbook par défaut). |
Height | string | Hauteur de tout le contrôle en longueur CSS (34rem par défaut). |
IgnoredWords | IReadOnlyCollection<string> | Mots jamais signalés comme mal orthographiés. |
Label | string | Nom accessible de la grille. Par défaut un Spreadsheet localisé. |
MaxImportSize | Int64 | Plus gros fichier pouvant être importé, en octets (5 000 000 par défaut). |
PdfFonts | PdfFontSet | |
ProofAsYouType | bool | Marque les cellules à problèmes à mesure que la feuille change (feuilles jusqu'à 50 000 cellules remplies) ; l'utilisateur peut l'activer dans le menu Review. |
Proofing | bool | Vérifie l'orthographe, la grammaire, les formules, les nombres et les totaux : menu Review, bouton de barre d'outils et F7 (true par défaut). |
ReadOnly | bool | Pas de modification, mais la sélection, la copie et l'export fonctionnent toujours. |
ShowFormulaBar | bool | Affiche la zone de nom et la barre de formule (true par défaut). |
ShowMenuBar | bool | Affiche la barre de menus (true par défaut). |
ShowSheetTabs | bool | Affiche les onglets de feuilles (true par défaut). |
ShowStatusBar | bool | Affiche la barre d'état avec Sum, Average, Count, Min et Max de la sélection (true par défaut). |
ShowToolbar | bool | Affiche la barre d'outils de mise en forme et de modification (true par défaut). |
Style | string | Style en ligne ajouté à l'élément racine. |
Workbook | Workbook | Les données à afficher et à modifier. Omettez-les pour un nouveau classeur vide (relisez-le avec GetWorkbook()). |
Événements
API
| Événement | Type | Description |
|---|---|---|
OnChanged | EventCallback | Déclenché après la modification du classeur : une modification, annuler ou rétablir. |
OnNew | EventCallback | |
OnSave | EventCallback<OfficeFileSave> | |
OnSaveAs | EventCallback<OfficeFileSave> | |
OnSelectionChanged | EventCallback<CellRange> | Déclenché quand la sélection a bougé. |
Paquet
Spreadsheet fait partie de RayCraft Complete. Paquet : RayCraft.Blazor.Complete. Il provient du flux privé RayCraft et nécessite une licence active. Voir Premiers pas.
Envoyer un retourVersion 1.0.3