Search results
From Wiki
Jump to navigationJump to searchCreate the page "Calc/To-Dos" on this wiki! See also the search results found.
- {{Template:Calc Project}} ...e|manual]], [[Documentation/How_Tos|HowTos]] and a [[Documentation/How_Tos/Calc:_Functions_listed_by_category|function list by category]]. This section her3 KB (449 words) - 14:45, 20 May 2011
- This list of to-dos gives some ideas where in the Application Help your contribution may be nee * Guides for Calc DataPilot3 KB (470 words) - 06:54, 30 March 2012
- Here you can find a list of ongoing or new to-dos in the area of the [[API]] project. If you are interested to help in this p The single to-dos are flagged to show the degree of difficulty.6 KB (1,014 words) - 06:31, 30 March 2012
- *To-Dos ''Probably a lot - please [[Performance/To-Dos| continue here]].6 KB (762 words) - 14:45, 20 May 2011
- Calc comes with a predefined set of formatting themes that you can apply to your It is not possible to add themes to Calc, and they cannot be modified. However, you can modify their styles after yo2 KB (287 words) - 15:47, 13 April 2012
- ...le /><noinclude>{{DISPLAYTITLE:</noinclude>Chapter 5. Getting Started with Calc<noinclude>}}</noinclude><section end=title /> = What is Calc? =2 KB (258 words) - 15:00, 13 April 2012
- [[Category:Documentation/How Tos/Calc]]1 KB (249 words) - 07:20, 30 March 2012
- == Removing Duplicate Rows in Calc == Q: ''How do I select all unique values from a column in an OOo Calc spreadsheet? I want to remove all redundant rows from a report with thousan2 KB (364 words) - 07:20, 30 March 2012
- ...ula aka ODFF, standardizes on recalulcated formula expression as used by [[Calc]] and introduces new functions and parameters that need to be implemented. * Align and enhance the already existing [[Calc/ODFF_Implementation/Examine_functions| overview and comparison]] of differe1 KB (147 words) - 14:45, 20 May 2011
- === Calc ===3 KB (476 words) - 20:11, 13 April 2012
- * Calc Add-Ins, which provide new functionality for Calc, including new functions that act like normal built-in functions * Data pilots that are used directly in Calc1 KB (185 words) - 11:21, 9 April 2012
- <section begin=title /><noinclude>{{DISPLAYTITLE:</noinclude>Saving Calc spreadsheets as web pages<noinclude>}}</noinclude><section end=title /> Calc can save files as HTML documents. As for Writer, use '''File > Save As''' a866 bytes (125 words) - 14:56, 9 April 2012
- ==Architectural To-Dos== ...xt editing functionality in EditEngine and TextEngine (used by Impress and Calc for their corresponding text functionality).11 KB (1,677 words) - 14:45, 20 May 2011
- ...base interface from {{OOo}} is available in the {{OOo}} Writer and {{OOo}} Calc applications, as well as in the database forms. ...tabases. To do this, you first create a standard {{OOo}} Writer or {{OOo}} Calc form and then link the fields to a database.2 KB (260 words) - 17:21, 5 September 2011
- Writer and Calc: XHTML and PDF.860 bytes (124 words) - 19:45, 10 April 2012
- ...on/Note| Selections on the Printer Options dialog are different in Writer, Calc, Impress, and Draw, but in all cases they apply to this printing of this do ...item, ''Use only paper tray from printer preference'', is not available in Calc.3 KB (416 words) - 16:48, 10 April 2012
- Use the '''New Document''' [[Image:New-calc-icon.jpg]] button on the Standard toolbar. (This button is always a page of Calc documents can also be created from templates, if you have any spreadsheet t2 KB (240 words) - 16:26, 13 April 2012
- ...luate a numeric value, see the [[Documentation/OOo3 User Guides/Calc Guide|Calc Guide]].}}2 KB (267 words) - 09:14, 30 March 2012
- * [[SimpleCalcAddIn| Calc Addin Tutorial]] * [[CompleteAddIn| An other Calc Addin Tutorial]]4 KB (512 words) - 14:45, 20 May 2011
- Most data entry in Calc can be accomplished using the keyboard. If a number is entered in the format ''01481'', Calc will drop the leading 0. (Exception: see Tip below.) To preserve the leadin4 KB (598 words) - 16:03, 13 April 2012
- == Regular expressions in Calc and Writer == Regular expressions are available in Calc as follows:8 KB (1,487 words) - 07:20, 30 March 2012
- [[Image:AutoCorrectCalc.png|thumb|none|500px|AutoCorrect dialog in Calc, showing four tabs and the Options choices]]1 KB (189 words) - 09:16, 30 March 2012
- [[Image:Calc-navigator3.png|thumb|none|500px|''Calc Navigator'']] ...er'' key moves the focus, by selecting '''Tools > Options > OpenOffice.org Calc > General'''.4 KB (712 words) - 16:15, 13 April 2012
- ...things such as inserting a formula, setting user data, setting filters in Calc, actions in database forms, and exporting a document to an encrypted PDF fi ...ate a macro, there is an add-in created by Paolo Mantovani, which converts Calc macros when they are recorded. The final code manipulates OpenOffice.org ob4 KB (636 words) - 13:30, 9 April 2012
- '''Calc'''3 KB (453 words) - 09:16, 30 March 2012
- *[[Documentation/How_Tos/Regular_Expressions_in_Calc|Regular Expressions in Calc]] [[Category:Documentation/How Tos/Calc]]3 KB (480 words) - 07:20, 30 March 2012
- .... Instructions on how to create charts are given in the [[../../Calc Guide|Calc Guide]].2 KB (246 words) - 15:07, 9 April 2012
- ...orm (as in equation 1). If you want to evaluate a numeric value, see the [[Calc Guide]].}}2 KB (243 words) - 09:18, 30 March 2012
- ...lyze your data or apply formulas, these operations are best performed in a Calc spreadsheet and the results displayed in an embedded Impress spreadsheet. ...rts comments (formerly called sticky notes) similar to those in Writer and Calc.4 KB (623 words) - 14:29, 13 April 2012
- This chapter describes how to do the following in Writer, Calc, Draw and Impress: Calc will always display an absolute hyperlink. Don’t be alarmed when it does3 KB (533 words) - 14:20, 9 April 2012
- |PrevPage=Documentation/OOo3_User_Guides/Calc Guide |NextPage=Documentation/OOo3_User_Guides/Calc Guide/Introducing Calc2 KB (228 words) - 09:14, 30 March 2012
- [[Image:InsertTable-Calc.jpg|thumb|none|500px|''Creating a table with the Insert Table dialog.'']] ...lations. For those functions, you need to use a spreadsheet inserted from Calc (discussed in [[Documentation/OOo3 User Guides/Getting Started/Adding objec3 KB (509 words) - 14:32, 13 April 2012
- The data in Calc can be formatting in several ways. It can either be edited as part of a cel ...enoffice.org/w/images/f/f4/0304CG3-StylesAndTemplates.pdf Chapter 4 of the Calc Guide] }}6 KB (1,007 words) - 15:53, 13 April 2012
- Entering data into a spreadsheet can be very labor-intensive, but Calc provides several tools for removing some of the drudgery from input. ...o drop and drag the contents of one cell to another with a mouse. However, Calc also includes several other tools for automating input, especially of repet6 KB (961 words) - 16:00, 13 April 2012
- ...of performing various statistical functions to analyze data in openoffice calc spreadsheets in a very user friendly manner. *Openoffice calc extension for statistical data analysis4 KB (601 words) - 14:45, 20 May 2011
- ...onent-specific set directly related to the work of that component (Writer, Calc, Impress, Draw and Base). This document describes the general set: the comp2 KB (309 words) - 09:50, 9 April 2012
- Like any other Calc element, sheets can be inserted, deleted and renamed.3 KB (413 words) - 16:09, 13 April 2012
- ...frames, Comments, Graphics, Bookmarks, and other items, as shown below. In Calc it shows Sheets, Range Names, Database Ranges, Graphics, Drawing Objects, a3 KB (487 words) - 21:09, 13 April 2012
- [[Category:Documentation/How Tos/Calc]]3 KB (525 words) - 07:20, 30 March 2012
- ...ppropriate program (for example, the default browser for an HTML page; OOo Calc for a .ODS file; a PDF viewer for a PDF file). You can create hotspots of v3 KB (500 words) - 16:07, 9 April 2012
- Sorting arranges the visible cells on the sheet. In Calc, you can sort by up to three criteria, with each criterion applied one afte3 KB (461 words) - 15:40, 13 April 2012
- ...as the file type when opening the file, the document opens in Writer, not Calc.}}2 KB (347 words) - 06:15, 14 April 2012
- == Calc (spreadsheet) == ...pen and work with Microsoft Excel workbooks and save them in Excel format. Calc can export spreadsheets to Adobe’s PDF and to HTML.5 KB (715 words) - 20:47, 13 April 2012
- ...Writer containing time‑varying data, such as sales results sourced from a Calc spreadsheet. The DDE link ensures that, as the source spreadsheet is update2 KB (427 words) - 09:16, 30 March 2012
- [[Category:Documentation/How Tos/Calc]]4 KB (663 words) - 07:20, 30 March 2012
- ..., it will not be accessible to the other OOo components such as Writer and Calc. If the database is registered, other components can access it.}}2 KB (362 words) - 16:40, 11 April 2012
- ...tion begin=title /><noinclude>{{DISPLAYTITLE:</noinclude>Parts of the main Calc window<noinclude>}}</noinclude><section end=title /> When Calc is started, the main window looks similar to the figure below.6 KB (1,033 words) - 16:31, 13 April 2012
- .... This distinction is not made in {{OOo}} Basic, because charts in {{OOo}} Calc are always created as embedded objects of a table page. The charts are alwa3 KB (441 words) - 15:59, 5 September 2011
- ..., it will not be accessible to the other OOo components such as Writer and Calc. If the database is registered, other components can access it.}}2 KB (356 words) - 09:16, 30 March 2012
- * Does the macro pertain to a specific document type, such as a Calc document?5 KB (818 words) - 11:25, 9 April 2012
- This chapter describes how to save documents as web pages from Writer, Calc, Draw and Impress.817 bytes (106 words) - 09:16, 30 March 2012
- |{{OOo}} Calc||scalc6 KB (802 words) - 16:05, 30 March 2012
- In Writer and Calc (but not Draw or Impress), you can also change the Internet link character5 KB (784 words) - 15:04, 9 April 2012
- == Integration of Grammar Checking into Calc, Draw and Impress == == Integration of language guessing and selection into Calc, Draw and Impress ==7 KB (1,167 words) - 14:45, 20 May 2011
- In Writer and Calc (but not Draw or Impress), you can also change the ''Internet link'' charac In Writer and Calc (but not Draw or Impress), you can also change the Internet link character7 KB (1,180 words) - 09:16, 30 March 2012
- ...tal, then you can use '''Data > Group and Outline > AutoOutline''' to have Calc add outline controls based on the pattern. Otherwise, you can set outline g4 KB (732 words) - 15:44, 13 April 2012
- <section begin=title /><noinclude>{{DISPLAYTITLE:</noinclude>Printing from Calc<noinclude>}}</noinclude><section end=title /> Printing from Calc is the same as printing from other OOo components (see [[../Printing,_Expor11 KB (1,863 words) - 15:37, 13 April 2012
- =Conditional Counting and Summation in Calc= The [[Documentation/How_Tos/Calc: COUNT function|COUNT function]] counts the number of cells which contain n13 KB (2,228 words) - 07:20, 30 March 2012
- Provides more than 120 templates for Writer, Calc, and Impress. Available in several languages. After you have installed this5 KB (751 words) - 09:16, 30 March 2012
- [[Category:Calc]] [[Category:Documentation/How Tos/Calc]]8 KB (1,200 words) - 07:20, 30 March 2012
- Draw supports comments (formerly called notes) similar to those in Writer and Calc.4 KB (669 words) - 17:13, 11 April 2012
- * April 2011 - Calc Guide (updated for OOo 3.3) published in [[/ooo3_user_guides/ooo3.3_user_gu * [[EN/documentation/faq/calc|Working with Spreadsheets (Calc)]]7 KB (835 words) - 12:33, 14 April 2012
- ...ow Tos/Doing Formulas in Writer Calc and Impress|Formules maken in Writer, Calc en Impress]] ...ow Tos/Doing Formulas in Writer Calc and Impress|Formules maken in Writer, Calc en Impress]]8 KB (1,059 words) - 07:09, 30 March 2012
- ...ck on a *.doc (Word) file, it opens in Writer; *.xls (Excel) files open in Calc, and *.ppt (Powerpoint) files open in Impress. ||Spreadsheet||Calc||<tt>-calc</tt>6 KB (1,054 words) - 05:46, 14 April 2012
- ...styles'' include margins, headers and footers, borders and backgrounds. In Calc, page styles also include the sequence for printing sheets. !Style Type !! Writer !! Calc !! Draw !! Impress5 KB (769 words) - 17:17, 13 April 2012
- ...J''||Toggles the view between fullscreen mode and normal mode in Writer or Calc.3 KB (496 words) - 10:33, 9 April 2012
- The process and dialogs are the same for Writer, Calc, Impress, and Draw, with a few minor differences mentioned in this section. * '''Export notes''': Exports notes in Writer and Calc documents as PDF notes. You may not want this!8 KB (1,278 words) - 06:30, 14 April 2012
- {{BreadCrumbL10n|RU/kb/module/calc/automation_calculations}}1 KB (83 words) - 18:26, 24 March 2012
- <section begin=title /><noinclude>{{DISPLAYTITLE:</noinclude>Viewing Calc<noinclude>}}</noinclude><section end=title />6 KB (959 words) - 16:06, 13 April 2012
- ...gistered, it can be used in any other OOo component (for example Writer or Calc) by selecting '''View > Data Sources''' or pressing the ''F4 ''key. ...ce, you can use it in other OpenOffice.org components including Writer and Calc.14 KB (2,375 words) - 15:59, 11 April 2012
- ...uite. For example, the drawing tools available in Writer are also found in Calc, with similar but enhanced versions in Impress and Draw.3 KB (479 words) - 05:57, 14 April 2012
- * '''Export notes''': Exports notes in Writer and Calc documents as PDF notes.You may not want this! ....''' If you have defined Writer bookmarks, Impress or Draw slide names, or Calc sheet names, this option exports them as “named destinations” to which7 KB (1,093 words) - 09:18, 30 March 2012
- More than 120 templates for Writer, Calc, and Impress. Available in several languages. After you have installed this5 KB (785 words) - 10:46, 9 April 2012
- {{OOo}} Calc supports the following types of styles: ...uide/spreadsheets|Spreadsheets]] can therefore be used not only in {{OOo}} Calc, but also in {{OOo}} Writer.6 KB (880 words) - 16:14, 2 September 2011
- <div style="float:right; margin-top: -45px;">[[image:Calc.png|50px]]</div> category=Documentation/How Tos/Calc3 KB (460 words) - 16:17, 30 March 2012
- ...umns. An array may be cells on a spreadsheet, or may be held internally by Calc. ...} )'''</tt>. If you enter the formula ‘normally’ by pressing '''Enter''', Calc will then evaluate the formula using a single value from the array as follo17 KB (2,989 words) - 07:20, 30 March 2012
- *[[Documentation/OOoAuthors User Manual/Calc Guide|Spreadsheets with {{OOo}} Calc]] - incomplete *[[Documentation/FAQ/Calc|Working with Spreadsheets (Calc)]]6 KB (614 words) - 17:28, 30 March 2012
- In addition to OpenDocument formats (.ods and .ots), Calc 3 can open the formats used by OOo 1.x (.sxc and .stc) and the followi In addition to OpenDocument formats (.ods and .ots), Calc 3 can save in these formats:7 KB (958 words) - 09:35, 9 April 2012
- ...o, although some details vary. See the chapters in this book about Writer, Calc, Draw, and Impress for descriptions of those details. ...convenient ways to quickly change some features. It is similar in Writer, Calc, Impress, and Draw, although each component includes some component-specifi8 KB (1,262 words) - 05:43, 14 April 2012
- <div style="float:right; margin-top: -45px;">[[image:Calc.png|50px]]</div> category=Documentation/How Tos/Calc4 KB (533 words) - 07:09, 30 March 2012
- ...clude>{{DISPLAYTITLE:База Знаний: Программирование. StarBASIC. </noinclude>Calc. Выделение и копирование нескольких стро2 KB (166 words) - 13:44, 24 March 2012
- * '''Export notes''': Exports notes in Writer and Calc documents as PDF notes. You may not want this!9 KB (1,404 words) - 09:16, 30 March 2012
- In addition to directly modifying cell content, {{OOo}} Calc also provides an interface that allows you to insert, delete, copy, or merg10 KB (1,544 words) - 18:05, 2 September 2011
- ==Application, Calc== ** For the time when a chart object hasn't been loaded yet, Calc has its own internal listener (ScChartListener) to load the chart if its da12 KB (1,858 words) - 06:55, 22 August 2011
- In addition to directly modifying cell content, {{OOo}} Calc also provides an interface that allows you to insert, delete, copy, or merg10 KB (1,543 words) - 09:01, 30 March 2012
- ...go}}[[Media:0105GS33-GettingStartedWithCalc.odt|Ch5 - Getting Started with Calc]] - 2010-11-16 (Nov 16) - 1 MB ...adding: 5px; font-size:120%; font-weight:bold; background-color: #CDDBF6;">Calc Guide - V3.3</div>11 KB (1,487 words) - 12:18, 14 April 2012
- The '''Format Cells''' dialog in {{OOo}} Calc provides an overview of the different formatting options for cells. ...ervice provides three text elements for the headers and footers of {{OOo}} Calc.21 KB (3,064 words) - 18:15, 2 September 2011
- The '''Format Cells''' dialog in {{OOo}} Calc provides an overview of the different formatting options for cells. ...ervice provides three text elements for the headers and footers of {{OOo}} Calc.21 KB (3,063 words) - 09:01, 30 March 2012
- ...go}}[[Media:0105GS33-GettingStartedWithCalc.pdf|Ch5 - Getting Started with Calc]] - 2010-11-16 (Nov 16) - 1MB ...adding: 5px; font-size:120%; font-weight:bold; background-color: #CDDBF6;">Calc Guide - V3.3</div>11 KB (1,560 words) - 10:57, 14 April 2012
- ;Calc:<tt>gm_p_Calc, gm_p_Calc_Bin, gm_p_Calc_Help, gm_p_Calc_Addins</tt>12 KB (1,864 words) - 07:20, 30 March 2012
- ** [[Calc]] (includes [[Chart]])4 KB (395 words) - 06:43, 30 March 2012
- For the Calc menu item '''Insert - Function list''', where the SlotID is 58991 and the ' where test area is: '''''Base''''', '''''Calc''''', '''''Chart''''', '''''Draw''''', '''''Framework''''', '''''Impress'''45 KB (6,864 words) - 10:23, 11 September 2011
- The following example shows how a text file separated by a comma in {{OOo}} Calc can be opened using the <tt>FilterName</tt> option. ...d. The <tt>Filtername</tt> property defines whether {{OOo}} uses a {{OOo}} Calc text filter to open files. The <tt>FilterOptions</tt> property contains the19 KB (2,911 words) - 12:13, 2 September 2011
- ...In Draw or Impress, open the dialog directly using '''Format > Area'''; in Calc and Writer, draw a temporary draw object and use the context menu of this o ...he boundaries of tables and sections (in Writer documents), page breaks in Calc, grid lines in Draw or Writer, and other features. In addition, you might p21 KB (3,378 words) - 20:45, 13 April 2012
- In Calc: ...pressions, you may find it easiest to study them in Writer rather than say Calc.27 KB (4,699 words) - 07:20, 30 March 2012
- ...text, table, and section boundaries (in Writer documents), page breaks in Calc, and grid lines in Draw or Writer. In addition, you might prefer different20 KB (3,194 words) - 07:09, 30 March 2012
- ....org/issues/show_bug.cgi?id=112427 112427] : Support Password to modify in calc and writer odf formats ** Description : The 'password to modify' feature is supported in writer and calc ODF-formats with this cws. No UI-related changes for UI of 'password to mod54 KB (7,681 words) - 14:03, 21 August 2011
- |Подвал для раздела Базы Знаний {{SecTitle|RU/kb/module/calc}}10 KB (677 words) - 17:38, 30 March 2012
- ...econsulting.com CalcLink] || A bi-directional link between Mathematica and Calc || commercial || [http://www.lauschkeconsulting.com Lauschke Consulting] ||39 KB (5,144 words) - 07:26, 21 August 2011
- |Zemin Gao || || gaozemin|| gaozm || Calc || [[Beijing Redflag Chinese 2000 Software Co., Ltd.|Beijing Redflag CH2000 | Jody Goldberg|| X || jodygoldberg||jody||[[Calc]] spreadsheet-ness||23 KB (3,093 words) - 14:45, 20 May 2011
- <!-- Обязательный элемент -->{{BreadCrumbL10n|RU/documentation/how_tos/calc}} [[Category:Calc]]14 KB (278 words) - 11:18, 25 August 2018