[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

--- Comment #12 from Timur  ---
Upon testing, I see this:
1. named ranges from XLSX are imported and saved (bug 64086);
2. named range are updated correctly if we modify the values in cells;

*but* the following issues remain for new bugs:

3. if we create chart with data including named range, they will not be used
automatically (as in MSO where cell reference in the formula will change to
their defined names automatically); 
4. if we change the Named range, the chart is not updated;
5. named ranges are not exported in ODS;
6. named ranges are opened for XLS but lost when saving to XLS, so chart on
reopen is wrong.

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

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

--- Comment #11 from Timur  ---
(In reply to Alexander Kriegisch from comment #10)
> Question: Was XLS import ignored on purpose or is that format somehow not
> being supported first-class anymore?
LO is volunteer based and devs choose what they do. Nisz, which resolved this,
is contributing to OOXML. 
Xlsx and Xls are different filters and we usually open different bugs. So,
please open a bug for Xls and link to bug 64086.

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

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

--- Comment #10 from Alexander Kriegisch  ---
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.

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

--- Comment #9 from Timur  ---
Please add to https://wiki.documentfoundation.org/ReleaseNotes/7.3.

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

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

NISZ LibreOffice Team  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #8 from NISZ LibreOffice Team  ---
Verified in:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: f98796df322d89912070c8e431c5f6d1283f
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded

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

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Balázs Varga  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

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

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

--- Comment #7 from Commit Notification 
 ---
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/233286df08aeedb4e228fd523365b94543b16fca

tdf#64086 tdf#143623 tdf#66250 XLSX: fix named ranges in charts

It will be available in 7.3.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

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

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:7.3.0

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

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Balázs Varga  changed:

   What|Removed |Added

   Assignee|varga.bala...@nisz.hu   |libreoffice-b...@lists.free
   ||desktop.org
 Status|ASSIGNED|NEW

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Balázs Varga  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |varga.bala...@nisz.hu
   |desktop.org |
 Status|NEW |ASSIGNED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

NISZ LibreOffice Team  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=14
   ||0489

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Ulrich Windl  changed:

   What|Removed |Added

 CC||ulrich.wi...@rz.uni-regensb
   ||urg.de

--- Comment #6 from Ulrich Windl  ---
Still no fix after 7 years? I think named ranges are rather useless if they
cannot be used in charts.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

NISZ LibreOffice Team  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||8108

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

 CC||uwag...@posteo.de

--- Comment #5 from Timur  ---
*** Bug 132647 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Timur  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=64
   ||086

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Regina Henschel  changed:

   What|Removed |Added

 CC||rb.hensc...@t-online.de

--- Comment #4 from Regina Henschel  ---
This issue is connected to bug 64086. The missing ODF feature is handled in
https://issues.oasis-open.org/browse/OFFICE-2081

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

--- Comment #3 from Pedro pedl...@gmail.com ---
(In reply to comment #2)
 Inserting a new row beneath the last row will then automatically update the
 chart as expected. Same effect if inserting a new row prior to first row of
 data.

Thanks. I already do that. But I hope that someone actually adds this feature.
It doesn't make sense that you can use Named ranges for some features but not
for others. It's inconsistent and unintuitive ;)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Owen Genat owen.ge...@gmail.com changed:

   What|Removed |Added

   See Also||https://issues.apache.org/o
   ||oo/show_bug.cgi?id=64604
Version|unspecified |Inherited From OOo

--- Comment #1 from Owen Genat owen.ge...@gmail.com ---
Added related Apache OO issue to See Also list. Version set to Inherited from
OOo.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

--- Comment #2 from Owen Genat owen.ge...@gmail.com ---
A workaround is to select an additional empty row (above and below) for the
Data Range and ensure this option is selected: 

Tools  Options  LibreOffice Calc  General  Input Setting  Expand
references when new columns/rows are inserted

Inserting a new row beneath the last row will then automatically update the
chart as expected. Same effect if inserting a new row prior to first row of
data.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 66250] Use a Named range as data source for Chart

[bugzilla-daemon]

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

Jorendc jore...@libreoffice.org changed:

   What|Removed |Added

   Severity|normal  |enhancement
Summary|Enhancement request: Use a  |Use a Named range as data
   |Named range as data source  |source for Chart
   |for Chart   |

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs