[Solved] Traces not aligned with cell center on large documents

Discuss the spreadsheet application
Post Reply
Acidello
Posts: 13
Joined: Thu Nov 19, 2020 12:51 am

[Solved] Traces not aligned with cell center on large documents

Post by Acidello »

Hi everyone!
Thanks in advance for your time (also in my previous posts) :D

I have a very large spreadsheet (3000 rows) and I notice a visual offset of the traces (both starting points and arrow tips) which get progressively further down/left compared to the center of the cell they are referring to, the more the row/column number increases.
I attached a picture of what I mean, as reference.

You can see that the blue dots aren't aligned with the zeroes, being instead offset to the bottom and left.
The rows in the screenshot are around 1900+ and the columns are about AZ+ in fact the vertical offset is larger than the horizontal one.
I attach the .ods file as well for further details if needed (sending a link as it was too large to attach).

https://drive.google.com/file/d/1MWiFIc ... sp=sharing

I haven't found reports about similar issues online. I really need to see cell references with precision as I browse my spreadsheet and having this offset makes things a bit difficult for me. I was wondering if there is a way to prevent it.

Thank you again for your time in reading, and to those who'll answer :D
Attachments
OOo.Traces.png
OOo.Traces.png (29.45 KiB) Viewed 625 times
Last edited by Acidello on Thu Aug 25, 2022 6:26 pm, edited 1 time in total.
Openoffice 4.1.13
Windows 10
User avatar
Hagar Delest
Moderator
Posts: 32667
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Traces not aligned with cell center on large documents

Post by Hagar Delest »

I have not checked with LIbreOffice, perhaps it does better.
Else, you should file a bug report. But there is hardly any development with AOO so far.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Traces not aligned with cell center on large documents

Post by John_Ha »

AOO is walking dead so this will never be fixed.

If it works in LO (and even if it is no better in LO) now would be a good time to migrate to the almost identical LibreOffice.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Acidello
Posts: 13
Joined: Thu Nov 19, 2020 12:51 am

Re: Traces not aligned with cell center on large documents

Post by Acidello »

Thanks for both your answers! :-D

I see the bug has been already reported on an older Oo version:
https://bz.apache.org/ooo/show_bug.cgi?id=83644

Also, since it is no more possible to create Bugzilla accounts (https://bz.apache.org/ooo/createaccount.cgi) I don't think there's much I can do.

I'll mark the post as [Solved] since there is nothing else to say in this regard.
Openoffice 4.1.13
Windows 10
Post Reply