Spreadsheet

Complete

Et komplet regneark: formler og funktioner, formatering, flettede celler, fastfrosne ruder, diagrammer, betinget formatering, datavalidering, flere ark, fortryd og gentag, kopiér og indsæt, udfyld, sortér, søg og erstat samt CSV-, .xlsx- og JSON-filer. Formelmotoren og filkoden er en del af RayCraft.Blazor.Office og indeholder ingen tredjepartsdele.

Parametre

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.

Parameter	Type	Beskrivelse
`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.

Parameter	Type	Beskrivelse
`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.

Parameter	Type	Beskrivelse
`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:A52, =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.

Parameter	Type	Beskrivelse
`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

Parameter	Type	Beskrivelse
`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

Parameter	Type	Beskrivelse
`AllowFileTransfer`	`bool`	Viser kommandoerne til import og eksport (standard true).
`AllowSheetChanges`	`bool`	Lader brugere tilføje, omdøbe og slette ark (standard true).
`Class`	`string`	Ekstra CSS-klasser, der tilføjes til rodelementet.
`FileName`	`string`	Navn, der gives til eksporterede filer, uden filtypenavn (standard workbook).
`Height`	`string`	Hele kontrollens højde som CSS-længde (standard 34rem).
`IgnoredWords`	`IReadOnlyCollection<string>`	Ord, der aldrig rapporteres som fejlstavet.
`Label`	`string`	Gitterets tilgængelige navn. Som standard et lokaliseret Spreadsheet.
`MaxImportSize`	`Int64`	Største fil, der kan importeres, i byte (standard 5.000.000).
`PdfFonts`	`PdfFontSet`
`ProofAsYouType`	`bool`	Markerer celler med problemer, efterhånden som arket ændres (ark med op til 50.000 udfyldte celler); brugeren kan slå det til i menuen Review.
`Proofing`	`bool`	Kontrollerer stavning, grammatik, formler, tal og totaler: menuen Review, værktøjslinjeknap og F7 (standard true).
`ReadOnly`	`bool`	Ingen redigering, men markering, kopiering og eksport virker stadig.
`ShowFormulaBar`	`bool`	Viser navnefeltet og formellinjen (standard true).
`ShowMenuBar`	`bool`	Viser menulinjen (standard true).
`ShowSheetTabs`	`bool`	Viser arkfanerne (standard true).
`ShowStatusBar`	`bool`	Viser statuslinjen med Sum, Average, Count, Min og Max for markeringen (standard true).
`ShowToolbar`	`bool`	Viser værktøjslinjen til formatering og redigering (standard true).
`Style`	`string`	Indlejret typografi, der tilføjes til rodelementet.
`Workbook`	`Workbook`	De data, der skal vises og redigeres. Udelad for en ny tom projektmappe (læs den tilbage med GetWorkbook()).

Hændelser

API

Hændelse	Type	Beskrivelse
`OnChanged`	`EventCallback`	Udløses, efter projektmappen er ændret: en redigering, fortryd eller gentag.
`OnNew`	`EventCallback`
`OnSave`	`EventCallback<OfficeFileSave>`
`OnSaveAs`	`EventCallback<OfficeFileSave>`
`OnSelectionChanged`	`EventCallback<CellRange>`	Udløses, når markeringen er flyttet.

Pakke

Spreadsheet er en del af RayCraft Complete. Pakke: RayCraft.Blazor.Complete. Den hentes fra RayCrafts private feed og kræver en aktiv licens. Se Kom i gang.

Send feedbackVersion 1.0.3