Age | Commit message (Collapse) | Author | Files | Lines |
|
This commit adds a new pivot table layout dialog which was implemented
from scratch. Instead of custom controls this one uses list boxes
for field entries which greatly reduces the code. It also fixes
some visual and behaviour bugs and adds the possibility to edit the
"Data" field.
Change-Id: I6c01252acee5a2e8910e40e65904504d00e03057
|
|
the buttons remain too narrow, but that seems to be the case for all
the formula buttons
Change-Id: Ib7ecc6dffeed23459eddb1fc98140faf1a26296d
|
|
Change-Id: I294a8ff5070af20403ec103ad4420a6e12a97561
|
|
Change-Id: Ie6443fd9b1ac6332b4937c4b6b5d565cca1fe612
|
|
Determines how to treat text when encountered as operand in an arithmetic
operation or as argument to a function that expects a number instead.
Selectable under Tools->Options->Calc->Formula "Detailed calculation settings"
"Custom" from "Conversion from text to number" are:
Generate #VALUE! error: =1+"1" or =1+"x" give #VALUE!
Treat as zero: =1+"1" or =1+"x" give 1
Convert only unambiguous: =1+"1" gives 2, but =1+"1.000" or =1+"x" give #VALUE!
Convert also locale dependent: =1+"1.000" may be 2 or 1001 ... =1+"x" gives #VALUE!
For "Generate #VALUE! error" and "Treat as zero" the "Treat empty string as
zero" option follows these settings, for "Convert only unambiguous" and
"Convert also locale dependent" it can be set independently.
When reading documents created by other spreadsheet applications or older
versions of LibreOffice, and to interchange documents between different locales
the "Convert only unambiguous" with "Treat empty string as zero = True" setting
is recommended, though LibreOffice so far acted as "Convert also locale
dependent" with "Treat empty string as zero = False", which is the reason that
option is kept as default.
The best setting to create new documents that can be interpreted by all
spreadsheet applications without on-the-fly string conversion is
"Generate #VALUE! error". Not having to convert strings during
calculation ist also faster, of course.
Change-Id: Ie6dc34a00a82064a2d862b2178ce715fab945f85
|
|
R for Row, C for Column, P for Page, and D for Data fields.
Change-Id: I4e29fcdf77a17498d9325a09f0b21154cab04f83
|
|
the key piece though is that labels that have mnemonic targets
are always candidates for getting mnemonics generated for them
Change-Id: Ie4bcbc18e94467936f40875c749cd22793021d0c
|
|
Change-Id: I795d296bae700d1e3a273fbe71fc842d145c5138
|
|
this dialog is hauntingly similar to the writer
one, a copy and paste job
Change-Id: Ic873038dba4ca4fd737690b917f6cd0d5144218a
|
|
Change-Id: I3c6256f1b2d176790a8eb7c094c1583ce053971b
Reviewed-on: https://gerrit.libreoffice.org/8382
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
|
|
Change-Id: Ie940352828a9b58d35dd1644d030d6fb5b72d386
|
|
especially relative positions were relative
to the dialog which was assumed to be then
a direct parent of the widgets so that
a simple calculation could make the positions
relative to the widgets
also now the pivot table fits into a 768 pixel high
screen
Change-Id: I86a4155439872e8273943b90f15320e560e237a4
|
|
pimped up dialog a bit, added mnemonics
Change-Id: I4585d9a3a1c96b45c7eedea8a5be41ec717139dd
|
|
Change-Id: Iecccfbcd6b1eaec9d14c594812293c3e2acfda46
|
|
Change-Id: I29397e454e30bff98644f0c9e0f3a8e00547af1b
|
|
Extending f25cdaa78d5e7d200fbaf31cce9895bab7c5ee63
"fdo#74132: Do not interrupt search in Writer." for Calc.
Change-Id: I3a7e5070300993d2811a79f17cb1b2edb0355c44
|
|
Change-Id: I66f7fe04155ad4c6e42e6aa96bb2db71ba4f682f
|
|
Change-Id: Iecca542c2c425a34184ba2c3ae0e34d093fa6a06
|
|
Change-Id: Ic94ed52bbe0e5c612258fa56a970d61de0972eb3
|
|
Change-Id: I7ae80079f4bd5fed1234753b521a680498ec43e1
|
|
Change-Id: Iaf20b6d2306ba76f21cb5f7be231f40b403c790a
|
|
Change-Id: Iee2eaf89f662b61fc4ec32b353b13417ee6b2610
|
|
Change-Id: Ibe782ed765a20adb34bb6ddd226c3d5ed328e810
|
|
Change-Id: I08abe30a259014ba33bcad63a40198baa1099893
|
|
Change-Id: Ie79ea86509004dc149cda2316c07cd7db9b339a4
|
|
Change-Id: I60b74cecc17352681fac7dfa0e41114515dbd6f5
|
|
Change-Id: I67c54ae9cee0a57baf900c80f50b28572bc9465b
|
|
Change-Id: I85b89c59c3545aef538da47a3d3727110cff4a82
|
|
Change-Id: I94e39f29c2920eea57262cf047f899eb0bbe62c4
|
|
Change-Id: I4ac7fb3a13cdc03d3c75cdd730bf39a7d814de99
|
|
Change-Id: I68da93c1227e8140511f3ad4071c87b3cf0443c0
|
|
the wrapper dialog not the list contained within
Change-Id: I4f4793888885ec5d991f1ab4218cc371726558e6
|
|
in calc->view options and that the checkbox entries cannot when options pane
isn't wide enough to fit everything in (fr). Necessitates swapping columns so
the stretching/shrinking column can be centered horizontally for e.g. en to
remain pretty.
Change-Id: I1402183b6ad0989af676a3472c8bf4d2b9c94ea8
|
|
calc compatibility page (e.g. de)
Change-Id: Ieab742900747808a4c27205b190e416b391b7a39
|
|
Calc general page (e.g. .de)
Change-Id: Ifc5c230040c9b59f8570a64deda0121ac93ed0e9
|
|
Change-Id: I46c5290ab411ac133ef8ea1e461197b00d837068
|
|
Change-Id: I47b0b0abd3cbb992b93cd1db10558fed579e4f1c
|
|
and that's the last TabDialog in calc converted
Change-Id: Idecf1b4ba991f7b59e40ea0f0813a5dc5644dfd3
|
|
Change-Id: I305b18bea24377dcd98b3e06c4cf75bdbdd4d717
|
|
Change-Id: I97940629f93a5a1948a8771b9d9668bc28c49a91
|
|
Change-Id: I4e58c86aa85b2e1639a047b07156b62c9900153c
|
|
Change-Id: I319210233dd1b71f6e717c7322b953de8f093150
|
|
Change-Id: I259f7d75591121be584e3a8cfe514232a404c0fa
|
|
Change-Id: Ia9062a21afde96510a4953d1b51e7e59e9012fb7
|
|
Change-Id: I121d4abd3227b96a274f1983e61ca313728419f7
|
|
Change-Id: Ib6bd84e48086a28210be7fa67b8adb211276cc0d
|
|
I'd be a bit happier if I know how to use the dialog in order
to test it completely, but it should be unchanged.
Change-Id: Ie9c561aef7ff697b9e829f9cf0c7e6938c58b217
|
|
Change-Id: If1789999363739231986e0e0e82c9d77f5ca0bc7
Reviewed-on: https://gerrit.libreoffice.org/7192
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>
|
|
Change-Id: Ib7be4172e2d9b80869dbfa47674b13f1e03877d3
|
|
Change-Id: Iccd4f2c8b628589c6a184cc561a1e6225c1a9441
|