[sc-issues] [Issue 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 13:38:22 + 2008 --- discoleo - pgan How is this different than creating the spreadsheet table inside a Writer document? Writer is NOT a spreadsheet, so IF the user needs to work inside a spreadsheet, then he CAN NOT work within Writer. Anyone who has worked professionally with a spreadsheet will understand these requirements. REASONS === - Important functionality is MISSING - REDUCED screen-size [a lot of unhelpful margins] - 2-dimensional flow outside the page [both right-side and bottom of the page] There are many more, including that I can NOT embed a spreadsheet currently in OOo-dev300 m35. Will have to check this more thoroughly if it is a different error. For a real life example, see also the xls-based Exception Report available from the following NHS-site (Britain's National Health Service): [shortened url: http://tinyurl.com/68tnvm] http://www.ic.nhs.uk/cmsincludes/_process_document.asp?sPublicationID=1225147131677sDocID=4318 http://www.ic.nhs.uk/statistics-and-data-collections/audits-and-performance/the-quality-and-outcomes-framework/the-quality-and-outcomes-2007-08-exception-report I will add also a screenshot. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 13:42:53 + 2008 --- Created an attachment (id=58597) Real Life Example (NHS Spreasdsheet) showing a Spreadsheet Header covering most of the upper half of the screen. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 --- Additional comments from [EMAIL PROTECTED] Fri Nov 21 02:32:16 + 2008 --- How is this different than creating the spreadsheet table inside a Writer document? That would allow putting text and pictures and spreadsheet tables anywhere in the document. I do agree that much of the UI in Numbers makes manipulations easier and should be adopted. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 --- Additional comments from [EMAIL PROTECTED] Tue May 6 16:40:47 + 2008 --- This might be in part a duplicate of Issue 8664... - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 --- Additional comments from [EMAIL PROTECTED] Tue May 6 18:46:53 + 2008 --- This might be in part a duplicate of Issue 8664... This is actually a much more comprehensive extension of issue 8664. Instead of allowing some workaround by adding only a logo to a header / footer, this issue intends actually to split the whole non-table information from the table-layer, in line e.g. with Apple's Numbers: see e.g. this iWorks tutorial http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov You can add a lot of objects to the spreadsheet in Numbers, including images, text, ... These objects are outside the table, and therefore do NOT interfere with the table data and operations. Also, most professional spreadsheets will have a comprehensive header only on the first page (usually taking a substantial part of the first page). It does NOT make sense to duplicate this header on every page. Also, the table might extend laterally on more than one pages, BUT it makes sense to have all the relevant header information only on the left-most page, and this independent of scaling factors and other external influences. Apple did it right and split the tables from the rest of the spreadsheet, or - more appropriately - created a big *CANVAS*, where the tables are just one part of this canvas. This big canvas behaves more like a OOo Draw page, with tables being just one element (the actual, classic spreadsheet), while users can work with the canvas more freely without being bound by spreadsheet limitations and interfering with the table proper. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 Issue #|83767 Summary|Spreadhseet Header Containing Company Logo Component|Spreadsheet Version|OOo 2.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|discoleo --- Additional comments from [EMAIL PROTECTED] Mon Nov 19 19:20:04 + 2007 --- This issue is part of a more comprehensive issue describing major design flaws of existing spreadsheets. I have posted already major design flaws parts (1.)(issue 79924) and (2.)(issue 80139) and this will contribute to part (4.) [it is only a subpart of a future part (4.) - Major Design Flaws in the Spreadsheet Structure; Part (3.) will deal with Multidimensional Spreadsheets - also a Spreadsheet Structure issue]. A.) SUMMARY === Allow a spreadsheet to begin with a separate LOGO/HEADER that is defined outside of the table proper. This header should be more like a Writer-type document (therefore NO spreadsheet, and NOT the existing - very limited - page header). B.) SPREADSHEET STRUCTURE = 1.) COMPANY DATA The first 4-to-20 rows of every professional spreadsheet contain some company specific data. Most often this data is a *company logo* and some company *specific text*. Virtually every official spreadsheet that I have done at work, will have this design. This is not something limited to my business. I will append to this issue an image from the IBM Symphony Demo depicting exactly this company logo. 2.) TITLE = After the company specific data, there will be some text describing the spreadsheet: a title and various other informations. 3.) COLUMN HEADERS == Only at this point will be the column headers/names. [This is truly spreadsheet data.] C.) RATIONALE = 1.) WRITER-LIKE TEXT STREAM === Both the 'Company specific data' and the 'Spreadsheet Title' are truly formatted text + some graphic elements. They are *NOT table data*, therefore they would be more easily created in a Writer-like application. Indeed, the text formatting is best done inside a text-processing application. It is especially cumbersome to format this text written inside table cells, when really it should flow like a paragraph. [Remember, you cannot adjust the column width, because you would break the actual table. Merging cells is an absolute NO because of many bugs with copy/paste/insert - I feel sorry for anyone who lost precious work after merging cells.] Also, you want this text printing only on the first page, and NOT being cut somehow between the first page and the page to the right (2nd or n-th, depending on printing preferences). This is especially cumbersome. 2.) BREAK TABLE STRUCTURE = These text-graphic streams break the concept of the spreadsheet. Especially in light of multidimensional spreadsheets, they have NO place in the spreadsheet proper. They are NOT data. They are really only text that does NOT fit into the concept of columns. [Unlike column headers, that are indeed table-specific.] This will also break various spreadsheet operations, e.g. SORT!!! It is impossible to simply select a table column and sort it, because this non-table data will interfere with the sort. [The column headers will partially interfere with the sort, too, BUT IF they would represent another special table element, this issue would be also solved.] AUTOFILTER Becomes non-trivial to select and to set. Sometimes, the data within the autofilter makes no sense (like TOP items). 3.) REUSABLE HEADERS It is likely that these headers would be reusable inside a company. The title will change, but everything else remains the same. 4.) TIME Most often a spreadsheet is first created without the headers, and then you have to insert dozens of rows and afterwards insert the graphics and text making the header. Simply attaching a HEADER/LOGO-file to your spreadsheet would be way easier. 5.) NAVIGATING the Table With dozens of rows of irrelevant data at the beginning of the spreadsheet, it becomes increasingly difficult to navigate the data. [One could hide them, but this is really best solved with a separate header that can be shown/hidden globally, see solutions - point 4.)!] D.) SOLUTION 1.) Break spreadsheet into functional domains 2.) The column headers and actual data are the spreadsheet proper 3.) The spreadsheet header/title is written
[sc-issues] [Issue 83767] Spreadhseet Header Contain ing Company Logo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83767 --- Additional comments from [EMAIL PROTECTED] Mon Nov 19 19:22:11 + 2007 --- Created an attachment (id=49754) Spreasheet Header/ Company Logo - This really DOES NOT fit into the structure of a spreadsheet and should be Separate Data - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]