in an existing chart the user can decide which should be the end of the data range, even if there empty cells in the selected range.
application example for this: monitoring a running measuring system which provide additional data every 20 s.
New data added by manual copy and paste via Notepad++ from the first data on.
There are some charts for different parameters to monitor at the same time.
how to reproduce:
create an (x-y-scatter)chart for some filled cells e.g. A1:B5
select data row x
extend the range beyond the filled cells, e.g. to A10 or more
the range will be shortened by calc nearly immediately after the input, if not before then at the time when you switch to the y-range to extend the range
this regression is true for all relases newer then LibreOffice 3.4.6
this behaviour is mentioned in Bug 47593 as point A
If I consider the test file from bug 47593 (https://bugs.freedesktop.org/attachment.cgi?id=58765), I think there is an easy workaround:
1/ set maximum for X and Y axis as automatic
2/ create a virtual last value for the chart
3/ add new values before the last one instead of after by inserting new cells
4/ if needed modify the X-value of the last virtual data point to extend the X-range.
Best regards. JBF
O.K. Testing the workaround with LO portable 18.104.22.168 and set the dummy value behind the chart range works. But let me try to explain my problem with this workaround:
Sorry I can't upload an example file because they contain customer data.
Last week I got a file with more than 12000 data rows in twelfe columns. Three diagrams with secondary y-axes for monitoring purposes of the system contain all data.
The measuring values are obtained calculating the slope of a mass against the cumulated volume. One chart per one measuring condition, that means a growing number of charts in one ods-file. In this case using dummy values is dangerous.
Because of that I had to stay with LO 3.4.6 at home pc and measuring computers. On my workplace pc I use the newest release, because there are no such growing data volumes to handle.
Best regards, ch
Thanks for the workaround. This bug has been driving me mad for months.
I can confirm this bug in Version 22.214.171.124 (Build ID: 58f22d5).
argln, we suffered from this bug for years and couldn't figure out what's the reason until i found this bug report. using a dummy value works too but that bug should really be fixed because it's very hard to track this down.
we're using calc for shopping lists with autofilter. of course some items won't have any numbers in front of them and calc then changes the data range :(
(In reply to comment #5)
> argln, we suffered from this bug for years and couldn't figure out what's
> the reason until i found this bug report. using a dummy value works too but
> that bug should really be fixed because it's very hard to track this down.
> we're using calc for shopping lists with autofilter. of course some items
> won't have any numbers in front of them and calc then changes the data range
sorry for replying to myself. this bug ends up in a logical problem in our usage. we use autofilter for empty/non-empty in column A to show/hide rows in column B. this can't work if anything empty is removed from the data range.
Hallo. Testing with the new releaese 126.96.36.199 (portable apps build)gives the same result as in all LO 3.5.x through 3.6.5 releases: the bug persists. Because of that, I set the keyword "regression". I forgot that in october. Since release 3.5.0 all users, which handle with growing data amounts in data sheets and charts, like measurement values and statistics are sidelined from the progress of LO. Exept users, which can apply the workaround from Jean-Baptiste.
Best regards, ch
This is related to the fix of Bug 39847
*** Bug 47593 has been marked as a duplicate of this bug. ***
I have found, that in Release 188.8.131.52 the bug is still existant. I also think it should be fixed asap!!
Improvements for this problem have been pushed as part of Bug 70609. Proper algorithm still needs some time.
(In reply to chemist56 from comment #7)
> Hallo. Testing with the new releaese 184.108.40.206 (portable apps build)gives the
> same result as in all LO 3.5.x through 3.6.5 releases: the bug persists.
> Because of that, I set the keyword "regression". I forgot that in october.
> Since release 3.5.0..
Bug predates start of bibisect, so
Whiteboard -> notBibisectable
Migrating Whiteboard tags to Keywords: (notBibisectable)
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.1.6 or 5.2.3 https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
Works for me. LO 5.2.6 x86/x64 on Windows 7, 8.1, 10.
Please have a look at comment 11 from Markus Mohrhard.
Best regards Ch