Bug 152604 - ActiveSheet.ChartObjects.Count reports false numbers
Summary: ActiveSheet.ChartObjects.Count reports false numbers
Status: RESOLVED DUPLICATE of bug 111303
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-20 02:23 UTC by Stéphane Aulery
Modified: 2022-12-20 02:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
debug_document_2.xlsm (19.54 KB, application/zip)
2022-12-20 02:24 UTC, Stéphane Aulery
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stéphane Aulery 2022-12-20 02:23:48 UTC
Description:
ActiveSheet.ChartObjects.Count reports false numbers

Steps to Reproduce:
Hello,

I can reproduce this bug on Windows 7 with LO 6.0.6.2 and 7.4.3.2 (x64), but it was found on Debian with LO 5.4.0-1 and 3.4.3.

In fact there are 2 bugs in this example:

To reproduce execute sub ComputeTableSolaire() in Module1 of the VBAProject.

a) In sheet "Graphics Solaire" the graph is an object but in sheet "Cumul Solaire" the graph is really a graph. You can see it in the object navigator. If I insert a graph in the sheet "Graphics Solaire" with the menu Insert > Graph..., an object is inserted, not a graph. ChartObjects.Count return 0 on sheet "Graphics Solaire" and 1 on sheet "Cumul Solaire".

b) The name property on a Chart object return an empty string.

Regards,

-- 
Stéphane Aulery

Actual Results:
a) ActiveSheet.ChartObjects.Count always return 0.

b) The name property on a Chart object return an empty string.

Expected Results:
a) ActiveSheet.ChartObjects.Count should report 1 in both cases.

b) The name property on a Chart object should return the cart name.


Reproducible: Always


User Profile Reset: No

Additional Info:
See the file attached which reproduces the behavior.
Comment 1 Stéphane Aulery 2022-12-20 02:24:50 UTC
Created attachment 184252 [details]
debug_document_2.xlsm
Comment 2 Stéphane Aulery 2022-12-20 02:27:30 UTC

*** This bug has been marked as a duplicate of bug 111303 ***