Re: [sc-dev] 65,000 lines on calc
Hi, Am 24.03.2010 20:36, schrieb Daniel Rentz: Alexandro Colorado schrieb: when did OOo Calc (what version #) get past the 65,000 limit on spreadsheets? It was the 32,000 row limit (now there are 65,536 rows available) However, you can get OOo builds with 1 million rows in Calc: http://go-oo.org/discover/ http://kohei.us/2010/02/20/increasing-calcs-row-limit-to-1-million/ Stefan. -- www.datenpilot.org - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Automatic date recognition
Hi, Leonard Mada schrieb: LOINC table from: http://loinc.org/downloads/files/loinc-table-ascii-text-format/gotoCopyrightedFile I can´t get access to this file, even after checking I Accept These Terms and Conditions. It keeps telling me: You have not reviewed and agreed to this file's copyright license. Stefan -- www.datenpilot.org - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Automatic date recognition
Hi Leonard, Leonard Mada schrieb: it should work with: http://loinc.org/downloads See the link with title: LOINC Table File - ASCII Text Format (2.9 MB). I got it. I can´t see any problem. Did you set the data type of the columns in the import options to text? Stefan -- www.datenpilot.org - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] Filling dates in Calc
Hi, Leonard Mada schrieb: I worked late last night and needed to fill in dates in Calc. Actually I needed to fill the same date in a variable number of cells. You could select the range of cells, that should get the same entry, first. Then type it in and close with {ALT}+{ENTER}. Stefan -- www.datenpilot.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] formatting of protected cell changed?
Hi Cor, Cor Nouws schrieb: Before entering in IssueTracker a question about something I experience in 2.4.0 (and dev300_m10) I cannot confirm this in * OOo 2.4.0 / Windows 2000 * OOo-dev BEA m1 / Ubuntu 7.10 Stefan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Spec. for Solver?
Hi Niklas, Niklas Nebel schrieb: The epsilon level value is passed to the lp_solve API, see http://lpsolve.sourceforge.net/5.5/set_epslevel.htm for the meaning of the values. Thanks a lot. This was helpful and enabled me to phrase this (german) explanation for the epsilon level: http://wiki.services.openoffice.org/wiki/DE:UebersetzungSolver#Epsilon-Level Stefan :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Spec. for Solver?
Hi Frank, Frank Loehmann schrieb: specification here: http://specs.openoffice.org/calc/features/Solver.odt Thank you, for your help. Unfortunately the Sepc does not define Epsilon Level used by the implemented algorithm. Can you point me to a definition? Gruß Stefan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Spec. for Solver?
Thanks again, Frank. Frank Loehmann schrieb: The item is defined in section 1.4.2 (Item #3). I think Niklas (NN) could describe the functional behavior behind this setting if needed. Niklas, can you join this thread? :-) specification here: http://specs.openoffice.org/calc/features/Solver.odt For translation, QA and user documentation a specification is needed, that defines the functional meaning of Epsilon Level. This term is not common to me, although I do have quite some knowledge about Linear Optimization. CU Stefan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Behavior of Ctrl-+ and - to insert/delete rows
Hi Niklas, Niklas Nebel schrieb: It depends on the current selection. If whole rows are selected, rows are inserted. Same for columns, otherwise the dialog is shown. Maybe that was the difference. Anyway, when you have selected a whole row and you perform Ctrl- one time, this results in a single cell selected, rather than a whole row selected. Thus you cannot delete multiple rows by simply pressing Ctrl- several times. Gruß aus Niederbayern :-) Stefan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] pdf_calc_Export for single sheet possible ?
is there an easy way to export a single sheet (which can contain 1-X print pages) to pdf ? Yes. sheet1 1 page sheet2 2 pages sheet3 1 page How to export sheet2 ? (1) File | Export to PDF... (2) Give file name and destination (3) Klick Save (4) Choose Range|Selection This will export the currently selected sheet(s) to PDF :-) Stefan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]