Libre Calc 'B5' shows #NAME? when using OpenPyxl
0
PROBLEM: Why Libre Calc 'B5' shows "#NAME?" not the amount 110?
I wrote Python using OpenPyxl
from openpyxl import Workbook
wb = Workbook()
cashbook = wb.active
Receipts = wb.create_sheet('Cashbook Receipts')
Receipts['B4'] = 100
Receipts['E4'] = 10
Balance_Sheet = wb.create_sheet('Balance Sheet')
Balance_Sheet['B5'].value = "=$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4"
wb.save('test.xlsx')
In Libre Calc it shows as below.
https://i.stack.imgur.com/3xkKw.png
What happened? what did I do wrong?
python python-3.x openpyxl libreoffice-calc
asked Nov 24 '18 at 16:19
smileymikesmileymike
128319
|
show 3 more comments
0
PROBLEM: Why Libre Calc 'B5' shows "#NAME?" not the amount 110?
I wrote Python using OpenPyxl
from openpyxl import Workbook
wb = Workbook()
cashbook = wb.active
Receipts = wb.create_sheet('Cashbook Receipts')
Receipts['B4'] = 100
Receipts['E4'] = 10
Balance_Sheet = wb.create_sheet('Balance Sheet')
Balance_Sheet['B5'].value = "=$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4"
wb.save('test.xlsx')
In Libre Calc it shows as below.
https://i.stack.imgur.com/3xkKw.png
What happened? what did I do wrong?
python python-3.x openpyxl libreoffice-calc
asked Nov 24 '18 at 16:19
smileymikesmileymike
128319
Your code ist contradict to what you explaine. Edit your Question and provide a Minimal, Complete, and Verifiable example.
– stovfl
Nov 24 '18 at 18:40
I reprhrase the challenge of overcoming #NAME? hope this is clearly explain to anybody
– smileymike
Nov 25 '18 at 13:54
I can confirm, using openpyxl: 2.4.1 - LibreOffice: 5.2.7.2*. Seems a LibreOffice bug
– stovfl
Nov 25 '18 at 14:52
Thank you for answer, LIbreOffice Version: 6.0.6.2. How I find out what version of openpyxl do I have? Also I tried to save in xls, " quotation mark have moved after the = equal symobol as it turned into ="$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4" .
– smileymike
Nov 25 '18 at 15:33
print(openpyxl.__version__)
– stovfl
Nov 25 '18 at 15:59
|
show 3 more comments
0
0
0
PROBLEM: Why Libre Calc 'B5' shows "#NAME?" not the amount 110?
I wrote Python using OpenPyxl
from openpyxl import Workbook
wb = Workbook()
cashbook = wb.active
Receipts = wb.create_sheet('Cashbook Receipts')
Receipts['B4'] = 100
Receipts['E4'] = 10
Balance_Sheet = wb.create_sheet('Balance Sheet')
Balance_Sheet['B5'].value = "=$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4"
wb.save('test.xlsx')
In Libre Calc it shows as below.
https://i.stack.imgur.com/3xkKw.png
What happened? what did I do wrong?
python python-3.x openpyxl libreoffice-calc
asked Nov 24 '18 at 16:19
smileymikesmileymike
128319
PROBLEM: Why Libre Calc 'B5' shows "#NAME?" not the amount 110?
I wrote Python using OpenPyxl
from openpyxl import Workbook
wb = Workbook()
cashbook = wb.active
Receipts = wb.create_sheet('Cashbook Receipts')
Receipts['B4'] = 100
Receipts['E4'] = 10
Balance_Sheet = wb.create_sheet('Balance Sheet')
Balance_Sheet['B5'].value = "=$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4"
wb.save('test.xlsx')
In Libre Calc it shows as below.
https://i.stack.imgur.com/3xkKw.png
What happened? what did I do wrong?
python python-3.x openpyxl libreoffice-calc
python python-3.x openpyxl libreoffice-calc
asked Nov 24 '18 at 16:19
smileymikesmileymike
128319
asked Nov 24 '18 at 16:19
smileymikesmileymike
128319
edited Nov 25 '18 at 13:51
smileymike
asked Nov 24 '18 at 16:19
smileymikesmileymike
128319
asked Nov 24 '18 at 16:19
smileymikesmileymike
128319
asked Nov 24 '18 at 16:19
smileymikesmileymike
128319
128319
Your code ist contradict to what you explaine. Edit your Question and provide a Minimal, Complete, and Verifiable example.
– stovfl
Nov 24 '18 at 18:40
I reprhrase the challenge of overcoming #NAME? hope this is clearly explain to anybody
– smileymike
Nov 25 '18 at 13:54
I can confirm, using openpyxl: 2.4.1 - LibreOffice: 5.2.7.2*. Seems a LibreOffice bug
– stovfl
Nov 25 '18 at 14:52
Thank you for answer, LIbreOffice Version: 6.0.6.2. How I find out what version of openpyxl do I have? Also I tried to save in xls, " quotation mark have moved after the = equal symobol as it turned into ="$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4" .
– smileymike
Nov 25 '18 at 15:33
print(openpyxl.__version__)
– stovfl
Nov 25 '18 at 15:59
|
show 3 more comments
Your code ist contradict to what you explaine. Edit your Question and provide a Minimal, Complete, and Verifiable example.
– stovfl
Nov 24 '18 at 18:40
I reprhrase the challenge of overcoming #NAME? hope this is clearly explain to anybody
– smileymike
Nov 25 '18 at 13:54
I can confirm, using openpyxl: 2.4.1 - LibreOffice: 5.2.7.2*. Seems a LibreOffice bug
– stovfl
Nov 25 '18 at 14:52
Thank you for answer, LIbreOffice Version: 6.0.6.2. How I find out what version of openpyxl do I have? Also I tried to save in xls, " quotation mark have moved after the = equal symobol as it turned into ="$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4" .
– smileymike
Nov 25 '18 at 15:33
print(openpyxl.__version__)
– stovfl
Nov 25 '18 at 15:59
Your code ist contradict to what you explaine. Edit your Question and provide a Minimal, Complete, and Verifiable example.
– stovfl
Nov 24 '18 at 18:40
Your code ist contradict to what you explaine. Edit your Question and provide a Minimal, Complete, and Verifiable example.
– stovfl
Nov 24 '18 at 18:40
I reprhrase the challenge of overcoming #NAME? hope this is clearly explain to anybody
– smileymike
Nov 25 '18 at 13:54
I reprhrase the challenge of overcoming #NAME? hope this is clearly explain to anybody
– smileymike
Nov 25 '18 at 13:54
I can confirm, using openpyxl: 2.4.1 - LibreOffice: 5.2.7.2*. Seems a LibreOffice bug
– stovfl
Nov 25 '18 at 14:52
I can confirm, using openpyxl: 2.4.1 - LibreOffice: 5.2.7.2*. Seems a LibreOffice bug
– stovfl
Nov 25 '18 at 14:52
Thank you for answer, LIbreOffice Version: 6.0.6.2. How I find out what version of openpyxl do I have? Also I tried to save in xls, " quotation mark have moved after the = equal symobol as it turned into ="$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4" .
– smileymike
Nov 25 '18 at 15:33
Thank you for answer, LIbreOffice Version: 6.0.6.2. How I find out what version of openpyxl do I have? Also I tried to save in xls, " quotation mark have moved after the = equal symobol as it turned into ="$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4" .
– smileymike
Nov 25 '18 at 15:33
print(openpyxl.__version__)– stovfl
Nov 25 '18 at 15:59
print(openpyxl.__version__)– stovfl
Nov 25 '18 at 15:59
|
show 3 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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
});
}
});
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53460069%2flibre-calc-b5-shows-name-when-using-openpyxl%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53460069%2flibre-calc-b5-shows-name-when-using-openpyxl%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
Your code ist contradict to what you explaine. Edit your Question and provide a Minimal, Complete, and Verifiable example.
– stovfl
Nov 24 '18 at 18:40
I reprhrase the challenge of overcoming #NAME? hope this is clearly explain to anybody
– smileymike
Nov 25 '18 at 13:54
I can confirm, using openpyxl: 2.4.1 - LibreOffice: 5.2.7.2*. Seems a LibreOffice bug
– stovfl
Nov 25 '18 at 14:52
Thank you for answer, LIbreOffice Version: 6.0.6.2. How I find out what version of openpyxl do I have? Also I tried to save in xls, " quotation mark have moved after the = equal symobol as it turned into ="$'Cashbook Receipts'.$B$4+$'Cashbook Receipts'.$E$4" .
– smileymike
Nov 25 '18 at 15:33
print(openpyxl.__version__)– stovfl
Nov 25 '18 at 15:59