Difference between revisions of "Documentation/How Tos/Calc: REPT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Difference between REPT and CONCATENATE) |
m |
||
| (9 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
| − | __NOTOC__ | + | {{DISPLAYTITLE:REPT function}} |
| + | {{Documentation/CalcFunc TextTOC | ||
| + | |ShowPrevNext=block | ||
| + | |PrevPage=Documentation/How_Tos/Calc:_REPLACE_function | ||
| + | |NextPage=Documentation/How_Tos/Calc:_RIGHT_function | ||
| + | }}__NOTOC__ | ||
== REPT == | == REPT == | ||
| − | returns a text string | + | returns a text string which includes repetitions of another text string. |
=== Syntax: === | === Syntax: === | ||
| Line 9: | Line 14: | ||
=== Example: === | === Example: === | ||
| − | * <tt>'''REPT("ha"; | + | * <tt>'''REPT("ha"; 7)'''</tt> |
| − | :: returns <tt>''' | + | :: returns <tt>'''hahahahahahaha'''</tt>! |
* <tt>'''REPT(ROUND(RAND()*10); 3)'''</tt> | * <tt>'''REPT(ROUND(RAND()*10); 3)'''</tt> | ||
:: returns <tt>'''nnn'''</tt> where <tt>'''n'''</tt> is a random digit repeated three times, while: | :: returns <tt>'''nnn'''</tt> where <tt>'''n'''</tt> is a random digit repeated three times, while: | ||
| Line 16: | Line 21: | ||
:: returns <tt>'''xyz'''</tt> where <tt>'''x'''</tt>, <tt>'''y'''</tt>, <tt>'''z'''</tt> are three randomly independent digits. | :: returns <tt>'''xyz'''</tt> where <tt>'''x'''</tt>, <tt>'''y'''</tt>, <tt>'''z'''</tt> are three randomly independent digits. | ||
| − | + | {{SeeAlso|EN| | |
| − | + | * [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]] | |
| − | + | * [[Documentation/How_Tos/Calc: Text functions|Text functions]] | |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
| + | [[Category: Documentation/Reference/Calc/Text functions]] | ||
Latest revision as of 15:36, 2 February 2024
REPT
returns a text string which includes repetitions of another text string.
Syntax:
REPT(text; number)
- returns number copies of text, joined together.
Example:
- REPT("ha"; 7)
- returns hahahahahahaha!
- REPT(ROUND(RAND()*10); 3)
- returns nnn where n is a random digit repeated three times, while:
- CONCATENATE(ROUND(RAND()*10); ROUND(RAND()*10); ROUND(RAND()*10))
- returns xyz where x, y, z are three randomly independent digits.
- returns nnn where n is a random digit repeated three times, while:
See Also
