[sc-dev] Copy/paste from Calc to writer
Hi list-members, Where is the code which creates the OLE object when I copy cells from a sheet and paste them into Writer? Thanks, Alan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] Dropdown list box
Hi list-members, Where can I find the code which displays a dropdown list box containing valid values for a cell? Thanks, Alan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] Increasing maximum worksheet size
Hi list-members, A number of our users have asked if there's a way we could increase the maximum worksheet size. One said that for this reason alone he's planning to move to Excel 2007, which allows over a million rows. What is involved in implementing this feature in Calc? I'd like to look into working on this, if it's manageable. Thanks, Alan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Text Direction in formula dialog
Hi Niklas, Thanks for your helpful reply. Regarding your last point: In general, Hebrew users (most of whom are used to Microsoft Office) expect that controls containing primarily English text will be left-aligned. An example is the font list in Hebrew Microsoft Word. For that reason, we disabled RTL in the OOo formula editor edit box, as described in Issue 62413. If a control's contents are primarily RTL but it includes some LTR entries, users expect right-aligned. This is the case with Word's toolbar list, which is mostly Hebrew, but contains a couple of English entries, such as WordArt. Alan Niklas Nebel wrote: Alan Yaniger wrote: Question 1: To align the names in the function list, I added following to ScFuncPage::UpdateFunctionList() : if (ScGlobal::IsSystemRTL()) aLbFunction.EnableMirroring( ); Is this the best way to do it? That would mean double mirroring, the flag wasn't intended to be used that way. The intended way to prevent mirroring is EnableRTL, but it would have to be called for the children of the list box, so maybe the ListBox should have an extra method. If you do use EnableMirroring, you should use GetSettings().GetLayoutRTL() instead of ScGlobal::IsSystemRTL(), to match VCL's configuration handling. But above all: Is there general consensus about mirroring a single control, including its scroll bar? What would you do with other list boxes that can contain English entries, or even mixed ones? Somehow, this doesn't seem right. Niklas - 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-dev] Text Direction in formula dialog
Hi list-members, In RTL OOo, function names are still English. I therefore want to change the function wizard dialog so that : 1) the names in the function list are left aligned, and 2) the multi-line edit in the dialog has textdirection LTR, and left-alignment I have two questions: Question 1: To align the names in the function list, I added following to ScFuncPage::UpdateFunctionList() : if (ScGlobal::IsSystemRTL()) aLbFunction.EnableMirroring( ); Is this the best way to do it? Question 2: How can I change the text direction and alignment of the multi-line edit? In the ScEditBox contructors, I tried: pMEdit-EnableRTL(FALSE); but that didn't work. How do I set the direction and alignment of this Edit Box? Thanks, Alan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-dev] Re: Text Direction in formula dialog
Hi list-members, I found the functionSetRightToLeft() in svtools/inc/svmedit.hxx, so that answers my second question. My first question still remains, though. Is Using EnableMirroring the best way to left-align the strings in the list box? Alan Alan Yaniger wrote: Hi list-members, In RTL OOo, function names are still English. I therefore want to change the function wizard dialog so that : 1) the names in the function list are left aligned, and 2) the multi-line edit in the dialog has textdirection LTR, and left-alignment I have two questions: Question 1: To align the names in the function list, I added following to ScFuncPage::UpdateFunctionList() : if (ScGlobal::IsSystemRTL()) aLbFunction.EnableMirroring( ); Is this the best way to do it? Question 2: How can I change the text direction and alignment of the multi-line edit? In the ScEditBox contructors, I tried: pMEdit-EnableRTL(FALSE); but that didn't work. How do I set the direction and alignment of this Edit Box? Thanks, Alan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Re: Calc cell justification
Hi Niklas, Thanks for your help in this matter. Since I'm new to setting properties, could you give me a little coding guidance here? Here's how I'm getting a cell's direction: ScBaseCell* pCell; pDocument-GetCell( nCol, nRow, nTab, pCell ); const ScPatternAttr* pPattern = pDocument-GetPattern( nCol, nRow, nTab ); const SfxItemSet* pCondSet = pDocument-GetCondResult( nCol, nRow, nTab ); const SvxFrameDirectionItem pItem = (const SvxFrameDirectionItem)pPattern-GetItem( ATTR_WRITINGDIR, pCondSet ); const SvxFrameDirection eCellDir = (SvxFrameDirection)pItem.GetValue(); Is this the way to get the text direction value if I want to change it ? To change the value, I've been trying to use the function, for example: pItem.PutValue( FRMDIR_ENVIRONMENT, ATTR_WRITINGDIR ); but I'm getting the compiler error: cannot convert 'this' pointer from 'const SvxFrameDirectionItem' to 'SvxFrameDirectionItem ' How do change I the text direction value? Thanks once more for your help, Alan Niklas Nebel wrote: for imported Excel files, one might go through the file after importing and apply Right-to-left attributes where needed. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] Re: Calc cell justification
Hi Niklas, Thanks very much. Alan Niklas Nebel wrote: Just modifying an item on the stack doesn't much effect anyway. Use something like pDocument-ApplyAttr( nCol, nRow, nTab, SvxFrameDirectionItem( FRMDIR_HORI_RIGHT_TOP, ATTR_WRITINGDIR ) ) This will take care of properly updating the ScAttrArray structure. Niklas - 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-dev] Re: Calc cell justification
Hi Niklas, To continue our exchange on the OOo dev list: Thanks for your suggestion. I added a function in output2.cxx to extend the default alignment handling, call it when necessary, and it works great. There's still a problem, though. When I edit a field by pressing F2 or clicking on the string in the input window, the alignment of the cell temporarily reverts to the old default alignment. Alignment of the input window is OK, the only problem is the alignment of the cell. When the editing is done, the cell is refreshed properly, but during the editing the text suddenly gets realigned. How can I prevent this? Another related question: I still have a problem when I import Excel documents with text direction set as Context. Here also I have to make the setting based on the text content, but this time it's the text direction setting, and it's only with imported Excel documents. How could I handle that problem? Thanks, Alan Niklas Nebel wrote: The alignment attribute is part of the cell attributes that are stored for cell ranges within a column in the ScAttrArray class. But if you want to dynamically change the alignment based on content, including formula results, it's probably better to extend the handling of default alignment that currently aligns text left, numbers right. Look for occurences of SVX_HOR_JUSTIFY_STANDARD, especially in sc/source/ui/view/output2.cxx, which has the code for text output. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]