https://bugs.documentfoundation.org/show_bug.cgi?id=66250

--- Comment #10 from Alexander Kriegisch <alexan...@kriegisch.name> ---
I was waiting for this feature for around 15 years. This was the main knock-out
criterion for me to not use OpenOffice and later LibreOffice, because I heavily
rely on named ranges in Excel for auto-updating charts. So I was excited to see
that this is suppoed to be fixed now.

I tried to import some of my old Excel XLS files and was disappointed to see no
effect whatsoever. Then I inspected the Git commit and saw that the change
seems to affect only XSLX import. My Microsoft 365 subscription lately having
expired, I had to ask a friend to convert the files to XSLX for me. I
re-tested, and I can see the charts now.

Question: Was XLS import ignored on purpose or is that format somehow not being
supported first-class anymore?

Issues: If I change data in the table, the diagram is never updated. If I want
to edit the chart's data ranges, I get an error message asking me if I want to
create new ones because the existing ones are based on an internal table
(sorry, the message is in German on my system).

>From my perspective, this feature is not fully implemented yet. The idea was to
get support for dynamic data ranges, not a static snapshot copy of data. If I
want static charts, I do not need dynamic named ranges in the first place. I
suggest to reopen the issue.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to