https://bugs.documentfoundation.org/show_bug.cgi?id=154770
Bug ID: 154770
Summary: Calc should support different document types in
different sheets
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
It has bugged me for years that no major office suite does this so I figured I
should suggest it.
Imagine a calc document (I'm picking calc because it's already a multi-sheet
format), where some sheets, as now, are spreadsheets, but others are writer
documents, or impress presentations.
What I'm looking to do is create a spreadsheet to centralise and calculate
numeric data, and then use that data in a Writer document, without having to
manage multiple documents separately, and to make the links to the data simpler
to configure and keep up to date.
A trivial example: sheet 1 might have my day and mileage rates, product prices,
etc, sheet 2 would be a Writer document into which the various rates are
inserted inline into the text ("site visits charged at £xxx plus £x.xx/mile
travel costs"). When I turn the document into a PDF or print it, only the
writer sheet is included.
But this extends towards far more complex documents which reference data,
including reports etc.
Often this can be done badly by putting text and images into a spreadsheet
(="site visits charged at £"&$Sheet1.C5&" plus £"&$Sheet1.C6&"/mile travel
costs"), but imagine trying to put the two numbers in bold or a different
colour, and you see how limiting this is.
Given that the functionality is already contained in one executable it doesn't
even feel that hard to do (relative to the benefit it creates), and that over
the years I have seen countless Excel/Calc documents which have tried to do
this sort of thing with the existing functionality and you can see how much
work obviously went into achieving pretty poor results, I am surprised this has
never been done by Excel or Calc, maybe someone can tell me.
The only significant issue I can see is that Excel doesn't do it - is that
alone a reason for Calc not to do it?
--
You are receiving this mail because:
You are the assignee for the bug.
