Spreadsheet

Complete

Una hoja de cálculo completa: fórmulas y funciones, formato, celdas combinadas, paneles inmovilizados, gráficos, formato condicional, validación de datos, varias hojas, deshacer y rehacer, copiar y pegar, rellenar, ordenar, buscar y reemplazar, y archivos CSV, .xlsx y JSON. El motor de fórmulas y el código de archivos forman parte de RayCraft.Blazor.Office y no contienen componentes de terceros.

Parámetros

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.

Parámetro	Tipo	Descripción
`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.

Parámetro	Tipo	Descripción
`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.

Parámetro	Tipo	Descripción
`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.

Parámetro	Tipo	Descripción
`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

Parámetro	Tipo	Descripción
`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

Parámetro	Tipo	Descripción
`AllowFileTransfer`	`bool`	Muestra los comandos de importación y exportación (true de forma predeterminada).
`AllowSheetChanges`	`bool`	Permite agregar, cambiar el nombre y eliminar hojas (true de forma predeterminada).
`Class`	`string`	Clases CSS adicionales que se agregan al elemento raíz.
`FileName`	`string`	Nombre dado a los archivos exportados, sin extensión (workbook de forma predeterminada).
`Height`	`string`	Altura de todo el control como longitud CSS (34rem de forma predeterminada).
`IgnoredWords`	`IReadOnlyCollection<string>`	Palabras que nunca se notifican como mal escritas.
`Label`	`string`	Nombre accesible de la cuadrícula. De forma predeterminada, un Spreadsheet localizado.
`MaxImportSize`	`Int64`	Mayor archivo que se puede importar, en bytes (5 000 000 de forma predeterminada).
`PdfFonts`	`PdfFontSet`
`ProofAsYouType`	`bool`	Marca las celdas con problemas a medida que cambia la hoja (hojas de hasta 50 000 celdas rellenas); el usuario puede activarlo en el menú Review.
`Proofing`	`bool`	Comprueba ortografía, gramática, fórmulas, números y totales: menú Review, botón de la barra de herramientas y F7 (true de forma predeterminada).
`ReadOnly`	`bool`	Sin edición, pero seleccionar, copiar y exportar siguen funcionando.
`ShowFormulaBar`	`bool`	Muestra el cuadro de nombre y la barra de fórmulas (true de forma predeterminada).
`ShowMenuBar`	`bool`	Muestra la barra de menús (true de forma predeterminada).
`ShowSheetTabs`	`bool`	Muestra las pestañas de hojas (true de forma predeterminada).
`ShowStatusBar`	`bool`	Muestra la barra de estado con Sum, Average, Count, Min y Max de la selección (true de forma predeterminada).
`ShowToolbar`	`bool`	Muestra la barra de herramientas de formato y edición (true de forma predeterminada).
`Style`	`string`	Estilo en línea agregado al elemento raíz.
`Workbook`	`Workbook`	Los datos que se muestran y editan. Omítalo para un libro vacío nuevo (léalo de nuevo con GetWorkbook()).

Eventos

API

Evento	Tipo	Descripción
`OnChanged`	`EventCallback`	Se genera después de que el libro cambie: una edición, deshacer o rehacer.
`OnNew`	`EventCallback`
`OnSave`	`EventCallback<OfficeFileSave>`
`OnSaveAs`	`EventCallback<OfficeFileSave>`
`OnSelectionChanged`	`EventCallback<CellRange>`	Se genera cuando la selección se movió.

Paquete

Spreadsheet forma parte de RayCraft Complete. Paquete: RayCraft.Blazor.Complete. Se obtiene del feed privado de RayCraft y requiere una licencia activa. Consulte Primeros pasos.

Enviar comentariosVersión 1.0.3