Libreoffice Calc, macro set Text Alignment Indent, or property documentation?
In Libreoffice Calc it is possible to use macro's to set the text properties of each cell, to format the layout and font. I was able to find some property names online, in code examples and forums.
oCell.CharHeight = 16
oCell.HoriJustify = com.sun.star.table.CellHoriJustify.CENTER
oCell.setPropertyValue("IsTextWrapped", True)
oCell.RotateAngle = 9000 ' rotate 90.00 degrees
' etc.
However, I can not find the macro code for some of the properties that are available in the GUI (right click, Format Cells). Specifically, I'm looking for macro code to set the "Text Alignment Indent" property.
I think I've found some documentation here, as it mentions .uno:AlignmentIndent and .uno:IncrementIndentValue but I have no clue on how to use this in a macro. I've tried guessing the property names using AlignmentIndent, setPropertyValue("TextAlignmentIndent", 10) etc. but all my guesses so far result in a runtime error:
BASIC runtime error. Property or method not found: AlignmentIndent
So my question is:
Is it possible to set the Text Alignment Indent using a macro?
Is there a way to find property names, where can I find documentation for Libreoffice macro's?
Is there a way to auto complete code when typing, similar to intellisense in VBA?
macros libreoffice libreoffice-calc
asked Jan 2 at 14:29
BdRBdR
1125
add a comment |
In Libreoffice Calc it is possible to use macro's to set the text properties of each cell, to format the layout and font. I was able to find some property names online, in code examples and forums.
oCell.CharHeight = 16
oCell.HoriJustify = com.sun.star.table.CellHoriJustify.CENTER
oCell.setPropertyValue("IsTextWrapped", True)
oCell.RotateAngle = 9000 ' rotate 90.00 degrees
' etc.
However, I can not find the macro code for some of the properties that are available in the GUI (right click, Format Cells). Specifically, I'm looking for macro code to set the "Text Alignment Indent" property.
I think I've found some documentation here, as it mentions .uno:AlignmentIndent and .uno:IncrementIndentValue but I have no clue on how to use this in a macro. I've tried guessing the property names using AlignmentIndent, setPropertyValue("TextAlignmentIndent", 10) etc. but all my guesses so far result in a runtime error:
BASIC runtime error. Property or method not found: AlignmentIndent
So my question is:
Is it possible to set the Text Alignment Indent using a macro?
Is there a way to find property names, where can I find documentation for Libreoffice macro's?
Is there a way to auto complete code when typing, similar to intellisense in VBA?
macros libreoffice libreoffice-calc
asked Jan 2 at 14:29
BdRBdR
1125
add a comment |
In Libreoffice Calc it is possible to use macro's to set the text properties of each cell, to format the layout and font. I was able to find some property names online, in code examples and forums.
oCell.CharHeight = 16
oCell.HoriJustify = com.sun.star.table.CellHoriJustify.CENTER
oCell.setPropertyValue("IsTextWrapped", True)
oCell.RotateAngle = 9000 ' rotate 90.00 degrees
' etc.
However, I can not find the macro code for some of the properties that are available in the GUI (right click, Format Cells). Specifically, I'm looking for macro code to set the "Text Alignment Indent" property.
I think I've found some documentation here, as it mentions .uno:AlignmentIndent and .uno:IncrementIndentValue but I have no clue on how to use this in a macro. I've tried guessing the property names using AlignmentIndent, setPropertyValue("TextAlignmentIndent", 10) etc. but all my guesses so far result in a runtime error:
BASIC runtime error. Property or method not found: AlignmentIndent
So my question is:
Is it possible to set the Text Alignment Indent using a macro?
Is there a way to find property names, where can I find documentation for Libreoffice macro's?
Is there a way to auto complete code when typing, similar to intellisense in VBA?
macros libreoffice libreoffice-calc
asked Jan 2 at 14:29
BdRBdR
1125
In Libreoffice Calc it is possible to use macro's to set the text properties of each cell, to format the layout and font. I was able to find some property names online, in code examples and forums.
oCell.CharHeight = 16
oCell.HoriJustify = com.sun.star.table.CellHoriJustify.CENTER
oCell.setPropertyValue("IsTextWrapped", True)
oCell.RotateAngle = 9000 ' rotate 90.00 degrees
' etc.
However, I can not find the macro code for some of the properties that are available in the GUI (right click, Format Cells). Specifically, I'm looking for macro code to set the "Text Alignment Indent" property.
I think I've found some documentation here, as it mentions .uno:AlignmentIndent and .uno:IncrementIndentValue but I have no clue on how to use this in a macro. I've tried guessing the property names using AlignmentIndent, setPropertyValue("TextAlignmentIndent", 10) etc. but all my guesses so far result in a runtime error:
BASIC runtime error. Property or method not found: AlignmentIndent
So my question is:
Is it possible to set the Text Alignment Indent using a macro?
Is there a way to find property names, where can I find documentation for Libreoffice macro's?
Is there a way to auto complete code when typing, similar to intellisense in VBA?
macros libreoffice libreoffice-calc
macros libreoffice libreoffice-calc
asked Jan 2 at 14:29
BdRBdR
1125
asked Jan 2 at 14:29
BdRBdR
1125
asked Jan 2 at 14:29
BdRBdR
1125
asked Jan 2 at 14:29
BdRBdR
1125
asked Jan 2 at 14:29
BdRBdR
1125
1125
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Is it possible to set the Text Alignment Indent using a macro?
Yes. You need to be setting com.sun.star.table.CellProperties. The property is:
ParaIndent
The indentation of the cell’s content (in 0.01 mm) as a Short Integer.
See below for source document.
Where can I find documentation for Libreoffice macro's?
At OpenOffice.org Macros Explained by Andrew Pitonyak [warning: pdf link].
answered Jan 2 at 14:58
DavidPostill♦DavidPostill
105k25227262
Thanks, but when I set oCell.ParaIndent = 10 there is no runtime error at least, but nothing happens. Also, is there any other documentation besides this PDF on a personal website?
– BdR
Jan 2 at 15:13
Sorry I see now the value is not in pt units like in the GUI but in 0.01 mm. For 10pt the corresponding value should be set to 353. Is there a better way to convert from pt to 0.01mm? So other thanoCell.ParaIndent = (10 * 35.28)?
– BdR
Jan 2 at 15:27
No idea. I don't really use the LibreOffice macros.
– DavidPostill♦
Jan 2 at 16:19
The PDF is actually a book, which the author is still working on. I don't know of any other such detailed documentation on macros.
– DavidPostill♦
Jan 2 at 16:23
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1389800%2flibreoffice-calc-macro-set-text-alignment-indent-or-property-documentation%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is it possible to set the Text Alignment Indent using a macro?
Yes. You need to be setting com.sun.star.table.CellProperties. The property is:
ParaIndent
The indentation of the cell’s content (in 0.01 mm) as a Short Integer.
See below for source document.
Where can I find documentation for Libreoffice macro's?
At OpenOffice.org Macros Explained by Andrew Pitonyak [warning: pdf link].
answered Jan 2 at 14:58
DavidPostill♦DavidPostill
105k25227262
Thanks, but when I set oCell.ParaIndent = 10 there is no runtime error at least, but nothing happens. Also, is there any other documentation besides this PDF on a personal website?
– BdR
Jan 2 at 15:13
Sorry I see now the value is not in pt units like in the GUI but in 0.01 mm. For 10pt the corresponding value should be set to 353. Is there a better way to convert from pt to 0.01mm? So other thanoCell.ParaIndent = (10 * 35.28)?
– BdR
Jan 2 at 15:27
No idea. I don't really use the LibreOffice macros.
– DavidPostill♦
Jan 2 at 16:19
The PDF is actually a book, which the author is still working on. I don't know of any other such detailed documentation on macros.
– DavidPostill♦
Jan 2 at 16:23
add a comment |
Is it possible to set the Text Alignment Indent using a macro?
Yes. You need to be setting com.sun.star.table.CellProperties. The property is:
ParaIndent
The indentation of the cell’s content (in 0.01 mm) as a Short Integer.
See below for source document.
Where can I find documentation for Libreoffice macro's?
At OpenOffice.org Macros Explained by Andrew Pitonyak [warning: pdf link].
answered Jan 2 at 14:58
DavidPostill♦DavidPostill
105k25227262
Thanks, but when I set oCell.ParaIndent = 10 there is no runtime error at least, but nothing happens. Also, is there any other documentation besides this PDF on a personal website?
– BdR
Jan 2 at 15:13
Sorry I see now the value is not in pt units like in the GUI but in 0.01 mm. For 10pt the corresponding value should be set to 353. Is there a better way to convert from pt to 0.01mm? So other thanoCell.ParaIndent = (10 * 35.28)?
– BdR
Jan 2 at 15:27
No idea. I don't really use the LibreOffice macros.
– DavidPostill♦
Jan 2 at 16:19
The PDF is actually a book, which the author is still working on. I don't know of any other such detailed documentation on macros.
– DavidPostill♦
Jan 2 at 16:23
add a comment |
Is it possible to set the Text Alignment Indent using a macro?
Yes. You need to be setting com.sun.star.table.CellProperties. The property is:
ParaIndent
The indentation of the cell’s content (in 0.01 mm) as a Short Integer.
See below for source document.
Where can I find documentation for Libreoffice macro's?
At OpenOffice.org Macros Explained by Andrew Pitonyak [warning: pdf link].
answered Jan 2 at 14:58
DavidPostill♦DavidPostill
105k25227262
Is it possible to set the Text Alignment Indent using a macro?
Yes. You need to be setting com.sun.star.table.CellProperties. The property is:
ParaIndent
The indentation of the cell’s content (in 0.01 mm) as a Short Integer.
See below for source document.
Where can I find documentation for Libreoffice macro's?
At OpenOffice.org Macros Explained by Andrew Pitonyak [warning: pdf link].
answered Jan 2 at 14:58
DavidPostill♦DavidPostill
105k25227262
answered Jan 2 at 14:58
DavidPostill♦DavidPostill
105k25227262
answered Jan 2 at 14:58
DavidPostill♦DavidPostill
105k25227262
answered Jan 2 at 14:58
DavidPostill♦DavidPostill
105k25227262
105k25227262
Thanks, but when I set oCell.ParaIndent = 10 there is no runtime error at least, but nothing happens. Also, is there any other documentation besides this PDF on a personal website?
– BdR
Jan 2 at 15:13
Sorry I see now the value is not in pt units like in the GUI but in 0.01 mm. For 10pt the corresponding value should be set to 353. Is there a better way to convert from pt to 0.01mm? So other thanoCell.ParaIndent = (10 * 35.28)?
– BdR
Jan 2 at 15:27
No idea. I don't really use the LibreOffice macros.
– DavidPostill♦
Jan 2 at 16:19
The PDF is actually a book, which the author is still working on. I don't know of any other such detailed documentation on macros.
– DavidPostill♦
Jan 2 at 16:23
add a comment |
Thanks, but when I set oCell.ParaIndent = 10 there is no runtime error at least, but nothing happens. Also, is there any other documentation besides this PDF on a personal website?
– BdR
Jan 2 at 15:13
Sorry I see now the value is not in pt units like in the GUI but in 0.01 mm. For 10pt the corresponding value should be set to 353. Is there a better way to convert from pt to 0.01mm? So other thanoCell.ParaIndent = (10 * 35.28)?
– BdR
Jan 2 at 15:27
No idea. I don't really use the LibreOffice macros.
– DavidPostill♦
Jan 2 at 16:19
The PDF is actually a book, which the author is still working on. I don't know of any other such detailed documentation on macros.
– DavidPostill♦
Jan 2 at 16:23
Thanks, but when I set oCell.ParaIndent = 10 there is no runtime error at least, but nothing happens. Also, is there any other documentation besides this PDF on a personal website?
– BdR
Jan 2 at 15:13
Thanks, but when I set oCell.ParaIndent = 10 there is no runtime error at least, but nothing happens. Also, is there any other documentation besides this PDF on a personal website?
– BdR
Jan 2 at 15:13
Sorry I see now the value is not in pt units like in the GUI but in 0.01 mm. For 10pt the corresponding value should be set to 353. Is there a better way to convert from pt to 0.01mm? So other than
oCell.ParaIndent = (10 * 35.28) ?– BdR
Jan 2 at 15:27
Sorry I see now the value is not in pt units like in the GUI but in 0.01 mm. For 10pt the corresponding value should be set to 353. Is there a better way to convert from pt to 0.01mm? So other than
oCell.ParaIndent = (10 * 35.28) ?– BdR
Jan 2 at 15:27
No idea. I don't really use the LibreOffice macros.
– DavidPostill♦
Jan 2 at 16:19
No idea. I don't really use the LibreOffice macros.
– DavidPostill♦
Jan 2 at 16:19
The PDF is actually a book, which the author is still working on. I don't know of any other such detailed documentation on macros.
– DavidPostill♦
Jan 2 at 16:23
The PDF is actually a book, which the author is still working on. I don't know of any other such detailed documentation on macros.
– DavidPostill♦
Jan 2 at 16:23
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1389800%2flibreoffice-calc-macro-set-text-alignment-indent-or-property-documentation%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
