LibO 3.5.7, WinXP. When sorting lines containing cells that are referenced to
(absolute reference - with $) either inside or outside the lines being
sorted, the reference remains to the same location rather than follow the
moved cell. For example, cell N55 contains a formula: =$N$37 with value
11.1. Perform a sort on block A3:Z40. The value of cell N55 (outside the
sorted block) will change to the new value at N37. Instead the value should
remain the same, and the absolute reference should change to the new
(sorted) location of the cell that used to be at N37.
--
View this message in context:
http://nabble.documentfoundation.org/Calc-does-not-respect-absolute-cell-references-when-sorting-tp4015514.html
Sent from the Dev mailing list archive at Nabble.com.
Context
- Calc does not respect absolute cell references when sorting · libremax
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.