Search results
From Apache OpenOffice Wiki
Page title matches
- {{DISPLAYTITLE: How do I format cells in Calc so that the rows number automatically?}} '''How do I format cells in Calc so that the rows number automatically?'''590 B (98 words) - 14:43, 2 October 2021
- [[Category:Documentation/FAQ/Calc/Formatting]]891 B (137 words) - 14:42, 2 October 2021
- will not be visible on, nor are they related to, the calc sheets themselves. [[Category:Documentation/FAQ/Calc/Formatting]]1 KB (251 words) - 14:40, 2 October 2021
- If you open such a formula into Calc, the formula looks like this: You need to save the database document with any changes made to it, and then manually refresh links perhaps by closing and reopening the sprea2 KB (249 words) - 16:49, 16 May 2021
- ...possible to open a Microsoft Excel file that is protected by a password in Calc?}} ...possible to open a Microsoft Excel file that is protected by a password in Calc?'''646 B (103 words) - 09:37, 6 October 2021
- {{DISPLAYTITLE: How do I insert external data into an existing Calc spreadsheet file?}} '''How do I insert external data into an existing Calc spreadsheet file?'''890 B (141 words) - 09:38, 6 October 2021
- ...f your ASCII file is not already named with a '''.txt''' extension, rename it that way. ...egal characters (in Writer), save (a copy of?) the file and reopen this in Calc, as "Text CSV".2 KB (367 words) - 10:35, 18 August 2022
- [[Category:Documentation/FAQ/Calc/Files]]423 B (60 words) - 09:36, 6 October 2021
- {{DISPLAYTITLE: Why does Calc refuse to open my .txt file?}} '''Why does Calc refuse to open my .txt file?'''1 KB (204 words) - 09:43, 6 October 2021
- {{DISPLAYTITLE: A large Calc spreadsheet was converted from another application. Some of my rows are mis '''A large Calc spreadsheet was converted from another application. Some of my rows are mis1 KB (164 words) - 09:49, 6 October 2021
- In OpenOffice.org 1.1.x, if you click in a cell, it is not selected, but focused. # Click on a cell to focus it920 B (165 words) - 14:43, 6 October 2021
- {{DISPLAYTITLE: Why does Calc print out all the sheets in the file?}} '''Why does Calc print out all the sheets in the file?'''593 B (93 words) - 10:03, 6 October 2021
- [[Category:Documentation/FAQ/Calc/Files]]954 B (155 words) - 09:44, 6 October 2021
- [[Category:Documentation/FAQ/Calc/Printing]]528 B (89 words) - 12:36, 6 October 2021
- ...rst create a new page style with the desired format options and then apply it to the [[Category:Documentation/FAQ/Calc/Printing]]1 KB (183 words) - 09:17, 19 May 2021
- [[Category:Documentation/FAQ/Calc/Printing]]1 KB (178 words) - 12:35, 6 October 2021
- ...eet is to be printed, or when several print ranges are associated with one Calc file.}} *[https://www.openoffice.org/documentation/HOW_TO/spreadsheet/calc5_EN.html How to Set the Printing Settings]4 KB (617 words) - 09:55, 6 October 2021
- [[Category:Documentation/FAQ/Calc/Charts]]488 B (81 words) - 13:42, 4 November 2008
- [[Category:Documentation/FAQ/Calc/Charts]]526 B (83 words) - 13:43, 4 November 2008
- You can do trendlines in Calc, but you can't show the equation of the line. To do that you need to do a l OpenOffice.org Version 1, Calc only really does linear.936 B (159 words) - 12:38, 6 October 2021
- When using Calc filters, selections that span a range of cells [[Category:Documentation/FAQ/Calc/Errors]]757 B (117 words) - 13:42, 6 October 2021
- ...tions option is not set under Tools - Options - OpenOffice Developer Build Calc - Calculate. * [[Documentation/FAQ/Calc/Errors/I_see_three_hash_signs_in_a_cell_that_formerly_held_data._How_can_I_4 KB (632 words) - 13:33, 6 October 2021
- # Select '''OpenOffice Calc - View''' (in OpenOffice.org 1.1.x: Spreadsheet - View) [[Category:Documentation/FAQ/Calc/Errors]]684 B (107 words) - 13:41, 6 October 2021
- Documentation/FAQ/Calc/Errors/How to get proper Calc Help files for OpenOffic.org 2.0.1 for Windows?{{DISPLAYTITLE: How to get proper Calc Help files for OpenOffic.org 2.0.1 for Windows?}} {{Documentation/Outdated}}443 B (62 words) - 13:46, 6 October 2021
- When the content of a cell is too long to be displayed in a single cell, it will * Go to the heading row and drag one of the column edges until it is wide enough to display your data properly if the cell content is a numbe857 B (160 words) - 13:39, 6 October 2021
- {{DISPLAYTITLE: How can I start {{AOo}} Calc instead of Writer?}} '''How can I start {{AOo}} Calc instead of Writer?'''487 B (72 words) - 14:48, 6 October 2021
- [[Category:Documentation/FAQ/Calc/Miscellaneous]]2 KB (343 words) - 14:37, 6 October 2021
- ...e to be protected.<br>If you only want to protect a small number of cells, it may be easier to clear the protection for all cells and the re-activate pro [[Category:Documentation/FAQ/Calc/Miscellaneous]]1 KB (212 words) - 13:53, 6 October 2021
- {{DISPLAYTITLE: How can I use cells from different Calc files?}} '''How can I use cells from different Calc files?'''681 B (107 words) - 14:49, 6 October 2021
- of the screen with the mouse and drag it to its new position. ....<br>You can even move the sheet to a different document that is opened in Calc.932 B (159 words) - 14:10, 6 October 2021
- * Double-click the sheet to rename it (OOo 3.1 and higher) [[Category:Documentation/FAQ/Calc/Miscellaneous]]549 B (83 words) - 14:08, 6 October 2021
- [[Category:Documentation/FAQ/Calc/Miscellaneous]]495 B (77 words) - 14:05, 4 November 2008
- In Calc, enter this function<br /> [[Category:Documentation/FAQ/Calc/Miscellaneous]]897 B (123 words) - 14:02, 6 October 2021
- [[Category:Documentation/FAQ/Calc/Miscellaneous]]508 B (83 words) - 14:46, 6 October 2021
- {{DISPLAYTITLE: How do I use regular expressions in Calc?}} '''How do I use regular expressions in Calc?'''389 B (54 words) - 14:04, 6 October 2021
- {{DISPLAYTITLE: How do I use arrays in Calc?}} '''How do I use arrays in Calc?'''336 B (49 words) - 15:48, 6 October 2021
- {{DISPLAYTITLE: Where do I find more detailed descriptions of Calc functions?}} '''Where do I find more detailed descriptions of Calc functions?'''449 B (63 words) - 14:45, 6 October 2021
- Please see the [https://wiki.openoffice.org/wiki/Documentation/How_Tos/Conditional_Counting_and_Summation Conditional Counting and Summati [[Category:Documentation/FAQ/Calc/Miscellaneous]]428 B (59 words) - 13:33, 17 March 2021
- {{DISPLAYTITLE: Where can I find more documentation for Calc?}} '''Where can I find more documentation for Calc?'''1,015 B (133 words) - 14:35, 6 October 2021
- {{DISPLAYTITLE: How can I extend the Calc functions by some extensions?}} '''How can I extend the Calc functions by some extensions?'''408 B (58 words) - 15:47, 6 October 2021
- If you press Delete in Calc, you get by default a Delete window that lets you delete formats, text, for # Choose {{menu|Tools|Customize}}, '''Keyboard''' tab. Be sure that the Calc radio button is selected.2 KB (286 words) - 13:54, 6 October 2021
- This FAQ comes from [https://openoffice.blogs.com Solveig Haugland's Blog] [[Category:Documentation/FAQ/Calc/Formatting]]1 KB (196 words) - 16:35, 16 May 2021
- This FAQ comes from [https://openoffice.blogs.com Solveig Haugland's Blog] [[Category:Documentation/FAQ/Calc/Miscellaneous]]662 B (93 words) - 14:39, 6 October 2021
Page text matches
- [[Category:FR/Documentation/FAQ/Calc]]2 KB (252 words) - 14:15, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc]]581 B (91 words) - 14:16, 5 May 2009
- ...umentation/How-to/calc/Notions_de_temps_avec_Calc.pdf Notion de temps avec Calc]. [[Category:FR/Documentation/FAQ/Calc]]739 B (106 words) - 14:17, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Impression]]1 KB (190 words) - 15:11, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc]]470 B (76 words) - 14:19, 5 May 2009
- Calc possède une application vraiment très pratique. Quand, par exemple, vous * Sélectionnez '''OpenOffice.org Calc''' > '''Liste de tris''' dans la boite de dialogue qui apparait.2 KB (357 words) - 14:20, 5 May 2009
- == Comment forcer Calc à faire un retour chariot sur la ligne du dessous et la cellule de gauche #* Dans la boite de dialogue, sélectionnez '''OpenOffice.org Calc''' > '''Général'''.2 KB (274 words) - 14:21, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc]]628 B (106 words) - 14:22, 5 May 2009
- ...choix "collage spécial" dans le menu contextuel du clic droit (comme sous Calc) ?== [[Category:FR/Documentation/FAQ/Writer|Edition]]684 B (92 words) - 11:18, 15 May 2009
- == Raccourcis claviers pour Calc == [[Category:FR/Documentation/FAQ/Calc]]9 KB (1,026 words) - 14:23, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc]]2 KB (303 words) - 14:27, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc]]754 B (103 words) - 15:04, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc]]516 B (73 words) - 15:05, 5 May 2009
- ...possible de le faire directement : ce fichier ne peut être ouvert par OOo Calc que si vous ôtez le mot de passe dans l'application d'origine. [[Category:FR/Documentation/FAQ/Calc]]430 B (71 words) - 15:06, 5 May 2009
- ...un fichier texte avec des champs séparés (*.txt, *.csv) dans un fichier Calc ? == [[Category:FR/Documentation/FAQ/Calc]]1 KB (197 words) - 19:53, 7 May 2009
- ...es fichiers texte d'extension autre que .CSV ou .TXT (.TAB, .PRN,...) avec Calc ? == ...e ce sont le plus souvent des fichiers tabulés de type CSV à ouvrir avec Calc.2 KB (341 words) - 14:31, 5 May 2009
- ...er la page (Portrait ou Paysage), voir la question [[Fr.openoffice.org/FAQ/Calc/100 |Comment peut-on choisir l'orientation de la feuille lors de l'impressi * Pour voir les limites de page, voir la question [[Fr.openoffice.org/FAQ/Calc/101|Est-il possible d'avoir une visualisation des limites de page comme dan3 KB (417 words) - 15:10, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Formatage]]1 KB (220 words) - 15:20, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Formatage]]1 KB (175 words) - 15:21, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Formatage]]2 KB (306 words) - 15:22, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Formatage]]798 B (140 words) - 15:22, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Formatage]]728 B (112 words) - 15:23, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Formatage]]746 B (115 words) - 15:23, 5 May 2009
- ...d'erreurs pour les feuilles de calcul dans la FAQ [[Fr.openoffice.org/FAQ/Calc/015 | 015]]. [[Category:FR/Documentation/FAQ/Calc|Erreur]]979 B (157 words) - 15:28, 5 May 2009
- ...formule fait directement ou indirectement référence à elle-même ; les itérations ne sont pas activées à l'entrée de menu Outils/Options/Classeur ...(financières) tendant vers une valeur donnée mais ne l'atteignant pas ou itérations de références en boucle n'arrivant pas à la modification minima5 KB (835 words) - 15:28, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Formules]]588 B (97 words) - 15:31, 5 May 2009
- ...AllChars préparé pour vous : FAQ de http://www.staroffice.online.fr/faq/FAQ.HTML et recherchez "virgule". [[Category:FR/Documentation/FAQ/Calc|Virgule]]2 KB (403 words) - 15:35, 5 May 2009
- * Dans la boite de dialogue qui apparait, sélectionnez '''OpenOffice.org Calc''' > '''Général'''. [[Category:FR/Documentation/FAQ/Calc|Diagramme]]501 B (71 words) - 15:39, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Diagramme]]2 KB (289 words) - 15:39, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Diagramme]]773 B (120 words) - 15:40, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Diagramme]]2 KB (285 words) - 15:41, 5 May 2009
- == Quelques règles concernant la mise à jour de cette FAQ == ...FAQ pour éviter autant que possible de modifier les liens des entrées de FAQ car ceux-ci sont souvent référencés par d'autres pages et d'autres sites3 KB (458 words) - 17:06, 21 May 2009
- * dans le tableur Calc, à la vision de la zone sélectionnée ; [[Category:FR/Documentation/FAQ/Generale]]564 B (91 words) - 19:56, 8 May 2009
- ==Comment importer des données d'une feuille HTML ou Calc et actualiser les données toutes les x secondes ?== Attention : cette méthode n'est possible que pour les fichiers HTML ou Calc.708 B (109 words) - 13:05, 5 May 2009
- ==J'ai une feuille Calc comme source de données, et elle n'affiche que les anciennes données :== ...e feuille de calcul, et que vous modifiez les données sous OpenOffice.org Calc, ces modifications ne sont pas reportées dans la vue de sources de donnée1 KB (210 words) - 13:06, 5 May 2009
- ==Est il possible de se connecter avec calc sur une base de donnée MySql installée chez mon provider ? Comment dans c [[Category: FR/Documentation/FAQ/Base]]524 B (89 words) - 13:17, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Impression]]629 B (94 words) - 15:19, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Impression]]2 KB (243 words) - 15:18, 5 May 2009
- ...ode échelle '''Réduire/agrandir l'impression''' comme expliqué [[FR/FAQ/Calc/110|ici]]. [[Category:FR/Documentation/FAQ/Calc|Impression]]1 KB (192 words) - 15:17, 5 May 2009
- Le fichier Calc fait 35 Ko et vous le trouverez sur cette page liée : [[Category:FR/Documentation/FAQ/Calc|Diagramme]]2 KB (272 words) - 15:42, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Impression]]665 B (96 words) - 15:16, 5 May 2009
- ...cul. Si aucune sélection n'est définie, suivez les instructions [[FR/FAQ/Calc/105|de cette question]]. [[Category:FR/Documentation/FAQ/Calc|Impression]]1 KB (182 words) - 15:14, 5 May 2009
- ...menssionnement en suivant la procédure expliquée [[Fr.openoffice.org/FAQ/Calc/104|à cette question]] (que cela soit par pourcentage ou nombre de pages). [[Category:FR/Documentation/FAQ/Calc|Impression]]2 KB (284 words) - 15:15, 5 May 2009
- ...ifférentes pour d'autres feuilles, cf. [[Fr.openoffice.org/FAQ/Calc/118 | FAQ 118]]. [[Category:FR/Documentation/FAQ/Calc|Impression]]568 B (78 words) - 15:13, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc]]476 B (75 words) - 14:32, 5 May 2009
- [[Category:FR/Documentation/FAQ/Calc|Formules]]425 B (67 words) - 15:33, 5 May 2009
- == Où est le solveur dans Calc ? == ...cro '''Fitoo''' de Laurent Godard disponible sur [http://fr.openoffice.org/Documentation/Outils/fitoo_fr.zip].2 KB (242 words) - 15:33, 5 May 2009
- ...Fr.openoffice.org/FAQ/Calc/100|orientation]] et le [[Fr.openoffice.org/FAQ/Calc/106| centrage]] éventuel. [[Category:FR/Documentation/FAQ/Calc|Impression]]813 B (115 words) - 15:17, 5 May 2009
- Lors de la frappe, Calc cherche automatiquement un mot commençant par les mêmes lettres ayant dé Pour Writer, cf. FAQ Writer [[Fr.openoffice.org/FAQ/Writer/005|005]].458 B (64 words) - 14:33, 5 May 2009
- See also [[FAQ (Base)| this page]] of Base FAQs and [https://web.archive.org/web/201003252 ...Dan Lewis’s excellent “Getting Started with Base” chapter, splitting it up to fit into this book’s outline and adding other material as needed—7 KB (1,146 words) - 13:53, 31 July 2022